/// <summary>
/// Updates the specified inserted.
/// </summary>
/// <param name="inserted">The inserted.</param>
/// <param name="updated">The updated.</param>
/// <param name="deleted">The deleted.</param>
public void Update(List <BLL.DispatchDetail> inserted, List <BLL.DispatchDetail> updated,
List <BLL.DispatchDetail> deleted)
{
CTSContext db = new CTSContext();
BLL.Dispatch orginal = db.Dispatches.Where(p => p.DispatchID == this.DispatchID).SingleOrDefault();
if (orginal != null)
{
orginal.BidNumber = this.BidNumber;
orginal.DispatchDate = this.DispatchDate;
orginal.DriverName = this.DriverName;
orginal.FDPID = this.FDPID;
orginal.GIN = this.GIN;
orginal.PeriodYear = this.PeriodYear;
orginal.PeriodMonth = this.PeriodMonth;
orginal.PlateNo_Prime = this.PlateNo_Prime;
orginal.PlateNo_Trailer = this.PlateNo_Trailer;
//orginal.ProgramID = this.ProgramID;
orginal.RequisitionNo = this.RequisitionNo;
orginal.Round = this.Round;
//orginal.StackNumber = this.StackNumber;
//orginal.StoreID = this.StoreID;
orginal.TransporterID = this.TransporterID;
orginal.UserProfileID = this.UserProfileID;
//orginal.WarehouseID = this.WarehouseID;
orginal.WeighBridgeTicketNumber = this.WeighBridgeTicketNumber;
orginal.Remark = this.Remark;
orginal.DispatchedByStoreMan = this.DispatchedByStoreMan;
//orginal.ProjectNumber = this.ProjectNumber;
//orginal.SINumber = this.SINumber;
foreach (BLL.DispatchDetail update in updated)
{
BLL.DispatchDetail updatedCommodity = db.DispatchDetails.Where(p => p.DispatchDetailID == update.DispatchDetailID).SingleOrDefault();
if (updatedCommodity != null)
{
updatedCommodity.CommodityID = update.CommodityID;
updatedCommodity.Description = update.Description;
//updatedCommodity.DispatchedQuantityInUnit = update.DispatchedQuantityInUnit;
//updatedCommodity.DispatchedQuantityInMT = update.DispatchedQuantityInMT;
updatedCommodity.RequestedQunatityInUnit = update.RequestedQunatityInUnit;
updatedCommodity.RequestedQuantityInMT = update.RequestedQuantityInMT;
updatedCommodity.UnitID = update.UnitID;
}
}
db.SaveChanges();
}
}
/// <summary>
/// Generates the dispatch model.
/// </summary>
/// <param name="dispatch">The dispatch.</param>
/// <param name="Repository">The repository.</param>
/// <returns></returns>
public static Models.DispatchModel GenerateDispatchModel(BLL.Dispatch dispatch, Transaction transactionObj)
{
DispatchModel model = new DispatchModel();
model.BidNumber = dispatch.BidNumber;
model.DispatchDate = dispatch.DispatchDate;
model.DispatchID = dispatch.DispatchID;
model.DriverName = dispatch.DriverName;
model.DispatchedByStoreMan = dispatch.DispatchedByStoreMan;
model.FDPID = dispatch.FDPID;
model.GIN = dispatch.GIN;
model.Month = dispatch.PeriodMonth;
model.Year = dispatch.PeriodYear;
model.PlateNo_Prime = dispatch.PlateNo_Prime;
model.PlateNo_Trailer = dispatch.PlateNo_Trailer;
model.RequisitionNo = dispatch.RequisitionNo;
model.Type = dispatch.Type;
//model.StackNumber = dispatch.StackNumber;
//model.StoreID = dispatch.StoreID;
model.TransporterID = dispatch.TransporterID;
model.WarehouseID = dispatch.HubID;
//model.ProgramID = dispatch.ProgramID;
model.WeighBridgeTicketNumber = dispatch.WeighBridgeTicketNumber;
model.Remark = dispatch.Remark;
model.OtherDispatchAllocationID = dispatch.OtherDispatchAllocationID;
model.DispatchAllocationID = dispatch.DispatchAllocationID;
// model.ProjectNumber = dispatch.ProjectNumber;
//model.SINumber = dispatch.SINumber;
//TODO:Check modification have any impact
BLL.Transaction transaction = transactionObj;// Repository.Dispatch.GetDispatchTransaction(dispatch.DispatchID);
if (transaction != null)
{
if (transaction.Stack != null)
{
model.StackNumber = transaction.Stack.Value;
}
model.StoreID = transaction.StoreID;
model.ProgramID = transaction.ProgramID;
model.ProjectNumber = transaction.ProjectCode.Value;
model.SINumber = transaction.ShippingInstruction.Value;
model.CommodityTypeID = transaction.Commodity.CommodityTypeID;
}
model.DispatchDetails = DispatchDetailModel.GenerateDispatchDetailModels(dispatch.DispatchDetails);
return(model);
}
/// <summary>
/// Gets the SMS text.
/// </summary>
/// <returns></returns>
public string GetSMSText()
{
StringBuilder builder = new StringBuilder();
CTSContext entities = new CTSContext();
BLL.Dispatch dispatch = entities.Dispatches.Where(d => d.DispatchID == this.DispatchID).SingleOrDefault();
if (dispatch != null)
{
BLL.DispatchDetail com = dispatch.DispatchDetails.FirstOrDefault();
if (com != null)
{
builder.Append(string.Format("There is a Dispatch with an ammount of {0}(MT) - {1} to your FDP({2}) ", com.RequestedQuantityInMT, com.Commodity.Name, dispatch.FDP.Name));
builder.Append(string.Format("on a car with plate no - {0}", dispatch.PlateNo_Prime));
}
}
return(builder.ToString());
}
/// <summary>
/// Generates the dipatch.
/// </summary>
/// <returns></returns>
public BLL.Dispatch GenerateDipatch(UserProfile user)
{
//TODO:Check if any impact converting default constructor to injuct user
//BLL.UserProfile user = Repository.UserProfile.GetUser(HttpContext.Current.User.Identity.Name);
BLL.Dispatch dispatch = new BLL.Dispatch()
{
BidNumber = this.BidNumber,
CreatedDate = DateTime.Now,
DispatchDate = this.DispatchDate,
DriverName = this.DriverName,
DispatchedByStoreMan = DispatchedByStoreMan,
FDPID = this.FDPID,
GIN = this.GIN,
PeriodYear = this.Year,
PeriodMonth = this.Month,
PlateNo_Prime = this.PlateNo_Prime,
PlateNo_Trailer = this.PlateNo_Trailer,
RequisitionNo = this.RequisitionNo,
//HubID = user.DefaultHub.HubID;
// StackNumber = this.StackNumber,
// StoreID = this.StoreID,
TransporterID = this.TransporterID,
HubID = this.WarehouseID,
//ProgramID = this.ProgramID,
WeighBridgeTicketNumber = this.WeighBridgeTicketNumber,
Round = this.Round,
Remark = this.Remark,
//ProjectNumber = this.ProjectNumber,
// SINumber = this.SINumber
};
if (this.DispatchID.HasValue)
{
dispatch.DispatchID = this.DispatchID.Value;
}
return(dispatch);
}
/// <summary>
/// Generates the dipatch.
/// </summary>
/// <returns></returns>
public BLL.Dispatch GenerateDipatch()
{
BLL.UserProfile user = Repository.UserProfile.GetUser(HttpContext.Current.User.Identity.Name);
BLL.Dispatch dispatch = new BLL.Dispatch()
{
BidNumber = this.BidNumber,
CreatedDate = DateTime.Now,
DispatchDate = this.DispatchDate,
DriverName = this.DriverName,
DispatchedByStoreMan = DispatchedByStoreMan,
FDPID = this.FDPID,
GIN = this.GIN,
PeriodYear = this.Year,
PeriodMonth = this.Month,
PlateNo_Prime = this.PlateNo_Prime,
PlateNo_Trailer = this.PlateNo_Trailer,
RequisitionNo = this.RequisitionNo,
//HubID = user.DefaultHub.HubID;
// StackNumber = this.StackNumber,
// StoreID = this.StoreID,
TransporterID = this.TransporterID,
HubID = this.WarehouseID,
//ProgramID = this.ProgramID,
WeighBridgeTicketNumber = this.WeighBridgeTicketNumber,
Round = this.Round,
Remark = this.Remark,
//ProjectNumber = this.ProjectNumber,
// SINumber = this.SINumber
};
if(this.DispatchID.HasValue)
{
dispatch.DispatchID = this.DispatchID.Value;
}
return dispatch;
}
