public ActionResult PacketOrderInsert(FormCollection collection)
{
if (Session["Farmer"] != null)
{
Farmer f = (Farmer)Session["Farmer"];
PacketOrder p = new PacketOrder();
p.PacketID = Convert.ToInt16(collection["PacketID"]);
Packet pkt = new Packet();
pkt.PacketID = p.PacketID;
pkt.SelectByID();
p.FarmerID = f.FarmerID;
p.RetailerID = pkt.RetailerID;
p.OrderDate = Convert.ToDateTime(DateTime.Now.ToString());
p.Status = "PENDING";
p.Qty = Convert.ToInt32(collection["Qty"]);
p.Price = pkt.Price;
p.NetPrice = p.Price * p.Qty;
p.PaymentStatus = "PENDING";
p.PaymentType = "";
p.Msg = "";
p.Rating = "";
p.insert();
return(RedirectToAction("OrderSummary", "Farmer"));
}
else
{
return(RedirectToAction("FarmerLogin", "Guest"));
}
}
public ActionResult PacketOrderDelete(int ID)
{
PacketOrder p = new PacketOrder();
p.PacketOrderID = ID;
p.delete();
return(RedirectToAction("OrderSummary"));
}
public ActionResult MyOrders()
{
Farmer f = (Farmer)Session["Farmer"];
PacketOrder p = new PacketOrder();
p.FarmerID = f.FarmerID;
DataTable dt = p.selectByFarmerIDAndStatus("SUBMITTED");
return(View(dt));
}
public ActionResult OrderSummary()
{
Farmer f = (Farmer)Session["Farmer"];
PacketOrder p = new PacketOrder();
p.FarmerID = f.FarmerID;
DataTable dt = p.selectByFarmerIDAndStatus("PENDING");
return(View(dt));
}
public ActionResult OrdersGot()
{
Retailer r = (Retailer)Session["Retailer"];
PacketOrder p = new PacketOrder();
p.RetailerID = r.RetailerID;
DataTable dt = p.selectByRetailerIDAndStatus("SUBMITTED");
return(View(dt));
}
public ActionResult Checkout()
{
if (Session["Farmer"] != null)
{
Farmer f = (Farmer)Session["Farmer"];
PacketOrder po = new PacketOrder();
po.FarmerID = f.FarmerID;
DataTable dt = po.selectByFarmerIDAndStatus("PENDING");
String allpackets = "";
double totalprice = 0;
foreach (DataRow dr in dt.Rows)
{
String packetname = dr["Title"].ToString();
String qty = dr["Qty"].ToString();
String netprice = dr["NetPrice"].ToString();
String farmername = f.Name;
String farmeremail = f.Email;
String retailername = dr["RetailerName"].ToString();
String retaileremail = dr["RetailerEmail"].ToString();
String PacketPhoto = dr["Photo"].ToString();
SendEmail(retaileremail, "New Order Received from Agri Store !!!", "Order from " + farmername + ", \n" + packetname + "(QTY: " + qty + ")" + " = Rs. " + netprice);
allpackets += "\n" + packetname + "(QTY = " + qty + ")" + " = Rs. " + netprice;
totalprice += Convert.ToSingle(netprice);
}
// Email to 1 Farmer
SendEmail(f.Email, "Thank you!", "Thank You " + f.Name + " for shopping with Agri Store!" + "\n" + allpackets + "\n\n\nTotal Price = " + totalprice);
// Conbvert order to submitted
f.MarkAllAsCheckedOut();
}
return(RedirectToAction("MyOrders", "Farmer"));
}
