public int SaveMileStone(TrackingMileStoneModel TMSM)
{
var result = dbContext.TrackingMileStones.Where(a => a.TrackingMileStoneId == TMSM.TrackingMileStoneId).FirstOrDefault();
var ShipHandelCount = dbContext.TrackingMileStones.Where(a => a.ShipmentHandlerMethodId == TMSM.ShipmentHandlerMethodId).ToList();
if (result == null)
{
TrackingMileStone TMS = new TrackingMileStone();
TMS.MileStoneKey = TMSM.MileStoneKey;
TMS.Description = TMSM.Description;
TMS.OrderNumber = TMSM.OrderNumber;
TMS.ShipmentHandlerMethodId = TMSM.ShipmentHandlerMethodId;
TMS.CreatedBy = TMSM.CreatedBy;
TMS.CreatedOnUtc = DateTime.UtcNow;
TMS.UpdatedBy = TMSM.UpdatedBy;
TMS.UpdatedOnUtc = DateTime.UtcNow;
dbContext.TrackingMileStones.Add(TMS);
dbContext.SaveChanges();
SetOrderAddEdit(TMS);
return(TMS.TrackingMileStoneId);
}
else
{
result.MileStoneKey = TMSM.MileStoneKey;
result.Description = TMSM.Description;
result.OrderNumber = TMSM.OrderNumber;
result.ShipmentHandlerMethodId = TMSM.ShipmentHandlerMethodId;
result.UpdatedBy = TMSM.UpdatedBy;
result.UpdatedOnUtc = DateTime.UtcNow;
dbContext.Entry(result).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
SetOrderAddEdit(result);
return(result.TrackingMileStoneId);
}
}
public bool SetOrderAddEdit(TrackingMileStone order)
{
if (order != null)
{
var result2 = dbContext.TrackingMileStones.Where(a => a.TrackingMileStoneId != order.TrackingMileStoneId).ToList();
var Res = result2.Where(a => a.ShipmentHandlerMethodId == order.ShipmentHandlerMethodId).ToList();
//var resultSmaller = Res.Where(a => a.OrderNumber < order.OrderNumber).OrderBy(a => a.OrderNumber).ToList();
var result = Res.Where(a => a.OrderNumber >= order.OrderNumber).OrderBy(a => a.OrderNumber).ToList();
if (result == null || result.Count == 0)
{
}
else if (result != null && result.Count > 0)
{
//var res = dbContext.TrackingMileStones.Where(a => a.OrderNumber >= order.OrderNumber).ToList();
var Count = 1;
foreach (var result1 in result)
{
result1.OrderNumber = order.OrderNumber + Count;
dbContext.Entry(result1).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
Count++;
}
}
}
return(true);
}
public bool SetOrderDelete(TrackingMileStone TM)
{
var Res = dbContext.TrackingMileStones.Where(a => a.ShipmentHandlerMethodId == TM.ShipmentHandlerMethodId).ToList();
var res = Res.Where(a => a.OrderNumber >= TM.OrderNumber).OrderBy(a => a.OrderNumber).ToList();
if (res != null)
{
var count1 = 1;
foreach (var result in res)
{
result.OrderNumber = result.OrderNumber - 1;
dbContext.Entry(result).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
count1++;
}
}
return(true);
}
