private BaseResponse UpdateKpiAchievement(IEnumerable <ConfigurationViewModel.Item> data)
{
var response = new BaseResponse {
IsSuccess = false, Message = "Data Not Valid"
};
if (data != null)
{
var batch = new BatchUpdateKpiAchievementRequest();
foreach (var datum in data)
{
var prepare = new UpdateKpiAchievementItemRequest()
{
Id = datum.Id, KpiId = datum.KpiId, Periode = datum.Periode, Value = datum.Value, PeriodeType = datum.PeriodeType, Remark = datum.Remark
}; // data.MapTo<UpdateKpiAchievementItemRequest>();
batch.BatchUpdateKpiAchievementItemRequest.Add(prepare);
}
response = _kpiAchievementService.BatchUpdateKpiAchievements(batch);
}
return(response);
}
UpdateKpiAchievementItemResponse UpdateKpiAchievementItem(UpdateKpiAchievementItemRequest request)
{
var response = new UpdateKpiAchievementItemResponse();
try
{
var kpiAchievement = request.MapTo <KpiAchievement>();
if (request.Id != 0)
{
var attachedEntity = DataContext.KpiAchievements.Find(request.Id);
if (attachedEntity != null && DataContext.Entry(attachedEntity).State != EntityState.Detached)
{
DataContext.Entry(attachedEntity).State = EntityState.Detached;
}
DataContext.KpiAchievements.Attach(kpiAchievement);
DataContext.Entry(kpiAchievement).State = EntityState.Modified;
DataContext.SaveChanges();
}
else
{
kpiAchievement.Kpi = DataContext.Kpis.FirstOrDefault(x => x.Id == request.KpiId);
DataContext.KpiAchievements.Add(kpiAchievement);
DataContext.SaveChanges();
}
response.Id = kpiAchievement.Id;
response.IsSuccess = true;
response.Message = "KPI Achievement item has been updated successfully";
}
catch (InvalidOperationException invalidOperationException)
{
response.Message = invalidOperationException.Message;
}
catch (ArgumentNullException argumentNullException)
{
response.Message = argumentNullException.Message;
}
return(response);
}
private BaseResponse UpdateKpiAchievement(IEnumerable <ConfigurationViewModel.Item> data)
{
var response = new BaseResponse {
IsSuccess = false, Message = "Data Not Valid"
};
if (data != null)
{
var batch = new BatchUpdateKpiAchievementRequest();
foreach (var datum in data)
{
var prepare = new UpdateKpiAchievementItemRequest()
{
Id = datum.Id, KpiId = datum.KpiId, Periode = datum.Periode, Value = datum.Value, PeriodeType = datum.PeriodeType, Remark = datum.Remark, UpdateFrom = "KPIAchievementForm"
}; // data.MapTo<UpdateKpiAchievementItemRequest>();
batch.BatchUpdateKpiAchievementItemRequest.Add(prepare);
}
batch.ControllerName = "File";
batch.ActionName = "ProcessFile";
batch.UserId = UserProfile().UserId;
response = _kpiAchievementService.BatchUpdateKpiAchievements(batch);
}
return(response);
}
public void Process(SaveKpiTransformationScheduleResponse kpiTransformationSchedule)
{
var action = new DSLNG.PEAR.Data.Entities.BaseAction {
UserId = kpiTransformationSchedule.UserId,
ControllerName = kpiTransformationSchedule.ControllerName,
ActionName = kpiTransformationSchedule.ActionName
};
var kpiPattern = @"k(\d+)";
JobManager.AddJob(() =>
{
var complete = true;
using (var dataContext = new DataContext())
{
var kpiAchievementService = new KpiAchievementService(dataContext);
var logService = new KpiTransformationLogService(dataContext);
var kpiTransformationScheduleService = new KpiTransformationScheduleService(dataContext);
var kpiService = new KpiService(dataContext);
#region loop date
foreach (var kpi in kpiTransformationSchedule.SelectedKpis)
{
for (var date = kpiTransformationSchedule.Start; date <= kpiTransformationSchedule.End; date = Increment(kpiTransformationSchedule, date))
{
try
{
var kpiTransformed = kpi.CustomFormula;
var ytdTransformed = kpi.CustomFormula;
var mtdTransformed = kpi.CustomFormula;
var itdTransformed = kpi.CustomFormula;
var existingKpiActual = kpiAchievementService.GetKpiAchievement(kpi.Id, date, kpiTransformationSchedule.PeriodeType);
// exception. could not be run because data dependency not found before Sept 30, 2016
// di remark kembali karena permintaan tanggal 25 Januari 2017, see Telegram
//if ((kpi.Id == 37 || kpi.Id == 8) && date < new DateTime(2016, 09, 30))
//{
// continue;
//}
// pilih yang methodnya formula
if (kpi.MethodId == 1)
{
if (string.IsNullOrEmpty(kpi.CustomFormula))
{
//log here for dependency error
var logRequest = new SaveKpiTransformationLogRequest
{
KpiId = kpi.Id,
KpiTransformationScheduleId = kpiTransformationSchedule.Id, PeriodeType = kpiTransformationSchedule.PeriodeType,
Periode = date,
Status = KpiTransformationStatus.Error, MethodId = kpi.MethodId,
Notes = "Method input is formula but the formula is not defined"
};
logService.Save(logRequest);
continue;
}
Regex r = new Regex(kpiPattern, RegexOptions.IgnoreCase);
Match m = r.Match(kpi.CustomFormula);
var meetRequirements = true;
while (m.Success)
{
Group g = m.Groups[1];
var relatedKpiId = int.Parse(g.Value);
var relatedKpiActual = kpiAchievementService.GetKpiAchievement(relatedKpiId, date, kpiTransformationSchedule.PeriodeType);
if (relatedKpiActual.IsSuccess && relatedKpiActual.Value.HasValue)
{
kpiTransformed = Regex.Replace(kpiTransformed, "k" + g.Value, (relatedKpiActual.Value % 1) == 0 ? relatedKpiActual.Value.ToString() + ".00" : relatedKpiActual.Value.ToString(), RegexOptions.IgnoreCase);
if (kpi.YtdFormula == YtdFormula.Custom)
{
if ((relatedKpiActual.Mtd.HasValue && relatedKpiActual.Ytd.HasValue && relatedKpiActual.Itd.HasValue && kpiTransformationSchedule.PeriodeType == PeriodeType.Daily) ||
(relatedKpiActual.Ytd.HasValue && relatedKpiActual.Itd.HasValue && kpiTransformationSchedule.PeriodeType == PeriodeType.Monthly) ||
(relatedKpiActual.Itd.HasValue && kpiTransformationSchedule.PeriodeType == PeriodeType.Yearly))
{
switch (kpiTransformationSchedule.PeriodeType)
{
case PeriodeType.Daily:
mtdTransformed = Regex.Replace(mtdTransformed, "k" + g.Value, relatedKpiActual.Mtd.ToString(), RegexOptions.IgnoreCase);
ytdTransformed = Regex.Replace(ytdTransformed, "k" + g.Value, relatedKpiActual.Ytd.ToString(), RegexOptions.IgnoreCase);
itdTransformed = Regex.Replace(itdTransformed, "k" + g.Value, relatedKpiActual.Itd.ToString(), RegexOptions.IgnoreCase);
break;
case PeriodeType.Monthly:
ytdTransformed = Regex.Replace(ytdTransformed, "k" + g.Value, relatedKpiActual.Ytd.ToString(), RegexOptions.IgnoreCase);
itdTransformed = Regex.Replace(itdTransformed, "k" + g.Value, relatedKpiActual.Itd.ToString(), RegexOptions.IgnoreCase);
break;
case PeriodeType.Yearly:
itdTransformed = Regex.Replace(itdTransformed, "k" + g.Value, relatedKpiActual.Itd.ToString(), RegexOptions.IgnoreCase);
break;
default:
break;
}
}
else
{
//log here for dependency error
var logRequest = new SaveKpiTransformationLogRequest
{
KpiId = kpi.Id,
KpiTransformationScheduleId = kpiTransformationSchedule.Id, PeriodeType = kpiTransformationSchedule.PeriodeType,
Periode = date,
Status = KpiTransformationStatus.Error, MethodId = kpi.MethodId,
Notes = "The aggregation for <strong>" + relatedKpiActual.Kpi.Name + " (" + relatedKpiActual.Kpi.Measurement + ")</strong> has not been proceed"
};
logService.Save(logRequest);
meetRequirements = false;
complete = false;
}
}
}
else
{
var relatedKpi = kpiService.GetBy(new Services.Requests.Kpi.GetKpiRequest {
Id = relatedKpiId
});
var logRequest = new SaveKpiTransformationLogRequest
{
KpiId = kpi.Id,
KpiTransformationScheduleId = kpiTransformationSchedule.Id, PeriodeType = kpiTransformationSchedule.PeriodeType,
Periode = date,
Status = KpiTransformationStatus.Error, MethodId = kpi.MethodId,
Notes = "Kpi <strong>" + relatedKpi.Name + " (" + relatedKpi.Measurement.Name + ")</strong> has no value for this periode of time"
};
logService.Save(logRequest);
meetRequirements = false;
complete = false;
}
m = m.NextMatch();
}
if (kpi.YtdFormula == YtdFormula.Custom)
{
if (meetRequirements)
{
var kpiActualRequest = new UpdateKpiAchievementItemRequest
{
Id = existingKpiActual.IsSuccess ? existingKpiActual.Id : 0,
KpiId = kpi.Id,
Periode = date,
PeriodeType = kpiTransformationSchedule.PeriodeType,
Value = null,
UserId = kpiTransformationSchedule.UserId,
ControllerName = action.ControllerName,
ActionName = action.ActionName
};
if (kpiTransformed != kpi.CustomFormula)
{
var val = new Expression(kpiTransformed).Evaluate().ToString();
if (!Double.IsInfinity(double.Parse(val)) && !Double.IsNaN(double.Parse(val)))
{
kpiActualRequest.Value = val; //new Expression(kpiTransformed).Evaluate().ToString();
}
else
{
var logRequest = new SaveKpiTransformationLogRequest
{
KpiId = kpi.Id,
KpiTransformationScheduleId = kpiTransformationSchedule.Id, PeriodeType = kpiTransformationSchedule.PeriodeType,
Periode = date,
Status = KpiTransformationStatus.Error, MethodId = kpi.MethodId,
Notes = "Infinite Result",
NeedCleanRowWhenError = true
};
logService.Save(logRequest);
complete = false;
continue;
}
}
if (mtdTransformed != kpi.CustomFormula)
{
var val = double.Parse(new Expression(mtdTransformed).Evaluate().ToString());
if (!Double.IsInfinity(val) && !Double.IsNaN(val))
{
kpiActualRequest.Mtd = val;
}
else
{
var logRequest = new SaveKpiTransformationLogRequest
{
KpiId = kpi.Id,
KpiTransformationScheduleId = kpiTransformationSchedule.Id, PeriodeType = kpiTransformationSchedule.PeriodeType,
Periode = date,
Status = KpiTransformationStatus.Error, MethodId = kpi.MethodId,
Notes = "Infinite Result",
NeedCleanRowWhenError = true
};
logService.Save(logRequest);
complete = false;
continue;
}
}
if (ytdTransformed != kpi.CustomFormula)
{
var ytd = double.Parse(new Expression(ytdTransformed).Evaluate().ToString());
if (!Double.IsInfinity(ytd) && !Double.IsNaN(ytd))
{
kpiActualRequest.Ytd = ytd;
}
else
{
var logRequest = new SaveKpiTransformationLogRequest
{
KpiId = kpi.Id,
KpiTransformationScheduleId = kpiTransformationSchedule.Id, PeriodeType = kpiTransformationSchedule.PeriodeType,
Periode = date,
Status = KpiTransformationStatus.Error, MethodId = kpi.MethodId,
Notes = "Infinite Result",
NeedCleanRowWhenError = true
};
logService.Save(logRequest);
complete = false;
continue;
}
}
if (itdTransformed != kpi.CustomFormula)
{
var itd = double.Parse(new Expression(itdTransformed).Evaluate().ToString());
if (!Double.IsInfinity(itd) && !Double.IsNaN(itd))
{
kpiActualRequest.Itd = itd;
}
else
{
var logRequest = new SaveKpiTransformationLogRequest
{
KpiId = kpi.Id,
KpiTransformationScheduleId = kpiTransformationSchedule.Id, PeriodeType = kpiTransformationSchedule.PeriodeType,
Periode = date,
Status = KpiTransformationStatus.Error, MethodId = kpi.MethodId,
Notes = "Infinite Result",
NeedCleanRowWhenError = true
};
logService.Save(logRequest);
complete = false;
continue;
}
}
kpiActualRequest.UpdateDeviation = true;
var resp = kpiAchievementService.UpdateKpiAchievementItem(kpiActualRequest);
if (resp.IsSuccess)
{
var thatYear = new DateTime(date.Year, 1, 1);
var existingYearKpiActual = kpiAchievementService.GetKpiAchievement(kpi.Id, thatYear, PeriodeType.Yearly);
var kpiactualYearlyRequest = new UpdateKpiAchievementItemRequest
{
Id = existingYearKpiActual.IsSuccess ? existingYearKpiActual.Id : 0,
KpiId = kpi.Id,
Periode = thatYear,
PeriodeType = PeriodeType.Yearly,
Value = kpiActualRequest.Ytd.ToString(),
UserId = kpiTransformationSchedule.UserId,
Itd = kpiActualRequest.Itd,
ControllerName = action.ControllerName,
ActionName = action.ActionName
};
switch (kpiTransformationSchedule.PeriodeType)
{
case PeriodeType.Daily:
var theDate = new DateTime(date.Year, date.Month, 1);
var existingMonthlyKpiActual = kpiAchievementService.GetKpiAchievement(kpi.Id, theDate, PeriodeType.Monthly);
var kpiActualMonthlyRequest = new UpdateKpiAchievementItemRequest
{
Id = existingMonthlyKpiActual.IsSuccess ? existingMonthlyKpiActual.Id : 0,
KpiId = kpi.Id,
Periode = theDate,
PeriodeType = PeriodeType.Monthly,
Value = kpiActualRequest.Mtd.ToString(),
UserId = kpiTransformationSchedule.UserId,
Ytd = kpiActualRequest.Ytd,
Itd = kpiActualRequest.Itd,
ControllerName = action.ControllerName,
ActionName = action.ActionName
};
kpiAchievementService.UpdateKpiAchievementItem(kpiActualMonthlyRequest);
//kpiAchievementService.UpdateKpiAchievementItem(kpi.Id, PeriodeType.Monthly, new DateTime(date.Year, date.Month, 1), kpiActualRequest.Mtd, kpiTransformationSchedule.UserId);
//kpiAchievementService.UpdateKpiAchievementItem(kpi.Id, PeriodeType.Yearly, new DateTime(date.Year, 1, 1), kpiActualRequest.Ytd, kpiTransformationSchedule.UserId);
kpiAchievementService.UpdateKpiAchievementItem(kpiactualYearlyRequest);
break;
case PeriodeType.Monthly:
kpiAchievementService.UpdateKpiAchievementItem(kpiactualYearlyRequest);
//kpiAchievementService.UpdateKpiAchievementItem(kpi.Id, PeriodeType.Yearly, new DateTime(date.Year, 1, 1), kpiActualRequest.Ytd, kpiTransformationSchedule.UserId);
break;
default:
break;
}
var logRequest = new SaveKpiTransformationLogRequest
{
KpiId = kpi.Id,
KpiTransformationScheduleId = kpiTransformationSchedule.Id, PeriodeType = kpiTransformationSchedule.PeriodeType,
Periode = date,
Status = KpiTransformationStatus.Complete,
};
logService.Save(logRequest);
}
else
{
var logRequest = new SaveKpiTransformationLogRequest
{
KpiId = kpi.Id,
KpiTransformationScheduleId = kpiTransformationSchedule.Id, PeriodeType = kpiTransformationSchedule.PeriodeType,
Periode = date,
Status = KpiTransformationStatus.Error, MethodId = kpi.MethodId,
Notes = resp.Message
};
logService.Save(logRequest);
complete = false;
}
}
}
else
{
if (meetRequirements)
{
var request = new UpdateKpiAchievementItemRequest
{
Periode = date,
PeriodeType = kpiTransformationSchedule.PeriodeType,
Id = existingKpiActual.IsSuccess ? existingKpiActual.Id : 0,
KpiId = kpi.Id,
UserId = kpiTransformationSchedule.UserId,
Value = new Expression(kpiTransformed).Evaluate().ToString(),
ControllerName = action.ControllerName,
ActionName = action.ActionName
};
var resp = kpiAchievementService.UpdateOriginalData(request);
if (resp.IsSuccess)
{
//if(kpi.YtdFormula == YtdFormula.NaN)
//{
// switch (kpiTransformationSchedule.PeriodeType)
// {
// case PeriodeType.Daily:
// kpiAchievementService.UpdateKpiAchievementItem(kpi.Id, PeriodeType.Monthly, new DateTime(date.Year, date.Month, 1), double.Parse(request.Value), kpiTransformationSchedule.UserId);
// kpiAchievementService.UpdateKpiAchievementItem(kpi.Id, PeriodeType.Yearly, new DateTime(date.Year, 1, 1), double.Parse(request.Value), kpiTransformationSchedule.UserId);
// break;
// case PeriodeType.Monthly:
// kpiAchievementService.UpdateKpiAchievementItem(kpi.Id, PeriodeType.Yearly, new DateTime(date.Year, 1, 1), double.Parse(request.Value), kpiTransformationSchedule.UserId);
// break;
// default:
// break;
// }
//}
var logRequest = new SaveKpiTransformationLogRequest
{
KpiId = kpi.Id,
KpiTransformationScheduleId = kpiTransformationSchedule.Id, PeriodeType = kpiTransformationSchedule.PeriodeType,
Periode = date,
Status = KpiTransformationStatus.Complete,
};
logService.Save(logRequest);
}
else
{
var logRequest = new SaveKpiTransformationLogRequest
{
KpiId = kpi.Id,
KpiTransformationScheduleId = kpiTransformationSchedule.Id, PeriodeType = kpiTransformationSchedule.PeriodeType,
Periode = date,
Status = KpiTransformationStatus.Error, MethodId = kpi.MethodId,
Notes = resp.Message
};
logService.Save(logRequest);
complete = false;
}
}
}
}
else
{
var request = new UpdateKpiAchievementItemRequest
{
Periode = date,
PeriodeType = kpiTransformationSchedule.PeriodeType,
Id = existingKpiActual.IsSuccess ? existingKpiActual.Id : 0,
KpiId = kpi.Id,
UserId = kpiTransformationSchedule.UserId,
Value = existingKpiActual.Value.ToString(),
Remark = existingKpiActual.Remark,
ControllerName = action.ControllerName,
ActionName = action.ActionName
};
var resp = kpiAchievementService.UpdateOriginalData(request);
if (resp.IsSuccess)
{
if (date == kpiTransformationSchedule.End)
{
}
var logRequest = new SaveKpiTransformationLogRequest
{
KpiId = kpi.Id,
KpiTransformationScheduleId = kpiTransformationSchedule.Id, PeriodeType = kpiTransformationSchedule.PeriodeType,
Periode = date,
Status = KpiTransformationStatus.Complete,
};
logService.Save(logRequest);
}
else
{
var logRequest = new SaveKpiTransformationLogRequest
{
KpiId = kpi.Id,
KpiTransformationScheduleId = kpiTransformationSchedule.Id, PeriodeType = kpiTransformationSchedule.PeriodeType,
Periode = date,
Status = KpiTransformationStatus.Error, MethodId = kpi.MethodId,
Notes = resp.Message
};
logService.Save(logRequest);
complete = false;
}
}
}
catch (Exception e)
{
var logRequest = new SaveKpiTransformationLogRequest
{
KpiId = kpi.Id,
KpiTransformationScheduleId = kpiTransformationSchedule.Id, PeriodeType = kpiTransformationSchedule.PeriodeType,
Periode = date,
Status = KpiTransformationStatus.Error, MethodId = kpi.MethodId,
Notes = string.Format("Excception Message :{0}<br/>Inner Exception Message : {1}", e.Message, e.InnerException != null ? e.InnerException.Message : "")
};
logService.Save(logRequest);
complete = false;
}
}
}
if (complete)
{
kpiTransformationScheduleService.UpdateStatus(kpiTransformationSchedule.Id, KpiTransformationStatus.Complete);
}
else
{
kpiTransformationScheduleService.UpdateStatus(kpiTransformationSchedule.Id, KpiTransformationStatus.Error);
}
#endregion
}
}, (s) => s.ToRunNow());
}
public ActionResult UpdateKpi(UpdateKpiOriginalViewModel viewModel)
{
if (viewModel.Id == 0 && viewModel.Value == null)
{
return(null);
}
var sPeriodeType = viewModel.Type.Split('-')[0];
var periodeType = (PeriodeType)Enum.Parse(typeof(PeriodeType), sPeriodeType, true);
var theDate = DateTime.ParseExact(viewModel.Date, "MM/dd/yyyy", CultureInfo.InvariantCulture);
switch (periodeType)
{
case PeriodeType.Monthly:
theDate = new DateTime(theDate.Year, theDate.Month, 1);
break;
case PeriodeType.Yearly:
theDate = new DateTime(theDate.Year, 1, 1);
break;
}
switch (viewModel.Type)
{
case "daily-actual":
{
var request = new UpdateKpiAchievementItemRequest
{
Periode = theDate,
PeriodeType = periodeType,
Id = viewModel.Id,
KpiId = viewModel.KpiId,
UserId = UserProfile().UserId,
Value = viewModel.ValueType == "value" ? viewModel.Value : null,
Remark = viewModel.ValueType == "remark" ? viewModel.Value : null,
ControllerName = "Der Input Form",
ActionName = string.Format("UpdateKPI daily-actual KPI:{0}", viewModel.KpiId),
ValueType = viewModel.ValueType
};
var resp = _kpiAchievementService.UpdateOriginalData(request, true);
return(Json(resp));
}
case "monthly-actual":
{
var request = new UpdateKpiAchievementItemRequest
{
Periode = theDate,
PeriodeType = periodeType,
Id = viewModel.Id,
KpiId = viewModel.KpiId,
UserId = UserProfile().UserId,
Value = viewModel.ValueType == "value" ? viewModel.Value : null,
Remark = viewModel.ValueType == "remark" ? viewModel.Value : null,
ControllerName = "Der Input Form",
ActionName = string.Format("UpdateKPI monthly-actual KPI:{0}", viewModel.KpiId),
ValueType = viewModel.ValueType
};
var resp = _kpiAchievementService.UpdateOriginalData(request, true);
return(Json(resp));
}
case "yearly-actual":
{
var request = new UpdateKpiAchievementItemRequest
{
Periode = theDate,
PeriodeType = periodeType,
Id = viewModel.Id,
KpiId = viewModel.KpiId,
UserId = UserProfile().UserId,
Value = viewModel.ValueType == "value" ? viewModel.Value : null,
Remark = viewModel.ValueType == "remark" ? viewModel.Value : null,
ControllerName = "Der Input Form",
ActionName = string.Format("UpdateKPI yearly-actual KPI:{0}", viewModel.KpiId),
ValueType = viewModel.ValueType
};
var resp = _kpiAchievementService.UpdateOriginalData(request, true);
return(Json(resp));
}
// case gila-gilaan
case "monthly-actual-prev":
{
var request = new UpdateKpiAchievementItemRequest
{
Periode = theDate.AddMonths(-1),
PeriodeType = periodeType,
Id = viewModel.Id,
KpiId = viewModel.KpiId,
UserId = UserProfile().UserId,
Value = viewModel.ValueType == "value" ? viewModel.Value : null,
Remark = viewModel.ValueType == "remark" ? viewModel.Value : null,
ControllerName = "Der Input Form",
ActionName = string.Format("UpdateKPI monthly-actual-prev KPI:{0}", viewModel.KpiId),
ValueType = viewModel.ValueType
};
var resp = _kpiAchievementService.UpdateOriginalData(request, true);
return(Json(resp));
}
case "monthly-actual-jcc":
{
var request = new UpdateKpiAchievementItemRequest
{
Periode = theDate,
PeriodeType = periodeType,
Id = viewModel.Id,
KpiId = viewModel.KpiId,
UserId = UserProfile().UserId,
Value = viewModel.ValueType == "value" ? viewModel.Value : null,
Remark = viewModel.ValueType == "remark" ? viewModel.Value : null,
ControllerName = "Der Input Form",
ActionName = string.Format("UpdateKPI monthly-actual-jcc KPI:{0}", viewModel.KpiId),
};
var resp = _kpiAchievementService.UpdateCustomJccFormula(request);
return(Json(resp));
}
case "monthly-actual-bunker":
{
var request = new UpdateKpiAchievementItemRequest
{
Periode = theDate,
PeriodeType = periodeType,
Id = viewModel.Id,
KpiId = viewModel.KpiId,
UserId = UserProfile().UserId,
Value = viewModel.ValueType == "value" ? viewModel.Value : null,
Remark = viewModel.ValueType == "remark" ? viewModel.Value : null,
ControllerName = "Der Input Form",
ActionName = string.Format("UpdateKPI monthly-actual-bunker KPI:{0}", viewModel.KpiId),
};
var resp = _kpiAchievementService.UpdateCustomBunkerPriceFormula(request);
return(Json(resp));
}
case "daily-actual-dafwc":
{
string value = viewModel.ValueType == "value" ? viewModel.Value : null;
if (viewModel.Value != null && viewModel.ValueType == "remark")
{
DateTime lastDAFWC;
DateTime.TryParse(viewModel.Value, out lastDAFWC);
if (lastDAFWC != null)
{
value = (theDate - lastDAFWC).TotalDays.ToString();
}
}
var request = new UpdateKpiAchievementItemRequest
{
Periode = theDate,
PeriodeType = periodeType,
Id = viewModel.Id,
KpiId = viewModel.KpiId,
UserId = UserProfile().UserId,
Value = value,
Remark = viewModel.ValueType == "remark" ? viewModel.Value : null,
ControllerName = "Der Input Form",
ActionName = string.Format("UpdateKPI monthly-actual-dafwc KPI:{0}", viewModel.KpiId),
ValueType = viewModel.ValueType
};
var resp = _kpiAchievementService.UpdateOriginalData(request, true);
return(Json(resp));
}
default:
{
var request = new SaveKpiTargetRequest
{
Periode = theDate,
PeriodeType = periodeType,
Id = viewModel.Id,
KpiId = viewModel.KpiId,
UserId = UserProfile().UserId,
Value = viewModel.ValueType == "value" ? viewModel.Value : null,
Remark = viewModel.ValueType == "remark" ? viewModel.Value : null,
ControllerName = "Der Input Form",
ActionName = string.Format("UpdateKPI Save KPI Target Request KPI:{0}", viewModel.KpiId)
};
var resp = _kpiTargetService.UpdateOriginalData(request);
return(Json(resp));
}
}
}
public UpdateKpiAchievementItemResponse UpdateKpiAchievementItem(UpdateKpiAchievementItemRequest request)
{
var response = new UpdateKpiAchievementItemResponse();
try
{
var user = DataContext.Users.First(x => x.Id == request.UserId);
var kpiAchievement = request.MapTo <KpiAchievement>();
if (request.Id > 0)
{
if (string.IsNullOrEmpty(request.Value) || request.Value == "-" || request.Value.ToLowerInvariant() == "null")
{
kpiAchievement = DataContext.KpiAchievements.Single(x => x.Id == request.Id);
DataContext.KpiAchievements.Remove(kpiAchievement);
}
else
{
kpiAchievement = DataContext.KpiAchievements
.Include(x => x.Kpi)
.Include(x => x.UpdatedBy)
.Single(x => x.Id == request.Id);
request.MapPropertiesToInstance <KpiAchievement>(kpiAchievement);
kpiAchievement.UpdatedBy = user;
kpiAchievement.Kpi = DataContext.Kpis.Single(x => x.Id == request.KpiId);
}
}
else if (request.Id == 0)
{
if ((string.IsNullOrEmpty(request.Value) || request.Value == "-" ||
request.Value.ToLowerInvariant() == "null") && request.Id == 0)
{
response.IsSuccess = false;
response.Message = "You can not update this item because it is not existed";
return(response);
}
else
{
kpiAchievement.CreatedBy = user;
kpiAchievement.UpdatedBy = user;
kpiAchievement.Kpi = DataContext.Kpis.Single(x => x.Id == request.KpiId);
DataContext.KpiAchievements.Add(kpiAchievement);
}
}
DataContext.SaveChanges();
response.Id = request.Id > 0 ? request.Id : kpiAchievement.Id;
response.IsSuccess = true;
response.Message = "KPI Achievement item has been updated successfully";
}
catch (InvalidOperationException invalidOperationException)
{
response.Message = invalidOperationException.Message;
}
catch (ArgumentNullException argumentNullException)
{
response.Message = argumentNullException.Message;
}
return(response);
}
