} //End public void CreateCPAR(User_DetailCPARVM poViewModel, HttpPostedFileBase poFileimage)
public void UpdateCPAR(User_DetailCPARVM poViewModel, HttpPostedFileBase poFileimage)
{
string vsMsgErr = "";
try
{
using (var db = new DBMAINContext())
{
#region User Area
User oModel = db.Users.AsNoTracking().SingleOrDefault(fld => fld.RUID == poViewModel.RUID);
//Set Field Header
oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set DTA_STS
oModel.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.UPDATE);
//Set BP_STS (Active)
oModel.setActivate();
//Set model from Viewmodel
oModel.USR_NM1 = poViewModel.USR_NM1;
oModel.USR_PSWD = hlpObf.randomEncrypt(poViewModel.USR_PSWD);
#endregion
#region Employee Area
Employee oModelEmployee = db.Employees.AsNoTracking().SingleOrDefault(fld => fld.RUID == oModel.RES_RUID);
//Set Field Header
oModelEmployee.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set DTA_STS
oModelEmployee.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.UPDATE);
//Set RES_TYPE
oModelEmployee.setRES_TYPE();
//Set model from Viewmodel
oModelEmployee.RES_NM1 = poViewModel.USR_NM1;
oModelEmployee.DEPT_RUID = poViewModel.DEPT_RUID;
//Set Image file name
if (poFileimage != null)
{
oModelEmployee.IMG_SRC = Utility_FileUploadDownload.setImage(oModelEmployee.RUID);
Utility_FileUploadDownload.saveImage_Employee(poFileimage, oModelEmployee.IMG_SRC);
} //End if (poFileimage != null)
#endregion
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
db.Entry(oModelEmployee).State = EntityState.Modified;
//Save to Database
db.SaveChanges();
this.RUID = oModel.RUID;
} //End using
} //End try
catch (Exception e) { vsMsgErr = e.Message; } //End catch
} //End public void UpdateCPAR(User_DetailCPARVM poViewModel, HttpPostedFileBase poFileimage)
} //End public void Create
public void Update(Complain_DetailVM poViewModel)
{
string vsMsgErr = "";
try
{
using (var db = new DBMAINContext())
{
Complain oModel = db.Complains.AsNoTracking().SingleOrDefault(fld => fld.RUID == poViewModel.RUID);
poViewModel.COMPLAIN_STS = oModel.COMPLAIN_STS;
poViewModel.IS_CPAR = oModel.IS_CPAR;
//Map Form Data
Mapper.CreateMap <Complain_DetailVM, Complain>();
oModel = Mapper.Map <Complain_DetailVM, Complain>(poViewModel);
//Set Field Header
oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set DTA_STS
oModel.DTA_STS = valFLAG.FLAG_CRUDOPT_CREATE;
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
db.SaveChanges();
} //End using
} //End try
catch (Exception e) { vsMsgErr = e.Message; } //End catch
} //End public void Update
} //End public void Cancel(CPAR_VerifyVM poViewModel)
//PATCH morefeature#1
public void patch_morefeature1(CPAR_DetailVM poViewModel)
{
string vsMsgErr = "";
try
{
using (var db = new DBMAINContext())
{
var oData = oDSCPAR.getDatalist();
foreach (var item in oData)
{
CPAR oModel = db.CPARs.AsNoTracking().SingleOrDefault(fld => fld.RUID == item.RUID);
//Set CPAR_FINISG_DT base on CPAR_DT
if (oModel.CPAR_FINISH_DT == null)
{
oModel.setFIELD_finishdate();
} //End if (oModel.CPAR_FINISH_DT == null)
//Set CPAR_RSPNLMT_DT base on CPAR_DT
oModel.setFIELD_responsedate();
//Set CPAR_VERLMT_DT base on CPAR_DT
oModel.setFIELD_verifydate();
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
//Process CRUD
db.SaveChanges();
} //End foreach (var item in oData)
} //End using
} //End try
catch (Exception e) { vsMsgErr = e.Message; } //End catch
} //End public void patch_morefeature1(CPAR_DetailVM poViewModel)
} //End public void Create
public void Update(StudentdetailVM poViewModel, HttpPostedFileBase poFileimage = null)
{
try
{
using (var db = new DBMAINContext())
{
Student oModel = db.Students.AsNoTracking().SingleOrDefault(fld => fld.ID == poViewModel.ID);
//Map Form Data
oModel.InjectFrom(poViewModel);
//Set Field Header
oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set DTA_STS
oModel.DTA_STS = valFLAG.FLAG_DTA_STS_UPDATE;
//Set Image file name
if (poFileimage != null)
{
if ((oModel.STUDENT_IMG == null) || (oModel.STUDENT_IMG == ""))
{
oModel.STUDENT_IMG = Utility_FileUploadDownload.setImage_Student();
}
} //End if (poFileimage != null)
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
db.SaveChanges();
this.ID = oModel.ID;
//Save file
if (poFileimage != null)
{
Utility_FileUploadDownload.saveImage_Student(poFileimage, oModel.STUDENT_IMG);
} //End if (poFileimage != null)
} //End using
} //End try
catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Update" + e.Message; } //End catch
} //End public void Update
} //End public void Create
public void Update(SuggestdetailVM poViewModel)
{
try
{
using (var db = new DBMAINContext())
{
poViewModel.SHORT_DESC = poViewModel.FULL_DESC;
Suggest oModel = db.Suggests.AsNoTracking().SingleOrDefault(fld => fld.ID == poViewModel.ID);
SuggesthiddenVM oModelhidden = new SuggesthiddenVM();
oModelhidden.InjectFrom(oModel);
poViewModel.InjectFrom(oModelhidden);
//Map Form Data
oModel.InjectFrom(poViewModel);
//Set Field Header
oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
db.SaveChanges();
this.ID = oModel.ID;
this.TIMELINE_ID = oModel.TIMELINE_ID;
} //End using
} //End try
catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Update" + e.Message; } //End catch
} //End public void Update
} //End public void Update
public void UpdateQuit(Employee_DetailVM poViewModel)
{
string vsMsgErr = "";
try
{
using (var db = new DBMAINContext())
{
#region Employee
Employee oModel = db.Employees.AsNoTracking().SingleOrDefault(fld => fld.RUID == poViewModel.RUID);
//Map Form Data
Mapper.CreateMap <Employee_DetailVM, Employee>();
oModel = Mapper.Map <Employee_DetailVM, Employee>(poViewModel);
//Set Field Header
oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set DTA_STS
oModel.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.UPDATE);
//Set RES_TYPE
oModel.setRES_TYPE();
//Set BP_STS
oModel.BP_STS = APPBASE.Svcbiz.valFLAG.FLAG_EMP_BPSTS_QUIT;
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
db.SaveChanges();
#endregion
} //End using
} //End try
catch (Exception e) { vsMsgErr = e.Message; } //End catch
} //End public void Update
} //End public void Delete
public void Career(Employee_DetailVM poViewModel)
{
string vsMsgErr = "";
try
{
using (var db = new DBMAINContext())
{
//Get Current Data by RUID
Employee oModel = db.Employees.AsNoTracking().SingleOrDefault(fld => fld.RUID == poViewModel.RUID);
//Set Field Header
oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set DTA_STS
oModel.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.UPDATE);
//Set Job info
oModel.RES_STS = poViewModel.RES_STS;
oModel.DEPT_RUID = poViewModel.DEPT_RUID;
oModel.JOB_TITLE_RUID = poViewModel.JOB_TITLE_RUID;
oModel.JOIN_DT = poViewModel.JOIN_DT;
oModel.JAMSOSTEK_NO = poViewModel.JAMSOSTEK_NO;
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
db.SaveChanges();
} //End using
} //End try
catch (Exception e) { vsMsgErr = e.Message; } //End catch
} //End public void Update
} //End public void Close(CPAR_VerifyVM poViewModel)
public void Cancel(CPAR_VerifyVM poViewModel)
{
string vsMsgErr = "";
try
{
using (var db = new DBMAINContext())
{
CPAR oModel = db.CPARs.AsNoTracking().SingleOrDefault(fld => fld.RUID == poViewModel.RUID);
//Map Form Data
//Mapper.CreateMap<CPAR_DetailVM, CPAR>();
//oModel = Mapper.Map<CPAR_DetailVM, CPAR>(poViewModel);
//Set Field Header
oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set DTA_STS
oModel.DTA_STS = valFLAG.FLAG_CRUDOPT_UPDATE;
//Set FIELD
oModel.setFIELD_cancel();
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
db.SaveChanges();
this.RUID = oModel.RUID;
} //End using
} //End try
catch (Exception e) { vsMsgErr = e.Message; } //End catch
} //End public void Cancel(CPAR_VerifyVM poViewModel)
} //End public UserCRUD()
//ALL
public void Changepassword(UserChangepasswordVM poViewModel)
{
try
{
using (var db = new DBMAINContext())
{
User oModel = db.Users.AsNoTracking().SingleOrDefault(fld => fld.ID == poViewModel.ID);
poViewModel.PASSWORD_NEW = hlpObf.randomEncrypt(poViewModel.PASSWORD_NEW);
oModel.PASSWORD = poViewModel.PASSWORD_NEW;
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
db.SaveChanges();
this.ID = oModel.ID;
} //End using
} //End try
catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Update" + e.Message; } //End catch
} //End public void Update
} //End public void ActivateCPAR(string id)
public void DeactivateCPAR(string id)
{
string vsMsgErr = "";
try
{
using (var db = new DBMAINContext())
{
User oModel = db.Users.AsNoTracking().SingleOrDefault(fld => fld.RUID == id);
oModel.setDeactivate();
//Set Field Header
oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
db.SaveChanges();
} //End using
} //End try
catch (Exception e) { vsMsgErr = e.Message; } //End catch
} //End public void DeactivateCPAR(string id)
} //End public void Create
public void Update(ThemedetailVM poViewModel)
{
try
{
using (var db = new DBMAINContext())
{
Theme oModel = db.Themes.AsNoTracking().SingleOrDefault(fld => fld.ID == poViewModel.ID);
//Map Form Data
oModel.InjectFrom(poViewModel);
//Set Field Header
oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
db.SaveChanges();
this.ID = oModel.ID;
} //End using
} //End try
catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Update" + e.Message; } //End catch
} //End public void Update
} //End public void Deactivate
public void Create_Usermenu(Userrole_DetailVM poViewModel, string psMDLE_RUID)
{
string vsMsgErr = "";
try
{
using (var db = new DBMAINContext())
{
////Map Form Data
//List<Userrolemenu_ListVM> oUserrolemenu_ListVM = poViewModel.Userrolemenu_ListVM;
//Mapper.CreateMap < List<Userrolemenu_ListVM>, List<Usermenu>>();
Mapper.CreateMap<Userrolemenu_ListVM, Usermenu>();
List<Usermenu> oModel = Mapper.Map<List<Userrolemenu_ListVM>, List<Usermenu>>(poViewModel.Userrolemenu_ListVM);
var oCurrentModel = db.Usermenus.Where(fld => fld.MDLE_RUID == psMDLE_RUID &&
fld.USR_RUID == poViewModel.RUID);
//Delete old usermenu
foreach (Usermenu item in oCurrentModel) { db.Usermenus.Remove(item); } //End foreach
//Add New usermenu
foreach (Usermenu item in oModel) {
item.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
item.MDLE_RUID = psMDLE_RUID;
item.USR_RUID = poViewModel.RUID;
item.IS_GRANTED = hlpGeneral.FlagInfo.getFlagValid();
db.Usermenus.Add(item);
} //End foreach
//Update User (field ROLE_RUID)
User oModelUser = db.Users.AsNoTracking().SingleOrDefault(fld => fld.RUID == poViewModel.RUID);
//Set Field Header
oModelUser.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set ROLE_RUID
oModelUser.ROLE_RUID = poViewModel.ROLE_RUID;
//Process CRUD
db.Entry(oModelUser).State = EntityState.Modified;
//Save Database
db.SaveChanges();
} //End using
} //End try
catch (Exception e) { vsMsgErr = e.Message; } //End catch
} //End public void Create
} //End public void Create
public void Update(User_DetailVM poViewModel)
{
string vsMsgErr = "";
try
{
using (var db = new DBMAINContext())
{
User oModel = db.Users.AsNoTracking().SingleOrDefault(fld => fld.RUID == poViewModel.RUID);
//Map Form Data
Mapper.CreateMap<User_DetailVM, User>();
oModel = Mapper.Map<User_DetailVM, User>(poViewModel);
//Set Field Header
oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
db.SaveChanges();
} //End using
} //End try
catch (Exception e) { vsMsgErr = e.Message; } //End catch
} //End public void Update
} //End public void patch_hotfix2()
//PATCH Patchhotfix3
public void patch_hotfix3()
{
string vsMsgErr = "";
try
{
using (var db = new DBMAINContext())
{
var oData = oDSCPAR.getDatalist_Patchhotfix3();
foreach (var item in oData)
{
CPAR oModel = db.CPARs.AsNoTracking().SingleOrDefault(fld => fld.RUID == item.RUID);
//Set CPAR_VERLMT_DT base on CPAR_DT
oModel.setFIELD_verifydate();
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
//Process CRUD
db.SaveChanges();
} //End foreach (var item in oData)
} //End using
} //End try
catch (Exception e) { vsMsgErr = e.Message; } //End catch
} //End public void patch_hotfix3()
} //End public void Delete
public void Rollup_RECEIPTNO()
{
try
{
using (var db = new DBMAINContext())
{
Mainconfig oModel = db.Mainconfigs.AsNoTracking().FirstOrDefault();
if (oModel.RECEIPT_NO == null)
{
oModel.RECEIPT_NO = 1;
}
else
{
oModel.RECEIPT_NO = oModel.RECEIPT_NO + 1;
}
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
db.SaveChanges();
this.ID = oModel.ID;
this.RECEIPT_NO = oModel.RECEIPT_NO;
} //End using
} //End try
catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Update" + e.Message; } //End catch
} //End public void Update
} //End public void Create
public void Update(CPAR_DetailVM poViewModel)
{
string vsMsgErr = "";
try
{
using (var db = new DBMAINContext())
{
CPAR oModel = db.CPARs.AsNoTracking().SingleOrDefault(fld => fld.RUID == poViewModel.RUID);
poViewModel.CPAR_STS = oModel.CPAR_STS;
poViewModel.CPAR_TYPE = oModel.CPAR_TYPE;
poViewModel.AUDITORDEPT_RUID = oModel.AUDITORDEPT_RUID;
poViewModel.AUDITEEDEPT_RUID = oModel.AUDITEEDEPT_RUID;
//Reflect data VM
if (oModel.CPAR_TYPE == valFLAG.FLAG_CPAR_TYPE_CC)
{
poViewModel.AUDITEE_RUID = oModel.AUDITEE_RUID;
poViewModel.AUDITEEDEPT_RUID = oModel.AUDITEEDEPT_RUID;
poViewModel.CPAR_DT = oModel.CPAR_DT;
poViewModel.CPAR_TRGT_DT = oModel.CPAR_TRGT_DT;
//poViewModel.CPAR_DESC = oModel.CPAR_DESC;
poViewModel.CPAR_RESOLUTION2 = oModel.CPAR_RESOLUTION2;
poViewModel.COMPLAIN_RUID = oModel.COMPLAIN_RUID;
} //End if (this.CPAR_TYPE == valFLAG.FLAG_CPAR_TYPE_CC)
//Map Form Data
Mapper.CreateMap <CPAR_DetailVM, CPAR>();
oModel = Mapper.Map <CPAR_DetailVM, CPAR>(poViewModel);
//Set Field Header
oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set DTA_STS
oModel.DTA_STS = valFLAG.FLAG_CRUDOPT_UPDATE;
//Set FIELD
oModel.setFIELD();
//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.Entry(oModel).State = EntityState.Modified;
//Set CPAR_stdref Delete by CPAR RUID
oCRUD_Stdref = new CPARStdrefCRUD();
oDSCPARStdref = new CPARStdrefDS();
var oQRY = oDSCPARStdref.getDatalist_byCPAR_RUID(oModel.RUID);
foreach (var item in oQRY)
{
CPARStdref oItem = db.CPARStdrefs.Find(item.RUID);
db.CPARStdrefs.Remove(oItem);
} //End foreach (var item in oQRY)
//Set CPAR_stdref Add by STDREF_LIST
if (poViewModel.STDREF_LIST != null)
{
foreach (var item in poViewModel.STDREF_LIST)
{
//LASTWORK
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 Update
} //End public void SaveNEW
public void SaveNEW_create(Transaction_indetailVM poViewModel)
{
try
{
using (var db = new DBMAINContext())
{
//TRN
Transaction_in oModelTRN = new Transaction_in();
//Map Form Data
oModelTRN.InjectFrom(poViewModel);
//Set Field Header
oModelTRN.setFIELD_HEADER(this.FIELD_HEADER);
//Set DTA_STS
oModelTRN.DTA_STS = this.DTA_STS;
//Process CRUD
db.Transaction_ins.Add(oModelTRN);
//Update database
db.SaveChanges();
this.ID = oModelTRN.ID;
this.TRN_DT = oModelTRN.TRN_DT;
//INST
Installment_in oModelINST = null;
List <Installment_in> LIST_INST = new List <Installment_in>();
Installment_in DETAIL_INST = null;
//INST - SPP
if (poViewModel.MONTHLY_INST_SPP != null)
{
poViewModel.MONTHLY_INST = poViewModel.MONTHLY_INST_SPP;
//Create
if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_CREATE)
{
oModelINST = new Installment_in();
//Map Form Data
oModelINST.InjectFrom(poViewModel.MONTHLY_INST);
//Set Field Header
oModelINST.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
//Set DTA_STS : Set in METHOD controller
//oModelINST.DTA_STS = this.DTA_STS;
//Set TRN_DT
oModelINST.INST_DT = this.TRN_DT;
//Process CRUD
db.Installment_ins.Add(oModelINST);
} //End if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_CREATE)
//Update
if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_UPDATE)
{
oModelINST = db.Installment_ins.AsNoTracking().SingleOrDefault(fld => fld.ID == poViewModel.MONTHLY_INST.ID);
//Map Form Data
oModelINST.InjectFrom(poViewModel.MONTHLY_INST);
//Set Field Header
oModelINST.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set DTA_STS : Set in METHOD controller
//oModelINST.DTA_STS = this.DTA_STS;
//Process CRUD
db.Entry(oModelINST).State = EntityState.Modified;
} //End if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_UPDATE)
//Update database-SPP
db.SaveChanges();
DETAIL_INST = new Installment_in();
DETAIL_INST.ID = oModelINST.ID;
DETAIL_INST.INST_TYPEID = oModelINST.INST_TYPEID;
LIST_INST.Add(DETAIL_INST);
} //End if (poViewModel.MONTHLY_INST_SPP != null)
//INST - EKSKUL
if (poViewModel.MONTHLY_INST_EKSKUL != null)
{
poViewModel.MONTHLY_INST = poViewModel.MONTHLY_INST_EKSKUL;
//Create
if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_CREATE)
{
oModelINST = new Installment_in();
//Map Form Data
oModelINST.InjectFrom(poViewModel.MONTHLY_INST);
//Set Field Header
oModelINST.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
//Set DTA_STS : Set in METHOD controller
//oModelINST.DTA_STS = this.DTA_STS;
//Set TRN_DT
oModelINST.INST_DT = this.TRN_DT;
//Process CRUD
db.Installment_ins.Add(oModelINST);
} //End if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_CREATE)
//Update
if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_UPDATE)
{
oModelINST = db.Installment_ins.AsNoTracking().SingleOrDefault(fld => fld.ID == poViewModel.MONTHLY_INST.ID);
//Map Form Data
oModelINST.InjectFrom(poViewModel.MONTHLY_INST);
//Set Field Header
oModelINST.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set DTA_STS : Set in METHOD controller
//oModelINST.DTA_STS = this.DTA_STS;
//Process CRUD
db.Entry(oModelINST).State = EntityState.Modified;
} //End if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_UPDATE)
//Update database-EKSKUL
db.SaveChanges();
DETAIL_INST = new Installment_in();
DETAIL_INST.ID = oModelINST.ID;
DETAIL_INST.INST_TYPEID = oModelINST.INST_TYPEID;
LIST_INST.Add(DETAIL_INST);
} //End if (poViewModel.MONTHLY_INST_EKSKUL != null)
//INST - SCLUB
if (poViewModel.MONTHLY_INST_SCLUB != null)
{
poViewModel.MONTHLY_INST = poViewModel.MONTHLY_INST_SCLUB;
//Create
if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_CREATE)
{
oModelINST = new Installment_in();
//Map Form Data
oModelINST.InjectFrom(poViewModel.MONTHLY_INST);
//Set Field Header
oModelINST.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
//Set DTA_STS : Set in METHOD controller
//oModelINST.DTA_STS = this.DTA_STS;
//Set TRN_DT
oModelINST.INST_DT = this.TRN_DT;
//Process CRUD
db.Installment_ins.Add(oModelINST);
} //End if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_CREATE)
//Update
if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_UPDATE)
{
oModelINST = db.Installment_ins.AsNoTracking().SingleOrDefault(fld => fld.ID == poViewModel.MONTHLY_INST.ID);
//Map Form Data
oModelINST.InjectFrom(poViewModel.MONTHLY_INST);
//Set Field Header
oModelINST.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set DTA_STS : Set in METHOD controller
//oModelINST.DTA_STS = this.DTA_STS;
//Process CRUD
db.Entry(oModelINST).State = EntityState.Modified;
} //End if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_UPDATE)
//Update database-SCLUB
db.SaveChanges();
DETAIL_INST = new Installment_in();
DETAIL_INST.ID = oModelINST.ID;
DETAIL_INST.INST_TYPEID = oModelINST.INST_TYPEID;
LIST_INST.Add(DETAIL_INST);
} //End if (poViewModel.MONTHLY_INST_SCLUB != null)
//INST - RANDOM
if (oViewModel.INSTLIST != null)
{
foreach (var item in oViewModel.INSTLIST)
{
poViewModel.INST = item;
//Create
if (poViewModel.INST.DTA_STS == valFLAG.FLAG_DTA_STS_CREATE)
{
oModelINST = new Installment_in();
//Map Form Data
oModelINST.InjectFrom(poViewModel.INST);
//Set Field Header
oModelINST.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
//Set DTA_STS : Set in METHOD controller
//oModelINST.DTA_STS = this.DTA_STS;
//Set TRN_DT
oModelINST.INST_DT = this.TRN_DT;
//Process CRUD
db.Installment_ins.Add(oModelINST);
} //End if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_CREATE)
//Update
if (poViewModel.INST.DTA_STS == valFLAG.FLAG_DTA_STS_UPDATE)
{
oModelINST = db.Installment_ins.AsNoTracking().SingleOrDefault(fld => fld.ID == poViewModel.INST.ID);
//Map Form Data
oModelINST.InjectFrom(poViewModel.INST);
//Set Field Header
oModelINST.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set DTA_STS : Set in METHOD controller
//oModelINST.DTA_STS = this.DTA_STS;
//Process CRUD
db.Entry(oModelINST).State = EntityState.Modified;
} //End if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_UPDATE)
//Save data
db.SaveChanges();
DETAIL_INST = new Installment_in();
DETAIL_INST.ID = oModelINST.ID;
DETAIL_INST.INST_TYPEID = oModelINST.INST_TYPEID;
LIST_INST.Add(DETAIL_INST);
} //End foreach (var item in oViewModel.INSTLIST)
} //End if (oViewModel.INSTLIST != null)
//TRNDetail
Transaction_ind oModelTRN_detail = null;
foreach (var item in poViewModel.DETAIL)
{
oModelTRN_detail = new Transaction_ind();
item.TRN_ID = this.ID;
//item.INST_ID = this.INST_ID;
if (LIST_INST.Count > 0)
{
var oData_INST = LIST_INST.Where(fld => fld.INST_TYPEID == item.TRINTYPE_ID).SingleOrDefault();
if (oData_INST != null)
{
item.INST_ID = oData_INST.ID;
}
} //End if (LIST_INST.Count > 0)
//Map Form Data
oModelTRN_detail.InjectFrom(item);
//Set Field Header
oModelTRN_detail.setFIELD_HEADER(this.FIELD_HEADER);
//Set DTA_STS
oModelTRN_detail.DTA_STS = this.DTA_STS;
//Process CRUD
db.Transaction_inds.Add(oModelTRN_detail);
} //End foreach (var item in poViewModel.DETAIL)
//Update database
db.SaveChanges();
} //End using
} //End try
catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Create: " + e.Message; } //End catch
} //End public void Create_bulk
} //End private Installment_in setINST(Installment_in oModelINST)
public void SaveNEW_create_BACKUP(Transaction_indetailVM poViewModel)
{
try
{
using (var db = new DBMAINContext())
{
//TRN
Transaction_in oModelTRN = new Transaction_in();
//Map Form Data
oModelTRN.InjectFrom(poViewModel);
//Set Field Header
oModelTRN.setFIELD_HEADER(this.FIELD_HEADER);
//Set DTA_STS
oModelTRN.DTA_STS = this.DTA_STS;
//Process CRUD
db.Transaction_ins.Add(oModelTRN);
//Update database
db.SaveChanges();
this.ID = oModelTRN.ID;
this.TRN_DT = oModelTRN.TRN_DT;
//INST - SPP
Installment_in oModelINST = null;
//Create
if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_CREATE)
{
oModelINST = new Installment_in();
//Map Form Data
oModelINST.InjectFrom(poViewModel.MONTHLY_INST);
//Set Field Header
oModelINST.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
//Set DTA_STS : Set in METHOD controller
//oModelINST.DTA_STS = this.DTA_STS;
//Set TRN_DT
oModelINST.INST_DT = this.TRN_DT;
//Process CRUD
db.Installment_ins.Add(oModelINST);
} //End if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_CREATE)
//Update
if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_UPDATE)
{
oModelINST = db.Installment_ins.AsNoTracking().SingleOrDefault(fld => fld.ID == poViewModel.ID);
//Map Form Data
oModelINST.InjectFrom(poViewModel.MONTHLY_INST);
//Set Field Header
oModelINST.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set DTA_STS : Set in METHOD controller
//oModelINST.DTA_STS = this.DTA_STS;
//Process CRUD
db.Entry(oModelINST).State = EntityState.Modified;
} //End if (poViewModel.MONTHLY_INST.DTA_STS == valFLAG.FLAG_DTA_STS_UPDATE)
//Update database
db.SaveChanges();
this.INST_ID = oModelINST.ID;
//TRNDetail
Transaction_ind oModelTRN_detail = null;
foreach (var item in poViewModel.DETAIL)
{
oModelTRN_detail = new Transaction_ind();
item.TRN_ID = this.ID;
item.INST_ID = this.INST_ID;
//Map Form Data
oModelTRN_detail.InjectFrom(item);
//Set Field Header
oModelTRN_detail.setFIELD_HEADER(this.FIELD_HEADER);
//Set DTA_STS
oModelTRN_detail.DTA_STS = this.DTA_STS;
//Process CRUD
db.Transaction_inds.Add(oModelTRN_detail);
} //End foreach (var item in poViewModel.DETAIL)
//Update database
db.SaveChanges();
} //End using
} //End try
catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Create: " + e.Message; } //End catch
} //End public void Create_bulk
} //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
} //End public void Create
public void Update(Employee_DetailVM poViewModel, HttpPostedFileBase poFileimage)
{
string vsMsgErr = "";
try
{
using (var db = new DBMAINContext())
{
#region Employee
Employee oModel = db.Employees.AsNoTracking().SingleOrDefault(fld => fld.RUID == poViewModel.RUID);
//Map Form Data
Mapper.CreateMap <Employee_DetailVM, Employee>();
oModel = Mapper.Map <Employee_DetailVM, Employee>(poViewModel);
//Set Field Header
oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
//Set DTA_STS
oModel.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.UPDATE);
//Set RES_TYPE
oModel.setRES_TYPE();
//Set Image file name
if (poFileimage != null)
{
oModel.IMG_SRC = Utility_FileUploadDownload.setImage(oModel.RUID);
Utility_FileUploadDownload.saveImage_Employee(poFileimage, oModel.IMG_SRC);
} //End if (poFileimage != null)
//Process CRUD
db.Entry(oModel).State = EntityState.Modified;
db.SaveChanges();
#endregion
#region Employee_address
//Delete old address
var oModel_address = db.Employee_addresss.Where(fld => fld.RES_RUID == poViewModel.RUID);
foreach (Employee_address item in oModel_address)
{
db.Employee_addresss.Remove(item);
} //End foreach
//Set Address DOMISILI
Employee_address oModel_addressKTP = new Employee_address();
//Set Field Header
oModel_addressKTP.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
//Set DTA_STS
oModel_addressKTP.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.CREATE);
//Set Address KTP
oModel_addressKTP.DTA_STS = oModel.DTA_STS;
//oModel_addressKTP.BP_STS = poViewModel.
oModel_addressKTP.RES_RUID = oModel.RUID;
oModel_addressKTP.CNTRY_RUID = poViewModel.CNTRY_RUID_IC;
oModel_addressKTP.CITY_RUID = poViewModel.CITY_RUID_IC;
oModel_addressKTP.ZIP = poViewModel.ZIP_IC;
oModel_addressKTP.ADDR_TYP = oModel.setAddressIC();
oModel_addressKTP.ADDR1 = poViewModel.ADDR1_IC;
oModel_addressKTP.ADDR2 = poViewModel.ADDR2_IC;
oModel_addressKTP.ADDR3 = poViewModel.ADDR3_IC;
//oModel_addressKTP.ADDR4 = poViewModel.
//oModel_addressKTP.ADDR5 = poViewModel.
//Set Address DOMISILI
Employee_address oModel_addressDOM = new Employee_address();
//Set Field Header
oModel_addressDOM.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
//Set DTA_STS
oModel_addressDOM.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.CREATE);
oModel_addressDOM.DTA_STS = oModel.DTA_STS;
//oModel_addressDOM.BP_STS = poViewModel.
oModel_addressDOM.RES_RUID = oModel.RUID;
oModel_addressDOM.CNTRY_RUID = poViewModel.CNTRY_RUID_DMCL;
oModel_addressDOM.CITY_RUID = poViewModel.CITY_RUID_DMCL;
oModel_addressDOM.ZIP = poViewModel.ZIP_DMCL;
oModel_addressDOM.ADDR_TYP = oModel.setAddressDMCL();
oModel_addressDOM.ADDR1 = poViewModel.ADDR1_DMCL;
oModel_addressDOM.ADDR2 = poViewModel.ADDR2_DMCL;
oModel_addressDOM.ADDR3 = poViewModel.ADDR3_DMCL;
//oModel_addressDOM.ADDR4 = poViewModel.
//oModel_addressDOM.ADDR5 = poViewModel.
//Process CRUD
db.Employee_addresss.Add(oModel_addressKTP);
db.Employee_addresss.Add(oModel_addressDOM);
db.SaveChanges();
#endregion
} //End using
} //End try
catch (Exception e) { vsMsgErr = e.Message; } //End catch
} //End public void Update