private void Search() { RegularOrderENT entRegularOrder = new RegularOrderENT(); RegularOrderBAL balRegularOrder = new RegularOrderBAL(); if (ddlCustomerID.SelectedIndex > 0) { entRegularOrder.CustomerID = Convert.ToInt32(ddlCustomerID.SelectedValue); } if (txtfromdate.Text.Trim() != String.Empty) { entRegularOrder.FromDate = Convert.ToDateTime(txtfromdate.Text.Trim()); } if (txttodate.Text.Trim() != String.Empty) { entRegularOrder.ToDate = Convert.ToDateTime(txttodate.Text.Trim()); } DataTable dtInvoice = balRegularOrder.RegularOrderSelectCustomerWiseSearchInvoice(entRegularOrder); rvInvoice.LocalReport.DataSources.Add(new ReportDataSource("RegularOrderSelectCustomerWiseSearchInvoice", dtInvoice)); rvInvoice.LocalReport.ReportPath = Server.MapPath("~/AdminPanel/Invoice/Report.rdlc"); rvInvoice.LocalReport.DisplayName = ddlCustomerID.SelectedItem.Text + " Invoice Sheet"; }
private void ProductAutoSelect() { try { RegularOrderENT entRegularOrder = new RegularOrderENT(); RegularOrderBAL balRegularOrder = new RegularOrderBAL(); if (ddlProductID.SelectedIndex > 0) { DataTable dt = balRegularOrder.SelectProductAmount(Convert.ToInt32(ddlProductID.SelectedValue)); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { if (!dr["BottlePrice"].Equals(DBNull.Value)) { txtAmount.Text = Convert.ToDecimal(dr["BottlePrice"]).ToString(); txtAmount.Enabled = false; } BottleAmount_TextChanged(); Quantity_TextChanged(); break; } } } } catch (Exception ex) { lblErrorMessage.Text = ex.Message.ToString(); } }
private void Search() { SqlInt32 BranchID = SqlInt32.Null; SqlInt32 CustomerID = SqlInt32.Null; SqlInt32 DistributorID = SqlInt32.Null; SqlInt32 ProductID = SqlInt32.Null; SqlDateTime FromDate = SqlDateTime.Null; SqlDateTime ToDate = SqlDateTime.Null; RegularOrderENT entRegularOrder = new RegularOrderENT(); if (ddlBranchID.SelectedIndex > 0) { entRegularOrder.BranchID = Convert.ToInt32(ddlBranchID.SelectedValue); } if (ddlCustomerID.SelectedIndex > 0) { entRegularOrder.CustomerID = Convert.ToInt32(ddlCustomerID.SelectedValue); } if (ddlDistributorID.SelectedIndex > 0) { entRegularOrder.DistributorID = Convert.ToInt32(ddlDistributorID.SelectedValue); } if (ddlProductID.SelectedIndex > 0) { entRegularOrder.ProductID = Convert.ToInt32(ddlProductID.SelectedValue); } if (txtfromdate.Text.Trim() != "") { entRegularOrder.FromDate = DateTime.Parse(txtfromdate.Text.Trim()); } if (txttodate.Text.Trim() != "") { entRegularOrder.ToDate = DateTime.Parse(txttodate.Text.Trim()); } RegularOrderBAL balRegularOrder = new RegularOrderBAL(); DataTable dtRegularOrder = balRegularOrder.RegularOrderSelectSearch(entRegularOrder); if (dtRegularOrder != null && dtRegularOrder.Rows.Count > 0) { gvRegularOrder.DataSource = dtRegularOrder; gvRegularOrder.DataBind(); } else { gvRegularOrder.DataSource = null; gvRegularOrder.DataBind(); } }
private void LoadControls(SqlInt32 RegularOrderID) { RegularOrderENT entRegularOrder = new RegularOrderENT(); RegularOrderBAL balRegularOrder = new RegularOrderBAL(); entRegularOrder = balRegularOrder.SelectByPK(RegularOrderID); if (!entRegularOrder.CustomerID.IsNull) { ddlCustomerID.SelectedValue = entRegularOrder.CustomerID.Value.ToString(); } if (!entRegularOrder.BranchID.IsNull) { ddlBranchID.SelectedValue = entRegularOrder.BranchID.Value.ToString(); } if (!entRegularOrder.DistributorID.IsNull) { ddlDistributorID.SelectedValue = entRegularOrder.DistributorID.Value.ToString(); } if (!entRegularOrder.ProductID.IsNull) { ddlProductID.SelectedValue = entRegularOrder.ProductID.Value.ToString(); } if (!entRegularOrder.Quantity.IsNull) { txtQuantity.Text = entRegularOrder.Quantity.Value.ToString(); } if (ddlProductID.SelectedIndex > 0) { ProductAutoSelect(); } if (!entRegularOrder.TotalAmount.IsNull) { txtTotalAmount.Text = entRegularOrder.TotalAmount.Value.ToString(); } if (!entRegularOrder.BottleIn.IsNull) { txtBottleIn.Text = entRegularOrder.BottleIn.Value.ToString(); } if (!entRegularOrder.OrderDate.IsNull) { txtOrderDate.Text = entRegularOrder.OrderDate.Value.ToString("yyyy-MM-dd"); } }
private void FillRegularOrderGridView() { if (Session["UserID"] != null) { RegularOrderBAL balRegularOrder = new RegularOrderBAL(); DataTable dtRegularOrder = balRegularOrder.SelectAll(); if (dtRegularOrder != null && dtRegularOrder.Rows.Count > 0) { gvRegularOrder.DataSource = dtRegularOrder; gvRegularOrder.DataBind(); } } }
protected void gvRegularOrder_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "DeleteRecord" && e.CommandArgument != null) { RegularOrderBAL balRegularOrder = new RegularOrderBAL(); if (balRegularOrder.Delete(Convert.ToInt32(e.CommandArgument))) { FillRegularOrderGridView(); } else { lblMessage.Text = balRegularOrder.Message; } } } catch (Exception ex) { lblMessage.Text = ex.Message.ToString(); } }
public void ddlCustomer_SelectedIndexChanged(object sender, EventArgs e) { RegularOrderENT entRegularOrder = new RegularOrderENT(); RegularOrderBAL balRegularOrder = new RegularOrderBAL(); if (ddlCustomerID.SelectedIndex > 0) { DataTable dt = balRegularOrder.FillCustomer(Convert.ToInt32(ddlCustomerID.SelectedValue)); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { if (!dr["BranchID"].Equals(DBNull.Value)) { ddlBranchID.SelectedValue = Convert.ToInt32(dr["BranchID"]).ToString(); } CommonFillMethod.FillDropDownListBranchToDistributor(ddlDistributorID, Convert.ToInt32(ddlBranchID.SelectedValue)); if (!dr["ProductID"].Equals(DBNull.Value)) { ddlProductID.SelectedValue = Convert.ToInt32(dr["ProductID"]).ToString(); } if (!dr["Quantity"].Equals(DBNull.Value)) { txtQuantity.Text = Convert.ToInt32(dr["Quantity"]).ToString(); } ProductAutoSelect(); BottleAmount_TextChanged(); Quantity_TextChanged(); } } } }
protected void btnSave_Click(object sender, EventArgs e) { try { #region Server Side Validation String strError = String.Empty; if (ddlCustomerID.SelectedIndex == 0) { strError += "- Select Customer Name<br />"; } if (ddlBranchID.SelectedIndex == 0) { strError += "- Select Branch<br />"; } if (ddlDistributorID.SelectedIndex == 0) { strError += "- Select Distributor<br />"; } if (ddlProductID.SelectedIndex == 0) { strError += "- Select Product<br />"; } if (txtQuantity.Text.Trim() == String.Empty) { strError += "- Enter Quantity<br />"; } if (txtTotalAmount.Text.Trim() == String.Empty) { strError += "- Enter Total Amount<br />"; } if (txtBottleIn.Text.Trim() == String.Empty) { strError += "- Enter In Bottle<br />"; } if (txtOrderDate.Text.Trim() == String.Empty) { strError += "- Enter Order Date<br />"; } #endregion Server Side Validation RegularOrderENT entRegularOrder = new RegularOrderENT(); RegularOrderBAL balRegularOrder = new RegularOrderBAL(); #region Gather Data if (ddlCustomerID.SelectedIndex > 0) { entRegularOrder.CustomerID = Convert.ToInt32(ddlCustomerID.SelectedValue); } if (ddlBranchID.SelectedIndex > 0) { entRegularOrder.BranchID = Convert.ToInt32(ddlBranchID.SelectedValue); } if (ddlDistributorID.SelectedIndex > 0) { entRegularOrder.DistributorID = Convert.ToInt32(ddlDistributorID.SelectedValue); } if (ddlProductID.SelectedIndex > 0) { entRegularOrder.ProductID = Convert.ToInt32(ddlProductID.SelectedValue); } if (txtQuantity.Text.Trim() != String.Empty) { entRegularOrder.Quantity = Convert.ToInt32(txtQuantity.Text.Trim()); } if (txtTotalAmount.Text.Trim() != String.Empty) { entRegularOrder.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text.Trim()); } if (txtOrderDate.Text.Trim() != String.Empty) { entRegularOrder.OrderDate = Convert.ToDateTime(txtOrderDate.Text.Trim()); } if (txtBottleIn.Text.Trim() != String.Empty) { entRegularOrder.BottleIn = Convert.ToInt32(txtBottleIn.Text.Trim()); } entRegularOrder.UserID = Convert.ToInt32(Session["UserID"]); if (Request.QueryString["RegularOrderID"] == null) { balRegularOrder.Insert(entRegularOrder); lblMessage.Text = "Data Inserted Successfully"; ClearControls(); } else { entRegularOrder.RegularOrderID = Convert.ToInt32(Request.QueryString["RegularOrderID"]); balRegularOrder.Update(entRegularOrder); Response.Redirect("~/AdminPanel/RegularOrder/RegularOrderList.aspx"); } #endregion Gather Data } catch (Exception ex) { lblErrorMessage.Text = ex.Message.ToString(); } }