} //End public void setCPAR_TYPE(string psCPAR_TYPE) public void Create(CPAR_DetailVM poViewModel) { string vsMsgErr = ""; try { using (var db = new DBMAINContext()) { CPAR oModel = new CPAR(); //Map Form Data Mapper.CreateMap <CPAR_DetailVM, CPAR>(); oModel = Mapper.Map <CPAR_DetailVM, CPAR>(poViewModel); //Set Field Header oModel.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE); //Set DTA_STS oModel.DTA_STS = valFLAG.FLAG_CRUDOPT_CREATE; //Set CPAR_STS oModel.CPAR_STS = valFLAG.FLAG_CPAR_STS_OPEN; //Set CPAR_TYPE oModel.CPAR_TYPE = this.CPAR_TYPE; //Get Config_cparid //oModel.oVMConfig_cparid = oDSConfig_cparid.getData(); //Set FIELD oModel.setFIELD(); //Set DEPT_RUID Auditor and Auditee if (oModel.AUDITOR_RUID != null) { oModel.AUDITORDEPT_RUID = oDSEmployee.getData_deptruid(oModel.AUDITOR_RUID); } //End if (AUDITOR_RUID != null) if (oModel.AUDITEE_RUID != null) { oModel.AUDITEEDEPT_RUID = oDSEmployee.getData_deptruid(oModel.AUDITEE_RUID); } //End if (AUDITEE_RUID != null) //Set Config CPAR_ID if (oModel.isNEW_CONFIG) { oCRUDConfig_cparid.Create_prepare(oModel.oVMConfig_cparid); db.Config_cparids.Add(oCRUDConfig_cparid.oModel); } //End if (oModel.isNEW_CONFIG) if (!oModel.isNEW_CONFIG) { oCRUDConfig_cparid.Update_prepare(oModel.oVMConfig_cparid); db.Entry(oCRUDConfig_cparid.oModel).State = EntityState.Modified; } //End if (!oModel.isNEW_CONFIG) //Set CPAR_FINISG_DT base on CPAR_DT //oModel.setFIELD_finishdate(poViewModel); oModel.setFIELD_finishdate(); //Set CPAR_RSPNLMT_DT base on CPAR_DT //oModel.setFIELD_responsedate(poViewModel); oModel.setFIELD_responsedate(); //Set CPAR_VERLMT_DT base on CPAR_DT //oModel.setFIELD_verifydate(poViewModel); oModel.setFIELD_verifydate(); //Process CRUD db.CPARs.Add(oModel); //Set CPAR_stdref oCRUD_Stdref = new CPARStdrefCRUD(); if (poViewModel.STDREF_LIST != null) { foreach (var item in poViewModel.STDREF_LIST) { CPARStdref_DetailVM oItem = new CPARStdref_DetailVM(); //Map Form Data Mapper.CreateMap <CPARStdref_ListVM, CPARStdref_DetailVM>(); oItem = Mapper.Map <CPARStdref_ListVM, CPARStdref_DetailVM>(item); oItem.CPAR_RUID = oModel.RUID; oCRUD_Stdref.Create_prepare(oItem); db.CPARStdrefs.Add(oCRUD_Stdref.oModel); } //End foreach (var item in poViewModel.STDREF_LIST) } //End if (poViewModel.STDREF_LIST != null) //Process CRUD db.SaveChanges(); this.RUID = oModel.RUID; } //End using } //End try catch (Exception e) { vsMsgErr = e.Message; } //End catch } //End public void Create
} //End public ComplainCRUD() public void Create(Complain_DetailVM poViewModel) { string vsMsgErr = ""; try { using (var db = new DBMAINContext()) { Complain oModel = new Complain(); //Map Form Data Mapper.CreateMap <Complain_DetailVM, Complain>(); oModel = Mapper.Map <Complain_DetailVM, Complain>(poViewModel); //Set Field Header oModel.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE); //Set DTA_STS oModel.DTA_STS = valFLAG.FLAG_CRUDOPT_CREATE; //Set CPAR_STS oModel.COMPLAIN_STS = valFLAG.FLAG_CPAR_STS_OPEN; //Set field oModel.setFIELD(valFLAG.FLAG_CRUDOPT_CREATE); //Set outo create CPAR if (oModel.IS_CPAR == valFLAG.FLAG_YES) { EmployeeDS oDSEmployee = new EmployeeDS(); CPARCRUD oCRUD_cpar = new CPARCRUD(); oCRUD_cpar.setCPAR_TYPE(valFLAG.FLAG_CPAR_TYPE_CC); //oCRUD_cpar.Create_prepare(); oCRUD_cpar.oModel.AUDITOR_RUID = null; oCRUD_cpar.oModel.AUDITORDEPT_RUID = null; oCRUD_cpar.oModel.AUDITEE_RUID = poViewModel.PIC_RUID; oCRUD_cpar.oModel.AUDITEEDEPT_RUID = oDSEmployee.getData_deptruid(oCRUD_cpar.oModel.AUDITEE_RUID); oCRUD_cpar.oModel.CPAR_DT = poViewModel.ISSUED_DT; oCRUD_cpar.oModel.CPAR_TRGT_DT = poViewModel.TARGET_DT; oCRUD_cpar.oModel.CPAR_DESC = poViewModel.DESCRIPTION; oCRUD_cpar.oModel.CPAR_RESOLUTION2 = poViewModel.SOLUTION; oCRUD_cpar.oModel.COMPLAIN_RUID = oModel.RUID; oCRUD_cpar.Create_prepare(); //Update model CPAR db.CPARs.Add(oCRUD_cpar.oModel); //Update model config //db.Entry(oCRUD_cpar.oCRUDConfig_cparid.oModel).State = EntityState.Modified; if (oCRUD_cpar.oModel.isNEW_CONFIG) { db.Config_cparids.Add(oCRUD_cpar.oCRUDConfig_cparid.oModel); } //End if (oModel.isNEW_CONFIG) if (!oCRUD_cpar.oModel.isNEW_CONFIG) { db.Entry(oCRUD_cpar.oCRUDConfig_cparid.oModel).State = EntityState.Modified; } //End if (!oModel.isNEW_CONFIG) } //End if (this.IS_CPAR == valFLAG.FLAG_YES) //Update model Complain db.Complains.Add(oModel); //Process CRUD db.SaveChanges(); } //End using } //End try catch (Exception e) { vsMsgErr = e.Message; } //End catch } //End public void Create