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