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); }