public IActionResult Insert_Unit([FromQuery] UnitAddOREditParam model) // done { string status; status = repository_unit.Insert_Unit(model); return(Json(status)); }
public IActionResult Update_Unit([FromBody] UnitAddOREditParam model) // done { string status; status = repository_unit.Update_Unit(model); return(Json(status)); }
public string Update_Unit(UnitAddOREditParam unit) { string status; using (var transaction = context.Database.BeginTransaction()) { try { var id_unit = (from b in context.Unit where b.IdUnit != unit.IdUnit && b.NameUnit.ToLower().Contains(unit.Name.ToLower()) select b.IdUnit).Count(); if (id_unit == 0) { var result = context.Unit.Where(b => b.IdUnit == unit.IdUnit).SingleOrDefault(); if (result != null) { result.NameUnit = unit.Name; context.SaveChanges(); status = constant.SUCCEES; } else { status = constant.NULL; } } else { status = constant.DUPLICATE; } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); status = constant.ERROR; } } return(status); }
public string Insert_Unit(UnitAddOREditParam model) { string status; using (var transaction = context.Database.BeginTransaction()) { try { var id_unit = (from b in context.Unit where b.NameUnit.ToLower() == (model.Name.ToLower()) select b.IdUnit).Count(); if (id_unit == 0) { var result = context.Unit.Where(a => a.NameUnit == model.Name).Count(); var nou = new Unit() { NameUnit = model.Name }; context.Unit.Add(nou); context.SaveChanges(); status = constant.SUCCEES; } else { status = constant.DUPLICATE; } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); status = constant.ERROR; } } return(status); }