public AutoTuneForm()
{
InitializeComponent();
Menu = new ContextMenu(new MenuItem[] { new MenuItem("Delete", Delete_AutoCheckItem, Shortcut.Del) });
QueueData.ContextMenu = Menu;
dataContext = new DataContext();
data_Services = new Data_Services(dataContext);
CheckingPerson = new CheckingPerson();
Timer.Tick += Timer_Tick;
PostTimer.Tick += PostTimer_Tick;
DS_PERSON.DataSource = data_Services.Get_CheckPersons();
try
{
string json = Properties.Settings.Default.His;
var his = JsonConvert.DeserializeObject <List <AutoCheck_Queue> >(json);
His = his;
cbxHis.Items.Clear();
foreach (var item in His)
{
cbxHis.Items.Add(item.CheckDate);
}
}
catch { }
}
public Form1()
{
InitializeComponent();
DataContext = new DataContext();
Data_Services = new Data_Services(DataContext);
ServerExport = new ServerExport(DataContext);
autoTuneForm = new AutoTuneForm();
}
public SubmitServices(DataContext DataContext, ECheckSubmit submit)
{
Data_Services = new Data_Services(DataContext);
ServerExport ServerExport = new ServerExport(DataContext);
try
{
Exception = ServerExport.Update_Database(submit);
Success = true;
AreadId = submit.Area_Id;
}
catch (Exception ex)
{
Success = false;
Exception = ex.ToString();
}
}
public ECheckSubmitController()
{
DataContext = new DataContext();
Data_Services = new Data_Services(DataContext);
}
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 ServerExport(DataContext DataContext)
{
this.DataContext = DataContext;
Data_Services = new Data_Services(this.DataContext);
}
