private static Order _getOrderData(Models.Order orderDetails) { var item1 = new Order.Item { ProductId = orderDetails.Product.ToString(), Quantity = orderDetails.Quantity, Files = new Order.Item.FileList { Content = $"https://www.printapi.nl/{orderDetails.ImagePath}", } }; var address = new Address { Name = orderDetails.Name, Line1 = orderDetails.Line1, PostCode = orderDetails.PostCode, City = orderDetails.City, Country = ConvertToProperCountry(orderDetails.CountryEnum), }; return(new Order { Email = orderDetails.EmailAddress, Items = new[] { item1 }, Shipping = new Order.ShippingInfo { Address = address } }); }
private void frmOrder_Load(object sender, System.EventArgs e) { this.Text += " - " + this.CompanyID; this.Title = this.Text; this.txtStudent.Enabled = false; this.txtTeacher.Enabled = false; this.txtOrderID.Focus(); IDetail = new Order.Item(); if (!Global.InDesignMode()) { this.txtStatus.Panels[5].Text = "Packing [" + Global.CurrrentLine + "]"; Pack oPack = new Pack(this.CompanyID); if (oPack.Find(Global.CurrrentLine)) { this.txtStatus.Panels[5].Text = "Packing [" + oPack.Description + "]"; } } /* Infragistics.Shared.ResourceCustomizer rc = Infragistics.Win.UltraWinGrid.Resources.Customizer; * * rc.SetCustomizedString("DeleteSingleRowPrompt", ""); * Grid.EventManager.AllEventsEnabled = false; * Grid.EventManager.SetEnabled(EventGroups.AllEvents, false);*/ PrintTitle(); }
private void AddItem() { this.IDetail.Quantity = 1; Order.Item item = new Order.Item(); item.ProductID = this.IDetail.ProductID; item.Description = this.IDetail.Description; item.Price = this.IDetail.Price; item.Length = this.IDetail.Length; item.Width = this.IDetail.Width; item.Height = this.IDetail.Height; if (!IfExist()) { item.Quantity = this.IDetail.Quantity; oOrder.Items.Add(this.IDetail.ProductID, item); } else { oOrder.Items[this.IDetail.ProductID].Quantity += this.IDetail.Quantity; } ShowDetail(); this.getTotals(); ActiveRow(); txtProductID.Focus(); return; }
private void frmPacking_Load(object sender, EventArgs e) { this.Text += " - " + this.CompanyID; this.lbCompany.Text = this.CompanyID; this.txtStudent.Enabled = false; this.txtTeacher.Enabled = false; this.txtOrderID.Focus(); IDetail = new Order.Item(); }
private void frmOrder_Load(object sender, System.EventArgs e) { this.Text += " - " + this.CompanyID; IDetail = new Order.Item(); txtCollected.Enabled = false; oOrder.CustomerID = this.CustomerID; if (!oOrder.oCustomer.Find(this.CustomerID)) { MessageBox.Show("Customer not found"); Close(); } oOrder.oCustomer.Brochures.Load(this.CompanyID, this.CustomerID); }
private void CreateOrder() { Order oOrder = new Order(_CompanyID); //Saving Order to SQL Server oOrder.CompanyID = _CompanyID; oOrder.CustomerID = _CustomerID; oOrder.Teacher = _Teacher; oOrder.Student = icrProcessor.Fields["LastName"].Result + ", " + icrProcessor.Fields["FirstName"].Result; Application.DoEvents(); String Code, Quantity; for (int i = 1; i <= 30; i++) { Code = icrProcessor.Fields["Code" + i.ToString()].GetResult(); Quantity = icrProcessor.Fields["Quantity" + i.ToString()].GetResult(); Code = Code.Trim(); Quantity = Quantity.Trim(); //oOrder.oProduct.CompanyID = _CompanyID; oOrder.oCustomer.Find(_CustomerID); if (Code != "" && Code.Length == 4) { if (oOrder.oProduct.Find(Code) && Quantity != "") { Order.Item Item = new Order.Item(); Item.ProductID = oOrder.oProduct.ID; Item.Quantity = Convert.ToInt32(Quantity.Trim()); Item.Description = oOrder.oProduct.Description; Item.Price = oOrder.oProduct.ExtendedPrice(oOrder.oCustomer); oOrder.Items.Add(oOrder.oProduct.ID, Item); oOrder.GetTotals(); } } } frmOrder ofrmOrder = new frmOrder(oOrder); ofrmOrder._OrderProcess = (int)OrderProcess.Discrepancy; ofrmOrder.ShowDialog(); }
private void frmOrder_Load(object sender, System.EventArgs e) { this.Text += " - " + this.CompanyID; this.lbCompany.Text = this.CompanyID; this.txtStudent.Enabled = false; this.txtTeacher.Enabled = false; this.txtOrderID.Focus(); IDetail = new Order.Item(); /* Infragistics.Shared.ResourceCustomizer rc = Infragistics.Win.UltraWinGrid.Resources.Customizer; * * rc.SetCustomizedString("DeleteSingleRowPrompt", ""); * Grid.EventManager.AllEventsEnabled = false; * Grid.EventManager.SetEnabled(EventGroups.AllEvents, false);*/ }
protected void AddItem(Order oOrder, Product oProduct, Int32 Quantity) { if (oOrder.Items.Contains(oProduct.ID)) { oOrder.Items[oProduct.ID].Quantity += Quantity; } else { Order.Item oItem = new Order.Item(oOrder.oMySql); oItem.ProductID = oProduct.ID; oItem.Quantity = Quantity; oItem.Price = oProduct.ExtendedPrice(oCustomer); oItem.Description = oProduct.Description; oItem.PackID = oOrder.oProduct.PackID(oCustomer); oOrder.Items.Add(oProduct.ID, oItem); } }
private void frmOrder_Load(object sender, System.EventArgs e) { this.Text += " - " + this.CompanyID; this.Title = this.Text; this.txtStudent.Enabled = false; this.txtTeacher.Enabled = false; this.txtOrderID.Focus(); IDetail = new Order.Item(); if (!Global.InDesignMode()) { this.txtStatus.Panels[5].Text = "Imprintint [" + Global.CurrrentLine + "]"; Pack oPack = new Pack(this.CompanyID); if (oPack.Find(Global.CurrrentLine)) { this.txtStatus.Panels[5].Text = "Imprinting [" + oPack.Description + "]"; } } oTicket = new Ticket(this.CompanyID); }
public Boolean CreateOrder() { Boolean ProcessOk = true; //Saving Order to SQL Server oOrder.Clear(); oOrder.CompanyID = CompanyID; oOrder.CustomerID = CustomerID; oOrder.Teacher = Teacher; oOrder.Type = OrderType.Scanned; SpellWord oWord = new SpellWord(); if (!oWord.GetResult(this.Fields["FirstName"])) { this.DrawRectangle(this.Fields["FirstName"]); ProcessOk = false; } String FirstName = oWord.Result; if (!oWord.GetResult(this.Fields["LastName"])) { this.DrawRectangle(this.Fields["LastName"]); ProcessOk = false; } String LastName = oWord.Result; // MessageBox.Show(oOrder.Student); oOrder.Student = LastName + ", " + FirstName; if (oOrder.Find(oOrder.Teacher, oOrder.Student)) { return(false); } String Digit = this.Fields["SchoolUse"].Result.Trim(); String nDecimal = this.Fields["SUDecimal"].Result.Trim(); if (Digit == "8") { Digit = "00"; } if (nDecimal == "") { nDecimal = "00"; } oOrder.Collected = Convert.ToDouble(Digit.Replace(" ", "") + "." + nDecimal.Replace(" ", "")); oOrder.oCustomer.Find(CustomerID); Application.DoEvents(); String Code, Quantity; for (int i = 1; i <= 30; i++) { Code = this.Fields["Code" + i.ToString()].Result; Quantity = this.Fields["Quantity" + i.ToString()].Result; Code = Code.Trim(); Quantity = Quantity.Trim(); //oOrder.oProduct.CompanyID = _CompanyID; Boolean bFound = false; if (Code != "" && Code.Length >= 3) { if (!oOrder.oProduct.Find(Code)) { if (!oOrder.oProduct.Find(Code)) { SpellWord oCode = new SpellWord(); ArrayList oCodes = oCode.getChars(this.Fields["Code" + i.ToString()]); foreach (String sCode in oCodes) { if (oOrder.oProduct.Find(sCode)) { //MessageBox.Show(sCode); Code = sCode; bFound = true; break; } } if (!bFound) { // MessageBox.Show("Not Found!:" + Field.Result); //this.Fields["Code" + i.ToString()].DrawRectangle(Color.Red); this.DrawRectangle(this.Fields["Code" + i.ToString()]); ProcessOk = false; continue; } } else { //MessageBox.Show("Ok:" + Field.Result); } } if (Quantity == "") { //this.Fields["Quantity" + i.ToString()].DrawRectangle(Color.Red); this.DrawRectangle(this.Fields["Quantity" + i.ToString()]); Quantity = "1"; } Order.Item Item = new Order.Item(); Item.ProductID = oOrder.oProduct.ID; Item.Quantity = Convert.ToInt32(Quantity.Trim().Replace(" ", "")); Item.Description = oOrder.oProduct.Description; Item.Price = oOrder.oProduct.ExtendedPrice(oOrder.oCustomer); if (oOrder.Items.Contains(oOrder.oProduct.ID)) { oOrder.Items[oOrder.oProduct.ID].Quantity += Item.Quantity; } else { oOrder.Items.Add(oOrder.oProduct.ID, Item); } } } oOrder.GetTotals(); /* * if (Math.Abs(oOrder.Diff) > 0) * { * this.Fields["SchoolUse"].DrawRectangle(Color.Red); * this.Fields["SUDecimal"].DrawRectangle(Color.Red); * ProcessOk = false; * * } */ return(ProcessOk); }
public void ConvertInvoiceToOrder(String CompanyID, String CustomerID, String Teacher) { Double DropPercentageCustomer = 0.00; Double DropPercentageItem = 0.00; DataTable dvInv = new DataTable(); dvInv = GetTotalDataTable("ProductID", DropPercentageCustomer, DropPercentageItem); if (dvInv.Rows.Count == 0) { MessageBox.Show("No Invoice Available for : " + CustomerID); return; } Order oOrder = new Order(CompanyID); oOrder.CustomerID = CustomerID; oOrder.oCustomer.Find(oOrder.CustomerID); oOrder.oCustomer.Brochures.Load(CompanyID, oOrder.CustomerID); oOrder.Teacher = Teacher; oOrder.Items.Clear(); Boolean firtTime = true; foreach (DataRow dvRow in dvInv.Rows) { if (firtTime) { oOrder.Student = dvRow["Student"].ToString(); firtTime = false; } // if (oOrder.oProduct.Find(dvRow["ProductID"].ToString())) { // Console.Out.WriteLine("Price: " + oOrder.oProduct.Price.ToString()); Order.Item Item = new Order.Item(); Item.ProductID = dvRow["ProductID"].ToString(); Item.Quantity = Convert.ToInt32(dvRow["Quantity"].ToString()); Item.Description = dvRow["Description"].ToString(); Item.Price = oOrder.oProduct.ExtendedPrice(oOrder.oCustomer); Item.PackID = oOrder.oProduct.PackID(oOrder.oCustomer); /* * row["CustomerID"] = dvRow["CustomerID"]; * row["ProductID"] = * row["Description"] = ; * row["Quantity"] = ; * row["Price"] = dvRow["Cost"]; * row["Tax"] = dvRow["Tax"]; * row["Total"] = dvRow["Total"]; */ //oOrder.Items.Add(oOrder.oProduct.ID, Item); oOrder.Items.Add(dvRow["ProductID"].ToString(), Item); } } oOrder.GetTotals(); oOrder.Collected = oOrder.Retail; oOrder.Save(); }
public Boolean CreateOrder() { Boolean ProcessOk = true; //Saving Order to SQL Server oOrder.Clear(); oOrder.CompanyID = CompanyID; oOrder.CustomerID = CustomerID; oOrder.Teacher = this.Teacher; oOrder.Type = OrderType.Scanned; //oOrder.Student = (oOrder.Fields["LastName"].Result + ", " + oOrder.Fields["FirstName"].Result).ToUpper(); if (oOrder.Find(oOrder.Teacher, oOrder.Student)) { return(false); } //oOrder.Collected = Convert.ToDouble(Digit + "." + nDecimal); //oOrder.oCustomer.Find(CustomerID); String Code, Quantity; for (int i = 1; i <= 30; i++) { Code = "ABC"; Quantity = "1"; Code = Code.Trim(); Quantity = Quantity.Trim(); //oOrder.oProduct.CompanyID = _CompanyID; if (Code != "" && Code.Length >= 3) { if (!oOrder.oProduct.Find(Code)) { ProcessOk = false; continue; } if (Quantity == "") { Quantity = "1"; } Order.Item Item = new Order.Item(); Item.ProductID = oOrder.oProduct.ID; Item.Quantity = Convert.ToInt32(Quantity.Trim().Replace(" ", "")); Item.Description = oOrder.oProduct.Description; Item.Price = oOrder.oProduct.ExtendedPrice(oOrder.oCustomer); if (oOrder.Items.Contains(oOrder.oProduct.ID)) { oOrder.Items[oOrder.oProduct.ID].Quantity += Item.Quantity; } else { oOrder.Items.Add(oOrder.oProduct.ID, Item); } } } oOrder.GetTotals(); if (Math.Abs(oOrder.Diff) > 0) { ProcessOk = false; } return(ProcessOk); }
public void ImportOrders() { DataSet dsTables = new DataSet(); dsTables.Tables.Add(this.oMySql.GetDataTable("Select * from ga_order Where Status='0'", "Order")); // dsTables.Tables.Add(this.oMySql.GetDataTable("Select * from ga_order Where Status='0'","OrderDetail")); Customer oCustomer = new Customer(this.CompanyID); GA_OrderInternet oOrder = new GA_OrderInternet(this.CompanyID); String strBody = ""; if (dsTables.Tables["Order"].Rows.Count > 0) { oOrder.OpenPrinter(1); } foreach (DataRow row in dsTables.Tables["Order"].Rows) { if (!oOrder.Exist((Int32)row["OrderID"], ShoppingType.GA)) { oOrder.Clear(); oOrder.IOrderID = (Int32)row["OrderID"]; oOrder.UpdateStatus(GA_InternetOrderStatus.Processing); oOrder.CustomerID = row["CustomerID"].ToString(); oOrder.Teacher = "RE-ORDER"; oOrder.Student = "RE-ORDER " + ((DateTime)row["Date"]).Month.ToString() + "/" + ((DateTime)row["Date"]).Day.ToString(); if (oOrder.Exist(oOrder.Teacher, oOrder.Student)) { oOrder.Student += "(" + row["OrderID"].ToString() + ")"; } oOrder.oCustomer.Find(oOrder.CustomerID); oOrder.oCustomer.Brochures.Load(this.CompanyID, oOrder.CustomerID); oOrder.Type = OrderType.GA_Internet; oOrder.Process = OrderProcess.Internet; oOrder.Items.Clear(); // Console.Out.WriteLine(oOrder.Student); DataTable dsDetail = oMySql.GetDataTable(String.Format("Select * from ga_order_detail Where OrderID='{0}'", row["OrderID"].ToString()), "Detail"); foreach (DataRow detailRow in dsDetail.Rows) { String ProductID = detailRow["ProductID"].ToString(); if (oOrder.oProduct.Find(ProductID)) { Order.Item Item = new Order.Item(); Item.ProductID = oOrder.oProduct.ID; Item.Quantity = (Int32)detailRow["Quantity"]; Item.Description = oOrder.oProduct.Description; Item.Price = oOrder.oProduct.ExtendedPrice(oOrder.oCustomer); Item.PackID = oOrder.oProduct.PackID(oOrder.oCustomer); if (oOrder.Items.Contains(oOrder.oProduct.ID)) { oOrder.Items[oOrder.oProduct.ID].Quantity += Item.Quantity; } else { oOrder.Items.Add(oOrder.oProduct.ID, Item); } } else { this.SendErrorEmail("Item Error " + oOrder.IOrderID.ToString() + " " + oOrder.Teacher + " " + oOrder.Student); } } oOrder.GetTotals(); oOrder.Collected = 0.00; // oOrder.Retail; oOrder.Save(OrderType.GA_Internet); //Printing Packing Slips if (oOrder.Find(Convert.ToInt32(oOrder.ID))) { oOrder.UpdateOrderID((Int32)row["OrderID"]); //Create Shortage Shortage oShortage = new Shortage(this.CompanyID); //oShortage.oOrder = oOrder; oShortage.OrderID = oOrder.ID; oShortage.oCustomer = oOrder.oCustomer; oShortage.CustomerID = oOrder.CustomerID; oShortage.SchoolName = oOrder.oCustomer.Name; oShortage.DayPhone = oOrder.oCustomer.PhoneNumber; oShortage.TeacherName = oOrder.Teacher; oShortage.StudentName = oOrder.Student; oShortage.Address = oOrder.oCustomer.Address; oShortage.City = oOrder.oCustomer.City; oShortage.ZipCode = oOrder.oCustomer.ZipCode; oShortage.State = oOrder.oCustomer.State; oShortage.Type = "I"; oShortage.Detail = oOrder.NoItems.ToString() + " Item(s)" + "\n\r" + "\n\r"; oShortage.Detail += "OrderID : " + oOrder.ID.ToString() + "\n\r"; oShortage.Detail += "Processed On : " + (row["Date"] == null ? "" : ((DateTime)row["Date"]).ToString()) + "\n\r"; oShortage.eMail = row["eMail"].ToString(); oShortage.Save(); // oShortage.Print(false); oOrder.ShortageID = Convert.ToInt32(oShortage.ID); oOrder.Print(); } else { this.SendErrorEmail(oOrder.IOrderID.ToString() + " " + oOrder.Teacher + " " + oOrder.Student + oOrder.LastError); } strBody += oOrder.ID.ToString() + " " + oOrder.Teacher.PadRight(30) + " " + oOrder.Student.PadRight(30).Substring(0, 30) + " " + oOrder.NoItems.ToString().PadRight(3).Substring(0, 3) + " " + oOrder.oCustomer.City + " " + oOrder.oCustomer.State + "\n\r"; Console.Out.WriteLine(DateTime.Now.ToString() + " " + oOrder.ID.ToString() + " " + oOrder.oCustomer.ID + " " + oOrder.oCustomer.Name); } if (!oOrder.UpdateStatus(GA_InternetOrderStatus.Processed)) { this.SendErrorEmail(oOrder.IOrderID.ToString() + " " + oOrder.Teacher + " " + oOrder.Student + oOrder.LastError); return; } } if (dsTables.Tables["Order"].Rows.Count > 0) { oOrder.ClosePrinter(); } /* //Sending Email * Smtp oSmtp = new Smtp(); * oSmtp.Subject = "Emails processed " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString(); * if (this.CustomerID == "TEST") * oSmtp.To = "\"Alvaro Medina\" <*****@*****.**>"; * else * oSmtp.To = "\"Daisy Caro\" <*****@*****.**>"; * oSmtp.From = "\"Signature Server\" <*****@*****.**>"; * * String strTitle = "Order ID Teacher Student Items City State Ship/Del Packed\n\r"; * strTitle += "------------------------------------------------------------------------------------------\n\r"; * oSmtp.Body = strTitle + strBody; * oSmtp.Send(); * } */ dsTables.Dispose(); }
public void ImportOrders(String Database, ShoppingType ShoppingCart, String CompanyID, String CustomerID) { this.CompanyID = CompanyID; this.CustomerID = CustomerID; Customer oCustomer = new Customer(this.CompanyID); /* * if (!oMySql.ChangeDatabase("69.89.31.153", "signatv9_sa", "sa", "signatv9_SigWeb")) * { * MessageBox.Show("We cannot open this database"); * return; * } */ oMySql.ChangeDatabase(Database); //DataTable dtOrders = oRemoteMysql.GetDataTable("SELECT * FROM cart_orders Where Status='"+(int)InternetOrderStatus.Pending+"' And open='n'","Order"); DataSet dsTables = oMySql.GetDataset("CALL get_tables();"); //MessageBox.Show(dsTables.Tables["Table6"].Rows.Count.ToString()); Console.WriteLine(ShoppingCart.ToString() + " " + dsTables.Tables["Table6"].Rows.Count.ToString() + " order(s)"); //return; //192.168.254.65 /* * if (!oMySql.ChangeDatabase(this.Local, "SigData", "SigData009", "SigData")) * { * return; * }*/ oMySql.ChangeDatabase("SigData"); dsTables.Tables["table"].TableName = "Customer"; dsTables.Tables["table1"].TableName = "Student"; dsTables.Tables["table2"].TableName = "CreditCard"; dsTables.Tables["table3"].TableName = "Shipment"; dsTables.Tables["table4"].TableName = "Detail"; dsTables.Tables["table5"].TableName = "Product"; dsTables.Tables["table6"].TableName = "Order"; dsTables.Tables["table7"].TableName = "CustomCard"; //dsTables.Tables.Add(dtOrders); DataRelation custOrderRel = dsTables.Relations.Add("OrdersCust", dsTables.Tables["Order"].Columns["customer"], dsTables.Tables["Customer"].Columns["id"], false); DataRelation studentOrderRel = dsTables.Relations.Add("OrdersStudent", dsTables.Tables["Order"].Columns["id"], dsTables.Tables["Student"].Columns["order_id"]); DataRelation detailOrderRel = dsTables.Relations.Add("OrdersDetail", dsTables.Tables["Order"].Columns["id"], dsTables.Tables["Detail"].Columns["order_id"]); DataRelation creditcardOrderRel = dsTables.Relations.Add("OrdersCreditcard", dsTables.Tables["Order"].Columns["id"], dsTables.Tables["CreditCard"].Columns["order_id"]); DataRelation shipOrderRel = dsTables.Relations.Add("OrdersShip", dsTables.Tables["Order"].Columns["id"], dsTables.Tables["Shipment"].Columns["order_id"]); DataRelation productDetailRel = dsTables.Relations.Add("DetailProduct", dsTables.Tables["Detail"].Columns["product_id"], dsTables.Tables["Product"].Columns["ProductID"], false); DataRelation productCustomCard = dsTables.Relations.Add("Custom_Card", dsTables.Tables["Detail"].Columns["id"], dsTables.Tables["CustomCard"].Columns["ticket_id"], false); //MySQL.conn = null; OrderInternet oOrder = new OrderInternet(this.CompanyID); //int i = 0; String strBody = ""; String strBodyPrizes = ""; if (dsTables.Tables["Order"].Rows.Count > 0) { oOrder.OpenPrinter(3); } foreach (DataRow row in dsTables.Tables["Order"].Rows) { oOrder.CustomerID = CustomerID; String StudentName = ""; String TeacherName = ""; String Customized = ""; if (row.GetChildRows(studentOrderRel).Length > 0) { TeacherName = row.GetChildRows(studentOrderRel)[0]["school_name"].ToString().ToUpper().Replace("\"", " ").Replace("'", " "); } if (TeacherName.Trim().Length == 0) { TeacherName = "GENERAL CUSTOMER"; StudentName = ((row.GetChildRows(shipOrderRel)[0]["FirstName"].ToString().Length > 0 ? (row.GetChildRows(shipOrderRel)[0]["FirstName"].ToString().Substring(0, 1)) : "?") + "." + row.GetChildRows(shipOrderRel)[0]["LastName"].ToString()).ToUpper().Replace("\"", " ").Replace("'", " "); } else { String Initial = ""; if (row.GetChildRows(shipOrderRel)[0]["FirstName"].ToString() != "") { Initial = row.GetChildRows(shipOrderRel)[0]["FirstName"].ToString().Substring(0, 1); } StudentName = (Initial + "." + row.GetChildRows(shipOrderRel)[0]["LastName"].ToString() + "-" + row.GetChildRows(studentOrderRel)[0]["student_name"].ToString()).ToUpper().Replace("\"", " ").Replace("'", " "); String Result = oCustomer.GetSchool(TeacherName, row.GetChildRows(studentOrderRel)[0]["school_city"].ToString()); if (oCustomer.Find(Result)) { TeacherName = oCustomer.Name.PadRight(30).Substring(0, 24) + " " + oCustomer.ID.Trim(); } else { TeacherName = TeacherName.PadRight(30).Substring(0, 24) + " " + "00000"; } // Console.Out.WriteLine(TeacherName + " " + Global.getState(row.GetChildRows(studentOrderRel)[0]["school_city"].ToString().ToUpper() )); } Console.Out.WriteLine(DateTime.Now.ToString() + "-" + TeacherName); // continue; if (!oOrder.Exist((Int32)row["id"], ShoppingCart)) { if (oOrder.Exist((ShoppingCart == ShoppingType.WLOT)? ShoppingType.WLOT.ToString():TeacherName, StudentName)) { if (StudentName.Length >= 33) { StudentName = StudentName.Substring(0, 33); } StudentName += "-" + row["id"].ToString(); } oOrder.Clear(); oOrder.CustomerID = CustomerID; oOrder.oCustomer.Find(oOrder.CustomerID); oOrder.oCustomer.Brochures.Load(this.CompanyID, oOrder.CustomerID); oOrder.Type = OrderType.Internet; oOrder.Process = OrderProcess.Internet; oOrder.IOrderID = (Int32)row["id"]; oOrder.Teacher = (ShoppingCart == ShoppingType.WLOT)? ShoppingType.WLOT.ToString():TeacherName; oOrder.Student = StudentName.Replace("\"", " ").Replace("'", " ");; oOrder.Items.Clear(); // Console.Out.WriteLine(oOrder.Student); foreach (DataRow detailRow in row.GetChildRows(detailOrderRel)) { // Console.Out.WriteLine("Product ID: " + detailRow["product_id"]); // Console.Out.WriteLine("Quantity: " + detailRow["quantity"]); //Console.Out.WriteLine("Description: " + oOrder.oProduct.Description); String ProductID = detailRow["product_id"].ToString(); if (IsMagazine(ProductID)) { if (detailRow.GetChildRows(productDetailRel).Length == 0) { this.SendErrorEmail(ShoppingCart.ToString() + " Item Error " + oOrder.IOrderID.ToString() + " " + oOrder.Teacher + " " + oOrder.Student + " Item:" + ProductID); continue; } else { ProductID = GetMagazineCode(ProductID, (Double)detailRow.GetChildRows(productDetailRel)[0]["Price"]); } } if (oOrder.oProduct.Find(ProductID)) { // Console.Out.WriteLine("Price: " + oOrder.oProduct.Price.ToString()); Order.Item Item = new Order.Item(); Item.ProductID = oOrder.oProduct.ID; Item.Quantity = (Int32)detailRow["quantity"]; Item.Description = oOrder.oProduct.Description; Item.Price = oOrder.oProduct.ExtendedPrice(oOrder.oCustomer); Item.PackID = oOrder.oProduct.PackID(oOrder.oCustomer); // Custom Card foreach (DataRow DetailRow in detailRow.GetChildRows(productCustomCard)) { Customized = "(Customized)"; // if (Item.ProductID != DetailRow["product_id"].ToString()) // continue; Ticket oTicket = new Ticket(oOrder.CompanyID); oTicket.OrderID = Convert.ToInt32(oOrder.ID); oTicket.Quantity = (Int32)detailRow["quantity"]; //1; Modified on 10/06/2001 oTicket.ProductID = DetailRow["product_id"].ToString(); //Line 1 Ticket.Line oLine = new Ticket.Line(); oLine.Text = (DetailRow["Line_1"].ToString().Length > 40 ? DetailRow["Line_1"].ToString().Substring(0, 39) : DetailRow["Line_1"].ToString()).ToUpper(); oLine.Type = Ticket.ImprintType.Card; oTicket.Lines.Add("Line_1", oLine); oLine = new Ticket.Line(); oLine.Text = (DetailRow["Line_2"].ToString().Length > 40 ? DetailRow["Line_2"].ToString().Substring(0, 39) : DetailRow["Line_2"].ToString()).ToUpper(); oLine.Type = Ticket.ImprintType.Card; oTicket.Lines.Add("Line_2", oLine); oLine = new Ticket.Line(); oLine.Text = (DetailRow["Line_3"].ToString().Length > 40 ? DetailRow["Line_3"].ToString().Substring(0, 39) : DetailRow["Line_3"].ToString()).ToUpper(); oLine.Type = Ticket.ImprintType.Card; oTicket.Lines.Add("Line_3", oLine); oLine = new Ticket.Line(); oLine.Text = (DetailRow["Line_4"].ToString().Length > 40 ? DetailRow["Line_4"].ToString().Substring(0, 39) : DetailRow["Line_4"].ToString()).ToUpper(); oLine.Type = Ticket.ImprintType.Card; oTicket.Lines.Add("Line_4", oLine); oLine = new Ticket.Line(); oLine.Text = (DetailRow["Line_5"].ToString().Length > 40 ? DetailRow["Line_5"].ToString().Substring(0, 39) : DetailRow["Line_5"].ToString()).ToUpper(); oLine.Type = Ticket.ImprintType.Card; oTicket.Lines.Add("Line_5", oLine); // Console.Out.WriteLine("Quantity: " + detailRow["quantity"]); //oTicket.Save(); Item.Tickets.Add(Item.ProductID, oTicket); } if (oOrder.Items.Contains(oOrder.oProduct.ID)) { oOrder.Items[oOrder.oProduct.ID].Quantity += Item.Quantity; } else { oOrder.Items.Add(oOrder.oProduct.ID, Item); } } else { this.SendErrorEmail(ShoppingCart.ToString() + " Item Error " + oOrder.IOrderID.ToString() + " " + oOrder.Teacher + " " + oOrder.Student + " Item:" + ProductID); } } oOrder.GetTotals(); oOrder.Collected = oOrder.Retail; oOrder.Save(OrderType.Internet); /* * //Custom Cards Detail * if (row.GetChildRows(productCustomCard).Length > 0) * { * if (oOrder.Find(Convert.ToInt32(oOrder.ID))) * { * foreach (DataRow detailRow in row.GetChildRows(productCustomCard)) * { * * Ticket oTicket = new Ticket(oOrder.CompanyID); * oTicket.OrderID = Convert.ToInt32(oOrder.ID); * oTicket.Quantity = 1; * oTicket.ProductID = detailRow["product_id"].ToString(); * * //Line 1 * Ticket.Line oLine = new Ticket.Line(); * oLine.Text = detailRow["Line_1"].ToString().Length > 40? detailRow["Line_1"].ToString().Substring(0,39):detailRow["Line_1"].ToString() ; * oLine.Type = Ticket.ImprintType.Card; * oTicket.Lines.Add("Line_1,",oLine); * * oLine = new Ticket.Line(); * oLine.Text = detailRow["Line_2"].ToString().Length > 40 ? detailRow["Line_2"].ToString().Substring(0, 39) : detailRow["Line_2"].ToString(); * oLine.Type = Ticket.ImprintType.Card; * oTicket.Lines.Add("Line_2,", oLine); * * oLine = new Ticket.Line(); * oLine.Text = detailRow["Line_3"].ToString().Length > 40 ? detailRow["Line_3"].ToString().Substring(0, 39) : detailRow["Line_3"].ToString(); * oLine.Type = Ticket.ImprintType.Card; * oTicket.Lines.Add("Line_3,", oLine); * * // Console.Out.WriteLine("Quantity: " + detailRow["quantity"]); * oTicket.Save(); * * * } * } * } */ //Printing Packing Slips if (oOrder.Find(Convert.ToInt32(oOrder.ID))) { oOrder.UpdateOrderID((Int32)row["id"], ShoppingCart); //Create Shortage Shortage oShortage = new Shortage(this.CompanyID); //oShortage.oOrder = oOrder; oShortage.OrderID = oOrder.ID; oShortage.oCustomer = oOrder.oCustomer; oShortage.CustomerID = oOrder.CustomerID; oShortage.SchoolName = (row.GetChildRows(shipOrderRel)[0]["FirstName"].ToString() + " " + row.GetChildRows(shipOrderRel)[0]["LastName"].ToString()).ToUpper(); oShortage.DayPhone = row.GetChildRows(shipOrderRel)[0]["phone"].ToString().Replace("(", "").Replace(")", "").Replace("-", "").Replace(" ", ""); oShortage.TeacherName = oOrder.Teacher; oShortage.StudentName = oOrder.Student; oShortage.Address = row.GetChildRows(shipOrderRel)[0]["address"].ToString() + " " + row.GetChildRows(shipOrderRel)[0]["address2"].ToString(); oShortage.City = row.GetChildRows(shipOrderRel)[0]["City"].ToString(); oShortage.ZipCode = row.GetChildRows(shipOrderRel)[0]["ZipCode"].ToString(); oShortage.State = row.GetChildRows(shipOrderRel)[0]["State"].ToString(); oShortage.Type = "I"; oShortage.Detail = oOrder.NoItems.ToString() + " Item(s)" + "\n\r" + "\n\r"; oShortage.Detail += "OrderID : " + oOrder.ID.ToString() + "\n\r"; oShortage.Detail += "Processed On : " + (row["processed_on"] == null? "": ((DateTime)row["processed_on"]).ToString()) + "\n\r"; oShortage.eMail = row.GetChildRows(custOrderRel).Length > 0?row.GetChildRows(custOrderRel)[0]["email"].ToString():""; oShortage.Save(); // oShortage.Print(false); oOrder.ShortageID = Convert.ToInt32(oShortage.ID); oOrder.Print(); } else { this.SendErrorEmail(oOrder.IOrderID.ToString() + " " + oOrder.Teacher + " " + oOrder.Student + oOrder.LastError); } if (TeacherName != "GENERAL CUSTOMER") { String DeliveryDate = " / "; // : oCustomer.DeliveryDate.ToString("dd/MM/yyyy"); String Packed = " "; if (oCustomer.ID != "") { if (oCustomer.ShipDate != Global.DNull) { DeliveryDate = oCustomer.ShipDate.ToString("MM/dd"); } else { DeliveryDate = oCustomer.DeliveryDate.ToString("MM/dd"); } Packed = oCustomer.NumberPallets > 0?"YES":"NO "; } //String Packed = oCustomer.ID == ""? " ":(oCustomer.ShipDate!=null?) if (oOrder.ID == "0") { strBody += "[" + oOrder.IOrderID.ToString().PadLeft(5) + "]" + oOrder.Teacher + " " + oOrder.Student.PadRight(30).Substring(0, 30) + " " + oOrder.NoItems.ToString().PadRight(3).Substring(0, 3) + " " + row.GetChildRows(studentOrderRel)[0]["school_city"].ToString().ToUpper() + " " + Global.getState(row.GetChildRows(studentOrderRel)[0]["school_state"].ToString().ToUpper()) + " " + DeliveryDate + " " + Packed + Customized + "\n\r"; } else { strBody += oOrder.ID.ToString().PadLeft(5) + " " + oOrder.Teacher + " " + oOrder.Student.PadRight(30).Substring(0, 30) + " " + oOrder.NoItems.ToString().PadRight(3).Substring(0, 3) + " " + row.GetChildRows(studentOrderRel)[0]["school_city"].ToString().ToUpper() + " " + Global.getState(row.GetChildRows(studentOrderRel)[0]["school_state"].ToString().ToUpper()) + " " + DeliveryDate + " " + Packed + Customized + "\n\r"; } if (ShoppingCart == ShoppingType.SigFund) { strBodyPrizes += row.GetChildRows(custOrderRel)[0]["FirstName"].ToString().ToUpper() + " " + row.GetChildRows(custOrderRel)[0]["LastName"].ToString().ToUpper() + " " + oOrder.Teacher.PadRight(30) + " " + row.GetChildRows(custOrderRel)[0]["City"].ToString().ToUpper() + " " + Global.getState(row.GetChildRows(custOrderRel)[0]["State"].ToString().ToUpper()) + " " + (row.GetChildRows(studentOrderRel)[0]["student_name"].ToString()).ToUpper().Replace("\"", " ").Replace("'", " ") + " " + oOrder.NoItems.ToString().PadRight(3).Substring(0, 3) + "\n\r"; } } else { strBody += oOrder.ID.ToString() + "[" + oOrder.IOrderID.ToString() + "]" + oOrder.Teacher.PadRight(30) + " " + oOrder.Student.PadRight(30).Substring(0, 30) + " " + oOrder.NoItems.ToString().PadRight(3).Substring(0, 3) + " " + row.GetChildRows(custOrderRel)[0]["City"].ToString().ToUpper() + " " + Global.getState(row.GetChildRows(custOrderRel)[0]["State"].ToString().ToUpper()) + Customized + "\n\r"; //oOrder.ID.ToString() + "[" + oOrder.IOrderID.ToString() + "]" + oOrder.Teacher.PadRight(30) + " " + oOrder.Student.PadRight(30).Substring(0, 30) + " " + oOrder.NoItems.ToString().PadRight(3).Substring(0, 3) + " " + row.GetChildRows(custOrderRel)[0]["City"].ToString().ToUpper() + " " + Global.getState(row.GetChildRows(custOrderRel)[0]["State"].ToString().ToUpper()) + Customized + "\n\r"; } } else { /* * Console.Out.Write("."); * // strBody += "(R)" + oOrder.ID.ToString() + " " + oOrder.Teacher + " " + oOrder.Student + " " + oOrder.NoItems.ToString() + " " + row.GetChildRows(studentOrderRel)[0]["school_city"].ToString().ToUpper() + " " + row.GetChildRows(studentOrderRel)[0]["school_state"].ToString().ToUpper() + "\n\r"; * if (TeacherName != "GENERAL CUSTOMER") * { * strBody += "(R)" + oOrder.ID.ToString() + " " + oOrder.Teacher + " " + oOrder.Student + " " + oOrder.NoItems.ToString() + " " + row.GetChildRows(studentOrderRel)[0]["school_city"].ToString().ToUpper() + " " + row.GetChildRows(studentOrderRel)[0]["school_state"].ToString().ToUpper() + "\n\r"; * } * else * { * strBody += "(R)" + oOrder.ID.ToString() + " " + oOrder.Teacher + " " + oOrder.Student + " " + oOrder.NoItems.ToString() + " " + row.GetChildRows(custOrderRel)[0]["City"].ToString().ToUpper() + " " + row.GetChildRows(custOrderRel)[0]["State"].ToString().ToUpper() + "\n\r"; * } */ //Print Orders When requested oOrder.Print(); } if (!oOrder.UpdateStatus(InternetOrderStatus.Processed, Database)) { this.SendErrorEmail(oOrder.IOrderID.ToString() + " " + oOrder.Teacher + " " + oOrder.Student + oOrder.LastError); return; } } if (dsTables.Tables["Order"].Rows.Count > 0) { oOrder.ClosePrinter(); //Sending Email Smtp oSmtp = new Smtp(); oSmtp.Subject = "Emails processed " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + " " + ShoppingCart.ToString(); if (this.CustomerID == "TEST") { oSmtp.To = "\"Alvaro Medina\" <*****@*****.**>"; } else { oSmtp.To = "\"Scott Elsbree\" <*****@*****.**>"; oSmtp.To = "\"Desiree\" <*****@*****.**>"; oSmtp.CC = "\"Alvaro Medina\" <*****@*****.**>"; if (ShoppingCart == ShoppingType.SigFund) { oSmtp.BCC = "\"signaturefundraising.com \" <*****@*****.**>"; } if (ShoppingCart == ShoppingType.ChristianCollection) { oSmtp.BCC = "\"abundantfunds.com \" <*****@*****.**>"; } } oSmtp.From = "\"Signature Server\" <*****@*****.**>"; String strTitle = "Order ID[Internet] Teacher Student Items City State Ship/Del Packed\n\r"; strTitle += "------------------------------------------------------------------------------------------\n\r"; String strTotal = "------------------------------------------------------------------------------------------\n\r"; strTotal += "Total: " + dsTables.Tables["Order"].Rows.Count.ToString() + " Order(s)"; oSmtp.Body = strTitle + strBody + strTotal; oSmtp.Send(); //Second Prize Report if (strBodyPrizes != "" && ShoppingCart == ShoppingType.SigFund) { oSmtp.Subject = "Emails processed (Items Update)" + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + " " + ShoppingCart.ToString(); oSmtp.To = "\"Item Update \" <*****@*****.**>"; oSmtp.From = "\"Signature Server\" <*****@*****.**>"; oSmtp.BCC = "\"Alvaro Medina\" <*****@*****.**>"; strTitle = "Online Customer School Name City State StudentName Items\n\r"; strTitle += "------------------------------------------------------------------------------------------\n\r"; strTotal = "------------------------------------------------------------------------------------------\n\r"; strTotal += "Total: " + dsTables.Tables["Order"].Rows.Count.ToString() + " Order(s)"; oSmtp.Body = strTitle + strBodyPrizes + strTotal; oSmtp.Send(); } } dsTables.Dispose(); }