public ActionResult DeleteConfirmed(int id)
{
order_master order_Master = db.order_master.Find(id);
db.order_master.Remove(order_Master);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ViewOrder()
{
order_master om = new order_master();
om.id = Convert.ToInt32(Request.Params["id"]);
//d1.driverid = (Guid)["driverid"];
om.orderstatus = Request.Params["orderstatus"];
om.mobileno = Request.Params["mobileno"];
om.orderno = Convert.ToInt32(Request.Params["orderno"]);
om.pickupperson = Request.Params["pickupperson"];
om.pickupcontact = Request.Params["pickupcontact"];
om.pickupitem = Request.Params["pickupitem"];
om.deliveryperson = Request.Params["deliveryperson"];
om.deliverycontact = Request.Params["deliverycontact"];
om.deliveryitem = Request.Params["deliveryitem"];
om.pickupaddress = Request.Params["pickupaddress"];
om.deliveryaddress = Request.Params["deliveryaddress"];
om.pickupmessage1 = Request.Params["pickupmessage1"];
om.pickupmessage2 = Request.Params["pickupmessage2"];
om.pickupmessage3 = Request.Params["pickupmessage3"];
om.pickupmessage4 = Request.Params["pickupmessage4"];
om.pickupmessage5 = Request.Params["pickupmessage5"];
om.billingtype = Request.Params["billingtype"];
om.billto = Request.Params["billto"];
om.deliverycharge = Request.Params["deliverycharge"];
om.pob = Request.Params["pob"];
om.tocollect = Request.Params["tocollect"];
om.orderdate = Convert.ToDateTime(Request.Params["orderdate"]);
om.deliverdate = Convert.ToDateTime(Request.Params["deliverdate"]);
om.pickuparea = Request.Params["pickuparea"];
om.deliveryarea = Request.Params["deliveryarea"];
om.startpickupkh = Convert.ToInt32(Request.Params["startpickupkh"]);
om.startpickupdate = Convert.ToDateTime(Request.Params["startpickupdate"]);
om.pickuprichkh = Convert.ToInt32(Request.Params["pickuprichkh"]);
om.pickuprichdate = Convert.ToDateTime(Request.Params["pickuprichdate"]);
om.pickupitemdate = Convert.ToDateTime(Request.Params["pickupitemdate"]);
om.startdeliverykh = Convert.ToInt32(Request.Params["startdeliverykh"]);
om.startdeliverydate = Convert.ToDateTime(Request.Params["startdeliverydate"]);
om.deliveryrichkh = Convert.ToInt32(Request.Params["deliveryrichkh"]);
om.deliverydate = Convert.ToDateTime(Request.Params["deliverydate"]);
om.collectperson = Request.Params["collectperson"];
om.startdeliverykh = Convert.ToInt32(Request.Params["startdeliverykh"]);
om.collectphone = Request.Params["collectphone"];
om.billno = Request.Params["billno"];
om.yourorderno = Request.Params["yourorderno"];
om.isread = Request.Params["isread"];
om.isremove = Request.Params["isremove"];
om.isactive = (Request.Params["isactive"] == "1");
DataTable dt = OrderLogic.SelectAll();
return(View(dt));
}
public ActionResult OrderDeleteSubmit()
{
int id = Convert.ToInt32(Request.Params["id"]);
order_master om = new order_master();
//d1.driverid = (Guid)["driverid"];
om.id = Convert.ToInt16(Request.Params["id"]);
om.driverid = System.Guid.Parse(Request.Params["driverid"]);
om.orderstatus = Request.Params["orderstatus"];
om.mobileno = Request.Params["mobileno"];
om.orderno = Convert.ToInt32(Request.Params["orderno"]);
om.pickupperson = Request.Params["pickupperson"];
om.pickupcontact = Request.Params["pickupcontact"];
om.pickupitem = Request.Params["pickupitem"];
om.deliveryperson = Request.Params["deliveryperson"];
om.deliverycontact = Request.Params["deliverycontact"];
om.deliveryitem = Request.Params["deliveryitem"];
om.pickupaddress = Request.Params["pickupaddress"];
om.deliveryaddress = Request.Params["deliveryaddress"];
om.pickupmessage1 = Request.Params["pickupmessage1"];
om.pickupmessage2 = Request.Params["pickupmessage2"];
om.pickupmessage3 = Request.Params["pickupmessage3"];
om.pickupmessage4 = Request.Params["pickupmessage4"];
om.pickupmessage5 = Request.Params["pickupmessage5"];
om.billingtype = Request.Params["billingtype"];
om.billto = Request.Params["billto"];
om.deliverycharge = Request.Params["deliverycharge"];
om.pob = Request.Params["pob"];
om.tocollect = Request.Params["tocollect"];
om.orderdate = Convert.ToDateTime(Request.Params["orderdate"]);
om.deliverdate = Convert.ToDateTime(Request.Params["deliverdate"]);
om.pickuparea = Request.Params["pickuparea"];
om.deliveryarea = Request.Params["deliveryarea"];
om.startpickupkh = Convert.ToInt32(Request.Params["startpickupkh"]);
om.startpickupdate = DateTime.Now;
om.pickuprichkh = Convert.ToInt32(Request.Params["pickuprichkh"]);
om.pickuprichdate = DateTime.Now;
om.pickupitemdate = DateTime.Now;
om.startdeliverykh = Convert.ToInt32(Request.Params["startdeliverykh"]);
om.startdeliverydate = DateTime.Now;
om.deliveryrichkh = Convert.ToInt32(Request.Params["deliveryrichkh"]);
om.deliverydate = DateTime.Now;
om.collectperson = Request.Params["collectperson"];
om.startdeliverykh = Convert.ToInt32(Request.Params["startdeliverykh"]);
om.collectphone = Request.Params["collectphone"];
om.billno = Request.Params["billno"];
om.yourorderno = Request.Params["yourorderno"];
om.isread = Request.Params["isread"];
om.isremove = Request.Params["isremove"];
om.isactive = Convert.ToBoolean(Request.Params["isactive"]);
OrderLogic.Update(om);
return(RedirectToAction("ViewOrder"));
}
public static int Update(order_master dt)
{
string query = "UPDATE order_master SET orderstatus = @orderstatus,mobileno = @mobileno,orderno = @orderno,pickupperson = @pickupperson,pickupcontact = @pickupcontact,pickupitem = @pickupitem,deliveryperson = @deliveryperson,deliverycontact = @deliverycontact,deliveryitem = @deliveryitem,pickupaddress = @pickupaddress,deliveryaddress = @deliveryaddress,pickupmessage1 = @pickupmessage1,pickupmessage2 = @pickupmessage2,pickupmessage3 = @pickupmessage3,pickupmessage4 = @pickupmessage4,pickupmessage5 = @pickupmessage5,billingtype = @billingtype,billto = @billto,deliverycharge = @deliverycharge,pob = @pob,tocollect = @tocollect,orderdate = @orderdate,deliverdate = @deliverdate,pickuparea = @pickuparea,deliveryarea = @deliveryarea,startpickupkh = @startpickupkh,startpickupdate = @startpickupdate,pickuprichkh = @pickuprichkh,pickuprichdate = @pickuprichdate,pickupitemdate = @pickupitemdate,startdeliverykh = @startdeliverykh,startdeliverydate = @startdeliverydate,deliveryrichkh = @deliveryrichkh,deliverydate = @deliverydate,collectperson = @collectperson,collectphone = @collectphone,billno = @billno,yourorderno = @yourorderno,isread = isread,isremove = @isremove,isactive = @isactive WHERE id = @id";
List <SqlParameter> parameters = new List <SqlParameter>();
//parameters.Add(new SqlParameter("@driverid", dt.driverid));
parameters.Add(new SqlParameter("@id", dt.id));
parameters.Add(new SqlParameter("@orderstatus", dt.orderstatus));
parameters.Add(new SqlParameter("@mobileno", dt.mobileno));
parameters.Add(new SqlParameter("@orderno", dt.orderno));
parameters.Add(new SqlParameter("@pickupperson", dt.pickupperson));
parameters.Add(new SqlParameter("@pickupcontact", dt.pickupcontact));
parameters.Add(new SqlParameter("@pickupitem", dt.pickupitem));
parameters.Add(new SqlParameter("@deliveryperson", dt.deliveryperson));
parameters.Add(new SqlParameter("@deliverycontact", dt.deliverycontact));
parameters.Add(new SqlParameter("@deliveryitem", dt.deliveryitem));
parameters.Add(new SqlParameter("@pickupaddress", dt.pickupaddress));
parameters.Add(new SqlParameter("@deliveryaddress", dt.deliveryaddress));
parameters.Add(new SqlParameter("@pickupmessage1", dt.pickupmessage1));
parameters.Add(new SqlParameter("@pickupmessage2", dt.pickupmessage2));
parameters.Add(new SqlParameter("@pickupmessage3", dt.pickupmessage3));
parameters.Add(new SqlParameter("@pickupmessage4", dt.pickupmessage4));
parameters.Add(new SqlParameter("@pickupmessage5", dt.pickupmessage5));
parameters.Add(new SqlParameter("@billingtype", dt.billingtype));
parameters.Add(new SqlParameter("@billto", dt.billto));
parameters.Add(new SqlParameter("@deliverycharge", dt.deliverycharge));
parameters.Add(new SqlParameter("@pob", dt.pob));
parameters.Add(new SqlParameter("@tocollect", dt.tocollect));
parameters.Add(new SqlParameter("@orderdate", dt.orderdate));
parameters.Add(new SqlParameter("@deliverdate", dt.deliverdate));
parameters.Add(new SqlParameter("@pickuparea", dt.pickuparea));
parameters.Add(new SqlParameter("@deliveryarea", dt.deliveryarea));
parameters.Add(new SqlParameter("@startpickupkh", dt.startpickupkh));
parameters.Add(new SqlParameter("@startpickupdate", dt.startpickupdate));
parameters.Add(new SqlParameter("@pickuprichkh", dt.pickuprichkh));
parameters.Add(new SqlParameter("@pickuprichdate", dt.pickuprichdate));
parameters.Add(new SqlParameter("@pickupitemdate", dt.pickupitemdate));
parameters.Add(new SqlParameter("@startdeliverykh", dt.startdeliverykh));
parameters.Add(new SqlParameter("@startdeliverydate", dt.startdeliverydate));
parameters.Add(new SqlParameter("@deliveryrichkh", dt.deliveryrichkh));
parameters.Add(new SqlParameter("@deliverydate", dt.deliverydate));
parameters.Add(new SqlParameter("@collectperson", dt.collectperson));
parameters.Add(new SqlParameter("@collectphone", dt.collectphone));
parameters.Add(new SqlParameter("@billno", dt.billno));
parameters.Add(new SqlParameter("@yourorderno", dt.yourorderno));
parameters.Add(new SqlParameter("@isread", dt.isread));
parameters.Add(new SqlParameter("@isremove", dt.isremove));
parameters.Add(new SqlParameter("@isactive", dt.isactive));
return(DBHelper.ModifyData(query, parameters));
}
public ActionResult Delete(order_master order)
{
using (DeliveryEntities1 db = new DeliveryEntities1())
if (ModelState.IsValid)
{
string exist = Convert.ToString((from Data in db.order_master
where Data.mobileno.Trim().ToLower() == order.mobileno.Trim().ToLower()
select Data.id).FirstOrDefault());
if (Convert.ToInt32(exist) == 0)
{
// order_master Data_Insert = new order_master();
// //Random r = new Random();
// // int rid = r.Next(0, 999999);
// // Data_Insert.driverid = drdt.driverid;
// Data_Insert.mobileno = order.mobileno;
// // Data_Insert.pickupperson = ord.pickupperson;
// // Data_Insert.mobileno = ord.mobileno;
// // Data_Insert.pickupcontact = ord.pickupcontact;
// Data_Insert.pickupitem = order.pickupitem;
// // Data_Insert.deliverycontact = ord.deliverycontact;
// // Data_Insert.pickupaddress = ord.pickupaddress;
// // Data_Insert.deliveryaddress = ord.deliveryaddress;
// // Data_Insert.pickupmessage1 = ord.pickupmessage1;
// // Data_Insert.billingtype = ord.billingtype;
// // Data_Insert.billto = ord.billto;
// Data_Insert.deliverycharge = order.deliverycharge;
// // Data_Insert.pob = ord.pob;
// // Data_Insert.tocollect = ord.tocollect;
// // Data_Insert.orderdate = ord.orderdate;
// Data_Insert.deliverydate = order.deliverydate;
// // Data_Insert.pickuparea = ord.pickuparea;
// // Data_Insert.deliveryarea = ord.deliveryarea;
// // Data_Insert.postalcode = drdt.postalcode;
// // Data_Insert.isactive = true;
// db.SaveChanges();
// return RedirectToAction("ViewOrder", "Order");
order.isactive = false;
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ViewOrder"));
}
else
{
return(RedirectToAction("Dashboard", "Login"));
}
}
return(View());
}
public static int Insert(order_master dt)
{
string query = "INSERT INTO order_master(orderstatus,mobileno,orderno,pickupperson,pickupcontact,pickupitem,deliveryperson,deliverycontact,deliveryitem,pickupaddress,deliveryaddress,pickupmessage1,pickupmessage2,pickupmessage3,pickupmessage4,pickupmessage5,billingtype,billto,deliverycharge,pob,tocollect,orderdate,deliverdate,pickuparea,deliveryarea,startpickupkh,startpickupdate,pickuprichkh,pickuprichdate,pickupitemdate,startdeliverykh,startdeliverydate,deliveryrichkh,deliverydate,collectperson,collectphone,billno,yourorderno,isread,isremove,isactive) VALUES(@orderstatus,@mobileno, @orderno, @pickupperson,@pickupcontact, @pickupitem, @deliveryperson,@deliverycontact, @deliveryitem,@pickupaddress,@deliveryaddress,@pickupmessage1,@pickupmessage2,@pickupmessage3,@pickupmessage4,@pickupmessage5,@billingtype,@billto,@deliverycharge,@pob,@tocollect,@orderdate,@deliverdate,@pickuparea,@deliveryarea, @startpickupkh,@startpickupdate,@pickuprichkh,@pickuprichdate,@pickupitemdate,@startdeliverykh, @startdeliverydate,@deliveryrichkh,@deliverydate,@collectperson,@collectphone,@billno,@yourorderno,@isread,@isremove,@isactive)";
List <SqlParameter> parameters = new List <SqlParameter>();
// parameters.Add(new SqlParameter("@id", dt.id));
// parameters.Add(new SqlParameter("@driverid", dt.driverid));
parameters.Add(new SqlParameter("@orderstatus", dt.orderstatus));
parameters.Add(new SqlParameter("@mobileno", dt.mobileno));
parameters.Add(new SqlParameter("@orderno", dt.orderno));
parameters.Add(new SqlParameter("@pickupperson", dt.pickupperson));
parameters.Add(new SqlParameter("@pickupcontact", dt.pickupcontact));
parameters.Add(new SqlParameter("@pickupitem", dt.pickupitem));
parameters.Add(new SqlParameter("@deliveryperson", dt.deliveryperson));
parameters.Add(new SqlParameter("@deliverycontact", dt.deliverycontact));
parameters.Add(new SqlParameter("@deliveryitem", dt.deliveryitem));
parameters.Add(new SqlParameter("@pickupaddress", dt.pickupaddress));
parameters.Add(new SqlParameter("@deliveryaddress", dt.deliveryaddress));
parameters.Add(new SqlParameter("@pickupmessage1", dt.pickupmessage1));
parameters.Add(new SqlParameter("@pickupmessage2", dt.pickupmessage2));
parameters.Add(new SqlParameter("@pickupmessage3", dt.pickupmessage3));
parameters.Add(new SqlParameter("@pickupmessage4", dt.pickupmessage4));
parameters.Add(new SqlParameter("@pickupmessage5", dt.pickupmessage5));
parameters.Add(new SqlParameter("@billingtype", dt.billingtype));
parameters.Add(new SqlParameter("@billto", dt.billto));
parameters.Add(new SqlParameter("@deliverycharge", dt.deliverycharge));
parameters.Add(new SqlParameter("@pob", dt.pob));
parameters.Add(new SqlParameter("@tocollect", dt.tocollect));
parameters.Add(new SqlParameter("@orderdate", dt.orderdate));
parameters.Add(new SqlParameter("@deliverdate", dt.deliverdate));
parameters.Add(new SqlParameter("@pickuparea", dt.pickuparea));
parameters.Add(new SqlParameter("@deliveryarea", dt.deliveryarea));
parameters.Add(new SqlParameter("@startpickupkh", dt.startpickupkh));
parameters.Add(new SqlParameter("@startpickupdate", dt.startpickupdate));
parameters.Add(new SqlParameter("@pickuprichkh", dt.pickuprichkh));
parameters.Add(new SqlParameter("@pickuprichdate", dt.pickuprichdate));
parameters.Add(new SqlParameter("@pickupitemdate", dt.pickupitemdate));
parameters.Add(new SqlParameter("@startdeliverykh", dt.startdeliverykh));
parameters.Add(new SqlParameter("@startdeliverydate", dt.startdeliverydate));
parameters.Add(new SqlParameter("@deliveryrichkh", dt.deliveryrichkh));
parameters.Add(new SqlParameter("@deliverydate", dt.deliverydate));
parameters.Add(new SqlParameter("@collectperson", dt.collectperson));
parameters.Add(new SqlParameter("@collectphone", dt.collectphone));
parameters.Add(new SqlParameter("@billno", dt.billno));
parameters.Add(new SqlParameter("@yourorderno", dt.yourorderno));
parameters.Add(new SqlParameter("@isread", dt.isread));
parameters.Add(new SqlParameter("@isremove", dt.isremove));
parameters.Add(new SqlParameter("@isactive", dt.isactive));
return(DBHelper.ModifyData(query, parameters));
}
public ActionResult AssignDriver(FormCollection collection)
{
int orderId = Convert.ToInt32(collection["orderId"]);
// int id = Convert.ToInt32(Request.Params["id"]);
order_master dd = OrderLogic.SelectByPK(orderId);
//dd.id = Convert.ToInt32(Request.Params["id"]);
dd.id = Convert.ToInt32(collection["orderId"]);
dd.driverid = (System.Guid.Parse(Request.Params["driverid"]));
OrderLogic.UpdateID(dd);
return(RedirectToAction("ViewOrder", "Order"));
}
// GET: order_master/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
order_master order_Master = db.order_master.Find(id);
if (order_Master == null)
{
return(HttpNotFound());
}
return(View(order_Master));
}
public ActionResult Edit(int id = 0)
{
order_master order = db.order_master.Find(id);
if (order == null)
{
return(HttpNotFound());
}
order_master ord = new order_master();
ord.mobileno = order.mobileno;
ord.deliveryitem = order.deliveryitem;
ord.deliverycharge = order.deliverycharge;
ord.deliverydate = order.deliverydate;
return(View(ord));
}
// GET: order_master/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
order_master order_Master = db.order_master.Find(id);
if (order_Master == null)
{
return(HttpNotFound());
}
Order_MasterVM orderMasterVM = new Order_MasterVM();
orderMasterVM.order_Master_products = new List <OrderMasterProducts>();
orderMasterVM.OrderNo = order_Master.order.OrderNo;
orderMasterVM.EmployeeName = order_Master.employee.FirstName + " " + order_Master.employee.LastName;
orderMasterVM.Status = order_Master.Status.ToString();
List <SelectListItem> items = new List <SelectListItem> {
new SelectListItem {
Text = statusEnum.NewOrder.ToString(), Value = "5"
},
new SelectListItem {
Text = statusEnum.InProgress.ToString(), Value = "6"
},
new SelectListItem {
Text = statusEnum.Completed.ToString(), Value = "4"
}
};
ViewBag.Status = new SelectList(items, "Value", "Text", orderMasterVM.Status);
foreach (var omi in db.order_master_items.Where(x => x.OrderMasterID == order_Master.ID).ToList())
{
OrderMasterProducts objOMP = new OrderMasterProducts();
objOMP.ID = omi.ID;
objOMP.Name = omi.product.Name;
objOMP.ProductID = omi.ProductID;
objOMP.Quantity = omi.Quantity;
objOMP.RemainingQuantity = 0;
orderMasterVM.order_Master_products.Add(objOMP);
}
return(View(orderMasterVM));
}
public static int UpdateID(order_master dt)
{
string query = "UPDATE order_master SET driverid = @driverid WHERE id = @id";
List <SqlParameter> parameters = new List <SqlParameter>();
int id = Convert.ToInt32(dt.id);
System.Guid driverId = dt.driverid;
parameters.Add(new SqlParameter("@id", id));
parameters.Add(new SqlParameter("@driverid", driverId));
return(DBHelper.ModifyData(query, parameters));
//SqlConnection connection = new SqlConnection("Data Source=LAPTOP-CELLHC4D;Initial Catalog=Delivery;Persist Security Info=True;User ID=sa;Password=root;MultipleActiveResultSets=True;Application Name=EntityFramework");
//SqlCommand commend = new SqlCommand()
}
public ActionResult Create(Order_MasterVM order_MasterVM)
{
order_MasterVM.order_Master_products.RemoveAt(0);
order_master OM = new order_master();
OM.EmployeeID = order_MasterVM.EmployeeID;
OM.OrderID = order_MasterVM.OrderID;
OM.Status = Convert.ToInt32(order_MasterVM.Status);
if (ModelState.IsValid)
{
foreach (var x in order_MasterVM.order_Master_products)
{
order_master_items obj = new order_master_items();
obj.ProductID = x.ProductID;
obj.Quantity = x.Quantity;
obj.RemainingQuantity = x.RemainingQuantity;
OM.order_master_items.Add(obj);
// update inventery
var objPI = db.productsinventories.Where(p => p.ProductID == x.ProductID).SingleOrDefault();
if (objPI != null)
{
objPI.Quantity = objPI.Quantity - (int)x.Quantity;
db.productsinventories.Attach(objPI);
db.Entry(objPI).State = EntityState.Modified;
db.SaveChanges();
}
else
{
throw new Exception("One or more product does not exist or it does not have required quantity.");
}
}
db.order_master.Add(OM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OrderID = new SelectList(db.orders, "ID", "OrderNo", order_MasterVM.OrderID);
return(View(order_MasterVM));
}
public static order_master SelectByPK(int ID)
{
string query = "SELECT * FROM order_master WHERE id = @id";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@id", ID));
DataTable dt = DBHelper.SelectData(query, parameters);
order_master d = new order_master();
if (dt.Rows.Count == 0)
{
return(d);
}
else
{
d.id = ID;
// d.driverid = (Guid)dt.Rows[0]["driverid"];
d.orderstatus = dt.Rows[0]["orderstatus"].ToString();
d.orderno = Convert.ToInt32(dt.Rows[0]["orderno"]);
d.mobileno = dt.Rows[0]["mobileno"].ToString();
d.pickupperson = dt.Rows[0]["pickupperson"].ToString();
d.pickupcontact = dt.Rows[0]["pickupcontact"].ToString();
d.pickupitem = dt.Rows[0]["pickupitem"].ToString();
d.deliveryperson = dt.Rows[0]["deliveryperson"].ToString();
d.deliverycontact = dt.Rows[0]["deliverycontact"].ToString();
d.deliveryitem = dt.Rows[0]["deliveryitem"].ToString();
d.pickupaddress = dt.Rows[0]["pickupaddress"].ToString();
d.deliveryaddress = dt.Rows[0]["deliveryaddress"].ToString();
d.pickupmessage1 = dt.Rows[0]["pickupmessage1"].ToString();
d.pickupmessage2 = dt.Rows[0]["pickupmessage2"].ToString();
d.pickupmessage3 = dt.Rows[0]["pickupmessage3"].ToString();
d.pickupmessage4 = dt.Rows[0]["pickupmessage4"].ToString();
d.pickupmessage5 = dt.Rows[0]["pickupmessage5"].ToString();
d.billingtype = dt.Rows[0]["billingtype"].ToString();
d.billto = dt.Rows[0]["billto"].ToString();
d.deliverycharge = dt.Rows[0]["deliverycharge"].ToString();
d.pob = dt.Rows[0]["pob"].ToString();
d.tocollect = dt.Rows[0]["tocollect"].ToString();
d.orderdate = Convert.ToDateTime(dt.Rows[0]["orderdate"]);
d.deliverdate = Convert.ToDateTime(dt.Rows[0]["deliverdate"]);
d.pickupmessage1 = dt.Rows[0]["pickupmessage1"].ToString();
d.pickuparea = dt.Rows[0]["pickuparea"].ToString();
d.deliveryarea = dt.Rows[0]["deliveryarea"].ToString();
d.startpickupkh = Convert.ToInt32(dt.Rows[0]["startpickupkh"]);
d.startpickupdate = Convert.ToDateTime(dt.Rows[0]["startpickupdate"]);
d.pickuprichkh = Convert.ToInt32(dt.Rows[0]["pickuprichkh"]);
d.pickuprichdate = Convert.ToDateTime(dt.Rows[0]["pickuprichdate"]);
d.pickupitemdate = Convert.ToDateTime(dt.Rows[0]["pickupitemdate"]);
d.startdeliverykh = Convert.ToInt32(dt.Rows[0]["startdeliverykh"]);
d.startdeliverydate = Convert.ToDateTime(dt.Rows[0]["startdeliverydate"]);
d.deliveryrichkh = Convert.ToInt32(dt.Rows[0]["deliveryrichkh"]);
d.deliverydate = Convert.ToDateTime(dt.Rows[0]["deliverydate"]);
d.collectperson = dt.Rows[0]["collectperson"].ToString();
d.collectphone = dt.Rows[0]["collectphone"].ToString();
d.billno = dt.Rows[0]["billno"].ToString();
d.yourorderno = dt.Rows[0]["yourorderno"].ToString();
d.isread = dt.Rows[0]["isread"].ToString();
d.isremove = dt.Rows[0]["isremove"].ToString();
d.isactive = (bool)dt.Rows[0]["isactive"];
return(d);
}
}
public ActionResult OrderDelete()
{
order_master dtls = OrderLogic.SelectByPK(Convert.ToInt32(Request.Params["id"]));
return(View(dtls));
}
