public HttpResponseMessage postUpdate(MasterDepartmentView model) { try { //check dupplicate branchCode var isDupplicate = departmentSvc.CheckDupplicate(model.departmentCode, model.departmentId); if (isDupplicate) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, string.Format("รหัสแผนก {0} มีอยู่ในระบบแล้ว", model.departmentCode))); } if (model.status == "I") { if (!departmentSvc.CanInactive(model.departmentId)) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, string.Format("รหัส {0} มีการใช้งานอยู่ไม่สามารถ Inactive ได้", model.departmentCode))); } } departmentSvc.Update(model); return(Request.CreateResponse(HttpStatusCode.OK, "บันทึกข้อมูลสำเร็จ")); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.ToString())); } }
public void SyncUpdate(MasterDepartmentView product) { using (var ctx = new ConXContext()) { using (TransactionScope scope = new TransactionScope()) { } } }
public void Update(MasterDepartmentView department) { using (var ctx = new ConXContext()) { using (TransactionScope scope = new TransactionScope()) { Department updateObj = ctx.Departments.Where(z => z.departmentId == department.departmentId).SingleOrDefault(); updateObj.departmentCode = department.departmentCode; updateObj.departmentName = department.departmentName; updateObj.status = department.status; updateObj.updateDatetime = DateTime.Now; ctx.SaveChanges(); scope.Complete(); } } }
public HttpResponseMessage postCreate(MasterDepartmentView model) { try { //check dupplicate branchCode var isDupplicate = departmentSvc.CheckDupplicate(model.departmentCode, 0); if (isDupplicate) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, string.Format("รหัสแผนก {0} มีอยู่ในระบบแล้ว", model.departmentCode))); } departmentSvc.Create(model); return(Request.CreateResponse(HttpStatusCode.OK, "บันทึกข้อมูลสำเร็จ")); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.ToString())); } }
public void Create(MasterDepartmentView department) { using (var ctx = new ConXContext()) { using (TransactionScope scope = new TransactionScope()) { Department newObj = new Department() { departmentCode = department.departmentCode, departmentName = department.departmentName, status = department.status, createUser = "******", createDatetime = DateTime.Now, updateUser = "******", updateDatetime = DateTime.Now }; ctx.Departments.Add(newObj); ctx.SaveChanges(); scope.Complete(); } } }