public void SendEmail() { Supplier s = db.Suppliers.Where(x => x.Supplier_ID == supplierID).FirstOrDefault(); Supplier_Contact_Details sc = db.Supplier_Contact_Details.Where(x => x.Supplier_Contact_ID == s.Supplier_ID).FirstOrDefault(); Stock_Item st = db.Stock_Item.Where(x => x.Stock_ID == stockID).FirstOrDefault(); Stock_Order_Line so = db.Stock_Order_Line.Where(x => x.Stock_Order_Line_ID == stockID).FirstOrDefault(); try { SmtpClient client = new SmtpClient("smtp.gmail.com", 587); MailMessage message = new MailMessage(); string myEmail = "*****@*****.**"; string pswd = "@mulaudzi"; message.From = new MailAddress(myEmail); message.Subject = "Placing an order"; foreach (var order in Globals.StockOrders) { message.Body = "Dear " + s.Supplier_Name + "\nWe are very interested in making an order for the following item:\n\n" + order.StockItemName + " Quantity: " + order.sOrderQuantity + "\n\nWe look forward to your reply \n\nKind Regards Mr Mafokwane (Manager)"; } //message.Body = "Dear \n"+s.Supplier_Name+"\nWe are very interested in making an order for the following item: \n"+ // st.Stock_Item_Name +" Quantity"+ so.Stock_Order_Quantity + // "\n\nWe look forward to your reply \n\nKind Regards Mr Mafokwane (Manager)"; //message.To.Add(sc.Supplier_Email_Adress); message.To.Add(sc.Supplier_Email_Adress); client.UseDefaultCredentials = false; client.EnableSsl = true; client.Credentials = new System.Net.NetworkCredential(myEmail, pswd); client.Send(message); message = null; } catch (Exception ex) { MessageBox.Show("Error " + ex); } }
private void btnSubmit_Click(object sender, EventArgs e) { //if (txtOrderQuantity.Text == "" && txtSelectStock.Text == "" && txtSelectSupplier.Text == "") //{ // btnSubmit.Enabled = false; //} //else // btnSubmit.Enabled = true; Stock_Order sOrder = new Stock_Order(); // orderLine.Q = orderLine.Stock_Order_Quantity; sOrder.Stock_Order_Description = "Description"; sOrder.Stock_Order_Issue_Date = DateTime.Now; sOrder.Stock_Order_Status_ID = 1; sOrder.Supplier_ID = supplierID; db.Stock_Order.Add(sOrder); db.SaveChanges(); foreach (var item in Globals.StockOrders) { Stock_Order_Line orderLine = new Stock_Order_Line(); orderLine.Stock_ID = item.OrderNo; orderLine.Stock_Order_Quantity = item.sOrderQuantity; orderLine.Stock_Order_ID = sOrder.Stock_Order_ID; // sOrder.Stock_Order_ID = item.OrderNo; db.Stock_Order_Line.Add(orderLine); db.SaveChanges(); // parent.load(); //} //SendEmail(); //// parent.loadReceivedOrder(); //MessageBox.Show("New Order Placed"); } }
private void ListOrders_Load(object sender, EventArgs e) { //foreach(var orders in Globals.StockOrders) //{ // TreeNode node = new TreeNode(orders.OrderNo.ToString()); // node.Nodes.Add(orders.StockItemName); // treeView1.Nodes.Add(node); //} foreach (var orders in db.Stock_Order) { Stock_Order so = new Stock_Order(); Stock_Order_Line sol = db.Stock_Order_Line.Where(x => x.Stock_Order_Line_ID == orders.Stock_Order_ID).FirstOrDefault(); TreeNode node = new TreeNode("Order No " + orders.Stock_Order_ID.ToString()); node.Nodes.Add(sol.Stock_Item.Stock_Item_Name); treeView1.Nodes.Add(node); } }