teresaleelim / intprojectmanagement

1 stars 0 forks source link

Quemado Status #45

Open AngelMa2274 opened 4 months ago

AngelMa2274 commented 4 months ago

start new page to have control over the status of area of Quemado

AngelMa2274 commented 4 months ago

Creation of tables in sql

image

image

AngelMa2274 commented 4 months ago

Added initial DTO model, Service and IService for ControlQuemado

image

AngelMa2274 commented 4 months ago

Modifications in Fact_ControlQuemado and Fact_ControlQuemadoDetails tables

Fact_ControlQuemado: image

Fact_ControlQuemadoDetails: image

Added the following Store Procedures that are use to retrive, update and insert data to our tables: image

AngelMa2274 commented 4 months ago

A new item has been added to the Nav Manu: image

In the main page "Control Quemado" there will be displayed infomation like shift, frames that have been made in manual and auto mode, total of frames and if there is a comment about the shift.

image

Also grouping feature in the DataGrid have been used to group the shift per day so this made the data more readeable. Each group will show information about the date, quantity of manual frames of the day, quantity of automatic frames of the day, total frames of the day and if there is a comment in some of the shifts of the day:

image

If we click the "add" button the following Dialog will be displayed and will ask us which date and shift do we want to add: image

after that, it will be added to the table and then we can select and click the "edit" button or simply do double click to add details to the desire shift:

image