public static Responses Delete(int Id)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
m_unit m_unit = db.m_unit.Where(o => o.id == Id).FirstOrDefault();
if (m_unit != null)
{
db.m_unit.Remove(m_unit);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public ResSubmit ThemMoiUnit(UnitAdd unitAdd)
{
tongcuclamnghiepEntities tongcuclamnghiep = new tongcuclamnghiepEntities();
ResSubmit resSubmit = new ResSubmit(true, "Thêm mới thành công");
if (!(unitAdd.unitname.Length >= 10 && unitAdd.unitname.Length <= 4000))
{
resSubmit = new ResSubmit(false, "Tên đơn vị không hợp lệ");
}
if (resSubmit.success && tongcuclamnghiep.m_unit.Any(a => a.unitname == unitAdd.unitname))
{
resSubmit = new ResSubmit(false, "Tên đơn vị đã tồn tại");
}
if (resSubmit.success && (unitAdd.account_id != 0 && unitAdd.account_id != null) && !tongcuclamnghiep.m_account.Where(a => a.role_id == 2 && a.id == unitAdd.account_id && a.status == true).ToList().Any(a => !tongcuclamnghiep.m_unit.Any(c => c.account_id == a.id)))
{
resSubmit = new ResSubmit(false, "Tài khoản quản lý không hợp lệ");
}
if (resSubmit.success)
{
m_unit _Unit = new m_unit();
_Unit.account_id = ((unitAdd.account_id != 0 && unitAdd.account_id != null) ? unitAdd.account_id : null);
_Unit.address = unitAdd.address;
_Unit.status = true;
_Unit.unitname = unitAdd.unitname;
_Unit.dientich1 = (unitAdd.dientich1 != null ? unitAdd.dientich1 : 0);
_Unit.dientich2 = (unitAdd.dientich2 != null ? unitAdd.dientich2 : 0);
_Unit.ngansachnhannuoc1 = (unitAdd.ngansachnhannuoc1 != null ? unitAdd.ngansachnhannuoc1 : 0);
_Unit.ngansachnhanuoc2 = (unitAdd.ngansachnhanuoc2 != null ? unitAdd.ngansachnhanuoc2 : 0);
_Unit.ngaythanhlap = unitAdd.ngaythanhlap;
_Unit.tongcanbo1 = (unitAdd.tongcanbo1 != null ? unitAdd.tongcanbo1 : 0);
_Unit.tongcanbo2 = (unitAdd.tongcanbo2 != null ? unitAdd.tongcanbo2 : 0);
tongcuclamnghiep.m_unit.Add(_Unit);
if (tongcuclamnghiep.SaveChanges() != 1)
{
resSubmit = new ResSubmit(false, "Thêm mới thất bại");
}
else
{
m_unitversion _Unitversion = new m_unitversion();
_Unitversion.createdate = DateTime.Now;
_Unitversion.datatext = unitAdd.UnitVersionText;
_Unitversion.unit_id = _Unit.id;
_Unitversion.status = true;
_Unitversion.version = 1;
_Unitversion.dientich1 = _Unit.dientich1;
_Unitversion.dientich2 = _Unit.dientich2;
_Unitversion.ngansachnhannuoc1 = _Unit.ngansachnhannuoc1;
_Unitversion.ngansachnhanuoc2 = _Unit.ngansachnhanuoc2;
_Unitversion.ngaythanhlap = _Unit.ngaythanhlap;
_Unitversion.tongcanbo1 = _Unit.tongcanbo1;
_Unitversion.tongcanbo2 = _Unit.tongcanbo2;
tongcuclamnghiep.m_unitversion.Add(_Unitversion);
tongcuclamnghiep.SaveChanges();
}
}
return(resSubmit);
}
// update
public static bool update(mUnitVM model)
{
bool result = false;
using (AppEntity db = new AppEntity())
{
m_unit item = db.m_unit.Find(model.id);
item.code = model.code;
item.name = model.name;
item.description = model.description;
item.updated_by = 2;
item.updated_date = DateTime.Now.Date;
try { db.SaveChanges(); result = true; } catch (Exception) { throw; }
}
return(result);
}
public static Responses update(M_UnitViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
m_unit m_unit = db.m_unit.Where(o => o.id == entity.Id).FirstOrDefault();
if (m_unit != null)
{
m_unit.code = entity.Code;
m_unit.name = entity.Name;
m_unit.description = entity.Description;
m_unit.is_delete = entity.IsDelete;
m_unit.updated_by = "David";
m_unit.updated_date = DateTime.Now;
db.SaveChanges();
}
}
else
{
m_unit m_unit = new m_unit();
m_unit.code = GetNewCode();
m_unit.name = entity.Name;
m_unit.description = entity.Description;
m_unit.is_delete = entity.IsDelete;
m_unit.created_by = "David";
m_unit.created_date = DateTime.Now;
db.m_unit.Add(m_unit);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static bool insert(mUnitVM model)
{
bool result = false;
using (AppEntity db = new AppEntity())
{
m_unit item = new m_unit()
{
code = model.code,
name = model.name,
description = model.description,
is_active = true,
created_by = 1,
created_date = DateTime.Now.Date,
updated_by = 1,
updated_date = DateTime.Now.Date,
};
db.m_unit.Add(item);
try { db.SaveChanges(); result = true; } catch (Exception) { throw; }
}
return(result);
}
public static string CreateUnit(UnitViewModel paramDataUnit)
{
string latestSaveCode = string.Empty;
using (var db = new MarkomApplicationDBEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
m_unit c = new m_unit();
c.code = UnitCode();
c.name = paramDataUnit.name;
c.description = paramDataUnit.description;
c.is_delete = paramDataUnit.isDelete;
c.create_by = paramDataUnit.createBy;
c.create_date = paramDataUnit.createDate;
db.m_unit.Add(c);
db.SaveChanges();
dbContextTransaction.Commit();
//get latest save code
latestSaveCode = c.code;
}
catch (Exception ex)
{
Message = ex.Message;
dbContextTransaction.Rollback();
//throw;
}
}
}
return(latestSaveCode);
}
