public ActionResult DeleteKPI(string id)
{
KPIVM kpi = new KPIVM();
kpi = Mapper.Map <KPIVM>(KPI_DAL.ReadKPIById(id));
return(View(kpi));
}
public async Task <IActionResult> Add2([FromBody] KPIVM entity)
{
await _hubContext.Clients.All.SendAsync("SentMess", "message");
return(Ok(await _KPIService.AddAsync2(entity)));
}
public ActionResult CreateKPI()
{
KPIVM kpi = new KPIVM();
kpi.Assignments = Mapper.Map <List <AssignmentVM> >(AssignmentDAL.ReadAssignments());
kpi.Projects = Mapper.Map <List <ProjectVM> >(ProjectDAL.ReadProjects());
kpi.Sprints = Mapper.Map <List <SprintVM> >(SprintDAL.ReadSprints());
kpi.Stories = Mapper.Map <List <StoryVM> >(StoryDAL.ReadStorys());
return(View(kpi));
}
public ActionResult UpdateKPI(string id)
{
KPIVM kpi = new KPIVM();
kpi = Mapper.Map <KPIVM>(KPI_DAL.ReadKPIById(id));
kpi.Stories = Mapper.Map <List <StoryVM> >(StoryDAL.ReadStorys());
kpi.Projects = Mapper.Map <List <ProjectVM> >(ProjectDAL.ReadProjects());
kpi.Sprints = Mapper.Map <List <SprintVM> >(SprintDAL.ReadSprints());
kpi.Assignments = Mapper.Map <List <AssignmentVM> >(AssignmentDAL.ReadAssignments());
return(View(kpi));
}
public async Task <bool> AddAsync(KPIVM entity)
{
try
{
//string code = string.Empty;
for (int i = 1; i < 10000; i++)
{
string code = i.ToString("D4");
if (!await _dbContext.KPIs.AnyAsync(x => x.Code == code))
{
entity.Code = code;
break;
}
}
var kpi = new KPI {
ID = entity.ID, LevelID = 1, CategoryCode = entity.Code, Unit = entity.Unit, Name = entity.NameEn, CreateTime = DateTime.Now, Code = entity.Code
};
_dbContext.KPIs.Add(kpi);
await _dbContext.SaveChangesAsync();
var listKPILangs = new List <KPILang> {
new KPILang {
Name = entity.NameVI, LanguageID = "vi", KPIID = kpi.ID
},
new KPILang {
Name = entity.NameTW, LanguageID = "zh-TW", KPIID = kpi.ID
},
new KPILang {
Name = entity.NameEn, LanguageID = "en", KPIID = kpi.ID
},
};
_dbContext.KPILangs.AddRange(listKPILangs);
List <KPILevel> kpiLevelList = new List <KPILevel>();
var levels = _dbContext.Levels.ToList();
foreach (var level in levels)
{
var kpilevel = new KPILevel();
kpilevel.LevelID = level.ID;
kpilevel.KPIID = kpi.ID;
kpiLevelList.Add(kpilevel);
}
_dbContext.KPILevels.AddRange(kpiLevelList);
await _dbContext.SaveChangesAsync();
return(true);
}
catch (Exception)
{
return(false);
}
}
public async Task <bool> UpdateAsync(KPIVM entity)
{
entity.Code = entity.Code.ToSafetyString().ToUpper();
try
{
var item = await _dbContext.KPIs.FirstOrDefaultAsync(x => x.ID == entity.ID);
item.Unit = entity.Unit;
item.KPI_Kind_ID = entity.KPI_Kind_ID;
item.Name = entity.NameEn;
item.Description = entity.Description;
item.Status = entity.Status;
var listLang = _dbContext.KPILangs.Where(x => x.KPIID == item.ID).ToList();
if (listLang == null || listLang.Count == 0)
{
var listKPILangs = new List <KPILang> {
new KPILang {
Name = entity.NameVI, LanguageID = "vi", KPIID = item.ID
},
new KPILang {
Name = entity.NameTW, LanguageID = "zh-TW", KPIID = item.ID
},
new KPILang {
Name = entity.NameEn, LanguageID = "en", KPIID = item.ID
},
};
_dbContext.KPILangs.AddRange(listKPILangs);
}
else
{
listLang.ForEach(x =>
{
switch (x.LanguageID)
{
case "zh-TW":
x.Name = entity.NameTW;
break;
case "en":
x.Name = entity.NameEn;
break;
case "vi":
x.Name = entity.NameVI;
break;
default:
break;
}
});
}
await _dbContext.SaveChangesAsync();
return(true);
}
catch (Exception ex)
{
var message = ex.Message;
//logging
return(false);
}
}
public ActionResult DeleteKPI(KPIVM kpi)
{
KPI_DAL.DeleteKPI(Mapper.Map <KPIDM>(kpi));
return(View());
}
public ActionResult CreateKPI(KPIVM kpi)
{
kpi.CreateDate = DateTime.Now;
KPI_DAL.CreateKPI(Mapper.Map <KPIDM>(kpi));
return(View());
}
public async Task <IActionResult> Update([FromBody] KPIVM entity)
{
return(Ok(await _KPIService.UpdateAsync(entity)));
}
