public string Update_Database(ECheckSubmit AreaData)
{
string Excp = string.Empty;
Data_Services Data_Services = new Data_Services(DataContext);
try
{
var area = Data_Services.Get_ECheckArea(AreaData.Area_Id);
if (area == null)
{
return($"Can not find aread with id {AreaData.Area_Id}");
}
if (area.ECheckings.Count != AreaData.CheckItems.Count)
{
return($"Total items not equal");
}
var person = Data_Services.Get_CheckPerson(AreaData.CheckPerson_Id);
if (person == null)
{
return($"Can not find person Id: {AreaData.CheckPerson_Id}");
}
ESubmit ESubmit = new ESubmit
{
AreaId = area.id,
PersonId = person.id,
Date = DateTime.Now,
UpdateTime = DateTime.Now.ToString("hh:mm tt, dd/MM/yy"),
};
// update new esubmit
Data_Services.Update_ESubmit(ESubmit);
foreach (var item in AreaData.CheckItems)
{
var CheckItem = Data_Services.Get_ECheckItem(item.Item);
var submit_data = new ECheckingDaily
{
ECheckAreaCode = area.AreaCode,
ECheckAreaId = area.id,
ECheckItemId = CheckItem.id,
ECheckItemCode = CheckItem.ECheckItemCode,
Status = item.Status,
Time = DateTime.Now,
CheckingPersonId = person.id,
ESubmitId = ESubmit.Id,
};
if (item.Status == 0x00)
{
submit_data.ECheckNotesId = item.Note;
}
if (!Data_Services.Update_ECheckDaily(submit_data))
{
Excp = $"Error when add item {item.Item} to database";
}
}
return(Excp);
}
catch (Exception ex)
{ return(ex.ToString()); }
}
public bool UpdateToExcel(ECheckSubmit AreaData, string path)
{
FileInfo CurrentExcel = new FileInfo(path);
DateTime Time = DateTime.Now;
int currentHour = Time.Hour;
int Area_Id = AreaData.Area_Id;
int Person_Id = AreaData.CheckPerson_Id;
try
{
var ECheckPerson = Data_Services.Get_CheckPerson(Person_Id);
using (ExcelPackage excelPackage = new ExcelPackage(CurrentExcel, "echecklist"))
{
ExcelWorksheet currentSheet = excelPackage.Workbook.Worksheets[Area_Id];
for (int checkItem = 0; checkItem < AreaData.CheckItems.Count; checkItem++)
{
int currentTime = 0;
for (int timeLine = 0; timeLine < 12; timeLine++)
{
if (currentHour == 0 && timeLine == 0)
{
currentTime = 0;
if (AreaData.CheckItems[checkItem].Status == 0xFF)
{
currentSheet.Cells[checkItem + 5, 1].Value = "X";
currentSheet.Cells[checkItem + 5, 1].Style.Font.Bold = true;
currentSheet.Cells[checkItem + 5, 2].Value = string.Empty;
}
else
{
currentSheet.Cells[checkItem + 5, 1].Value = string.Empty;
currentSheet.Cells[checkItem + 5, 2].Value = "X";
currentSheet.Cells[checkItem + 5, 2].Style.Font.Bold = true;
}
}
else
{
if (currentHour / 2 == timeLine)
{
currentTime = timeLine * 2 + 2;
if (AreaData.CheckItems[checkItem].Status == 0xFF)
{
currentSheet.Cells[checkItem + 5, timeLine * 2 + 2].Value = "X";
currentSheet.Cells[checkItem + 5, timeLine * 2 + 2].Style.Font.Bold = true;
currentSheet.Cells[checkItem + 5, timeLine * 2 + 1 + 2].Value = string.Empty;
}
else
{
currentSheet.Cells[checkItem + 5, timeLine * 2 + 2].Value = string.Empty;
currentSheet.Cells[checkItem + 5, timeLine * 2 + 1 + 2].Value = "X";
currentSheet.Cells[checkItem + 5, timeLine * 2 + 1 + 2].Style.Font.Bold = true;
}
}
}
}
if (ECheckPerson != null)
{
currentSheet.Cells[AreaData.CheckItems.Count + 5, currentTime].Value = ECheckPerson.Name;
}
}
excelPackage.Save();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}