public ActionResult AddRefNo(MISS01P001Model model)
{
SetDefaulButton(StandardButtonMode.Create);
AddButton(StandButtonType.ButtonAjax, "GetRefNo", "Reference No", iconCssClass: FaIcons.FaPrint);
SetDefaultData(StandardActionName.Add);
localModel.USER_ID = SessionHelper.SYS_USER_ID;
string view = "AddRefNo";
#region set ref_no
if (!model.REF_NO.IsNullOrEmpty())
{
var da = new MISS01P001DA();
da.DTO.Execute.ExecuteType = MISS01P001ExecuteType.GetReOpen;
da.DTO.Model.NO = model.REF_NO;
da.DTO.Model.REF_NO = model.REF_NO;
da.DTO.Model.APP_CODE = model.COM_CODE;
da.SelectNoEF(da.DTO);
da.DTO.Model.NO = da.DTO.Model.NO + 1;
localModel = da.DTO.Model;
SetDefaultData(StandardActionName.Add);
}
#endregion
return(View(view, localModel));
}
public ActionResult SearchExl()
{
var da = new MISS01P001DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = MISS01P001ExecuteType.GetExl;
da.SelectNoEF(da.DTO);
return(JsonAllowGet(da.DTO.Models, da.DTO.Result));
}
//----------------------------------------------//
private DTOResult SaveData(string mode, object model)
{
var da = new MISS01P001DA();
//ในกรณีที่มีการ SaveLog ให้ Include SetStandardLog ด้วย
Session[SessionSystemName.SYS_APPS] = TempModel.APP_CODE;
SetStandardLog(
da.DTO,
model,
GetSaveLogConfig("dbo", "VSMS_ISSUE", "COM_CODE", "NO"));
if (mode == StandardActionName.SaveCreate)
{
SetStandardFieldWithoutComCode(model);
da.DTO.Model = (MISS01P001Model)model;
da.DTO.Execute.ExecuteType = MISS01P001ExecuteType.Insert;
da.InsertNoEF(da.DTO);
}
else if (mode == StandardActionName.SaveModify)
{
SetStandardFieldWithoutComCode(model);
da.DTO.Execute.ExecuteType = MISS01P001ExecuteType.Update;
da.DTO.Model = (MISS01P001Model)model;
da.UpdateNoEF(da.DTO);
}
else if (mode == "Upload")
{
da.DTO.Execute.ExecuteType = MISS01P001ExecuteType.CallSPInsertExcel;
SetStandardFieldWithoutComCode(model);
da.DTO.Model = (MISS01P001Model)model;
da.InsertNoEF(da.DTO);
if (da.DTO.Result.IsResult)
{
da.DTO.Execute.ExecuteType = MISS01P001ExecuteType.ValidateExl;
da.UpdateNoEF(da.DTO);
}
}
else if (mode == "SaveUpload")
{
da.DTO.Execute.ExecuteType = MISS01P001ExecuteType.SaveExl;
SetStandardFieldWithoutComCode(model);
da.DTO.Model = (MISS01P001Model)model;
da.InsertNoEF(da.DTO);
}
return(da.DTO.Result);
}
public ActionResult GetRefNo(MISS01P001Model model)
{
var jsonResult = new JsonResult();
var da = new MISS01P001DA();
da.DTO.Execute.ExecuteType = MISS01P001ExecuteType.GetNo;
TempModel.APP_CODE = da.DTO.Model.COM_CODE = model.APP_CODE;
da.SelectNoEF(da.DTO);
da.DTO.Model.NO = da.DTO.Model.NO + 1;
localModel.RESPONSE_BY_MODEL = BindResponseByIn();
//jsonResult = Success(da.DTO.Result, StandardActionName.Add);
return(JsonAllowGet(da.DTO.Model));
//return jsonResult;
}
public ActionResult Info(MISS01P001Model model)
{
var da = new MISS01P001DA();
da.DTO.Execute.ExecuteType = MISS01P001ExecuteType.GetByID;
//da.DTO.Model.COM_CODE = SessionHelper.SYS_COM_CODE;
da.DTO.Model.APP_CODE = model.COM_CODE;
da.DTO.Model.NO = model.NO;
da.SelectNoEF(da.DTO);
localModel = da.DTO.Model;
SetDateToString(da.DTO.Model);
SetDefaulButton(StandardButtonMode.Other);
return(View(StandardActionName.Info, localModel));
}
public ActionResult Search(MISS01P001Model model)
{
var da = new MISS01P001DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = MISS01P001ExecuteType.GetAll;
if (Request.GetRequest("page").IsNullOrEmpty())
{
model.IsDefaultSearch = true;
TempSearch = model;
}
da.DTO.Model = TempSearch;
da.DTO.Model.COM_CODE = SessionHelper.SYS_COM_CODE;
da.SelectNoEF(da.DTO);
return(JsonAllowGet(da.DTO.Models, da.DTO.Result));
}
public ActionResult Index(string ACTIVE_STEP = "1")
{
string ACTIVE_WIZARD_MAX = "2";
var view = string.Empty;
var da = new MISS01P001DA();
if (ACTIVE_STEP == "1")
{
view = "Index1";
SetDefaulButton(StandardButtonMode.Index);
RemoveStandardButton("DeleteSearch");
AddStandardButton(StandardButtonName.Upload);
AddStandardButton(StandardButtonName.DownloadTemplate, url: "MISS01TP001");
if (TempSearch.IsDefaultSearch && !Request.GetRequest("page").IsNullOrEmpty())
{
localModel = TempSearch.CloneObject();
}
localModel.USER_ID = SessionHelper.SYS_USER_ID;
SetDefaultData(StandardActionName.Index);
}
else if (ACTIVE_STEP == "2")
{
view = "Index2";
AddButton(StandButtonType.ButtonAjax, "report", "Report Issue", iconCssClass: FaIcons.FaPrint, cssClass: "std-btn-print", url: Url.Action("ViewReport"), isValidate: true);
AddButton(StandButtonType.ButtonAjax, "report", "Summary Issue", iconCssClass: FaIcons.FaPrint, cssClass: "std-btn-print", url: Url.Action("ViewReportSummary"), isValidate: true);
AddButton(StandButtonType.ButtonAjax, "report", "Report02", iconCssClass: FaIcons.FaPrint, cssClass: "std-btn-print", url: Url.Action("ViewReport02"), isValidate: true);
if (TempSearch.IsDefaultSearch && !Request.GetRequest("page").IsNullOrEmpty())
{
localModel = TempSearch.CloneObject();
}
}
SetHeaderWizard(new WizardHelper.WizardHeaderConfig(
ACTIVE_STEP,
ACTIVE_WIZARD_MAX,
new WizardHelper.WizardHeader("", Url.Action("Index", new { ACTIVE_STEP = "1" }), iconCssClass: FaIcons.FaPencil, textStep: Translation.MIS.MISS01P001.Index1),
new WizardHelper.WizardHeader("", Url.Action("Index", new { ACTIVE_STEP = "2" }), iconCssClass: FaIcons.FaSearch, textStep: Translation.MIS.MISS01P001.Index2)));
return(View(view, localModel));
}
public ActionResult Edit(MISS01P001Model model)
{
var da = new MISS01P001DA();
da.DTO.Execute.ExecuteType = MISS01P001ExecuteType.GetByID;
da.DTO.Model.NO = model.NO;
TempModel.APP_CODE = da.DTO.Model.APP_CODE = model.COM_CODE;
da.SelectNoEF(da.DTO);
localModel = da.DTO.Model;
localModel.RESPONSE_BY_MODEL = BindResponseByIn();
Set(localModel);
SetDefaultData(StandardActionName.Edit);
SetDateToString(da.DTO.Model);
SetDefaulButton(StandardButtonMode.Modify);
AddButton(StandButtonType.ButtonAjax, "GetRefNo", "Reference No", iconCssClass: FaIcons.FaPrint);
return(View(StandardActionName.Edit, localModel));
}
public ActionResult GetNo(MISS01P001Model model)
{
var jsonResult = new JsonResult();
var da = new MISS01P001DA();
da.DTO.Execute.ExecuteType = MISS01P001ExecuteType.GetNo;
da.DTO.Model.COM_CODE = model.APP_CODE;
da.SelectNoEF(da.DTO);
if (da.DTO.Model.NO.IsNullOrEmpty())
{
da.DTO.Model.NO = 1;
}
else
{
da.DTO.Model.NO = da.DTO.Model.NO + 1;
}
//jsonResult = Success(da.DTO.Result, StandardActionName.Add);
return(JsonAllowGet(da.DTO.Model));
//return jsonResult;
}
