public bool Add(EF.KPI entity)
{
try
{
for (int i = 1; i < 10000; i++)
{
string code = i.ToString("D4");
if (_dbContext.KPIs.FirstOrDefault(x => x.Code == code) == null)
{
entity.Code = code;
break;
}
}
_dbContext.KPIs.Add(entity);
_dbContext.SaveChanges();
List <EF.KPILevel> kpiLevelList = new List <EF.KPILevel>();
var levels = _dbContext.Levels.ToList();
foreach (var level in levels)
{
var kpilevel = new EF.KPILevel();
kpilevel.LevelID = level.ID;
kpilevel.KPIID = entity.ID;
kpiLevelList.Add(kpilevel);
}
_dbContext.KPILevels.AddRange(kpiLevelList);
_dbContext.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool Update(EF.KPI entity)
{
entity.Code = entity.Code.ToUpper();
try
{
var iteam = _dbContext.KPIs.FirstOrDefault(x => x.ID == entity.ID);
iteam.Name = entity.Name;
iteam.Code = entity.Code;
iteam.LevelID = entity.LevelID;
iteam.CategoryID = entity.CategoryID;
_dbContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
var message = ex.Message;
//logging
return(false);
}
}
public async Task <bool> Update(EF.KPI entity)
{
entity.Code = entity.Code.ToSafetyString().ToUpper();
try
{
var iteam = await _dbContext.KPIs.FirstOrDefaultAsync(x => x.ID == entity.ID);
iteam.Name = entity.Name;
//iteam.Code = entity.Code;
iteam.LevelID = entity.LevelID;
iteam.CategoryID = entity.CategoryID;
iteam.Unit = entity.Unit;
await _dbContext.SaveChangesAsync();
return(true);
}
catch (Exception ex)
{
var message = ex.Message;
//logging
return(false);
}
}
