protected void gdvReceived_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName.Equals("Upd"))
{
PlaceOrderBLL objupd = new PlaceOrderBLL();
OrderDetails objOrder = new OrderDetails();
TextBox recivedQunatity = (TextBox)gdvReceived.Rows[gdvReceived.EditIndex].FindControl("txtOrderedQuantity");
Label lblExpiry = (Label)gdvReceived.Rows[gdvReceived.EditIndex].FindControl("lblExpiry");
objOrder.OrderDetailID = Convert.ToInt32(e.CommandArgument);
objOrder.ReceivedQuantity = Convert.ToInt32(recivedQunatity.Text);
objOrder.RoleType = Session["Type"].ToString();
// objOrder.ExpiryDate = Convert.ToDateTime(lblExpiry.Text);
objOrder.ExpiryDate = DateTime.Now;
objOrder.ReceivedDate = DateTime.Now;
objupd.updateOrderByStatus(objOrder);
}
}
catch (Exception)
{
throw;
}
finally
{
gdvReceived.EditIndex = -1;
BindGdvReceived();
}
}
public void BindGdvDetails()
{
DataSet ds2 = new DataSet();
OrderDetails objDetails = new OrderDetails();
if (Session["OrderID"] == null)
{
Session["OrderID"] = Convert.ToInt32(ds.Tables[0].Rows[0]["OrderID"]);
}
objDetails.OrderID = Convert.ToInt32(Session["OrderID"]);
ds2 = PlaceOrderBLL.GetOrderDetailsById(objDetails);
gdvOrderDetail.DataSource = ds2;
gdvOrderDetail.DataBind();
if (plsChilde.Visible == true)
{
if (Session["OrderID"] != null)
{
DataSet dspro = new DataSet();
dspro = ProductBLL.GetAvailableProducts();
DropDownList drpOrderDetail = (DropDownList)gdvOrderDetail.FooterRow.FindControl("drpAddOrderDetail");
drpOrderDetail.DataSource = dspro;
drpOrderDetail.DataTextField = "ProductName";
drpOrderDetail.DataValueField = "ProductID";
drpOrderDetail.DataBind();
}
}
}
public void AddNewOrder()
{
OrderDetails obj = new OrderDetails();
obj.OrderDate = DateTime.Now;
obj.OrderAmount = float.Parse("00");
obj.UserID = Convert.ToInt32(Session["UserID"]);
obj.OrderStatus = "Pending";
obj.OrderRequestBy = Convert.ToInt32(Session["UserID"]);
if (drpOrderType.SelectedValue == "5")
{
obj.OrderRequestedFor = Convert.ToInt32(Session["UserID"]);
obj.VendorID = drpOrderTo.SelectedValue;
obj.OrderMode = "vendor";
}
else
{
obj.OrderRequestedFor = Convert.ToInt32(drpOrderTo.SelectedValue);
obj.OrderMode = "Demand";
}
obj.OrderTypeID = Convert.ToInt32(drpOrderType.SelectedValue);
ds = PlaceOrderBLL.GetNewOrderDetails(obj);
}
public void AddOrderDetails()
{
if (ds.Tables[0].Rows.Count > 0)
{
OrderDetails objDetails = new OrderDetails();
objDetails.OrderID = Convert.ToInt32(ds.Tables[0].Rows[0]["OrderID"]);
objDetails.ProductID = Convert.ToInt32(drpSerchProduct.SelectedValue);
objDetails.OrderDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["OrderDate"]);
objDetails.OrderedQuantity = Convert.ToInt32(txtQuantity.Text);
if (Session["Type"] == "WareHouse")
{
objDetails.StatusDetails = "Initiated";
}
else if (Session["Type"] == "Store")
{
objDetails.StatusDetails = "Pending";
}
PlaceOrderBLL objAdd = new PlaceOrderBLL();
objAdd.AddOrderDetails(objDetails);
}
}
protected void gdvReceived_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName.Equals("Upd"))
{
PlaceOrderBLL objupd = new PlaceOrderBLL();
OrderDetails objOrder = new OrderDetails();
TextBox detailDescription = (TextBox)gdvReceived.Rows[gdvReceived.EditIndex].FindControl("txtDetailDescription");
TextBox SalePrice = (TextBox)gdvReceived.Rows[gdvReceived.EditIndex].FindControl("txtSalePrice");
Label lblExpiry = (Label)gdvReceived.Rows[gdvReceived.EditIndex].FindControl("lblExpiry");
Label lblProductDetail = (Label)gdvReceived.Rows[gdvReceived.EditIndex].FindControl("lblProductDetail");
objOrder.OrderDetailID = Convert.ToInt32(e.CommandArgument);
objOrder.ReceivedDate = DateTime.Now;
objOrder.OrderDescription = detailDescription.Text;
objOrder.ExpiryDate = DateTime.Now;
objOrder.SalePrice = Convert.ToInt32(SalePrice.Text);
objOrder.RoleType = Session["Type"].ToString();
objOrder.ExpiryDate = Convert.ToDateTime(lblExpiry.Text);
objOrder.StatusDetails = "Complete";
objOrder.ProductDetailId = Convert.ToInt32(lblProductDetail.Text);
objupd.updateOrderByStatus(objOrder);
}
else if (e.CommandName.Equals("discard"))
{
PlaceOrderBLL objupd = new PlaceOrderBLL();
OrderDetails objOrder = new OrderDetails();
objOrder.OrderDetailID = Convert.ToInt32(e.CommandArgument);
objOrder.ReceivedDate = DateTime.Now;
objOrder.ExpiryDate = DateTime.Now;
objOrder.RoleType = Session["Type"].ToString();
objOrder.OrderDescription = "Stock Not Available";
objOrder.StatusDetails = "Cancel";
objupd.updateOrderByStatus(objOrder);
}
}
catch (Exception)
{
throw;
}
finally
{
gdvReceived.EditIndex = -1;
BindGdvReceived();
}
}
public void BindGdvReceived()
{
DataSet ds2 = new DataSet();
OrderDetails objDetails = new OrderDetails();
objDetails.OrderRequestedFor = Convert.ToInt32(Session["UserID"]);
objDetails.OrderRequestBy = Convert.ToInt32(Session["UserID"]);
objDetails.OrderMode = "PenddingOrder";
ds2 = PlaceOrderBLL.GetPenddingOrders(objDetails);
gdvPendding.DataSource = ds2;
gdvPendding.DataBind();
}
public void AddOrderDetails()
{
if (ds.Tables[0].Rows.Count > 0)
{
OrderDetails objDetails = new OrderDetails();
objDetails.OrderID = Convert.ToInt32(ds.Tables[0].Rows[0]["OrderID"]);
objDetails.ProductID = Convert.ToInt32(drpSerchProduct.SelectedValue);
objDetails.OrderDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["OrderDate"]);
objDetails.OrderedQuantity = Convert.ToInt32(txtQuantity.Text);
objDetails.StatusDetails = "Initiated";
objDetails.SalePrice = Convert.ToInt32(txtPrize.Text);
objDetails.OrderDescription = "Requested";
PlaceOrderBLL objAdd = new PlaceOrderBLL();
objAdd.AddOrderDetails(objDetails);
}
}
public void BindGdvReceived()
{
if (!string.IsNullOrEmpty(txtSearch.Text))
{
DataSet ds2 = new DataSet();
OrderDetails objDetails = new OrderDetails();
objDetails.OrderRequestedFor = Convert.ToInt32(Session["UserID"]);
objDetails.OrderRequestBy = Convert.ToInt32(Session["UserID"]);
objDetails.OrderID = Convert.ToInt32(txtSearch.Text);
objDetails.OrderMode = "Request";
ds2 = PlaceOrderBLL.GetPenddingOrders(objDetails);
gdvReceived.DataSource = ds2;
gdvReceived.DataBind();
}
}
protected void gdvReceived_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName.Equals("Upd"))
{
PlaceOrderBLL objupd = new PlaceOrderBLL();
OrderDetails objOrder = new OrderDetails();
TextBox receivedDate = (TextBox)gdvReceived.Rows[gdvReceived.EditIndex].FindControl("txtDateRec");
TextBox recivedQunatity = (TextBox)gdvReceived.Rows[gdvReceived.EditIndex].FindControl("txtRecQuantity");
TextBox discount = (TextBox)gdvReceived.Rows[gdvReceived.EditIndex].FindControl("txtBonus");
TextBox txtDateExpired = (TextBox)gdvReceived.Rows[gdvReceived.EditIndex].FindControl("txtDateExpired");
objOrder.ExpiryDate = Convert.ToDateTime(txtDateExpired.Text);
objOrder.OrderDetailID = Convert.ToInt32(e.CommandArgument);
objOrder.ReceivedQuantity = Convert.ToInt32(recivedQunatity.Text);
objOrder.RoleType = Session["Type"].ToString();
objOrder.InvoiceNumber = txtInvoiceNum.Text;
objOrder.Discount = float.Parse(discount.Text);
objOrder.ReceivedDate = Convert.ToDateTime(receivedDate.Text);
objupd.updateOrderByStatus(objOrder);
}
}
catch (Exception exp)
{
//throw;
}
finally
{
gdvReceived.EditIndex = -1;
BindGdvReceived();
}
}
protected void gdvOrderDetail_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName.Equals("Add"))
{
OrderDetails objDetails = new OrderDetails();
TextBox txtAddquantity = (TextBox)gdvOrderDetail.FooterRow.FindControl("txtAddquantity");
TextBox txtAddSalePrice = (TextBox)gdvOrderDetail.FooterRow.FindControl("txtAddSalePrice");
DropDownList drpOrderDetail = (DropDownList)gdvOrderDetail.FooterRow.FindControl("drpAddOrderDetail");
objDetails.OrderID = Convert.ToInt32(Session["OrderID"]);
objDetails.ProductID = Convert.ToInt32(drpOrderDetail.SelectedValue);
objDetails.OrderDate = DateTime.Now;
objDetails.StatusDetails = "Initiated";
objDetails.OrderDescription = "Requested";
objDetails.OrderedQuantity = Convert.ToInt32(txtAddquantity.Text);
objDetails.SalePrice = Convert.ToInt32(txtAddSalePrice.Text);
PlaceOrderBLL objAdd = new PlaceOrderBLL();
objAdd.AddOrderDetails(objDetails);
}
else if (e.CommandName.Equals("Del"))
{
PlaceOrderBLL objDel = new PlaceOrderBLL();
OrderDetails objOrer = new OrderDetails();
objOrer.OrderDetailID = Convert.ToInt32(e.CommandArgument);
objDel.Delete(objOrer);
}
else if (e.CommandName.Equals("Upd"))
{
PlaceOrderBLL objupd = new PlaceOrderBLL();
OrderDetails objOrder = new OrderDetails();
TextBox txtSalePrice = (TextBox)gdvOrderDetail.Rows[gdvOrderDetail.EditIndex].FindControl("txtSalePrice");
TextBox txtquantity = (TextBox)gdvOrderDetail.Rows[gdvOrderDetail.EditIndex].FindControl("txtquantity");
DropDownList ddlPro = (DropDownList)(gdvOrderDetail.Rows[gdvOrderDetail.EditIndex].FindControl("drpOrderDetail"));
long DrpPro = Convert.ToInt64(ddlPro.SelectedItem.Value);
objOrder.OrderDetailID = Convert.ToInt32(e.CommandArgument);
objOrder.SalePrice = Convert.ToInt32(txtSalePrice.Text);
objOrder.ProductID = DrpPro;
objOrder.OrderDescription = "Requested";
objOrder.OrderedQuantity = Convert.ToInt32(txtquantity.Text);
objupd.update(objOrder);
}
else
{
//WebMessageBoxUtil.Show("Invalid input in Order Place field ");
}
}
catch (Exception)
{
throw;
}
finally
{
gdvOrderDetail.EditIndex = -1;
BindGdvDetails();
}
}
