public void MigrateOldDb(DateTime dtFrom, DateTime dtTo)
{
var categories = dbContext.Categories.AsNoTracking().ToList();
dtFrom = dtFrom.Date;
dtTo = dtTo.Date + new TimeSpan(23, 59, 59);
var oldInTheMachines = dbContext.InTheMachines.AsNoTracking().ToList();
foreach (var oldIntTheMachine in oldInTheMachines)
{
var category = categories.FirstOrDefault(a => a.CategoryIdOld == oldIntTheMachine.CATID);
var weekDetail = new WeekDetail(oldIntTheMachine.DT);
var newMachineUnBaledWaste = new MachineUnBaledWaste()
{
CategoryId = category?.CategoryId ?? 0,
DT = oldIntTheMachine.DT,
FirstDay = weekDetail.FirstDay,
LastDay = weekDetail.LastDay,
MC = oldIntTheMachine.MC,
WeekDay = weekDetail.WeekDay,
WeekNum = weekDetail.WeekNum,
Wt = (int)oldIntTheMachine.ITHWeight
};
dbContext.MachineUnBaledWastes.Add(newMachineUnBaledWaste);
dbContext.SaveChanges();
}
;
}
private bool validateEntity(MachineUnBaledWaste model)
{
var modelErrors = repository.Validate(model);
if (modelErrors.Count > 0)
{
foreach (var modelError in modelErrors)
{
ModelState.AddModelError(modelError.Key, modelError.Value);
}
}
return(ModelState.ErrorCount == 0);
}
public Dictionary <string, string> Validate(MachineUnBaledWaste model)
{
var modelErrors = new Dictionary <string, string>();
var duplicateCount = dbContext.MachineUnBaledWastes.AsNoTracking().Count(a => a.CategoryId == model.CategoryId && a.DT == model.DT && a.MachineUnBaledWasteId != model.MachineUnBaledWasteId);
if (duplicateCount > 0)
{
modelErrors.Add(nameof(model.CategoryId), "Entry with the same date and category already exists");
}
return(modelErrors);
}
public MachineUnBaledWaste Create(MachineUnBaledWaste model)
{
if (model.DT == new DateTime(1, 1, 1))
{
model.DT = DateTime.Now;
}
var weekDetail = new WeekDetail(model.DT);
model.WeekDay = weekDetail.WeekDay;
model.WeekNum = weekDetail.WeekNum;
model.FirstDay = weekDetail.FirstDay;
model.LastDay = weekDetail.LastDay;
dbContext.MachineUnBaledWastes.Add(model);
dbContext.SaveChanges();
return(model);
}
public IActionResult Put([FromBody] MachineUnBaledWaste model)
{
try
{
if (!ModelState.IsValid)
{
return(InvalidModelStateResult());
}
if (!validateEntity(model))
{
return(InvalidModelStateResult());
}
return(Accepted(repository.Update(model)));
}
catch (Exception ex)
{
logger.LogError(ex.GetExceptionMessages());
return(StatusCode(StatusCodes.Status500InternalServerError, Constants.ErrorMessages.UpdateError));
}
}
public MachineUnBaledWaste Update(MachineUnBaledWaste model)
{
var entity = dbContext.MachineUnBaledWastes.Find(model.MachineUnBaledWasteId);
if (entity == null)
{
throw new Exception("Selected Record does not exists.");
}
if (model.DT == new DateTime(1, 1, 1))
{
model.DT = DateTime.Now;
}
entity.CategoryId = model.CategoryId;
entity.Wt = model.Wt;
entity.MC = model.MC;
entity.DT = model.DT;
dbContext.MachineUnBaledWastes.Update(entity);
dbContext.SaveChanges();
return(entity);
}
public bool Delete(MachineUnBaledWaste model)
{
dbContext.MachineUnBaledWastes.Remove(model);
dbContext.SaveChanges();
return(true);
}
