public bool BookIn(int orderID, string bookedInBy, string bookedInWith, string bookedInReferences, string dateOption, string datefromDate, string dateFromTime, string dateFromByDate, string dateFromByTime)
{
Orchestrator.EF.DataContext context = new Orchestrator.EF.DataContext();
Orchestrator.EF.Order order = context.OrderSet.FirstOrDefault(o => o.OrderId == orderID);
order.BookedIn = true;
order.BookedInByUserName = bookedInBy;
order.BookedInDateTime = DateTime.Now;
order.BookedInStateId = (int)eBookedInState.BookedIn;
order.BookedInWith = bookedInWith;
order.BookedInReferences = bookedInReferences;
// Set the date and time for the Delivery based on the book in details
if (int.Parse(dateOption) == 0) //window
{
order.DeliveryFromDateTime = DateTime.Parse(datefromDate).Add(TimeSpan.Parse(dateFromTime));
order.DeliveryDateTime = DateTime.Parse(dateFromByDate).Add(TimeSpan.Parse(dateFromByTime));
}
else
{
order.DeliveryFromDateTime = DateTime.Parse(datefromDate).Add(TimeSpan.Parse(dateFromTime));
order.DeliveryDateTime = DateTime.Parse(datefromDate).Add(TimeSpan.Parse(dateFromTime));
}
order.LastUpdateDate = DateTime.Now;
order.LastUpdateUserID = bookedInBy;
context.SaveChanges(true);
return(true);
}
public static List <string> UpdateOrder(int orderID, DateTime collectFromDate, DateTime?collectFromTime, DateTime collectByDate, DateTime?collectByTime, int collectionTimeType,
DateTime deliverFromDate, DateTime?deliverFromTime, DateTime deliverToDate, DateTime?deliverToTime, int deliveryTimeType,
decimal rate, string deliveryNotes, string userID)
{
List <string> result = new List <string>();
result.Add(true.ToString());
Orchestrator.EF.DataContext data = EF.DataContext.Current;
Orchestrator.EF.Order order = data.OrderSet.First(o => o.OrderId == orderID);
//determine the date(s) to use
order.CollectionDateTime = collectFromDate.Add(collectFromTime.HasValue ? new TimeSpan(collectFromTime.Value.Hour, collectFromTime.Value.Minute, 0) : new TimeSpan(23, 59, 0));
if (collectionTimeType == 1)
{
order.CollectionByDateTime = order.CollectionDateTime;
}
else
{
order.CollectionByDateTime = collectByDate.Add(collectByTime.HasValue ? new TimeSpan(collectByTime.Value.Hour, collectByTime.Value.Minute, 0) : new TimeSpan(23, 59, 0));
}
order.DeliveryFromDateTime = deliverFromDate.Add(deliverFromTime.HasValue ? new TimeSpan(deliverFromTime.Value.Hour, deliverFromTime.Value.Minute, 0) : new TimeSpan(23, 59, 0));
if (deliveryTimeType == 1)
{
order.DeliveryDateTime = order.DeliveryFromDateTime.Value;
}
else
{
order.DeliveryDateTime = deliverToDate.Add(deliverToTime.HasValue ? new TimeSpan(deliverToTime.Value.Hour, deliverToTime.Value.Minute, 0) : new TimeSpan(23, 59, 0));
}
order.LastUpdateDate = DateTime.Now;
order.LastUpdateUserID = userID;
order.DeliveryNotes = deliveryNotes;
order.ForeignRate = rate;
Facade.IExchangeRates facER = new Facade.ExchangeRates();
CultureInfo nativeCulture = new CultureInfo(Orchestrator.Globals.Configuration.NativeCulture);
if (order.LCID != nativeCulture.LCID)
{
order.ExchangeRateID = facER.GetCurrentExchangeRateID(Facade.Culture.GetCurrencySymbol(order.LCID.Value), order.CollectionDateTime);
order.Rate = facER.GetConvertedRate(order.ExchangeRateID.Value, order.ForeignRate.Value);
}
else
{
order.Rate = decimal.Round(order.ForeignRate.Value, 4, MidpointRounding.AwayFromZero);
}
data.SaveChanges();
result.Add(orderID.ToString());
return(result);
}
public void SetBookedInState(int orderID, eBookedInState bookedInState, string userName)
{
Orchestrator.EF.DataContext context = new Orchestrator.EF.DataContext();
Orchestrator.EF.Order order = context.OrderSet.FirstOrDefault(o => o.OrderId == orderID);
order.BookedIn = false;
order.BookedInByUserName = string.Empty;
order.BookedInDateTime = null;;
order.BookedInStateId = (int)bookedInState;
order.LastUpdateDate = DateTime.Now;
order.LastUpdateUserID = userName;
context.SaveChanges(true);
}
public static bool BookIn(int orderID, string bookedInBy, string bookedInWith, string bookedInReferences, string dateOption, string datefromDate, string dateFromTime, string dateFromByDate, string dateFromByTime)
{
Orchestrator.EF.DataContext context = EF.DataContext.Current;
Orchestrator.EF.Order order = context.OrderSet.FirstOrDefault(o => o.OrderId == orderID);
Facade.IOrder facOrder = new Facade.Order();
Entities.Order orderOriginal = facOrder.GetForOrderID(orderID);
order.BookedIn = true;
order.BookedInByUserName = bookedInBy;
order.BookedInDateTime = DateTime.Now;
order.BookedInStateId = (int)eBookedInState.BookedIn;
order.BookedInWith = bookedInWith;
order.BookedInReferences = bookedInReferences;
// Set the date and time for the Delivery based on the book in etails
if (int.Parse(dateOption) == 0) //window
{
order.DeliveryFromDateTime = DateTime.Parse(datefromDate).Add(TimeSpan.Parse(dateFromTime));
order.DeliveryDateTime = DateTime.Parse(dateFromByDate).Add(TimeSpan.Parse(dateFromByTime));
}
else
{
order.DeliveryFromDateTime = DateTime.Parse(datefromDate).Add(TimeSpan.Parse(dateFromTime));
order.DeliveryDateTime = DateTime.Parse(datefromDate).Add(TimeSpan.Parse(dateFromTime));
}
order.LastUpdateDate = DateTime.Now;
order.LastUpdateUserID = bookedInBy;
context.SaveChanges(true);
Entities.Order orderNew = facOrder.GetForOrderID(orderID);
var exports = Orchestrator.Application.GetSpecificImplementations <Application.IExportOrder>();
if (exports.Any())
{
foreach (var export in exports)
{
export.Update(orderNew, orderOriginal, bookedInBy);
}
}
return(true);
}
public static List <string> RemoveRequiresBookingIn(int orderID, string linkClientID, string userName)
{
Orchestrator.EF.DataContext context = EF.DataContext.Current;
Orchestrator.EF.Order order = context.OrderSet.FirstOrDefault(o => o.OrderId == orderID);
order.BookedIn = false;
order.BookedInByUserName = string.Empty;
order.BookedInDateTime = null;;
order.BookedInStateId = (int)eBookedInState.NotRequired;
order.LastUpdateDate = DateTime.Now;
order.LastUpdateUserID = userName;
context.SaveChanges(true);
List <string> result = new List <string>();
result.Add(true.ToString().ToLower());
result.Add(linkClientID);
result.Add(string.Format("SetBookInRequired(this,{0}); return false;", orderID));
return(result);
}
public bool UpdateOrder(int orderID, DateTime collectFromDate, DateTime?collectFromTime, DateTime collectByDate, DateTime?collectByTime, int collectionTimeType,
DateTime deliverFromDate, DateTime?deliverFromTime, DateTime deliverToDate, DateTime?deliverToTime, int deliveryTimeType,
decimal rate, string deliveryNotes, string userID)
{
bool result = true;
Orchestrator.EF.DataContext data = new Orchestrator.EF.DataContext();
Orchestrator.EF.Order order = data.OrderSet.First(o => o.OrderId == orderID);
//determine the date(s) to use
order.CollectionDateTime = collectFromDate.Add(collectFromTime.HasValue ? new TimeSpan(collectFromTime.Value.Hour, collectFromTime.Value.Minute, 0) : new TimeSpan(23, 59, 0));
if (collectionTimeType == 1 || collectionTimeType == 2)
{
order.CollectionByDateTime = order.CollectionDateTime;
}
else
{
order.CollectionByDateTime = collectByDate.Add(collectByTime.HasValue ? new TimeSpan(collectByTime.Value.Hour, collectByTime.Value.Minute, 0) : new TimeSpan(23, 59, 0));
}
order.DeliveryFromDateTime = deliverFromDate.Add(deliverFromTime.HasValue ? new TimeSpan(deliverFromTime.Value.Hour, deliverFromTime.Value.Minute, 0) : new TimeSpan(23, 59, 0));
if (deliveryTimeType == 1 || deliveryTimeType == 2)
{
order.DeliveryDateTime = order.DeliveryFromDateTime.Value;
}
else
{
order.DeliveryDateTime = deliverToDate.Add(deliverToTime.HasValue ? new TimeSpan(deliverToTime.Value.Hour, deliverToTime.Value.Minute, 0) : new TimeSpan(23, 59, 0));
}
order.LastUpdateDate = DateTime.Now;
order.LastUpdateUserID = userID;
order.DeliveryNotes = deliveryNotes;
order.ForeignRate = rate;
data.SaveChanges();
return(result);
}
