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;
}
}
