public IActionResult Update([FromBody] CategoryCommon categoryCommon)
{
var cc = _context.Query <CategoryCommon>().Where(c => c.Id == categoryCommon.Id).FirstOrDefault();
if (cc == null)
{
return(StatusCode(404, _excep.Throw("Not Found")));
}
try
{
//var ccc = _context.Query<CategoryCommon>().Where(c => c.Code == categoryCommon.Code).FirstOrDefault();
//if(ccc!=null) Duplicate Cat.Code
_context.Session.BeginTransaction();
_context.Update <CategoryCommon>(c => c.Id == categoryCommon.Id, x => new CategoryCommon()
{
Code = categoryCommon.Code,
Name = categoryCommon.Name,
IsActive = categoryCommon.IsActive,
UpdateDate = DateTime.Now,
UpdateUserId = categoryCommon.UpdateUserId,
});
_context.Session.CommitTransaction();
Utils.Log(
_contextmdmdb,
"Business",
2,
GetCurrentUserId(),
GetIpClient(),
"/app/category-common",
"Sửa",
categoryCommon,
"Chuyên khoa",
"Sửa chuyên khoa",
true,
GetHealthFacilitiesId(_contextmdmdb, GetCurrentUserId()));
return(Json(new ActionResultDto()));
}
catch (Exception e)
{
if (_context.Session.IsInTransaction)
{
_context.Session.RollbackTransaction();
}
return(StatusCode(500, _excep.Throw("Có lỗi xảy ra", e.Message)));
}
}
public CategoryCommonViewModel(CategoryCommon cc) : this()
{
Id = cc.Id;
Name = cc.Name;
Code = cc.Code;
Type = cc.Type;
IsDelete = cc.IsDelete;
CreateDate = cc.CreateDate;
UpdateDate = cc.UpdateDate;
CreateUserId = cc.CreateUserId;
UpdateUserId = cc.UpdateUserId;
IsActive = cc.IsActive;
IsDelete = cc.IsDelete;
}
public IActionResult Create([FromBody] CategoryCommon categoryCommon)
{
try
{
_context.Session.BeginTransaction();
var cc = _context.Query <CategoryCommon>().Where(c => c.Code.Equals(categoryCommon.Code) && c.IsDelete == false).FirstOrDefault();
if (cc == null)
{
_context.Insert(() => new CategoryCommon
{
Name = categoryCommon.Name,
Code = categoryCommon.Code,
IsActive = categoryCommon.IsActive,
Type = "CHUYENKHOA",
CreateDate = DateTime.Now,
CreateUserId = categoryCommon.CreateUserId,
UpdateDate = DateTime.Now,
UpdateUserId = categoryCommon.UpdateUserId
});
}
else
{
Utils.Log(
_contextmdmdb,
"Business",
2,
GetCurrentUserId(),
GetIpClient(),
"/app/category-common",
"Tạo mới",
categoryCommon,
"Chuyên khoa",
"Tạo mới chuyên khoa",
false,
GetHealthFacilitiesId(_contextmdmdb, GetCurrentUserId()));
return(StatusCode(406, _excep.Throw(406, "Tạo không thành công !", "Mã chuyên khoa đã tồn tại")));
}
_context.Session.CommitTransaction();
Utils.Log(
_contextmdmdb,
"Business",
2,
GetCurrentUserId(),
GetIpClient(),
"/app/category-common",
"Tạo mới",
categoryCommon,
"Chuyên khoa",
"Tạo mới chuyên khoa",
true,
GetHealthFacilitiesId(_contextmdmdb, GetCurrentUserId()));
return(Json(new ActionResultDto()));
}
catch (Exception e)
{
if (_context.Session.IsInTransaction)
{
_context.Session.RollbackTransaction();
}
return(StatusCode(500, _excep.Throw("Có lỗi xảy ra !", e.Message)));
}
}
