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