public bool CheckTypeName(TypeItemEntity typeItemEntity)
{
var typeName = typeItemEntity.TypeName;
if (!typeItemEntity.TypeId.HasValue)
{
var query = _context.TB_M_TYPE.Where(x => x.TYPE_NAME.ToUpper().Equals(typeName.ToUpper()));
var count = query.Count();
if (count > 0)
{
return(false);
}
else
{
return(true);
}
}
else
{
var query = _context.TB_M_TYPE.Where(x => x.TYPE_NAME.ToUpper().Equals(typeName.ToUpper()) && x.TYPE_ID != typeItemEntity.TypeId);
var count = query.Count();
if (count > 0)
{
return(false);
}
else
{
return(true);
}
}
}
public JsonResult SaveType(TypeSaveViewModel typeSaveVM)
{
Logger.Info(_logMsg.Clear().SetPrefixMsg("Type Save").ToInputLogString());
try
{
if (ModelState.IsValid)
{
TypeItemEntity typeEntity = new TypeItemEntity
{
TypeId = typeSaveVM.TypeId,
TypeName = typeSaveVM.TypeName,
TypeCode = typeSaveVM.TypeCode,
Status = typeSaveVM.Status,
UserId = UserInfo.UserId,
CreateUser = typeSaveVM.CreateUser,
CreateDate = typeSaveVM.CreateDate
};
_typeFacade = new TypeFacade();
if (typeEntity.TypeName.Length <= 100 && typeEntity.TypeName.Length > 0)
{
var checkType = _typeFacade.CheckTypeName(typeEntity);
if (checkType == false)
{
return(Json(new { is_success = false, message = "ชื่อ Type ซ้ำ" }));
}
else
{
var isSuccess = _typeFacade.SaveType(typeEntity);
return(isSuccess
? Json(new { is_success = true, message = "บันทึก Type สำเร็จ" })
: Json(new { is_success = false, message = "บันทึก Type ไม่สำเร็จ" }));
}
}
else
{
return(Json(new { is_success = false, message = "ชื่อ Type ต้องมากกว่าหรือเท่ากับ 1 ตัวอักษร และไม่เกิน 100 ตัวอักษร" }));
}
}
return(Json(new
{
is_success = false,
message = string.Empty
}));
}
catch (Exception ex)
{
Logger.Error("Exception occur:\n", ex);
Logger.Info(_logMsg.Clear().SetPrefixMsg("Type Save").Add("Error Message", ex.Message).ToFailLogString());
return(Json(new { is_success = false, message = string.Format(CultureInfo.InvariantCulture, "Error : {0}", ex.Message) }));
}
}
public bool SaveType(TypeItemEntity typeItemEntity)
{
_context.Configuration.AutoDetectChangesEnabled = false;
var now = DateTime.Now;
try
{
TB_M_TYPE type;
if (!typeItemEntity.TypeId.HasValue)
{
//save
type = new TB_M_TYPE();
type.TYPE_NAME = typeItemEntity.TypeName;
type.TYPE_CODE = Convert.ToDecimal(typeItemEntity.TypeCode);
type.TYPE_IS_ACTIVE = typeItemEntity.Status;
type.CREATE_USER = typeItemEntity.UserId;
type.CREATE_DATE = now;
type.UPDATE_USER = typeItemEntity.UserId;
type.UPDATE_DATE = now;
_context.TB_M_TYPE.Add(type);
Save();
}
else
{
//save
type = _context.TB_M_TYPE.SingleOrDefault(t => t.TYPE_ID == typeItemEntity.TypeId.Value);
type.TYPE_NAME = typeItemEntity.TypeName;
type.TYPE_CODE = Convert.ToDecimal(typeItemEntity.TypeCode);
type.TYPE_IS_ACTIVE = typeItemEntity.Status;
type.UPDATE_USER = typeItemEntity.UserId;
type.UPDATE_DATE = now;
SetEntryStateModified(type);
Save();
}
return(true);
}
catch (Exception ex)
{
Logger.Error("Exception occur:\n", ex);
return(false);
}
finally
{
_context.Configuration.AutoDetectChangesEnabled = true;
}
}
public bool CheckTypeName(TypeItemEntity typeItemEntity)
{
_typeDataAccess = new TypeDataAccess(_context);
return(_typeDataAccess.CheckTypeName(typeItemEntity));
}
public bool SaveType(TypeItemEntity typeItemEntity)
{
_typeDataAccess = new TypeDataAccess(_context);
return(_typeDataAccess.SaveType(typeItemEntity));
}
