public ActionResult Edit(int?areaId) { Logger.Info(_logMsg.Clear().SetPrefixMsg("Edit Area").Add("areaId", areaId).ToInputLogString()); if (areaId.HasValue) { var areaVM = new AreaEditViewModel(); _areaFacade = new AreaFacade(); //get area section AreaItemEntity areaItemEntity = _areaFacade.GetArea(areaId.Value); areaVM.AreaId = areaItemEntity.AreaId; areaVM.txtAreaName = areaItemEntity.AreaName; areaVM.AreaCode = areaItemEntity.AreaCode; areaVM.txtCreateUser = areaItemEntity.CreateUser != null ? areaItemEntity.CreateUser.FullName : ""; areaVM.txtUpdateUser = areaItemEntity.UpdateUser != null ? areaItemEntity.UpdateUser.FullName : ""; areaVM.txtCreateDateTime = DateUtil.ToStringAsDateTime(areaItemEntity.CreateDate); areaVM.txtUpdateDateTime = DateUtil.ToStringAsDateTime(areaItemEntity.UpdateDate); areaVM.txtUpdateUser = areaItemEntity.UpdateDate.HasValue ? DateUtil.ToStringAsDateTime(areaItemEntity.UpdateDate) : ""; areaVM.selectStatus = areaItemEntity.Status; areaVM.StatusList = new List <SelectListItem>(); areaVM.StatusList.Add(new SelectListItem() { Text = "Active", Value = "true" }); areaVM.StatusList.Add(new SelectListItem() { Text = "Inactive", Value = "false" }); areaVM.SubAreaSearchFilter = new SelectSubAreaSearchFilter { SubAreaName = string.Empty, SubAreaIdList = string.Empty, PageNo = 1, PageSize = 15, SortField = "SubAreaName", SortOrder = "ASC" }; areaVM.SelectSearchFilter = new SelectSubAreaSearchFilter { PageNo = 1, PageSize = 15, SortField = "SubAreaName", SortOrder = "ASC" }; ViewBag.PageSize = areaVM.SubAreaSearchFilter.PageSize; ViewBag.Message = string.Empty; return(View(areaVM)); } return(View("Create")); }
public JsonResult SaveArea(AreaSaveViewModel model, string idSubAreas) { Logger.Info(_logMsg.Clear().SetPrefixMsg("Save Area").Add("IdSubAreas", idSubAreas).Add("AreaName", model.AreaName).ToInputLogString()); try { if (ModelState.IsValid) { _areaFacade = new AreaFacade(); //validate area name var isValidate = _areaFacade.ValidateAreaName(model.AreaId, model.AreaName); if (!isValidate) { return(Json(new { is_success = false, message = Resource.Error_SaveFailedDuplicate })); } AreaItemEntity areaEntity = new AreaItemEntity { AreaId = model.AreaId, AreaName = model.AreaName, AreaCode = model.AreaCode, Status = model.Status, UserId = UserInfo.UserId }; var isSuccess = _areaFacade.SaveArea(areaEntity, idSubAreas); return(isSuccess ? Json(new { is_success = true, message = "บันทึก Area สำเร็จ" }) : Json(new { is_success = false, message = "บันทึก Area ไม่สำเร็จ" })); } return(Json(new { is_success = false, message = string.Empty })); } catch (Exception ex) { Logger.Error("Exception occur:\n", ex); Logger.Info(_logMsg.Clear().SetPrefixMsg("Save Area").Add("Error Message", ex.Message).ToFailLogString()); return(Json(new { is_success = false, message = string.Format(CultureInfo.InvariantCulture, "Error : {0}", ex.Message) })); } }
public bool SaveArea(AreaItemEntity areaItemEntity, string idSubAreas) { _context.Configuration.AutoDetectChangesEnabled = false; try { var isEdit = areaItemEntity.AreaId.HasValue; TB_M_AREA area; if (!isEdit) { //add area = new TB_M_AREA(); area.AREA_CODE = GetNextAreaCode(); } else { area = _context.TB_M_AREA.SingleOrDefault(a => a.AREA_ID == areaItemEntity.AreaId.Value); if (area == null) { Logger.ErrorFormat("SUBAREA ID: {0} does not exist", areaItemEntity.AreaId); return(false); } } area.AREA_NAME = areaItemEntity.AreaName; //area.AREA_CODE = Convert.ToDecimal(areaItemEntity.AreaCode); area.AREA_IS_ACTIVE = areaItemEntity.Status; area.UPDATE_USER = areaItemEntity.UserId; area.UPDATE_DATE = DateTime.Now; if (!isEdit) { area.CREATE_USER = areaItemEntity.UserId; area.CREATE_DATE = DateTime.Now; _context.TB_M_AREA.Add(area); this.Save(); //save area_subarea if (!string.IsNullOrEmpty(idSubAreas)) { string[] idSubAreasArray = idSubAreas.Split(','); foreach (var idSubArea in idSubAreasArray) { var areaSubArea = new TB_M_AREA_SUBAREA(); areaSubArea.AREA_ID = area.AREA_ID; areaSubArea.SUBAREA_ID = Convert.ToInt32(idSubArea, CultureInfo.InvariantCulture); areaSubArea.CREATE_USER = areaItemEntity.UserId; areaSubArea.CREATE_DATE = DateTime.Now; _context.TB_M_AREA_SUBAREA.Add(areaSubArea); Save(); } } } else { SetEntryStateModified(area); //delete area_subarea var areaSubAreaList = _context.TB_M_AREA_SUBAREA.Where(a => a.AREA_ID == areaItemEntity.AreaId); foreach (var areaSubAreaItem in areaSubAreaList) { _context.TB_M_AREA_SUBAREA.Remove(areaSubAreaItem); } this.Save(); //update area_subarea if (!string.IsNullOrEmpty(idSubAreas)) { string[] idSubAreasArray = idSubAreas.Split(','); foreach (var idSubArea in idSubAreasArray) { var areaSubArea = new TB_M_AREA_SUBAREA(); areaSubArea.AREA_ID = area.AREA_ID; areaSubArea.SUBAREA_ID = Convert.ToInt32(idSubArea, CultureInfo.InvariantCulture); areaSubArea.CREATE_USER = areaItemEntity.UserId; areaSubArea.CREATE_DATE = DateTime.Now; _context.TB_M_AREA_SUBAREA.Add(areaSubArea); this.Save(); } } } this.Save(); return(true); } catch (Exception ex) { Logger.Error("Exception occur:\n", ex); return(false); } finally { _context.Configuration.AutoDetectChangesEnabled = true; } }
public bool SaveArea(AreaItemEntity areaItemEntity, string idSubAreas) { _areaDataAccess = new AreaDataAccess(_context); return(_areaDataAccess.SaveArea(areaItemEntity, idSubAreas)); }