protected void BindOrdersList() { BPOrders bpcat = new BPOrders(); DSOrders = bpcat.SelectAll(); // DSOrders.tbl_Orders.DefaultView.Sort = "CustomerLastName"; dgOrders.DataBind(); }
private void GetOrderInfo() { BPOrders bp = new BPOrders(); BEOrders ds = bp.SelectOrdersByID(OrderID); BEOrders.tbl_OrdersRow Order = ds.tbl_Orders.FindByOrderID(OrderID); lblTitleAction.Text = "Edit "; lblTitleType.Text = CompanyName + " Transfer - #" + Order.OrderID; if (! Order.IsOrderRigNumberNull()) { txtOrderRigNumber.Text = Order.OrderRigNumber;} if (! Order.IsOrderJobNumberNull()) { txtOrderJobNumber.Text = Order.OrderJobNumber;} dtOrderDateRequired.SelectedDate = Order.OrderDateRequired; if (! Order.IsOrderTimeRequiredNull()) { txtOrderTimeRequired.Text = Order.OrderTimeRequired;} if (! Order.IsOrderRequestedByNull()) { txtOrderRequestedBy.Text = Order.OrderRequestedBy;} if (! Order.IsOrderShipVIANull()) { txtOrderShipVIA.Text = Order.OrderShipVIA;} if (! Order.IsOrderLeaseNumberNull()) { txtOrderLeaseNumber.Text = Order.OrderLeaseNumber;} if (! Order.IsOrderShipToNull()) { txtOrderShipTo.Text = Order.OrderShipTo;} if (! Order.IsOrderCommentsNull()) { txtOrderComments.Text = Order.OrderComments;} pnlEquipmentOrdered.Visible = true; if (Order.OrderCompleted == true) { btnReview.Visible = true; pnlViewInventory.Visible = false; OrderCompleted = true; btnSubmit.Visible = false; btnDelete.Visible = false; btnCancel.Visible = true; } else { pnlViewInventory.Visible = true; } }
private void CheckForIncompleteOrder() { BPOrders bp = new BPOrders(); BEOrders ds = new BEOrders(); ds = bp.SelectIncompleteByCompanyUserID(OryxUser.OryxIdentity.MemberID); ds.tbl_Orders.DefaultView.RowFilter = "IsTransfer=1"; if (ds.tbl_Orders.DefaultView.Count > 0) { OrderID = Convert.ToInt32(ds.tbl_Orders.DefaultView[0]["OrderID"]); } }
private DataSet BuildGridData() { BPOrders bp = new BPOrders(); BPInventory bpInv = new BPInventory(); if (ddlCompanies.SelectedValue == "-1") { DSOrders = bp.SelectWithCompanyByCompanyID(0); DSOrders.tbl_Orders.DefaultView.Sort = "OrderDate DESC"; DSOrders.Merge(bpInv.SelectOrderDetailsWithInventoryByCompanyID(0)); } else { DSOrders = bp.SelectWithCompanyByCompanyID(Convert.ToInt32(ddlCompanies.SelectedValue)); DSOrders.tbl_Orders.DefaultView.Sort = "OrderDate DESC"; DSOrders.Merge(bpInv.SelectOrderDetailsWithInventoryByCompanyID(Convert.ToInt32(ddlCompanies.SelectedValue))); } DSOrders.Relations.Add(DSOrders.Tables["tbl_Orders"].Columns["OrderId"], DSOrders.Tables["tbl_OrderDetails"].Columns["OrderId"]); rptLetters.Visible = false; DSOrders.tbl_Orders.DefaultView.RowFilter = RowFilter("", "OrderCurrent"); string filter; if (AdvancedSearchFilter != "") { filter = DSOrders.tbl_Orders.DefaultView.RowFilter; if (filter.Length >1) { filter = "(" + filter + ") and "; } filter += AdvancedSearchFilter; DSOrders.tbl_Orders.DefaultView.RowFilter = filter; } return DSOrders; }
private bool CheckForOrders() { BPOrders bp = new BPOrders(); if (CompanyID == Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings.Get("OryxCompanyID"))) { DSOrders = bp.SelectByRentalCompanies(); } else { DSOrders = bp.SelectOrderByCompanyID(CompanyID); } if (DSOrders.tbl_Orders.Count > 0) { return true; } else { return false; } }
public void CreateAndSendEmails(int orderID) { BPOrders bpOrder = new BPOrders(); BPOrderDetails bpDetails = new BPOrderDetails(); BEOrders dsOrder = bpOrder.SelectOrdersByID(orderID); dsOrder.Merge(bpDetails.SelectOrderDetailsWithInventoryByOrderID(orderID)); BEOrders.tbl_OrdersRow order = (BEOrders.tbl_OrdersRow) dsOrder.tbl_Orders.Rows[0]; BPCompanyEmails bp = new BPCompanyEmails(); BPCompanies bpCompany = new BPCompanies(); BPCompanyAliases bpAliases = new BPCompanyAliases(); BECompanies ds = bp.SelectActiveCompanyEmailsByCompanyID(order.CompanyID); ds.Merge(bpCompany.SelectCompaniesByID(order.CompanyID)); ds.Merge(bpAliases.SelectCompanyColumnsByCompanyID(order.CompanyID)); BECompanies.tbl_CompanyAliasesRow aliases = (BECompanies.tbl_CompanyAliasesRow) ds.tbl_CompanyAliases.Rows[0]; BECompanies.tbl_CompaniesRow company; bool hasHuntingInventoryAccess = false; string CompanyImage = ""; if(ds.tbl_Companies.Count > 0) { company = (BECompanies.tbl_CompaniesRow) ds.tbl_Companies.Rows[0]; if (!company.IsCompanyImageIDNull()) { BPImages bpImages = new BPImages(); BEImages DSImages = bpImages.SelectByID(company.CompanyImageID); string imageName = DSImages.tbl_Images.FindByImageID(company.CompanyImageID).ImageName; CompanyImage = "<img src='" + companyLogoPath + "l_" + imageName + "' />"; } hasHuntingInventoryAccess = company.CompanyRentalInventory; } string createOrder = ""; createOrder += "<table border='0' cellspacing='0' cellpadding='0'><tr>"; createOrder += "<td><img src='" + huntingLogoPath + "' /></td>"; createOrder += "<td style='text-align:right;'>" + CompanyImage + "</td>"; createOrder += "</tr></table>"; createOrder += "<br>"; createOrder += "<table class='orderdetails'>"; createOrder += "<tr><th colspan='4' class='heading'>Confirmation of " + _EmailType.ToUpper() + " ID: " + order.OrderID + "</th></tr><tr>"; createOrder += "<th width='20%'>Date</th>"; createOrder += "<td width='30%'>" + order.OrderDate.ToString("MMM d, yyyy h:mm tt") + "</td>"; createOrder += "<th width='20%'> </th>"; createOrder += "<td width='30%'> </td>"; createOrder += "</tr>"; createOrder += "<tr>"; if (_EmailType == "Order") { createOrder += "<th>Ordered By </th>"; } else { createOrder += "<th>Transferred By </th>"; } createOrder += "<td>" + order.OrderRequestedBy + "</td>"; createOrder += "<th width='16%'>Rig </th>"; createOrder += "<td width='34%'>" + order.OrderRigNumber + "</td>"; createOrder += "</tr>"; createOrder += "<tr>"; createOrder += "<th>Ship To </th>"; createOrder += "<td>" + order.OrderShipTo + "</td>"; createOrder += "<th>Job # </th>"; createOrder += "<td>" + order.OrderJobNumber + "</td>"; createOrder += "</tr>"; createOrder += "<tr>"; createOrder += "<th>Via </th>"; createOrder += "<td>" + order.OrderShipVIA + "</td>"; createOrder += "<th>Lease </th>"; createOrder += "<td>" + order.OrderLeaseNumber + "</td>"; createOrder += "</tr>"; createOrder += "<tr>"; createOrder += "<th>Date Required </th>"; createOrder += "<td>" + order.OrderDateRequired.ToString("MMM d, yyyy") + "</td>"; createOrder += "<th>Time Required</th>"; createOrder += "<td>" + order.OrderTimeRequired + "</td>"; createOrder += "</tr>"; createOrder += "<tr>"; createOrder += "<th>Comments</th>"; createOrder += "<td colspan='3'>" + order.OrderComments + "</td>"; createOrder += "</tr></table>"; ArrayList columns = new ArrayList(); createOrder += "<br><table class='itemdetails'><tr>"; if(hasHuntingInventoryAccess) { createOrder += "<th width='40px' nowrap='true'>B/R</th>"; columns.Add("BuyRentStatus"); } createOrder += "<th>" + aliases.ItemNumber + "</th>"; columns.Add("ItemNumber"); createOrder += "<th>" + aliases.Description + "</th>"; columns.Add("Description"); createOrder += "<th>" + aliases.Box + "</th>"; columns.Add("Box"); createOrder += "<th>" + aliases.Pin + "</th>"; columns.Add("Pin"); createOrder += "<th>" + aliases.MajorOD + "</th>"; columns.Add("MajorOD"); createOrder += "<th>" + aliases.MinorOD + "</th>"; columns.Add("MinorOD"); createOrder += "<th>" + aliases.InsideDiameter + "</th>"; columns.Add("InsideDiameter"); createOrder += "<th>" + aliases.SealtoSealLength + "</th>"; columns.Add("SealtoSealLength"); createOrder += "<th>" + aliases.FloatBore + "</th>"; columns.Add("FloatBore"); createOrder += "<th>" + aliases.Box2 + "</th>"; columns.Add("Box2"); createOrder += "<th>" + aliases.GeneralComments + "</th>"; columns.Add("GeneralComments"); if (!aliases.IsExtraColumn1Null()) { createOrder += "<th>" + aliases.ExtraColumn1 + "</th>"; columns.Add("ExtraColumn1"); } if (!aliases.IsExtraColumn2Null()) { createOrder += "<th>" + aliases.ExtraColumn2 + "</th>"; columns.Add("ExtraColumn2"); } if (!aliases.IsExtraColumn3Null()) { createOrder += "<th>" + aliases.ExtraColumn3 + "</th>"; columns.Add("ExtraColumn3"); } if (!aliases.IsExtraColumn4Null()) { createOrder += "<th>" + aliases.ExtraColumn4 + "</th>"; columns.Add("ExtraColumn4"); } if (!aliases.IsExtraColumn5Null()) { createOrder += "<th>" + aliases.ExtraColumn5 + "</th>"; columns.Add("ExtraColumn5"); } if (!aliases.IsExtraColumn6Null()) { createOrder += "<th>" + aliases.ExtraColumn6 + "</th>"; columns.Add("ExtraColumn6"); } if (!aliases.IsExtraColumn7Null()) { createOrder += "<th>" + aliases.ExtraColumn7 + "</th>"; columns.Add("ExtraColumn7"); } if (!aliases.IsExtraColumn8Null()) { createOrder += "<th>" + aliases.ExtraColumn8 + "</th>"; columns.Add("ExtraColumn8"); } if (!aliases.IsExtraColumn9Null()) { createOrder += "<th>" + aliases.ExtraColumn9 + "</th>"; columns.Add("ExtraColumn9"); } if (!aliases.IsExtraColumn10Null()) { createOrder += "<th>" + aliases.ExtraColumn10 + "</th>"; columns.Add("ExtraColumn10"); } createOrder += "</tr>"; int rowCount = 0; string strColor2 = ""; foreach (BEOrders.tbl_OrderDetailsRow item in dsOrder.tbl_OrderDetails.Rows) { rowCount += 1; if (rowCount % 2 == 0) { strColor2 = "#efefef"; } else { strColor2 = "#ffffff"; } createOrder += "<tr class='tablerows' bgColor='" + strColor2 + "'>"; foreach (string col in columns) { if (item[col] != null && item[col].ToString() != "") { createOrder += "<td>" + item[col].ToString() + "</td>"; } else { createOrder += "<td> </td>"; } } createOrder += "</tr>"; } createOrder += "</table>"; createOrder += "<table cellpadding='0' cellspacing='0' border='0' align='center'>"; createOrder += "<tr><td align='center'>_________________________________________________</td></tr>"; createOrder += "<tr><td align='center'>"; createOrder += "If you require further clarification please call <br/>"; createOrder += "Mazz Oilfield Services. Customer Service at:<br>"; createOrder += "(403) 720-6299"; createOrder += "<br/><br/>"; createOrder += " Thank you for using Mazz Oilfield Services Online."; createOrder += "</td></tr></table>"; createOrder += "</div><div class='bottom'></div>"; Response.Write(createOrder); }
private void DeleteOrder(int someOrderID) { if (someOrderID > 0) { BPOrders bp = new BPOrders(); BPOrderDetails bpOD = new BPOrderDetails(); BEOrders.tbl_OrdersRow Order; DSOrders = bp.SelectOrdersByID(someOrderID); Order = DSOrders.tbl_Orders.FindByOrderID(someOrderID); if (!Order.OrderCompleted) ChangeInventoryStatus(someOrderID, Convert.ToInt32(!Order.IsTransfer)); Order.Delete(); DSOrders.Merge(bpOD.SelectOrderDetailsWithInventoryByOrderID(someOrderID)); foreach (BEOrders.tbl_OrderDetailsRow row in DSOrders.tbl_OrderDetails.Rows) { row.Delete(); } bp.Update(DSOrders); bpOD.Update(DSOrders); } }
private void ChangeInventoryStatus(int OrderID, int newStatus) { BPOrders bp = new BPOrders(); bp.ChangeInventoryInStockStatusForCompletedOrder(OrderID, newStatus); }
private void DeleteOrder(int someOrderID) { if (someOrderID > 0) { UpdateOrderItemJobNumbers(someOrderID, string.Empty ); BPOrders bp = new BPOrders(); BPOrderDetails bpOD = new BPOrderDetails(); BEOrders.tbl_OrdersRow Order; DSOrders = bp.SelectOrdersByID(someOrderID); Order = DSOrders.tbl_Orders.FindByOrderID(someOrderID); if (!Order.OrderCompleted) ChangeInventoryStatus(someOrderID, 0); Order.Delete(); DSOrders.Merge(bpOD.SelectOrderDetailsWithInventoryByOrderID(someOrderID)); foreach (BEOrders.tbl_OrderDetailsRow row in DSOrders.tbl_OrderDetails.Rows) { row.Delete(); } bp.Update(DSOrders); bpOD.Update(DSOrders); } }
private void GetOrderInfo() { BPOrders bp = new BPOrders(); BEOrders ds = bp.SelectOrdersByID(OrderID); BEOrders.tbl_OrdersRow Order = ds.tbl_Orders.FindByOrderID(OrderID); if (Order == null) { Response.Redirect("BrowseTransfers.aspx"); } lblTitleAction.Text = "Edit "; ddlCompanies.SelectedIndex = -1; ListItem tmpItem = ddlCompanies.Items.FindByValue(Order.CompanyID.ToString()); if (tmpItem != null) { tmpItem.Selected = true; GlobalCompanyID = Convert.ToInt32(ddlCompanies.SelectedValue); CompanyName = ddlCompanies.SelectedItem.Text; ddlCompanies.Enabled = false; CheckRentalStatus(); lblTitleType.Text = CompanyName + " Transfer - #" + Order.OrderID; if (! Order.IsOrderRigNumberNull()) { txtOrderRigNumber.Text = Order.OrderRigNumber;} if (! Order.IsOrderJobNumberNull()) { txtOrderJobNumber.Text = Order.OrderJobNumber;} dtOrderDateRequired.SelectedDate = Order.OrderDateRequired; if (! Order.IsOrderTimeRequiredNull()) { txtOrderTimeRequired.Text = Order.OrderTimeRequired;} if (! Order.IsOrderRequestedByNull()) { txtOrderRequestedBy.Text = Order.OrderRequestedBy;} if (! Order.IsOrderShipVIANull()) { txtOrderShipVIA.Text = Order.OrderShipVIA;} if (! Order.IsOrderLeaseNumberNull()) { txtOrderLeaseNumber.Text = Order.OrderLeaseNumber;} if (! Order.IsOrderShipToNull()) { txtOrderShipTo.Text = Order.OrderShipTo;} if (! Order.IsOrderCommentsNull()) { txtOrderComments.Text = Order.OrderComments;} pnlEquipmentOrdered.Visible = true; if (Order.OrderCompleted == true) { btnReview.Visible = true; pnlViewInventory.Visible = false; OrderCompleted = true; } else { pnlViewInventory.Visible = true; } } }
private void CheckForIncompleteOrder() { BPOrders bp = new BPOrders(); BEOrders ds = new BEOrders(); ds = bp.SelectIncompleteByAdminID(OryxUser.OryxIdentity.MemberID); ds.tbl_Orders.DefaultView.RowFilter = "IsTransfer=1"; if (ds.tbl_Orders.DefaultView.Count > 0) { if (ddlCompanies.Items.FindByValue(ds.tbl_Orders.DefaultView[0]["CompanyID"].ToString()) != null) { OrderID = Convert.ToInt32(ds.tbl_Orders.DefaultView[0]["OrderID"]); } } }
protected void BindSalesList(int CustomerID) { BPOrders bp = new BPOrders(); DSOrders = bp.SelectByCustomerID(CustomerID); string searchString = string.Empty; if (dtStart.SelectedDate != DateTime.MinValue) { searchString += String.Format("OrderDate >= {0}", dtStart.SelectedDate.ToString("MM/dd/yyyy")); } if (dtEnd.SelectedDate != DateTime.MinValue) { if (searchString != string.Empty) { searchString += " and "; } searchString += String.Format("OrderDate <= {0}", dtEnd.SelectedDate.ToString("MM/dd/yyyy")); } DSOrders.tbl_Orders.DefaultView.RowFilter = searchString; dgOrders.DataBind(); }
protected void BindSalesList() { int CustomerID = Convert.ToInt32(ddlCustomers.SelectedValue); BPOrders bp = new BPOrders(); if (CustomerID == -1) { DSOrders = bp.SelectAll(); } else { DSOrders = bp.SelectByCustomerID(CustomerID); } string searchString = string.Empty; if (dtStart.SelectedDate != DateTime.MinValue) { //searchString += String.Format("OrderDate >= '{0}'", dtStart.SelectedDate.ToString("MM/dd/yyyy")); searchString += String.Format("OrderDate >= '{0}'", Convert.ToDateTime(dtStart.SelectedDate.ToString("MM/dd/yyyy"))); //searchString += String.Format("OrderDate >= '" + dtStart.SelectedDate.ToString("MM/dd/yyyy") + "'"); //searchString += "OrderDate >= " + Convert.ToDateTime(dtStart.SelectedDate.ToString("MM/dd/yyyy")); } if (dtEnd.SelectedDate != DateTime.MinValue) { if (searchString != string.Empty) { searchString += " and "; } //searchString += String.Format("OrderDate <= '{0}'", dtEnd.SelectedDate.ToString("MM/dd/yyyy")); searchString += String.Format("OrderDate < '{0}'", Convert.ToDateTime((dtEnd.SelectedDate.AddDays(1).ToString("MM/dd/yyyy")))); //searchString += String.Format("OrderDate <= '" + dtEnd.SelectedDate.ToString("dd/MM/yyyy") + "'"); //searchString += "OrderDate <= " + Convert.ToDateTime(dtEnd.SelectedDate.ToString("MM/dd/yyyy")); } string Filter = searchString; if (Filter != null && Filter != "" && Filter != " ") { Filter = "(" + Filter + ") and "; } Filter += " OrderApproved = 1"; //DataRow [] somearray; //somearray = DSOrders.tbl_Orders.Select(Filter); DSOrders.tbl_Orders.DefaultView.RowFilter = Filter; }
private void btnSubmit_Click(object sender, EventArgs e) { BPOrders bp = new BPOrders(); BEOrders.tbl_OrdersRow Order; DSOrders = new BEOrders(); if (OrderID == 0) { // Add new Order Order = DSOrders.tbl_Orders.Newtbl_OrdersRow(); Order.OrderCompleted = false; Order.OrderCurrent = true; } else { // Edit a Order DSOrders = bp.SelectOrdersByID(OrderID); Order = DSOrders.tbl_Orders.FindByOrderID(OrderID); Order.OrderCompleted = true; } //all content to be updated/inserted between here Order.CompanyID = CompanyID; Order.CompanyUserID = Convert.ToInt32(OryxUser.OryxIdentity.MemberID); Order.OrderRigNumber = txtOrderRigNumber.Text; Order.OrderJobNumber = txtOrderJobNumber.Text; if (dtOrderDateRequired.SelectedDate != DateTime.MinValue) { Order.OrderDateRequired = Convert.ToDateTime(dtOrderDateRequired.SelectedDate); } else { Order.OrderDateRequired = DateTime.Now; } Order.OrderTimeRequired = txtOrderTimeRequired.Text; Order.OrderRequestedBy = txtOrderRequestedBy.Text; Order.OrderShipVIA = txtOrderShipVIA.Text; Order.OrderLeaseNumber = txtOrderLeaseNumber.Text; Order.OrderShipTo = txtOrderShipTo.Text; Order.OrderComments = txtOrderComments.Text; Order.IsTransfer = true; if (OrderID == 0) { Order.OrderDate = DateTime.Now; DSOrders.tbl_Orders.Addtbl_OrdersRow(Order); bp.Update(DSOrders); Response.Redirect("EditTransfers.aspx?OrderID=" + Order.OrderID); } else { ChangeInventoryStatus(OrderID, 0); CheckInPastOrders(); bp.Update(DSOrders); SendOrderEmail email = new SendOrderEmail("transfer"); string pdfFilePath = Server.MapPath(ConfigurationSettings.AppSettings["PDFFilePath"]); email.CreateAndSendEmails(((BEOrders.tbl_OrdersRow) DSOrders.tbl_Orders.Rows[0]).OrderID, pdfFilePath); Response.Redirect("OrderConfirmation.aspx?OrderID=" + OrderID); } }
private void GetOrderInfo() { BPOrders bpCat = new BPOrders(); BEOrders ds = bpCat.SelectOrdersByID(OrderID); BEOrders.tbl_OrdersRow order = ds.tbl_Orders.FindByOrderID(OrderID); lblTitle.Text = "View Order - " + order.OrderID + " - " + order.CustomerLastName + ", " + order.CustomerFirstName; lblOrderID.Text = order.OrderID.ToString(); lblOrderDate.Text = order.OrderDate.ToString(); lblCustomerFirstName.Text = order.CustomerFirstName; lblCustomerLastName.Text = order.CustomerLastName; if (!order.IsCustomerEmailNull()) { lblCustomerEmail.Text = order.CustomerEmail; } BPShippingMethods bp = new BPShippingMethods(); BEShipping.tbl_ShippingMethodsRow shipMethod = bp.SelectShippingMethodsByID(order.ShippingMethodID).tbl_ShippingMethods[0]; lblShippingMethod.Text = shipMethod.ShippingMethodName; if (order.OrderApproved == true) { imgApproved.Visible = true; imgNotApproved.Visible = false; }else { imgApproved.Visible = false; imgNotApproved.Visible = true; } //Billing address info lblBillingFirstName.Text = order.BillingFirstName; lblBillingLastName.Text = order.BillingLastName; lblBillingLine1.Text = order.BillingLine1; if (!order.IsBillingLine2Null()) { lblBillingLine2.Text = order.BillingLine2; } if (!order.IsBillingEmailNull()) { lblBillingEmail.Text = order.BillingEmail; } lblBillingPhone.Text = order.BillingPhone; lblBillingCity.Text = order.BillingCity; lblBillingProvinceName.Text = order.BillingProvinceName; lblBillingCountryName.Text = order.BillingCountryName; lblBillingPostalCode.Text = order.BillingPostalCode; //shipping address info lblShippingFirstName.Text = order.ShippingFirstName; lblShippingLastName.Text = order.ShippingLastName; lblShippingLine1.Text = order.ShippingLine1; if (!order.IsShippingLine2Null()) { lblShippingLine2.Text = order.ShippingLine2; } if (!order.IsShippingEmailNull()) { lblShippingEmail.Text = order.ShippingEmail; } lblShippingPhone.Text = order.ShippingPhone; lblShippingCity.Text = order.ShippingCity; lblShippingProvinceName.Text = order.ShippingProvinceName; lblShippingCountryName.Text = order.ShippingCountryName; lblShippingPostalCode.Text = order.ShippingPostalCode; //Order Details DSOrders = bpCat.SelectOrderDetailsByOrderID(OrderID); rptOrderList.DataBind(); }
private void CheckInPastOrders() { BPOrders bp = new BPOrders(); foreach (GridItem dgi in dgEquipmentOrdered.Items) { bp.UpdateCurrentStatusByInventoryID(Convert.ToInt32(dgi[12]), true); } }
private void rptOrderList_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == System.Web.UI.WebControls.ListItemType.Footer) { BPOrders bpCat = new BPOrders(); BEOrders ds = bpCat.SelectOrdersByID(OrderID); BEOrders.tbl_OrdersRow order = ds.tbl_Orders.FindByOrderID(OrderID); ((Label)e.Item.FindControl("lblSubTotal")).Text = order.OrderSubTotal.ToString(MONEY_FORMAT); ((Label)e.Item.FindControl("lblDiscount")).Text = order.OrderDiscount.ToString(MONEY_FORMAT); ((Label)e.Item.FindControl("lblGST")).Text = order.OrderGST.ToString(MONEY_FORMAT); ((Label)e.Item.FindControl("lblShippingSurcharge")).Text = order.OrderShippingSurcharge.ToString(MONEY_FORMAT); ((Label)e.Item.FindControl("lblShipping")).Text = order.OrderShipping.ToString(MONEY_FORMAT); ((Label)e.Item.FindControl("lblTotal")).Text = order.OrderTotal.ToString(MONEY_FORMAT); } }
private void CheckOldOrders() { BPOrders bp = new BPOrders(); DSOrders = bp.SelectOldOrders(); foreach (BEOrders.tbl_OrdersRow oldOrder in DSOrders.tbl_Orders) { DeleteOrder(oldOrder.OrderID); } }
private void btnAdd_Click(object sender, EventArgs e) { int inventoryID = 0; string newUsed = ""; string jobNumber = ""; BPOrderDetails bpOrderDetails = new BPOrderDetails(); BPOrders bpOrders = new BPOrders(); BPInventory bpInventory = new BPInventory(); DSInventory = new BEInventory(); GridItemCollection CheckedCollection = new GridItemCollection(); CheckedCollection = dgInventory.GetCheckedItems(dgInventory.Levels[0].Columns[1]); if (OrderID > 0 && OrderCompleted == false) { DSOrders = bpOrderDetails.SelectByOrderID(OrderID); DSOrders.Merge(bpOrders.SelectOrdersByID(OrderID)); //for tracking JobNumber with inventory item if(DSOrders.tbl_Orders.Count > 0) { BEOrders.tbl_OrdersRow order = DSOrders.tbl_Orders[0]; jobNumber = order.IsOrderJobNumberNull() ? "" : order.OrderJobNumber; } foreach (GridItem item in CheckedCollection) { inventoryID = Convert.ToInt32(item[0]); newUsed = item[3].ToString(); DSOrders.tbl_OrderDetails.DefaultView.RowFilter = "InventoryID=" + inventoryID; if (DSOrders.tbl_OrderDetails.DefaultView.Count == 0) { BEOrders.tbl_OrderDetailsRow OrderDetails; OrderDetails = DSOrders.tbl_OrderDetails.Newtbl_OrderDetailsRow(); OrderDetails.OrderID = OrderID; OrderDetails.InventoryID = inventoryID; OrderDetails.InventoryItemReturned = false; switch ((InventoryTypes)InventoryType) { case InventoryTypes.Buy: if(newUsed.ToLower() == "new") OrderDetails.BuyRentStatus = "Buy-N"; else OrderDetails.BuyRentStatus = "Buy-U"; break; case InventoryTypes.Rental: OrderDetails.BuyRentStatus = "Rent"; break; default: OrderDetails.SetBuyRentStatusNull(); break; } DSOrders.tbl_OrderDetails.Addtbl_OrderDetailsRow(OrderDetails); BEInventory.tbl_InventoryRow Inventory; DSInventory.Merge(bpInventory.SelectInventoryByID(inventoryID)); Inventory = DSInventory.tbl_Inventory.FindByInventoryID(inventoryID); Inventory.InventoryInStock = 2; //track order's JobNumber with inventory item if(jobNumber != "") Inventory.JobNumber = jobNumber; else Inventory.SetJobNumberNull(); } } bpOrderDetails.Update(DSOrders); bpInventory.Update(DSInventory); } // reset or turn off warning message on submit button // if (CheckedCollection.Count > 0) // { // SetSubmitButtonWarningMessage(OrderID); // } dgInventory.UnCheckAll(); BindDSInventory(); BindDSOrders(); }
public void CreateAndSendEmails(int orderID, string pdfFilePath) { BPOrders bpOrder = new BPOrders(); BPOrderDetails bpDetails = new BPOrderDetails(); BEOrders dsOrder = bpOrder.SelectOrdersByID(orderID); dsOrder.Merge(bpDetails.SelectOrderDetailsWithInventoryByOrderID(orderID)); BEOrders.tbl_OrdersRow order = (BEOrders.tbl_OrdersRow) dsOrder.tbl_Orders.Rows[0]; BPCompanyEmails bp = new BPCompanyEmails(); BPCompanies bpCompany = new BPCompanies(); BPCompanyAliases bpAliases = new BPCompanyAliases(); BECompanies ds = bp.SelectActiveCompanyEmailsByCompanyID(order.CompanyID); ds.Merge(bpCompany.SelectCompaniesByID(order.CompanyID)); ds.Merge(bpAliases.SelectCompanyColumnsByCompanyID(order.CompanyID)); BECompanies.tbl_CompanyAliasesRow aliases = (BECompanies.tbl_CompanyAliasesRow) ds.tbl_CompanyAliases.Rows[0]; BECompanies.tbl_CompaniesRow company; bool hasHuntingInventoryAccess = false; string CompanyImage = ""; if(ds.tbl_Companies.Count > 0) { company = (BECompanies.tbl_CompaniesRow) ds.tbl_Companies.Rows[0]; if (!company.IsCompanyImageIDNull()) { BPImages bpImages = new BPImages(); BEImages DSImages = bpImages.SelectByID(company.CompanyImageID); string imageName = DSImages.tbl_Images.FindByImageID(company.CompanyImageID).ImageName; CompanyImage = "<img src='" + companyLogoPath + "l_" + imageName + "' />"; } hasHuntingInventoryAccess = company.CompanyRentalInventory; } MailMessage mm = new MailMessage(); mm.Subject = "Confirmation of " + _EmailType.ToUpper() + " ID:" + orderID; foreach (BECompanies.tbl_CompanyEmailsRow row in ds.tbl_CompanyEmails.Rows) { mm.To += row.CompanyEmail + ";"; } mm.From = ConfigurationSettings.AppSettings.Get("AdministratorEmailFrom"); mm.Fields["http://schemas.microsoft.com/cdo/configuration/smtpserverport"] = Convert.ToInt32(ConfigurationSettings.AppSettings["SmtpServerPort"]); SmtpMail.SmtpServer = ConfigurationSettings.AppSettings.Get("SmtpServer"); string createOrder = ""; createOrder += "<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01//EN' 'http://www.w3.org/TR/html4/strict.dtd'>"; createOrder += "<Html><head><LINK href='" + cssLinkPath + "screen.css' type='text/css' rel='stylesheet'></head><body class='alignleft'><div class='top'></div><div class='wrap'>"; createOrder += "<table border='0' cellspacing='0' cellpadding='0' style='margin-bottom:10px;' class='tablewidth'><tr>"; createOrder += "<td><img src='" + huntingLogoPath + "' /></td>"; createOrder += "<td style='text-align:right;'>" + CompanyImage + "</td>"; createOrder += "</tr></table>"; //new order details table createOrder += "<table class='orderdetails tablewidth'>"; createOrder += "<tr><th colspan='4' class='heading'>Confirmation of " + _EmailType.ToUpper() + " ID: " + order.OrderID + "</th></tr><tr>"; createOrder += "<th width='20%'>Date</th>"; createOrder += "<td width='30%'>" + order.OrderDate.ToString("MMM d, yyyy h:mm tt") + "</td>"; createOrder += "<th width='20%'> </th>"; createOrder += "<td width='30%'> </td>"; createOrder += "</tr>"; createOrder += "<tr>"; if (_EmailType == "Order") { createOrder += "<th>Ordered By </th>"; } else { createOrder += "<th>Received By </th>"; } createOrder += "<td>" + order.OrderRequestedBy + "</td>"; createOrder += "<th width='16%'>Rig </th>"; createOrder += "<td width='34%'>" + order.OrderRigNumber + "</td>"; createOrder += "</tr>"; createOrder += "<tr>"; createOrder += "<th>Ship To </th>"; createOrder += "<td>" + order.OrderShipTo + "</td>"; createOrder += "<th>Job # </th>"; createOrder += "<td>" + order.OrderJobNumber + "</td>"; createOrder += "</tr>"; createOrder += "<tr>"; createOrder += "<th>Via </th>"; createOrder += "<td>" + order.OrderShipVIA + "</td>"; createOrder += "<th>Lease </th>"; createOrder += "<td>" + order.OrderLeaseNumber + "</td>"; createOrder += "</tr>"; createOrder += "<tr>"; if (_EmailType == "Order") { createOrder += "<th>Date Required </th>"; } else { createOrder += "<th>Date Received </th>"; } createOrder += "<td>" + order.OrderDateRequired.ToString("MMM d, yyyy") + "</td>"; if (_EmailType == "Order") { createOrder += "<th>Time Required</th>"; } else { createOrder += "<th>Time Received</th>"; } createOrder += "<td>" + order.OrderTimeRequired + "</td>"; createOrder += "</tr>"; createOrder += "<tr>"; createOrder += "<th>Comments</th>"; createOrder += "<td colspan='3'>" + order.OrderComments + "</td>"; createOrder += "</tr></table><div style='page-break-after:avoid'> </div>"; ArrayList columns = new ArrayList(); createOrder += "<table class='emailitemdetails'><tr>"; if(hasHuntingInventoryAccess) { createOrder += "<th width='40px'>B/R</th>"; columns.Add("BuyRentStatus"); } createOrder += "<th>" + aliases.ItemNumber + "</th>"; columns.Add("ItemNumber"); createOrder += "<th>" + aliases.Description + "</th>"; columns.Add("Description"); createOrder += "<th>" + aliases.Box + "</th>"; columns.Add("Box"); createOrder += "<th>" + aliases.Pin + "</th>"; columns.Add("Pin"); createOrder += "<th>" + aliases.MajorOD + "</th>"; columns.Add("MajorOD"); createOrder += "<th>" + aliases.MinorOD + "</th>"; columns.Add("MinorOD"); createOrder += "<th>" + aliases.InsideDiameter + "</th>"; columns.Add("InsideDiameter"); createOrder += "<th>" + aliases.SealtoSealLength + "</th>"; columns.Add("SealtoSealLength"); createOrder += "<th>" + aliases.FloatBore + "</th>"; columns.Add("FloatBore"); createOrder += "<th>" + aliases.Box2 + "</th>"; columns.Add("Box2"); createOrder += "<th>" + aliases.GeneralComments + "</th>"; columns.Add("GeneralComments"); if (!aliases.IsExtraColumn1Null()) { createOrder += "<th>" + aliases.ExtraColumn1 + "</th>"; columns.Add("ExtraColumn1"); } if (!aliases.IsExtraColumn2Null()) { createOrder += "<th>" + aliases.ExtraColumn2 + "</th>"; columns.Add("ExtraColumn2"); } if (!aliases.IsExtraColumn3Null()) { createOrder += "<th>" + aliases.ExtraColumn3 + "</th>"; columns.Add("ExtraColumn3"); } if (!aliases.IsExtraColumn4Null()) { createOrder += "<th>" + aliases.ExtraColumn4 + "</th>"; columns.Add("ExtraColumn4"); } if (!aliases.IsExtraColumn5Null()) { createOrder += "<th>" + aliases.ExtraColumn5 + "</th>"; columns.Add("ExtraColumn5"); } if (!aliases.IsExtraColumn6Null()) { createOrder += "<th>" + aliases.ExtraColumn6 + "</th>"; columns.Add("ExtraColumn6"); } if (!aliases.IsExtraColumn7Null()) { createOrder += "<th>" + aliases.ExtraColumn7 + "</th>"; columns.Add("ExtraColumn7"); } if (!aliases.IsExtraColumn8Null()) { createOrder += "<th>" + aliases.ExtraColumn8 + "</th>"; columns.Add("ExtraColumn8"); } if (!aliases.IsExtraColumn9Null()) { createOrder += "<th>" + aliases.ExtraColumn9 + "</th>"; columns.Add("ExtraColumn9"); } if (!aliases.IsExtraColumn10Null()) { createOrder += "<th>" + aliases.ExtraColumn10 + "</th>"; columns.Add("ExtraColumn10"); } createOrder += "<td class='lastcell'> </td></tr>"; int rowCount = 0; string strColor2 = ""; foreach (BEOrders.tbl_OrderDetailsRow item in dsOrder.tbl_OrderDetails.Rows) { rowCount += 1; if (rowCount % 2 == 0) { strColor2 = "#efefef"; } else { strColor2 = "#ffffff"; } createOrder += "<tr style='page-break-inside:avoid'>"; foreach (string col in columns) { if (item[col] != null && item[col].ToString() != "") { if(col == "BuyRentStatus") createOrder += "<td nowrap bgColor='" + strColor2 + "'>" + item[col].ToString() + "</td>"; else createOrder += "<td bgColor='" + strColor2 + "'>" + item[col].ToString() + "</td>"; } else { createOrder += "<td bgColor='" + strColor2 + "'> </td>"; } } createOrder += "<td class='lastcell'> </td></tr>"; } createOrder += "</table>"; createOrder += "<br><div style='page-break-inside:avoid;'><hr><table cellpadding='0' cellspacing='0' border='0' align='center'>"; createOrder += "<tr><td align='center'>"; createOrder += "If you require further clarification please call Mazz Oilfield Services. Customer Service at (403) 720-6299."; createOrder += "<br/>"; createOrder += " Thank you for using Mazz Oilfield Services Online!"; createOrder += "</td></tr></table><hr></div>"; createOrder += "<br><table class='shippingdept' style='width: 550px !important;' align='center'>"; createOrder += "<tr><th colspan='2' class='heading'>ORDER ID: " + order.OrderID + " - Shipping Verification</th></tr>"; createOrder += "<tr><th>Information Check List</th><th width='50%'>Shipper's Initial</td></th>"; createOrder += "<tr bgColor='#efefef'><td><img src='" + activeIconPath + "'> Check Box Connections</td><td> </td></tr>"; createOrder += "<tr><td><img src='" + activeIconPath + "'> Check Pin Connections</td><td> </td></tr>"; createOrder += "<tr bgColor='#efefef'><td><img src='" + activeIconPath + "'> Check Serial Numbers</td><td> </td></tr>"; createOrder += "<tr><td><img src='" + activeIconPath + "'> Gauge Float Bore</td><td> </td></tr>"; createOrder += "<tr bgColor='#efefef'><td><img src='" + activeIconPath + "'> Gauge UBHO Bore</td><td> </td></tr>"; createOrder += "<tr><td><img src='" + activeIconPath + "'> Check Protectors</td><td> </td></tr>"; createOrder += "</table><br>"; createOrder += "<br><table class='receiver' align='center'>"; createOrder += "<tr><td align='left'>All Items Verified and Thread Protectors Installed:</td><td align='center'>____________________________________</td></tr>"; createOrder += "<tr><td> </td><td align='center'>RECEIVER</td></tr>"; createOrder += "</table></br>"; createOrder += "</div><div class='bottom'></div>"; createOrder += "</body></html>"; string pdfFileName = "ConfirmOrderID_" + orderID + ".pdf"; string fullPDFFilePath = pdfFilePath + pdfFileName; ConvertHTMLToPDF(createOrder, fullPDFFilePath); try { mm.Body = "Please review the attached PDF file for Order Confirmation"; MailAttachment pdfAttachment = new MailAttachment(fullPDFFilePath); mm.Attachments.Add(pdfAttachment); mm.BodyFormat = MailFormat.Html; SmtpMail.Send(mm); if (File.Exists(fullPDFFilePath)) File.Delete(fullPDFFilePath); } catch (Exception ex) { ex.ToString(); // Response.Redirect (strMWRequestBad); //response.write "There was a problem sending the email"; } }
private void btnReturnToStock_Click(object sender, EventArgs e) { string message = ""; if(ddlCompanies.SelectedValue == ConfigurationSettings.AppSettings["OryxCompanyID"]) message = ValidateOryxItems(); if(message == "") { BPInventory bp = new BPInventory(); BEInventory.tbl_InventoryRow InventoryItem; BEInventory DSInventory = new BEInventory(); if (InventoryID == 0) { // Add new Inventory Item InventoryItem = DSInventory.tbl_Inventory.Newtbl_InventoryRow(); } else { // Edit a Company DSInventory = bp.SelectInventoryByID(InventoryID); InventoryItem = DSInventory.tbl_Inventory.FindByInventoryID(InventoryID); } //all content to be updated/inserted between here InventoryItem.InventoryInStock = 1; InventoryItem.SetJobNumberNull(); InventoryItem.CompanyID = Convert.ToInt32(ddlCompanies.SelectedValue); InventoryItem.ItemNumber = txtItemNumber.Text; InventoryItem.Description = WriteNullableField(txtDescription.Text); InventoryItem.Box = WriteNullableField(txtBox.Text); InventoryItem.Pin = WriteNullableField(txtPin.Text); InventoryItem.Box2 = WriteNullableField(txtBox2.Text); InventoryItem.MajorOD = WriteNullableField(txtMajorOD.Text); InventoryItem.MinorOD = WriteNullableField(txtMinorOD.Text); InventoryItem.InsideDiameter = WriteNullableField(txtInsideDiameter.Text); InventoryItem.SealtoSealLength = WriteNullableField(txtSealToSeal.Text); InventoryItem.FloatBore = WriteNullableField(txtFloatBore.Text); InventoryItem.GeneralComments = WriteNullableField(txtComments.Text); InventoryItem.ExtraColumn1 = WriteNullableField(txtExtraColumn1.Text); InventoryItem.ExtraColumn2 = WriteNullableField(txtExtraColumn2.Text); InventoryItem.ExtraColumn3 = WriteNullableField(txtExtraColumn3.Text); InventoryItem.ExtraColumn4 = WriteNullableField(txtExtraColumn4.Text); InventoryItem.ExtraColumn5 = WriteNullableField(txtExtraColumn5.Text); InventoryItem.ExtraColumn6 = WriteNullableField(txtExtraColumn6.Text); InventoryItem.ExtraColumn7 = WriteNullableField(txtExtraColumn7.Text); InventoryItem.ExtraColumn8 = WriteNullableField(txtExtraColumn8.Text); InventoryItem.ExtraColumn9 = WriteNullableField(txtExtraColumn9.Text); InventoryItem.ExtraColumn10 = WriteNullableField(txtExtraColumn10.Text); if (Convert.ToInt32(ddlCompanies.SelectedValue) == Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings.Get("OryxCompanyID"))) { InventoryItem.InventoryRental = chkInventoryRent.Checked; if(txtRentalPrice.Text.Trim() != "") InventoryItem.RentalPrice = txtRentalPrice.Text.Trim(); else InventoryItem.SetRentalPriceNull(); InventoryItem.InventoryBuy = chkInventoryBuy.Checked; if(txtSalePriceNew.Text.Trim() != "") InventoryItem.SalePriceNew = txtSalePriceNew.Text.Trim(); else InventoryItem.SetSalePriceNewNull(); if(txtSalePriceUsed.Text.Trim() != "") InventoryItem.SalePriceUsed = txtSalePriceUsed.Text.Trim(); else InventoryItem.SetSalePriceUsedNull(); InventoryItem.InventoryNewUsed = rblNewUsed.SelectedValue; } else { InventoryItem.InventoryRental = false; InventoryItem.SetRentalPriceNull(); InventoryItem.InventoryBuy = false; InventoryItem.SetSalePriceNewNull(); InventoryItem.SetSalePriceUsedNull(); InventoryItem.SetInventoryNewUsedNull(); } InventoryItem.DateModified = DateTime.Now; InventoryItem.ModifiedByAdminID = Convert.ToInt32(OryxUser.OryxIdentity.MemberID); InventoryItem.InventoryActive = chkInventoryActive.Checked; if (InventoryID == 0) { //Add new Application Category InventoryItem.DateCreated = DateTime.Now; DSInventory.tbl_Inventory.Addtbl_InventoryRow(InventoryItem); } bp.Update(DSInventory); // // BPInventory bpInv = new BPInventory(); // BEInventory ds = bpInv.SelectInventoryByID(InventoryID); // BEInventory.tbl_InventoryRow row = ds.tbl_Inventory.FindByInventoryID(InventoryID); // row.InventoryInStock = 1; // bpInv.Update(ds); BPOrders bpOrders = new BPOrders(); bpOrders.UpdateCurrentStatusByInventoryID(InventoryID, false); Response.Redirect("BrowseInventory.aspx"); } else { lblMessage.Text = message; pnlMessage.Visible = true; } }