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();
}
}
}
