public ActionResult LoadExcel(MISS02P001Model model)
{
var jsonResult = new JsonResult();
if (ModelState.IsValid)
{
model.ds = ExcelData.TBL_SELECT;
model.CLIENT_ID = TempModel.CLIENT_ID = Guid.NewGuid().ToString();
model.COM_CODE = model.APP_CODE; //checked
model.FILE_EXCEL = ExcelData.UPLOAD_FILENAME;
var result = SaveData("Upload", model);
if (result.IsResult)
{
if (model.ERROR_CODE == "0" && model.ERROR_MSG == "")
{
TempModel.ERROR_CODE = "C";
return(Json(new WEBAPP.Models.AjaxResult("Upload", true, AlertStyles.Success, "Load Excel File Completed!")));
}
else
{
return(Json(new WEBAPP.Models.AjaxResult("Upload", false, AlertStyles.Error, "Load Excel File InComplete!")));
}
}
return(Json(new WEBAPP.Models.AjaxResult("Upload", false, AlertStyles.Error, "Load Excel File InComplete!" + " " + result.ResultMsg)));
}
else
{
jsonResult = ValidateError(ModelState, StandardActionName.SaveModify);
}
return(jsonResult);
}
public ActionResult Edit(MISS02P001Model model)
{
SetDefaulButton(StandardButtonMode.Modify);
TempModel.YEAR = model.YEAR;
localModel.YEAR = model.YEAR;
TempModel.APP_CODE = model.COM_CODE;
localModel.APP_CODE = model.COM_CODE;
SetDefaultData(); //set ค่า DDL
return(View(StandardActionName.Edit, localModel));
}
public ActionResult Index()
{
SetDefaulButton(StandardButtonMode.Index);
AddStandardButton(StandardButtonName.DownloadTemplate, url: "MISS02TP001");
//AddStandardButton(StandardButtonName.LoadFile);
AddStandardButton(StandardButtonName.Upload);
if (TempSearch.IsDefaultSearch && !Request.GetRequest("page").IsNullOrEmpty())
{
localModel = TempSearch.CloneObject();
}
SetDefaultData();
return(View(StandardActionName.Index, localModel));
}
public ActionResult CD_DUP(MISS02P001Model model)
{
var da = new MISS02P001DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = MISS02P001ExecuteType.cd_dup;
da.DTO.Model = model;
da.SelectNoEF(da.DTO);
return(JsonAllowGet(da.DTO.Model));
}
public ActionResult SaveModify(MISS02P001Model model)
{
var jsonResult = new JsonResult();
if (ModelState.IsValid)
{
model.COM_CODE = TempModel.APP_CODE = model.APP_CODE;
var result = SaveData(StandardActionName.SaveModify, model);
jsonResult = Success(result, StandardActionName.SaveModify, Url.Action(StandardActionName.Index, new { page = 1 }));
}
else
{
jsonResult = ValidateError(ModelState, StandardActionName.SaveModify);
}
return(jsonResult);
}
public ActionResult Search(MISS02P001Model model)
{
var da = new MISS02P001DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = MISS02P001ExecuteType.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));
}
