protected void btnAdd_Click(object sender, EventArgs e)
{
string _ErrorStr = "Connection not openned";
OrderTbl _OrderTbl = new OrderTbl();
OrderHeaderData _OrderHeaderData = Get_dvOrderHeaderData(false);
OrderTblData _OrderData = new OrderTblData();
// first summary data
_OrderData.CustomerId = _OrderHeaderData.CustomerID;
_OrderData.OrderDate = _OrderHeaderData.OrderDate;
_OrderData.RoastDate = _OrderHeaderData.RoastDate;
_OrderData.RequiredByDate = _OrderHeaderData.RequiredByDate;
_OrderData.ToBeDeliveredBy = Convert.ToInt32(_OrderHeaderData.ToBeDeliveredBy);
_OrderData.PurchaseOrder = _OrderHeaderData.PurchaseOrder;
_OrderData.Confirmed = _OrderHeaderData.Confirmed;
_OrderData.InvoiceDone = _OrderHeaderData.InvoiceDone;
_OrderData.Done = _OrderHeaderData.Done;
_OrderData.PurchaseOrder = _OrderHeaderData.PurchaseOrder;
_OrderData.Notes = _OrderHeaderData.Notes;
// Now line data
TrackerTools _TT = new TrackerTools();
_OrderData.ItemTypeID = Convert.ToInt32(ddlNewItemDesc.SelectedValue);
_OrderData.ItemTypeID = _TT.ChangeItemIfGroupToNextItemInGroup(_OrderData.CustomerId, _OrderData.ItemTypeID, _OrderData.RequiredByDate);
_OrderData.QuantityOrdered = Convert.ToDouble(tbxNewQuantityOrdered.Text);
_OrderData.PackagingID = Convert.ToInt32(ddlNewPackaging.SelectedValue);
_ErrorStr = _OrderTbl.InsertNewOrderLine(_OrderData);
ltrlStatus.Text = (String.IsNullOrWhiteSpace(_ErrorStr) ? "Item Added" : "Error adding item: " + _ErrorStr);
HideNewOrderItemPanel();
}
protected bool AddNewOrderLine(int pNewItemID, double pNewQuantityOrdered, int pNewPackagingID)
{
string _ErrorStr = "";
OrderTblData _OrderData = new OrderTblData();
OrderTbl _OrderTbl = new OrderTbl();
_OrderData.CustomerId = Convert.ToInt64(ddlContacts.SelectedValue);
_OrderData.OrderDate = Convert.ToDateTime(tbxOrderDate.Text).Date;
_OrderData.RoastDate = Convert.ToDateTime(tbxRoastDate.Text).Date;
_OrderData.RequiredByDate = Convert.ToDateTime(tbxRequiredByDate.Text).Date;
_OrderData.ToBeDeliveredBy = Convert.ToInt32(ddlToBeDeliveredBy.SelectedValue);
_OrderData.PurchaseOrder = tbxPurchaseOrder.Text;
_OrderData.Confirmed = Convert.ToBoolean(cbxConfirmed.Checked);
_OrderData.InvoiceDone = cbxInvoiceDone.Checked;
_OrderData.Done = Convert.ToBoolean(cbxDone.Checked);
_OrderData.Notes = tbxNotes.Text;
// Now line data
Session[OrderHeaderData.CONST_BOUNDOLDDELIVERYDATE] = _OrderData.RequiredByDate.Date;
TrackerTools _TT = new TrackerTools();
_OrderData.ItemTypeID = _TT.ChangeItemIfGroupToNextItemInGroup(_OrderData.CustomerId, pNewItemID, _OrderData.RequiredByDate);
_OrderData.QuantityOrdered = pNewQuantityOrdered;
_OrderData.PackagingID = pNewPackagingID;
_ErrorStr = _OrderTbl.InsertNewOrderLine(_OrderData);
BindRowQueryParameters();
return(String.IsNullOrEmpty(_ErrorStr));
}
public bool MapOrderTblToOrderViewModel(OrderTbl order, StoreTbl store, UserAdmin sender, UserAdmin recipient, UserAdmin customer, IEnumerable <OrderDetailTbl> orderDetail)
{
try
{
if (order == null)
{
return(false);
}
this.Id = order.Id;
this.TotalWeight = order.TotalWeight;
this.Store = store == null ? StringProvider.NOTFOUND : store.Name;
this.CustomerConfirm = customer == null ? "" : customer.FullName;
this.NumberOfDOCS = orderDetail.Count();
this.Notes = order.Notes;
this.Shipment = order.Shipment;
this.SenderName = sender == null ? StringProvider.NOTFOUND : sender.FullName;
this.PhoneSender = sender == null ? StringProvider.NOTFOUND : sender.Phone;
this.RecipientName = recipient == null ? StringProvider.NOTFOUND : recipient.FullName;
this.RecipientPhone = recipient == null ? StringProvider.NOTFOUND : recipient.Phone;
this.RecipientAddress = recipient == null ? StringProvider.NOTFOUND : recipient.Address;
this.Status = order.Status;
this.CreateDate = TimestampStaicClass.ConvertToDatetime(order.CreateDate);
this.ModifyDate = TimestampStaicClass.ConvertToDatetime(order.ModifyDate);
this.PickupDate = TimestampStaicClass.ConvertToDatetime(order.PickupDate);
return(true);
} catch (Exception e)
{
return(false);
}
}
public async Task <IActionResult> PutOrderTbl([FromRoute] int id, [FromBody] OrderTbl orderTbl)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != orderTbl.Id)
{
return(BadRequest());
}
_context.Entry(orderTbl).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!OrderTblExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
// PUT api/Order/5
public IHttpActionResult PutOrderTbl(int id, OrderTbl ordertbl)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != ordertbl.OrderId)
{
return(BadRequest());
}
db.Entry(ordertbl).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!OrderTblExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void DeleteOrderItem(string pOrderID)
{
OrderTbl _Order = new OrderTbl();
string _ErrorStr = _Order.DeleteOrderById(Convert.ToInt64(pOrderID));
ltrlStatus.Text = (_ErrorStr.Length == 0) ? "Item deleted" : _ErrorStr;
}
private string UnDoneOrderItem(string pOrderID)
{
long _OrderID = Convert.ToInt64(pOrderID);
OrderTbl _Order = new OrderTbl();
return(_Order.UpdateSetDoneByID(false, _OrderID));
}
public ActionResult Dispatch(Int64 id)
{
OrderTbl rec = entity.OrderTbls.Find(id);
ViewBag.OrderID = rec.OrderID;
ViewBag.OrderDate = rec.OrderDate;
ViewBag.UserName = rec.UserTbl.UserName;
ViewBag.AgencyID = new SelectList(entity.DispatchAgencyTbls.ToList(), "DispatchAgencyID", "DispatchAgencyName");
return(View());
}
public IHttpActionResult GetOrderTbl(int id)
{
OrderTbl ordertbl = db.OrderTbls.Find(id);
if (ordertbl == null)
{
return(NotFound());
}
return(Ok(ordertbl));
}
protected void MarkItemAsInvoiced()
{
OrderTbl _Orders = new OrderTbl();
long _CustomerId = (long)Session[OrderHeaderData.CONST_BOUNDCUSTOMERID];
DateTime _RequiredByDate = ((DateTime)Session[OrderHeaderData.CONST_BOUNDDELIVERYDATE]).Date;
string _Notes = (string)Session[OrderHeaderData.CONST_BOUNDNOTES];
_Orders.UpdateSetInvoiced(true, _CustomerId, _RequiredByDate, _Notes);
/* odsOrderSummary.Update();*/
pnlOrderHeader.Update();
}
public IHttpActionResult PostOrderTbl(OrderTbl ordertbl)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.OrderTbls.Add(ordertbl);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = ordertbl.OrderId }, ordertbl));
}
public IHttpActionResult DeleteOrderTbl(int id)
{
OrderTbl ordertbl = db.OrderTbls.Find(id);
if (ordertbl == null)
{
return(NotFound());
}
db.OrderTbls.Remove(ordertbl);
db.SaveChanges();
return(Ok(ordertbl));
}
public string Post([FromBody] OrderTbl ord)
{
string retMessage;
try
{
// _hubContext.Clients.All.BroadcastMessage(ord.Id,ord.OrderTime,ord.Quantity,ord.SubTotal,ord.TotalPrice,ord.PaymentType,ord.MenueId,ord.CustomerId);
retMessage = "Success";
}
catch (Exception e)
{
retMessage = e.ToString();
}
return(retMessage);
}
public IEnumerable <OrderTbl> GetyourOrder()
{
OrderTbl order = new OrderTbl();
// _context.OrderTbl.Include(e => e.Menue.Id).ToList();
// _context.OrderTbl.Include(e => e.Customer.Id).ToList();
IQueryable <OrderTbl> orders = null;
orders = from b in _context.OrderTbl
join std in _context.MenueTbl on b.MenueId equals std.Id
join cmp in _context.CustomerTbl on b.CustomerId equals cmp.Id
where b.CustomerId == Global.UserID
//join ctg in _context.CategoryTbl on b.CategoryId equals ctg.Id
orderby b.OrderTime descending
select new OrderTbl
{
Id = b.Id,
OrderTime = b.OrderTime,
Quantity = b.Quantity,
TotalPrice = b.TotalPrice,
PaymentType = b.PaymentType,
Subtotal = b.Subtotal,
Menue = new MenueTbl()
{
Id = std.Id,
Name = std.Name,
},
Customer = new CustomerTbl()
{
Id = cmp.Id,
Name = cmp.Name,
ContactNo = cmp.ContactNo,
Address = cmp.Address
},
//Category = new CategoryTbl()
//{
// Id = ctg.Id,
// Name = ctg.Name
//}
}
;
return(orders.ToList());
// return _context.OrderTbl;
}
public async Task <IActionResult> PostOrderTbl([FromBody] OrderTbl orderTbl)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (orderTbl.PaymentType == "1")
{
orderTbl.PaymentType = "Cash On Delivery";
}
if (orderTbl.PaymentType == "2")
{
orderTbl.PaymentType = "Bkash";
}
orderTbl.OrderTime = DateTime.Now;
orderTbl.CustomerId = Global.UserID;
//orderTbl.CustomerId = TempData["userid"] as string;
_context.OrderTbl.Add(orderTbl);
NotificationTbl notification = new NotificationTbl();
notification.Message = "New Order placed by " + Global.UserName + " at " + orderTbl.OrderTime.Value.ToString("yyyy-MM-dd hh:mm:ss tt");
Global.Counter++;
_context.NotificationTbl.Add(notification);
await _context.SaveChangesAsync();
// return CreatedAtAction("GetOrderTbl", new { id = orderTbl.Id }, orderTbl);
// signalR notification
string retMessage;
try
{
await _hubContext.Clients.All.BroadcastMessage(orderTbl.Id, orderTbl.Quantity, orderTbl.Subtotal, orderTbl.TotalPrice, orderTbl.PaymentType, orderTbl.CustomerId, orderTbl.MenueId, orderTbl.OrderTime);
retMessage = "Success";
}
catch (Exception e)
{
retMessage = e.ToString();
}
// return retMessage;
return(CreatedAtAction("GetOrderTbl", new { id = orderTbl.Id }, orderTbl));
}
private bool LogARepair(RepairsTbl pRepair, bool pCalcOrderData)
{
bool _Success = false;
// create a new order for delivery [RoastDate]
OrderCls _OrderData = new OrderCls();
DateTime _RequiredByDate = DateTime.Now.Date.AddDays(7);
// add the default data to order
_OrderData.HeaderData.CustomerID = pRepair.CustomerID;
_OrderData.HeaderData.Notes = "Collect/Swop out Machine for Service";
List <OrderDetailData> orderDetailDatas = new List <OrderDetailData>();
OrderDetailData orderDetailData = new OrderDetailData();
orderDetailData.ItemTypeID = ItemTypeTbl.CONST_SERVICEITEMID;
orderDetailData.QuantityOrdered = 1;
// Calculate the Data from the customer details
if (pCalcOrderData)
{
TrackerTools _TT = new TrackerTools();
_OrderData.HeaderData.RoastDate = _TT.GetNextRoastDateByCustomerID(pRepair.CustomerID, ref _RequiredByDate);
TrackerTools.ContactPreferedItems _ContactPreferedItems = _TT.RetrieveCustomerPrefs(pRepair.CustomerID);
_OrderData.HeaderData.OrderDate = DateTime.Now.Date;
_OrderData.HeaderData.RequiredByDate = _RequiredByDate;
if (_ContactPreferedItems.RequiresPurchOrder)
{
_OrderData.HeaderData.PurchaseOrder = TrackerTools.CONST_POREQUIRED;
}
_OrderData.HeaderData.ToBeDeliveredBy = _ContactPreferedItems.DeliveryByID;
}
else
{
_OrderData.HeaderData.RoastDate = _OrderData.HeaderData.OrderDate = DateTime.Now.Date;
_OrderData.HeaderData.RequiredByDate = _RequiredByDate;
}
// save the data to the orders
OrderTbl _Order = new OrderTbl();
_Order.InsertNewOrderLine(_OrderData);
pRepair.RelatedOrderID = _Order.GetLastOrderAdded(_OrderData.HeaderData.CustomerID, _OrderData.HeaderData.OrderDate, ItemTypeTbl.CONST_SERVICEITEMID);
return(_Success);
}
public void CreateOrder(OrderCreateModel data)
{
OrderTbl order = new OrderTbl();
order.SenderId = data.SenderId;
order.RecipientId = data.RecipientId;
order.StoreId = data.StoreId;
order.Notes = data.Note;
order.TotalWeight = data.TotalWeight ?? 0;
order.Status = "New";
order.Shipment = data.Shipment;
order.CreateDate = TimestampStaicClass.ConvertTotimestamp(DateTime.UtcNow);
order.ModifyDate = TimestampStaicClass.ConvertTotimestamp(DateTime.UtcNow);
order.Id = Guid.NewGuid().ToString();
orderRepo.Create(order);
var listOrderdetail = new List <OrderDetailTbl>();
if (data.listOrdertail != null)
{
foreach (var item in data.listOrdertail)
{
var orderdetail = new OrderDetailTbl();
orderdetail.createDate = TimestampStaicClass.ConvertTotimestamp(DateTime.UtcNow);
orderdetail.modifyDate = TimestampStaicClass.ConvertTotimestamp(DateTime.UtcNow);
orderdetail.status = "New";
orderdetail.description = item.description;
orderdetail.productCategoryId = item.productCategoryId;
orderdetail.id = Guid.NewGuid().ToString();
orderdetail.orderId = order.Id;
orderdetail.price = item.price;
orderdetail.productCode = item.productCode;
orderdetail.quality = item.quality;
orderdetail.weight = item.weight;
listOrderdetail.Add(orderdetail);
}
}
orderDetailRepo.CreateMulti(listOrderdetail);
}
public async Task <ActionResult <OrderTbl> > PostOrderTbl(OrderTbl orderTbl)
{
_context.OrderTbl.Add(orderTbl);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (OrderTblExists(orderTbl.Oid))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetOrderTbl", new { id = orderTbl.Oid }, orderTbl));
}
public ActionResult PlaceOrder(int id)
{
Int64 userid = Convert.ToInt64(Session["UserID"]);
var usercart = entity.CartTbls.Where(p => p.UserID == userid);
//Store in ordertbl
decimal? amount = usercart.Sum(p => p.Price * p.Qty);
OrderTbl order = new OrderTbl();
order.OrderDate = DateTime.Now;
order.UserID = userid;
order.PaymentMode = id;
entity.OrderTbls.Add(order);
entity.SaveChanges();
//order details
foreach (var temp in usercart)
{
OrderDetTbl ordet = new OrderDetTbl();
ordet.OrderID = order.OrderID;
ordet.Price = temp.Price;
ordet.Qty = temp.Qty;
ordet.ProductID = temp.ProductID;
entity.OrderDetTbls.Add(ordet);
}
entity.SaveChanges();
var newusercart = entity.CartTbls.Where(p => p.UserID == userid);
foreach (var temp in newusercart)
{
entity.CartTbls.Remove(temp);
}
entity.SaveChanges();
ViewBag.OrderID = order.OrderID;
ViewBag.Amount = amount;
return(View());
}
protected void gvOrderLines_RowCommand(object sender, GridViewCommandEventArgs e)
{
bool _UpdateGrids = false;
if (e.CommandName == "MoveOneDayOn")
{
_UpdateGrids = true;
int index = Convert.ToInt32(e.CommandArgument);
Label _OrderLabel = (Label)gvOrderLines.Rows[index].FindControl("lblOrderID");
string _DeliveryDateStr = dvOrderHeaderGetLabelValue("lblRequiredByDate");
DateTime _DeliveryDate = Convert.ToDateTime(_DeliveryDateStr).Date;
if (_DeliveryDate.DayOfWeek < DayOfWeek.Friday)
{
_DeliveryDate = _DeliveryDate.AddDays(1);
}
else
{
int _daysUntilMonday = ((int)DayOfWeek.Monday - (int)_DeliveryDate.DayOfWeek + 7) % 7;
_DeliveryDate = _DeliveryDate.AddDays(_daysUntilMonday);
}
OrderTbl _OrderTbl = new OrderTbl();
_OrderTbl.UpdateOrderDeliveryDate(_DeliveryDate, Convert.ToInt64(_OrderLabel.Text));
}
else if (e.CommandName == "DeleteOrder")
{
_UpdateGrids = true;
DeleteOrderItem(e.CommandArgument.ToString());
}
if (_UpdateGrids)
{
dvOrderHeader.DataBind();
pnlOrderHeader.Update();
gvOrderLines.DataBind();
upnlOrderLines.Update();
}
}
public ActionResult Details(Int64 id)
{
OrderTbl ord = entity.OrderTbls.Find(id);
return(View(ord));
}
public bool HandleAndUpdateRepairStatusChange(RepairsTbl pRepair)
{
// send email and handle status change
bool _Success = true;
switch (pRepair.RepairStatusID)
{
case CONST_REPAIRSTATUS_LOGGED:
{
_Success = LogARepair(pRepair, true);
break;
}
case CONST_REPAIRSTATUS_COLLECTED:
{
if (pRepair.RelatedOrderID.Equals(0))
{
_Success = LogARepair(pRepair, true);
}
else
{
OrderTbl _Order = new OrderTbl();
_Order.UpdateIncDeliveryDateBy7(pRepair.RelatedOrderID);
}
break;
}
case CONST_REPAIRSTATUS_WORKSHOP:
{
if (pRepair.RelatedOrderID.Equals(0))
{
_Success = LogARepair(pRepair, false);
}
else
{
OrderTbl _Order = new OrderTbl();
_Order.UpdateIncDeliveryDateBy7(pRepair.RelatedOrderID);
}
if (!String.IsNullOrEmpty(pRepair.MachineSerialNumber))
{
// if we have no serial number in the current Customer Tbl then update
CustomersTbl _Customers = new CustomersTbl();
_Customers.SetEquipDetailsIfEmpty(pRepair.MachineTypeID, pRepair.MachineSerialNumber, pRepair.CustomerID);
}
break;
}
case CONST_REPAIRSTATUS_READY:
{
if (pRepair.RelatedOrderID > 0)
{
OrderTbl _Order = new OrderTbl();
NextRoastDateByCityTbl _NextDates = new NextRoastDateByCityTbl();
_Order.UpdateOrderDeliveryDate(_NextDates.GetNextDeliveryDate(pRepair.CustomerID), pRepair.RelatedOrderID);
}
break;
}
case CONST_REPAIRSTATUS_DONE:
{
if (pRepair.RelatedOrderID > 0)
{
OrderTbl _Order = new OrderTbl();
_Order.UpdateSetDoneByID(true, pRepair.RelatedOrderID);
// ??? should we do this since it interupts with the Preiction Calculations
}
break;
}
default:
{
break;
}
}
_Success = String.IsNullOrEmpty(UpdateRepair(pRepair));
_Success = _Success && SendStatusChangeEmail(pRepair);
return(_Success);
}
bool SendReminder(SendCheckEmailTextsData pEmailTextData, ContactToRemindWithItems pContact, string pOrderType)
#endif
{
const string CONST_SERVERURL = "http://tracker.quaffee.co.za/QonT/";
const string CONST_HTMLBREAK = "<br /><br />";
const string CONST_ADDORDERURL = "Internal: Order Ref <a href='" + CONST_SERVERURL + "{0}'>here</a>.";
const string CONST_DISABLECUSTOMERURL = "If you would prefer to be disabled then click <a href='" + CONST_SERVERURL + "DisableClient.aspx?CoID={0}'>disable me</a>";
bool _ReminderSent = false;
bool _HasAutoFulfilElements = false, _HasReoccuringElements = false, _HadError = false;
SentRemindersLogTbl _ReminderLog = new SentRemindersLogTbl();
#region CreateAndPopulateUsageSummaryTable
string _EmailBodyTable = UsageSummaryTableHeader(pContact);
string _OrderType = (String.IsNullOrEmpty(pOrderType)) ? "a reminder only" : pOrderType;
// send a reminder
// build up Table
_EmailBodyTable += String.Format(CONST_SUMMARYTABLEHEADER, "Company/Contact", pContact.CompanyName);
_EmailBodyTable += String.Format(CONST_SUMMARYTABLBODYROW2COL, "Next estimate prep date", String.Format("{0:d MMM, ddd}", pContact.NextPrepDate));
_EmailBodyTable += String.Format(CONST_SUMMARYTABLBODYALTROW2COL, "Next estimate dispatch date", String.Format("{0:d MMM, ddd}", pContact.NextDeliveryDate));
_EmailBodyTable += String.Format(CONST_SUMMARYTABLBODYALTROW2COL, "Type", _OrderType);
if (pContact.ItemsContactRequires.Count > 0)
{
_EmailBodyTable += String.Format(CONST_SUMMARYTABLBODYROW3COL, "<b>List of Items</b>");
for (int j = 0; j < pContact.ItemsContactRequires.Count; j++)
{
_EmailBodyTable += CONST_SUMMARYTABLEBODYROWSTART + AddLastOrderTableRow(pContact.ItemsContactRequires[j], (j % 2 == 0)) + CONST_SUMMARYTABLEBODYROWEND;
}
}
_EmailBodyTable += CONST_SUMMARYTABLEBODYEND;
#endregion
// add to orders if it is a autofulful or
#region AddOrderLines
if (!String.IsNullOrWhiteSpace(pOrderType))
{
OrderTblData _OrderData = new OrderTblData();
_HasAutoFulfilElements = true;
_OrderData.CustomerId = pContact.CustomerID;
_OrderData.OrderDate = DateTime.Now.Date;
_OrderData.RoastDate = pContact.NextPrepDate.Date;
_OrderData.RequiredByDate = pContact.NextDeliveryDate.Date;
_OrderData.ToBeDeliveredBy = (pContact.PreferedAgentID < 0) ? TrackerTools.CONST_DEFAULT_DELIVERYBYID : pContact.PreferedAgentID; // the prefered person is the delivery agent
_OrderData.Confirmed = false; // we have not confirmed the order, it is a reoccuring or auto order
_OrderData.InvoiceDone = false; // we have not confirmed the order, it is a reoccuring or auto order
_OrderData.PurchaseOrder = string.Empty; // we have not confirmed the order, it is a reoccuring or auto order
_OrderData.Notes = pOrderType;
ReoccuringOrderDAL _Reoccur = new ReoccuringOrderDAL(); // to set the last date
OrderTbl _OrderTbl = new OrderTbl();
string _InsertErr = String.Empty;
int j = 0;
// insert each itm that is Reoccuing or auto
while ((j < pContact.ItemsContactRequires.Count) && String.IsNullOrEmpty(_InsertErr))
{
_OrderData.ItemTypeID = pContact.ItemsContactRequires[j].ItemID;
_OrderData.QuantityOrdered = pContact.ItemsContactRequires[j].ItemQty;
_OrderData.PackagingID = pContact.ItemsContactRequires[j].ItemPackagID;
_OrderData.PrepTypeID = pContact.ItemsContactRequires[j].ItemPrepID;
_InsertErr = _OrderTbl.InsertNewOrderLine(_OrderData);
// mark a reoccuring item as done with the current prep date
if (pContact.ItemsContactRequires[j].ReoccurOrder)
{
_Reoccur.SetReoccuringOrdersLastDate(pContact.NextPrepDate, pContact.ItemsContactRequires[j].ReoccurID);
_HasReoccuringElements = true;
}
j++;
}
// add a record into the log to say it was sent
_HadError = !String.IsNullOrEmpty(_InsertErr);
if (_HadError)
{
showMessageBox _MsgBox = new showMessageBox(this.Page, "Error Inserting order for :" + pContact.CompanyName, _InsertErr);
}
else
{
pEmailTextData.Footer += CONST_HTMLBREAK + "Items added to orders.";
}
}
else /// we are not autoadding so lets append a "LastOrder Equiv to the message"
{
string _AddOrder = String.Format("Pages/NewOrderDetail.aspx?Z&{0}={1}", NewOrderDetail.CONST_URL_REQUEST_CUSTOMERID, pContact.CustomerID);
for (int j = 0; j < pContact.ItemsContactRequires.Count; j++)
{
_AddOrder += String.Format("&SKU{0}={1}&SKUQty{2}={3}", j + 1, GetItemSKU(pContact.ItemsContactRequires[j].ItemID), j + 1,
pContact.ItemsContactRequires[j].ItemQty);
}
pEmailTextData.Footer += CONST_HTMLBREAK + String.Format(CONST_ADDORDERURL, _AddOrder);
pEmailTextData.Footer += CONST_HTMLBREAK + String.Format(CONST_DISABLECUSTOMERURL, pContact.CustomerID);
}
#endregion
#if _DEBUG
pContact.EmailAddress = "*****@*****.**";
pContact.AltEmailAddress = "";
#endif
#region SendEmail
string _FromEmail = ConfigurationManager.AppSettings[EmailCls.CONST_APPSETTING_FROMEMAILKEY];
string _Greetings = String.Empty;
EmailCls _Email = new EmailCls();
_Email.SetEmailFrom(_FromEmail);
_Email.SetEmailSubject(tbxEmailSubject.Text);
if (pContact.EmailAddress.Contains("@"))
{
_Email.SetEmailTo(pContact.EmailAddress, true);
_Greetings = String.IsNullOrWhiteSpace(pContact.ContactFirstName) ? "<p>Hi Coffee Lover,</p>" : "<p>Hi " + pContact.ContactFirstName + ",</p>";
_Email.MsgBody = _Greetings + "<p>" + pEmailTextData.Header + "</p><p>" + pEmailTextData.Body + "</p><br />" +
_EmailBodyTable + "<br /><br />" + pEmailTextData.Footer;
#if _DEBUG
_ReminderSent = true;
//if ((pReminderCount < 5) || (!String.IsNullOrWhiteSpace(pOrderType)))
// _ReminderSent = _Email.SendEmail();
//else
// _ReminderSent = true;
#else
_ReminderSent = _Email.SendEmail();
#endif
}
if (pContact.AltEmailAddress.Contains("@"))
{
_Email.SetEmailTo(pContact.AltEmailAddress, true);
_Greetings = String.IsNullOrWhiteSpace(pContact.ContactAltFirstName) ? "<p>Hi Coffee Lover,</p>" : "<p>Hi " + pContact.ContactAltFirstName + ",</p>";
_Email.MsgBody = _Greetings + "<p>" + pEmailTextData.Header + "</p><p>" + pEmailTextData.Body + "</p><br />" +
_EmailBodyTable + CONST_HTMLBREAK + pEmailTextData.Footer;
#if _DEBUG
_ReminderSent = true;
#else
_ReminderSent = (_ReminderSent) || (_Email.SendEmail());
#endif
}
#endregion
/// cipy values across and add to database
_ReminderLog.CustomerID = pContact.CustomerID;
_ReminderLog.DateSentReminder = System.DateTime.Now.Date;
_ReminderLog.NextPrepDate = pContact.NextCoffee.Date; // use the coffee date
_ReminderLog.ReminderSent = _ReminderSent;
_ReminderLog.HadAutoFulfilItem = _HasAutoFulfilElements;
_ReminderLog.HadReoccurItems = _HasReoccuringElements;
_ReminderLog.InsertLogItem(_ReminderLog);
return(_ReminderSent);
}
public MessageResult InsertNewOrder(List <DetailOrdersDTO> doLst, OrdersDTO o)
{
MessageResult mr = new MessageResult();
var check1 = db.Borrowers.Find(o.BorrowerID);
var check2 = db.Librarians.Find(o.LibrarianID);
if (check1 != null)
{
if (check2 != null && o.LibrarianID == CurrentSession.sessionId)
{
var books = db.Books.ToList();
bool flag = true;
List <DetailOrdersDTO> errorDetailOrders = new List <DetailOrdersDTO>();
foreach (var i in doLst)
{
foreach (var j in books)
{
if (i.BookId == j.bookID)
{
if (i.QuantityBorrowed > j.quantity)
{
flag = false;
errorDetailOrders.Add(i);
}
}
}
}
if (flag)
{
OrderTbl od = new OrderTbl();
if (o != null)
{
od.orderID = CreateOrderId();
od.dateBorrowed = o.DateBorrowed;
od.borrowerID = o.BorrowerID;
od.returnDate = o.ReturnDate;
od.status = o.Status;
od.librarianID = o.LibrarianID;
db.OrderTbls.Add(od);
db.SaveChanges();
}
var temp = db.OrderTbls.Find(od.orderID);
if (temp != null)
{
DetailOrderDAO.Instance.InsertDetailOrder(doLst, od.orderID);
mr.isSuccess = true;
}
else
{
mr.isSuccess = false;
mr.returnMessage = "Something's wrong. Fail to create order. ";
}
}
else
{
mr.isSuccess = false;
string mess = "";
foreach (var k in errorDetailOrders)
{
mess += k.BookId.ToString() + " ";
}
mr.returnMessage = "Some Books were out of stock. Here are these of BookIDs: " + mess;
}
}
else
{
mr.isSuccess = false;
mr.returnMessage = "[Danger] Invalid Session.";
}
}
else
{
mr.isSuccess = false;
mr.returnMessage = "Something's wrong. Borrower ID: '" + o.BorrowerID + "' is not existed. ";
}
return(mr);
}
