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 CheckTrackingMileStoneKey(TrackingMileStoneModel TrackingMSM)
{
var Res = dbContext.TrackingMileStones.Where(a => a.ShipmentHandlerMethodId == TrackingMSM.ShipmentHandlerMethodId).ToList();
var result = Res.Where(a => a.MileStoneKey == TrackingMSM.MileStoneKey).FirstOrDefault();
if (result != null)
{
return(true);
}
else
{
return(false);
}
}
public bool CheckOrderNo(TrackingMileStoneModel order)
{
var result = dbContext.TrackingMileStones.Where(a => a.ShipmentHandlerMethodId == order.ShipmentHandlerMethodId).Select(s => s.OrderNumber).ToList();
if (result != null && result.Count > 0 && order.TrackingMileStoneId == 0)
{
var maxval = result.Max() + 1;
if (order.OrderNumber != 0 && order.OrderNumber <= maxval)
{
return(false);
}
else
{
return(true);
}
}
else
{
var maxval = 0;
if (result.Count > 0)
{
maxval = result.Max();
}
else
{
maxval = 1;
}
if (order.OrderNumber != 0 && order.OrderNumber <= maxval)
{
return(false);
}
else
{
return(true);
}
}
}
public List <TrackingMileStoneModel> GetTrackingMileStone(int ShipmentHandlerMethodId)
{
List <TrackingMileStoneModel> SMList = new List <TrackingMileStoneModel>();
var ShipMileStn = dbContext.TrackingMileStones.Where(a => a.ShipmentHandlerMethodId == ShipmentHandlerMethodId).ToList();
if (ShipMileStn != null)
{
foreach (var SHMet in ShipMileStn)
{
TrackingMileStoneModel TMS = new TrackingMileStoneModel();
TMS.TrackingMileStoneId = SHMet.TrackingMileStoneId;
TMS.MileStoneKey = SHMet.MileStoneKey;
TMS.Description = SHMet.Description;
TMS.OrderNumber = SHMet.OrderNumber;
TMS.CreatedBy = SHMet.CreatedBy;
TMS.CreatedOnUtc = SHMet.CreatedOnUtc;
TMS.UpdatedBy = SHMet.UpdatedBy.Value;
TMS.UpdatedOnUtc = SHMet.UpdatedOnUtc.Value;
TMS.ShipmentHandlerMethodId = SHMet.ShipmentHandlerMethodId;
SMList.Add(TMS);
}
}
return(SMList.OrderBy(a => a.OrderNumber).ToList());
}
public bool CheckOrderNo(TrackingMileStoneModel order)
{
return(new TrackingMileStoneRepository().CheckOrderNo(order));
}
public IHttpActionResult CheckTrackingMileStoneKey(TrackingMileStoneModel TrackingMSM)
{
var Result = new TrackingMileStoneRepository().CheckTrackingMileStoneKey(TrackingMSM);
return(Ok(Result));
}
public IHttpActionResult SaveMileStone(TrackingMileStoneModel TMSM)
{
var res = new TrackingMileStoneRepository().SaveMileStone(TMSM);
return(Ok(res));
}
