} //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
