public void CreateCPAR(User_DetailCPARVM poViewModel, HttpPostedFileBase poFileimage)
{
string vsMsgErr = "";
try
{
using (var db = new DBMAINContext())
{
#region User Area
User oModel = new User();
//Map Form Data
//Mapper.CreateMap<User_DetailCPARVM, User>();
//oModel = Mapper.Map<User_DetailCPARVM, User>(poViewModel);
//Set Field Header
oModel.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
//Set DTA_STS
oModel.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.CREATE);
//Set BP_STS (Active)
oModel.setActivate();
//Set model from Viewmodel
oModel.USR_ID = poViewModel.USR_ID;
oModel.USR_NM1 = poViewModel.USR_NM1;
//Encrypt password
oModel.USR_PSWD = hlpObf.randomEncrypt(poViewModel.USR_PSWD);
#endregion
#region Employee Area
Employee oModelEmployee = new Employee();
//Set Field Header
oModelEmployee.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
//Set DTA_STS
oModelEmployee.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.CREATE);
//Set RES_TYPE
oModelEmployee.setRES_TYPE();
//Set BP_STS
oModelEmployee.setActivate();
//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
//Set RES_RUID in User Table
oModel.RES_RUID = oModelEmployee.RUID;
//Process CRUD
db.Users.Add(oModel);
db.Employees.Add(oModelEmployee);
//Save to Database
db.SaveChanges();
this.RUID = oModel.RUID;
} //End using
} //End try
catch (Exception e) { vsMsgErr = e.Message; } //End catch
} //End public void CreateCPAR(User_DetailCPARVM poViewModel, HttpPostedFileBase poFileimage)
} //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 static List<User_ListVM> getDatalist()
public List<User_ListVM> getDatalist(User_DetailCPARVM poViewModel)
{
List<User_ListVM> oReturn;
using (var db = new DBMAINContext())
{
List<string> sNotIn = new List<string>();
sNotIn.Add(valDFLT.USR_IDSYSTEM); sNotIn.Add(valDFLT.USR_IDGENERAL); sNotIn.Add(valDFLT.USR_IDDEMO);
var oQRY = from tb in db.User_infos
where !sNotIn.Contains(tb.USR_ID)
select new User_ListVM
{
RUID = tb.RUID,
DTA_STS = tb.DTA_STS,
BP_STS = tb.BP_STS,
ROLE_RUID = tb.ROLE_RUID,
ROLE_NM = tb.ROLE_NM,
USR_ID = tb.USR_ID,
USR_NM1 = tb.USR_NM1,
RES_NM1 = tb.RES_NM1,
DEPT_NM = tb.DEPT_NM,
BRNCH_NM = tb.BRNCH_NM,
JOB_TITLE_NM = tb.JOB_TITLE_NM,
IMG_SRC = tb.IMG_SRC,
RES_RUID = tb.RES_RUID
};
if ((poViewModel.ROLE_RUID != "") && (poViewModel.ROLE_RUID != null)) { oQRY = oQRY.Where(fld => fld.ROLE_RUID == poViewModel.ROLE_RUID); }
if ((poViewModel.FILTER_ROLE != "") && (poViewModel.FILTER_ROLE != null)) { oQRY = oQRY.Where(fld => fld.ROLE_NM.ToUpper().Contains(poViewModel.FILTER_ROLE.ToUpper())); }
if ((poViewModel.FILTER_DEPARTEMEN != "") && (poViewModel.FILTER_DEPARTEMEN != null)) { oQRY = oQRY.Where(fld => fld.DEPT_NM.ToUpper().Contains(poViewModel.FILTER_DEPARTEMEN.ToUpper())); }
if ((poViewModel.FILTER_NAMA != "") && (poViewModel.FILTER_NAMA != null)) { oQRY = oQRY.Where(fld => fld.USR_NM1.ToUpper().Contains(poViewModel.FILTER_NAMA.ToUpper())); }
oReturn = oQRY.OrderBy(fld => fld.USR_ID).ToList();
} //End using (var = new DbContext())
return oReturn;
} //End public List<User_ListVM> getDatalist(User_DetailCPARVM poViewModel = null)
//Constructor 2
public User_Validation(User_DetailCPARVM poViewModel, HttpPostedFileBase poFileimage)
{
oViewModelCPAR = poViewModel;
} //End public User_Validation()