public void InsertDeliItem(DeliItem obj_DeliITem)
{
Guid id = Guid.NewGuid();
using (OnlineShoppingDataContext db = new OnlineShoppingDataContext())
{
tbl_DeliItemID tbl_deliItem = new tbl_DeliItemID();
tbl_deliItem.DeliItemID = id.ToString();
tbl_deliItem.OrderID = obj_DeliITem.OrderID;
tbl_deliItem.Status = obj_DeliITem.Status;
tbl_deliItem.EstDeliveryDate = obj_DeliITem.EstDeliveryDate;
tbl_deliItem.CreatedDate = obj_DeliITem.CreatedDate;
tbl_deliItem.UpdatedDate = obj_DeliITem.UpdatedDate;
tbl_deliItem.OrderNo = obj_DeliITem.OrderNo;
tbl_deliItem.OrderAmount = obj_DeliITem.OrderAmount;
tbl_deliItem.Tax = obj_DeliITem.Tax;
tbl_deliItem.DiscountAmount = obj_DeliITem.DiscountAmount;
tbl_deliItem.DeliveryCharges = obj_DeliITem.DeliveryCharges;
tbl_deliItem.OrderQuantity = obj_DeliITem.OrderQuantity;
tbl_deliItem.CustomerName = obj_DeliITem.CustomerName;
tbl_deliItem.CustomerMobile = obj_DeliITem.CustomerMobile;
tbl_deliItem.CustomerAddress = obj_DeliITem.CustomerAddress;
tbl_deliItem.OrderDescription = obj_DeliITem.OrderDescription;
db.tbl_DeliItemIDs.InsertOnSubmit(tbl_deliItem);
db.SubmitChanges();
}
}
public DeliItem GetDeliItemByOrderID(string OrderID)
{
DeliItem obj_DeliItem = new DeliItem();
using (OnlineShoppingDataContext db = new OnlineShoppingDataContext())
{
var data = db.sp_GetDeliItemByOrderID(OrderID);
foreach (var obj in data)
{
obj_DeliItem.DeliItemID = obj.DeliItemID;
obj_DeliItem.OrderID = obj.OrderID;
obj_DeliItem.OrderNo = obj.OrderNo;
obj_DeliItem.OrderQuantity = obj.OrderQuantity;
obj_DeliItem.OrderAmount = obj.OrderAmount;
obj_DeliItem.DiscountAmount = obj.DiscountAmount;
obj_DeliItem.Tax = obj.Tax;
obj_DeliItem.DeliveryCharges = obj.DeliveryCharges;
obj_DeliItem.CustomerName = obj.CustomerName;
obj_DeliItem.CustomerMobile = obj.CustomerMobile;
obj_DeliItem.CustomerAddress = obj.CustomerAddress;
obj_DeliItem.OrderDescription = obj.OrderDescription;
obj_DeliItem.EstDeliveryDate = obj.EstDeliveryDate;
obj_DeliItem.CreatedDate = obj.CreatedDate;
obj_DeliItem.UpdatedDate = obj.UpdatedDate;
obj_DeliItem.DeliManID = obj.DeliManID;
obj_DeliItem.DeliMan_Name = obj.DeliMan_Name;
obj_DeliItem.DeliMan_Mobile = obj.DeliMan_Mobile;
obj_DeliItem.Status = obj.Status;
}
}
return(obj_DeliItem);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["OrderID"].ToString() != null)
{
if (!IsPostBack)
{
string OrderID = Request.QueryString["OrderID"].ToString();
DeliItemController deliItemController = new DeliItemController();
DeliItem obj_DeliItem = deliItemController.GetDeliItemByOrderID(OrderID);
order_id.InnerText = obj_DeliItem.OrderID;
txtOrderNo.Text = obj_DeliItem.OrderNo;
txtOrderQuantity.Text = obj_DeliItem.OrderQuantity.ToString();
txtOrderAmount.Text = obj_DeliItem.OrderAmount.ToString("###,###.00");
txtDeliveryCharges.Text = obj_DeliItem.DeliveryCharges.ToString("###,###.00");
txtCustomerName.Text = obj_DeliItem.CustomerName;
txtCustomerMobile.Text = obj_DeliItem.CustomerMobile;
txtCustomerAddress.Text = obj_DeliItem.CustomerAddress;
txtOrderDescription.Text = obj_DeliItem.OrderDescription;
string deliManName = obj_DeliItem.DeliMan_Name;
DataBindToDDL(deliManName);
txtDeliManMobile.Text = obj_DeliItem.DeliMan_Mobile;
if (obj_DeliItem.Status == true)
{
ddlDeliMan.Enabled = false;
btnAddDeliMan.Visible = false;
}
}
}
}
public void UpdateDeliMan(DeliItem obj_DeliItem)
{
using (OnlineShoppingDataContext db = new OnlineShoppingDataContext())
{
tbl_DeliItemID table_DeliItem = (from a in db.tbl_DeliItemIDs where a.OrderID == obj_DeliItem.OrderID select a).FirstOrDefault();
if (table_DeliItem != null)
{
table_DeliItem.DeliManID = obj_DeliItem.DeliManID;
db.SubmitChanges();
}
}
}
protected void btnAddDeliMan_Click(object sender, EventArgs e)
{
DeliItemController deliItemController = new DeliItemController();
DeliManController deliManController = new DeliManController();
DeliMan obj_DeliMan = deliManController.GetDeliManBy_Name_Mobile(ddlDeliMan.Items[ddlDeliMan.SelectedIndex].Text, ddlDeliMan.Items[ddlDeliMan.SelectedIndex].Value);
DeliItem obj_DeliItem = new DeliItem();
obj_DeliItem.OrderID = order_id.InnerText;
obj_DeliItem.DeliManID = obj_DeliMan.DeliManID;
// Update Deli Item for Deli Man
deliItemController.UpdateDeliMan(obj_DeliItem);
Response.Redirect("DeliItemList.aspx");
}
protected void btnCheckOrder_Click(object sender, EventArgs e)
{
OrderController orderControl = new OrderController();
DeliItemController deliItemControl = new DeliItemController();
//Prepare Order Info
OrderInfo obj_orderInfo = new OrderInfo();
obj_orderInfo.OrderID = order_id.InnerText;
obj_orderInfo.OrderStatus = "Confirmed";
obj_orderInfo.EstDeliveryDate = Convert.ToDateTime(deliveryDate.Value);
//Prepare Deli Item Info
DeliItem obj_deliItem = new DeliItem();
obj_deliItem.OrderID = order_id.InnerText;
obj_deliItem.Status = false;
obj_deliItem.EstDeliveryDate = Convert.ToDateTime(deliveryDate.Value);
obj_deliItem.CreatedDate = DateTime.Today;
obj_deliItem.UpdatedDate = DateTime.Today;
obj_deliItem.OrderNo = lblOrderNo.Text;
obj_deliItem.OrderAmount = Convert.ToDecimal(lblGrandTotal.Text);
obj_deliItem.Tax = Convert.ToDecimal(lblTax.Text);
obj_deliItem.DiscountAmount = Convert.ToDecimal(0);//Will add control later.
obj_deliItem.DeliveryCharges = Convert.ToDecimal(lblDeliveryCharges.Text);
obj_deliItem.OrderQuantity = Convert.ToInt32(lblOrderQuantity.Text);
obj_deliItem.CustomerName = lblCustomerName.Text;
obj_deliItem.CustomerMobile = lblCustomerMobile.Text;
obj_deliItem.CustomerAddress = lblCustomerAddress.Text;
obj_deliItem.OrderDescription = lblAdditionalRequest.Text;
// Update Order Info and Insert Deli Item
orderControl.UpdateOrderStatus(obj_orderInfo);
deliItemControl.InsertDeliItem(obj_deliItem);
//Send Voucher to Customer
ExportOrderVoucher(order_id.InnerText);
Response.Redirect("OrderInfoList.aspx");
}
