public ActionResult EditMySelf(string USER_ID)
{
SetDefaulButton(StandardButtonMode.Modify);
var da = new SECS02P002DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SECS02P002ExecuteType.GetUser;
TempModel.USER_ID = da.DTO.Model.USER_ID = USER_ID;
da.Select(da.DTO);
if (da.DTO.Model != null)
{
localModel = da.DTO.Model;
localModel.APP_CODE = da.DTO.Model.COM_CODE;
TempModel.COM_CODE = da.DTO.Model.COM_CODE;
TempModel.IS_DISABLED = "N";
}
SetDefaultData(StandardActionName.Edit);
string view = "EditMySelf";
AddButton(StandButtonType.ButtonAjax, "RePassword", "RePassword", iconCssClass: FaIcons.FaRefresh);
return(View(view, localModel));
}
public ActionResult BindDetailAdd()
{
var da = new SECS02P002DA();
SetStandardErrorLog(da.DTO);
return(JsonAllowGet(da.DTO.Model.Details));
}
private void UpdateLastLogin(string USER_ID)
{
var da = new SECS02P002DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SECS02P002ExecuteType.UpdateLastLogin;
da.DTO.Model.USER_ID = USER_ID;
da.DTO.Model.CRET_DATE = DateTime.Now;
da.UpdateNoEF(da.DTO);
}
public ActionResult GetFullAppName(SECS02P002Model model)
{
var da = new SECS02P002DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SECS02P002ExecuteType.GetFullAppName;
da.DTO.Model.COM_CODE = model.APP_CODE;
da.SelectNoEF(da.DTO);
return(JsonAllowGet(da.DTO.Model.Details[0]));
}
private SECS02P002Model GET_VSMS_USER(string USER_ID)
{
var da = new SECS02P002DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SECS02P002ExecuteType.GetByID;
da.DTO.Model.USER_ID = USER_ID;
da.Select(da.DTO);
return(da.DTO.Model);
}
public ActionResult BindDetail()
{
var da = new SECS02P002DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SECS02P002ExecuteType.GetDetailByID;
da.DTO.Model.USER_ID = TempModel.USER_ID;
da.SelectNoEF(da.DTO);
return(JsonAllowGet(da.DTO.Model.Details));
}
public ActionResult GetOldPwd(string OLD_PWD, string USER_ID)
{
var da = new SECS02P002DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SECS02P002ExecuteType.GetOldPwd;
da.DTO.Model.USER_PWD = OLD_PWD;
da.DTO.Model.USER_ID = USER_ID;
da.SelectNoEF(da.DTO);
return(JsonAllowGet(da.DTO.Model));
}
public ActionResult ForGetPassword(SECS02P002Model model)
{
var da = new SECS02P002DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SECS02P002ExecuteType.ForGetPassword;
model.CRET_BY = SessionHelper.SYS_USER_ID;
model.COM_CODE = SessionHelper.SYS_COM_CODE;
da.DTO.Model = model;
da.UpdateNoEF(da.DTO);
return(JsonAllowGet(da.DTO.Model));
}
public ActionResult Info(string USER_ID)
{
SetDefaulButton(StandardButtonMode.View);
var da = new SECS02P002DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = DTOExecuteType.GetByID;
TempModel.USER_ID = da.DTO.Model.USER_ID = USER_ID;
da.Select(da.DTO);
if (da.DTO.Model != null)
{
localModel = da.DTO.Model;
}
return(View(StandardActionName.Info, localModel));
}
public ActionResult CheckAdmin(SECS02P002Model model)
{
var jsonResult = new JsonResult();
var da = new SECS02P002DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SECS02P002ExecuteType.CheckAdmin;
da.DTO.Model.USG_ID = model.USG_ID;
da.SelectNoEF(da.DTO);
jsonResult = Success(da.DTO.Result, StandardActionName.Add);
return(JsonAllowGet(da.DTO.Model));
//return jsonResult;
}
public ActionResult CustomsExport(SECS02P002Model model)
{
var da = new SECS02P002DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SECS02P002ExecuteType.GetQuerySearchAll;
da.Select(da.DTO);
if (da.DTO.Models != null)
{
ExportHelper.ExportExcel(Response, da.DTO.Models);
}
return(Content("ExportExcel clicked"));
}
public ActionResult Search(SECS02P002Model model)
{
var da = new SECS02P002DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SECS02P002ExecuteType.GetQuerySearchAll;
if (Request.GetRequest("page").IsNullOrEmpty())
{
model.IsDefaultSearch = true;
TempSearch = model;
}
da.DTO.Model = TempSearch;
da.DTO.Model.COM_CODE = SessionHelper.SYS_COM_CODE;
da.Select(da.DTO);
return(JsonAllowGet(da.DTO.Models, da.DTO.Result));
}
private DTOResult SaveData(string mode, object model)
{
var da = new SECS02P002DA();
//ในกรณีที่มีการ SaveLog ให้ Include SetStandardLog ด้วย
SetStandardLog(
da.DTO,
model,
GetSaveLogConfig("dbo", "VSMS_USER", "USER_ID"));
if (mode == StandardActionName.SaveCreate)
{
SetStandardField(model);
da.DTO.Model = (SECS02P002Model)model;
// SetStandardField(da.DTO.Model.ComUserModel);
da.InsertNoEF(da.DTO);
}
else if (mode == StandardActionName.SaveModify)
{
SetStandardField(model);
da.DTO.Model = (SECS02P002Model)model;
da.DTO.Model.COM_CODE = TempModel.COM_CODE;
da.DTO.Execute.ExecuteType = SECS02P002ExecuteType.Update;
//SetStandardField(da.DTO.Model.ComUserModel);
da.UpdateNoEF(da.DTO);
}
else if (mode == "DeleteDetails")
{
da.DTO.Model = new SECS02P002Model();
da.DTO.Models = (List <SECS02P002Model>)model;
da.DTO.Execute.ExecuteType = SECS02P002ExecuteType.DeleteDetail;
da.Delete(da.DTO);
}
else if (mode == StandardActionName.Delete)
{
da.DTO.Model = new SECS02P002Model();
da.DTO.Models = (List <SECS02P002Model>)model;
da.DTO.Execute.ExecuteType = SECS02P002ExecuteType.Delete;
da.DeleteNoEF(da.DTO);
}
return(da.DTO.Result);
}
public ActionResult Edit(string USER_ID)
{
SetDefaulButton(StandardButtonMode.Modify);
var da = new SECS02P002DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SECS02P002ExecuteType.GetByID;
TempModel.USER_ID = da.DTO.Model.USER_ID = USER_ID;
da.Select(da.DTO);
if (da.DTO.Model != null)
{
localModel = da.DTO.Model;
localModel.APP_CODE = da.DTO.Model.COM_CODE;
TempModel.COM_CODE = da.DTO.Model.COM_CODE;
}
SetDefaultData(StandardActionName.Edit);
return(View(StandardActionName.Edit, localModel));
}
