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