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