//protected void btnLogin_Click(object sender, EventArgs e) //{ // try // { // if(Page.IsValid) // { // } // } // catch(Exception ex) // { // throw ex; // } // finally // { // } //} protected void btnLogin_Click(object sender, EventArgs e) { try { if (Page.IsValid) { objBusinessFacadLayer = new BusinessFacadLayer(); dtRecord = new DataTable(); dtRecord = objBusinessFacadLayer.getUserLoginDetail(txtUserName.Value.Trim(), txtPassword.Value.Trim()); if (dtRecord.Rows.Count > 0) { Session["UserName"] = txtUserName.Value.Trim(); Response.Redirect("frmDashboard.aspx", false); } else { dvError.Visible = true; dvError.InnerHtml = "Invalid UserName / Password"; } } } catch (Exception ex) { throw ex; } finally { } }
private void Fill_TransportationListDropdown() { try { objBusinessFacadLayer = new BusinessFacadLayer(); using (dtRecords = new DataTable()) { dtRecords = objBusinessFacadLayer.getTransposrationList(); if (dtRecords.Rows.Count > 0) { ddlTransportationType.DataSource = dtRecords; ddlTransportationType.DataValueField = dtRecords.Columns["ID"].ToString(); ddlTransportationType.DataTextField = dtRecords.Columns["TransportationName"].ToString(); ddlTransportationType.DataBind(); ddlTransportationType.Items.Insert(0, objListDDLSelect); //ddlCompany.Items.Insert(0, new ListItem("0","Select")); } else { ddlTransportationType.ClearSelection(); ddlTransportationType.DataSource = null; ddlTransportationType.DataBind(); } } } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; } }
private void Fill_ShippingSearchCustomerDetailinForm(Int32 ShippingSearchCustomerID) { try { dtRecords = new DataTable(); objBusinessFacadLayer = new BusinessFacadLayer(); dtRecords = objBusinessFacadLayer.getShippingSearchCustomerDetailinForm(ShippingSearchCustomerID); if (dtRecords.Rows.Count > 0) { txtShippingCustomerName.Text = dtRecords.Rows[0]["CustomerName"].ToString(); txtShippingProprietorName.Text = dtRecords.Rows[0]["ShippingProprietorName"].ToString(); txtShippingAddressLine1.Text = dtRecords.Rows[0]["ShippingAddress1"].ToString(); txtShippingAddressLine2.Text = dtRecords.Rows[0]["ShippingAddress2"].ToString(); txtShippingCity.Text = dtRecords.Rows[0]["ShippingCity"].ToString(); txtShippingPin.Text = dtRecords.Rows[0]["Shippingpin"].ToString(); txtShippingPhoneNo.Text = dtRecords.Rows[0]["ShippingPhone"].ToString(); txtShippingEmail.Text = dtRecords.Rows[0]["ShippingEmail"].ToString(); txtShippingAadharNo.Text = dtRecords.Rows[0]["ShippingAadharNo"].ToString(); txtShippingGSTINNo.Text = dtRecords.Rows[0]["ShippingGSTINNo"].ToString(); } } catch (Exception ex) { throw ex; } finally { dtRecords.Dispose(); objBusinessFacadLayer = null; } }
protected void GridView_Button_Click(object sender, EventArgs e) { try { RowIndex = ((sender as LinkButton).NamingContainer as GridViewRow).RowIndex; if (RowIndex > -1) { intProductID = Convert.ToInt32(gvMasterGrid.DataKeys[RowIndex].Value.ToString()); if (gvMasterGrid.Rows[RowIndex].Cells[6].Text.ToUpper() == "TRUE") { blnEnableDisable = false; blnDelete = false; } else if (gvMasterGrid.Rows[RowIndex].Cells[6].Text.ToUpper() == "FALSE") { blnEnableDisable = true; blnDelete = false; } objBusinessFacadLayer = new BusinessFacadLayer(); objBusinessFacadLayer.DeleteorEnableDisableCompanyProduct(intProductID, blnEnableDisable, blnDelete); Fill_Master(); } } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; } }
private void Fill_Master() { try { dtRecords = new DataTable(); objBusinessFacadLayer = new BusinessFacadLayer(); dtRecords = objBusinessFacadLayer.getProductMaster(0); if (dtRecords.Rows.Count > 0) { gvMasterGrid.DataSource = dtRecords; gvMasterGrid.DataBind(); } else { gvMasterGrid.DataSource = null; gvMasterGrid.DataBind(); } } catch (Exception ex) { throw ex; } finally { dtRecords.Dispose(); objBusinessFacadLayer = null; } }
private void Fill_BillMasterGrid() { try { objBusinessFacadLayer = new BusinessFacadLayer(); dtRecord = new DataTable(); dtRecord = objBusinessFacadLayer.getBillMasterList(123); if (dtRecord.Rows.Count > 0) { gvBillItemDetails.DataSource = dtRecord; gvBillItemDetails.DataBind(); } else { gvBillItemDetails.DataSource = null; gvBillItemDetails.DataBind(); } } catch (Exception ex) { throw ex; } finally { } }
private void Fill_BillingCustomerDropdown() { try { objBusinessFacadLayer = new BusinessFacadLayer(); using (dtRecords = new DataTable()) { dtRecords = objBusinessFacadLayer.getBillingCustomerList(); if (dtRecords.Rows.Count > 0) { ddlSearchBillingCustomer.DataSource = dtRecords; ddlSearchBillingCustomer.DataValueField = dtRecords.Columns["BillingID"].ToString(); ddlSearchBillingCustomer.DataTextField = dtRecords.Columns["BillingCustomer"].ToString(); ddlSearchBillingCustomer.DataBind(); ddlSearchBillingCustomer.Items.Insert(0, objListDDLSearchCustomerSelect); //ddlCompany.Items.Insert(0, new ListItem("0","Select")); } else { ddlSearchBillingCustomer.DataSource = null; ddlSearchBillingCustomer.DataBind(); } } } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; } }
private void Fill_ProductDetail(int CompanyID, int ProductID) { try { objBusinessFacadLayer = new BusinessFacadLayer(); using (dtRecords = new DataTable()) { dtRecords = objBusinessFacadLayer.getProductMaster(CompanyID, ProductID); if (dtRecords.Rows.Count > 0) { lblHSNCode.Text = dtRecords.Rows[0]["HSNCode"].ToString(); lblUOM.Text = dtRecords.Rows[0]["UOM"].ToString(); } else { lblHSNCode.Text = "#"; lblUOM.Text = "#"; } } } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; } }
private void Fill_ProductPrice(int ProductID) { try { objBusinessFacadLayer = new BusinessFacadLayer(); using (dtRecords = new DataTable()) { dtRecords = objBusinessFacadLayer.getProductPrice(ProductID); if (dtRecords.Rows.Count > 0) { lblRate.Text = dtRecords.Rows[0]["Price"].ToString(); lblSGSTRate.Text = dtRecords.Rows[0]["SGSTPercentageRate"].ToString(); lblCGSTRate.Text = dtRecords.Rows[0]["CGSTPercentageRate"].ToString(); } else { lblRate.Text = "#"; lblSGSTRate.Text = "#"; lblCGSTRate.Text = "#"; } } } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { mvInvoice.SetActiveView(vwInvoiceDetail); if (Request.QueryString.Count == 1) { if (Request.QueryString["InvoiceNo"] != null && Request.QueryString["InvoiceNo"].ToString() != "") { objBusinessFacadLayer = new BusinessFacadLayer(); dsRecord = new DataSet(); dsRecord = objBusinessFacadLayer.getInvoiceDetails(Convert.ToInt64(Request.QueryString["InvoiceNo"].ToString()), 0, 0); if (dsRecord.Tables["tbl_SKSDetails"].Rows.Count == 1 && dsRecord.Tables["vw_BillInvoiceMaster"].Rows.Count == 1 && dsRecord.Tables["vw_Bill_InvoiceDetails"].Rows.Count > 0) { this.ReportViewer1.Reset(); ReportViewer1.ProcessingMode = ProcessingMode.Local; this.ReportViewer1.LocalReport.ReportPath = Server.MapPath("RptFile\\rptInvoice-Modified.rdlc"); ReportDataSource rds = new ReportDataSource("StoreDetail", dsRecord.Tables[0]); this.ReportViewer1.LocalReport.DataSources.Clear(); this.ReportViewer1.LocalReport.DataSources.Add(rds); this.ReportViewer1.DataBind(); ReportDataSource rds1 = new ReportDataSource("InvoiceMaster", dsRecord.Tables[1]); this.ReportViewer1.LocalReport.DataSources.Add(rds1); this.ReportViewer1.DataBind(); ReportDataSource rds2 = new ReportDataSource("InvoiceDetail", dsRecord.Tables[2]); this.ReportViewer1.LocalReport.DataSources.Add(rds2); this.ReportViewer1.DataBind(); this.ReportViewer1.LocalReport.Refresh(); Fill_Billing_N_ShippingAddress_Transportation_AdditionalCharges(dsRecord); Fill_InvoiceItemDetails(dsRecord); Fill_PriceSummaryFor_InvoiceItem(); //Fill_Transportation_Details(dsRecord.Tables["InvoiceMaster"]); //Fill_Invoice_OtherCharges(dsRecord.Tables["InvoiceMaster"]); } } } } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; dsRecord.Dispose(); } } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (Page.IsValid) { dvError.Visible = false; dvError.InnerHtml = ""; objBusinessFacadLayer = new BusinessFacadLayer(); objProductPrice = new tbl_ProductPrice(); objProductPrice.FK_ProductMasterID = Convert.ToInt16(ddlcompanyProduct.SelectedItem.Value.ToString()); objProductPrice.Price = Convert.ToDecimal(txtProductPrice.Value.ToString().Trim()); objProductPrice.SGSTPercentageRate = Convert.ToDecimal(txtSGSTRate.Value.ToString().Trim()); objProductPrice.CGSTPercentageRate = Convert.ToDecimal(txtCGSTRate.Value.ToString().Trim()); if (chkIsActive.Checked == true) { objProductPrice.IsActive = true; } else { objProductPrice.IsActive = false; } objProductPrice.IsDeleted = false; objProductPrice.CreatedBy = "Admin"; objProductPrice.CreatedOn = Convert.ToDateTime(DateTime.Now.ToString()); isExist = objBusinessFacadLayer.AddProductPrice(objProductPrice); if (isExist > 0) { dvError.Visible = true; dvError.InnerHtml = "Price for Product " + ddlcompanyProduct.SelectedItem.Text.ToString() + " already exist"; // return "failed|Product -" + ProductName + ", already exist for Company -" + objfrmProductPriceMaster.ddlCompanyName.SelectedItem.Text.ToString(); } else { ClearForm(); } } } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; objProductPrice = null; } }
protected void btnAddItem_Click(object sender, EventArgs e) { try { // objmdl_BillDetails_temp = new mdl_BillDetails_temp(); objtbl_BillDetails_temp = new tbl_BillDetails_temp(); objtbl_BillDetails_temp.CompanyID = Convert.ToInt32(ddlCompany.SelectedItem.Value.ToString()); objtbl_BillDetails_temp.ProductID = Convert.ToInt32(ddlcompanyProduct.SelectedItem.Value.ToString()); objtbl_BillDetails_temp.Company = ddlCompany.SelectedItem.Text.ToString(); objtbl_BillDetails_temp.Product = ddlcompanyProduct.SelectedItem.Text.ToString(); objtbl_BillDetails_temp.HSNNo = lblHSNCode.Text; objtbl_BillDetails_temp.Qnty = Convert.ToInt32(txtQuantity.Text.Trim()); objtbl_BillDetails_temp.UOM = lblUOM.Text; objtbl_BillDetails_temp.Rate = Convert.ToDecimal(lblRate.Text.Trim()); objtbl_BillDetails_temp.Total = Convert.ToDecimal(txtTotal.Text.ToString()); objtbl_BillDetails_temp.Discount = Convert.ToDecimal(txtDiscount.Text.Trim()); //objtbl_BillDetails_temp.TaxableValue= Convert.ToDecimal(lblTaxableValue.Text); objtbl_BillDetails_temp.TaxableValue = Convert.ToDecimal(txtTaxableValue.Text); objtbl_BillDetails_temp.SGSTRate = Convert.ToDecimal(lblSGSTRate.Text.Trim()); //objtbl_BillDetails_temp.SGSTValue = Convert.ToDecimal(lblSGSTValue.Text.Trim()); objtbl_BillDetails_temp.SGSTValue = Convert.ToDecimal(txtSGSTValue.Text.Trim()); objtbl_BillDetails_temp.CGSTRate = Convert.ToDecimal(lblCGSTRate.Text.Trim()); //objtbl_BillDetails_temp.CGSTValue = Convert.ToDecimal(lblCGSTValue.Text.Trim()); objtbl_BillDetails_temp.CGSTValue = Convert.ToDecimal(txtCGSTValue.Text.Trim()); objtbl_BillDetails_temp.CreatedOn = Convert.ToDateTime(DateTime.Now.ToLongDateString()); objtbl_BillDetails_temp.CreatedBy = "Admin"; objtbl_BillDetails_temp.IsActive = true; objtbl_BillDetails_temp.IsDeleted = false; objtbl_BillDetails_temp.GUID = hdnGUID.Value.ToString(); // objtbl_BillDetails_temp.Id= objBusinessFacadLayer = new BusinessFacadLayer(); objBusinessFacadLayer.AddItemInBillDetailsTemp(objtbl_BillDetails_temp); ResetFormForAddBillItem_Temp(); } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; objmdl_BillDetails_temp = null; // objtbl_BillDetails_temp = null; } }
public static string AddProduct(int CompanyID, string ProductName, string HSNCode, string UOM, bool Status) { frmProductMaster objfrmProductMaster = new frmProductMaster(); try { objBusinessFacadLayer_Static = new BusinessFacadLayer(); if (CompanyID <= 0) { return("false|Select Company Name"); } else if (ProductName.Trim() == "") { return("false|Enter Product Name"); } else if (HSNCode.Trim() == "") { return("false|Enter HSN Code"); } else if (UOM.Trim() == "") { return("false|Enter UOM"); } objBusinessFacadLayer_Static = new BusinessFacadLayer(); objProductMaster_Static = new tbl_ProductMaster(); objProductMaster_Static.FK_CompanyMasterID = CompanyID; objProductMaster_Static.ProductName = ProductName; objProductMaster_Static.HSNCode = HSNCode; objProductMaster_Static.UOM = UOM; objProductMaster_Static.IsActive = Status; objProductMaster_Static.IsDeleted = false; objProductMaster_Static.CreatedBy = "Admin"; objProductMaster_Static.CreatedOn = Convert.ToDateTime(DateTime.Now.ToString()); isExist = objBusinessFacadLayer_Static.AddProduct(objProductMaster_Static); if (isExist > 0) { return("failed|Product -" + ProductName + ", already exist for Company -");// + objfrmProductMaster.ddlCompanyName.SelectedItem.Text.ToString(); } else { return("success|New Product -" + ProductName + ", added successfully");// + objfrmProductMaster.ddlCompanyName.SelectedItem.Text.ToString() + " - Company"; } } catch (Exception ex) { throw ex; } }
private void DownloadPDF(string fileName, Int64 InvoiceNo) { // Variables Warning[] warnings; string[] streamIds; string mimeType = string.Empty; string encoding = string.Empty; string extension = string.Empty; objBusinessFacadLayer = new BusinessFacadLayer(); dsRecord = new DataSet(); dsRecord = objBusinessFacadLayer.getInvoiceDetails(Convert.ToInt64(InvoiceNo), 0, 0); if (dsRecord.Tables["tbl_SKSDetails"].Rows.Count == 1 && dsRecord.Tables["vw_BillInvoiceMaster"].Rows.Count == 1 && dsRecord.Tables["vw_Bill_InvoiceDetails"].Rows.Count > 0) { // Setup the report viewer object and get the array of bytes //ReportViewer ReportViewer1 = new ReportViewer(); ReportViewer1.Reset(); ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = Server.MapPath("RptFile\\rptInvoice-Modified.rdlc"); ReportDataSource rds = new ReportDataSource("StoreDetail", dsRecord.Tables[0]); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(rds); ReportViewer1.DataBind(); ReportDataSource rds1 = new ReportDataSource("InvoiceMaster", dsRecord.Tables[1]); ReportViewer1.LocalReport.DataSources.Add(rds1); ReportViewer1.DataBind(); ReportDataSource rds2 = new ReportDataSource("InvoiceDetail", dsRecord.Tables[2]); ReportViewer1.LocalReport.DataSources.Add(rds2); ReportViewer1.DataBind(); ReportViewer1.LocalReport.Refresh(); byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings); // Now that you have all the bytes representing the PDF report, buffer it and send it to the client. Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=" + fileName + "." + extension); Response.BinaryWrite(bytes); // create the file Response.Flush(); // send it to the client to download } }
public static string AddCompany(string CompanyName, string CompanyShortName, string CompanyContactPersonName, string CompanyContactPersonMobileNo, string ContactPersonEmailID, string CompanyWebsiteURL, bool Status) { // string result = "CompanyName=" + CompanyName + "CompanyShortName=" + CompanyShortName + "CompanyContactPersonName=" + CompanyContactPersonName + "CompanyContactPersonMobileNo=" + CompanyContactPersonMobileNo + "CompanyWebsiteURL=" + CompanyWebsiteURL + "Status=" + Status; try { if (CompanyName.Trim() == "") { return("false|Enter Company Name"); } objBusinessFacadLayer_Static = new BusinessFacadLayer(); objCompanyMaster_Static = new tbl_CompanyMaster(); objCompanyMaster_Static.Name = CompanyName; objCompanyMaster_Static.CompanyShortKey = CompanyShortName; objCompanyMaster_Static.ContactPersonName = CompanyContactPersonName; objCompanyMaster_Static.BusinessWebsite = CompanyWebsiteURL; objCompanyMaster_Static.MobileNo = CompanyContactPersonMobileNo; objCompanyMaster_Static.Email = ContactPersonEmailID; objCompanyMaster_Static.IsActive = Status; objCompanyMaster_Static.IsDeleted = false; objCompanyMaster_Static.CreatedBy = "Admin"; objCompanyMaster_Static.CreatedOn = Convert.ToDateTime(DateTime.Now.ToString()); isExist = objBusinessFacadLayer_Static.AddCompany(objCompanyMaster_Static); if (isExist > 0) { return("failed|Company -" + CompanyName + ", already exist"); } else { return("success|New Company -" + CompanyName + ", added successfully"); } } catch (Exception ex) { throw ex; } finally { } }
private void Fill_BillDetailsGrid(string GUID) { try { objBusinessFacadLayer = new BusinessFacadLayer(); using (dtRecords = new DataTable()) { dtRecords = objBusinessFacadLayer.getBillDetails_Temp(GUID); if (dtRecords.Rows.Count > 0) { gvBillItemDetails.DataSource = dtRecords; gvBillItemDetails.DataBind(); //gvBillItemDetails.Columns[16].Visible = false; //gvBillItemDetails.Columns[17].Visible = false; CalculateTotalItemAmountinGrid(); } else { lblSummaryTotalQuantity.Text = "000"; lblSummaryTotalAmount.Text = "0.00"; lblSummarytotaldiscount.Text = "0.00"; lblSummaryTaxableAmount.Text = "0.00"; lblSummarySGSTAmount.Text = "0.00"; lblSummaryCGSTAmount.Text = "0.00"; txtInvoiceTotal.Text = ""; gvBillItemDetails.DataSource = null; gvBillItemDetails.DataBind(); } } } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; } }
protected void GridView_Print_Click(object sender, EventArgs e) { try { RowIndex = ((sender as LinkButton).NamingContainer as GridViewRow).RowIndex; if (RowIndex > -1) { intInvoiceNo = Convert.ToInt32(gvBillItemDetails.DataKeys[RowIndex].Value.ToString()); DownloadPDF("Invoice No -" + Convert.ToString(intInvoiceNo), intInvoiceNo); } } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; } }
protected void gvBillItemDetails_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Delete") { string id = e.CommandArgument.ToString(); objBusinessFacadLayer = new BusinessFacadLayer(); objBusinessFacadLayer.DeleteItemInBillDetailsTemp(Convert.ToInt64(id), hdnGUID.Value.ToString()); ResetFormForAddBillItem_Temp(); } } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; } }
private void Fill_CompanyMaster() { try { objBusinessFacadLayer = new BusinessFacadLayer(); using (dtRecords = new DataTable()) { dtRecords = objBusinessFacadLayer.getCompanyMaster(); dvFilterRecords = new DataView(dtRecords); dvFilterRecords.RowFilter = "IsActive=True"; dtRecords = dvFilterRecords.ToTable(); if (dtRecords.Rows.Count > 0) { ddlCompany.DataSource = dtRecords; ddlCompany.DataValueField = dtRecords.Columns["ID"].ToString(); ddlCompany.DataTextField = dtRecords.Columns["Name"].ToString(); ddlCompany.DataBind(); ddlCompany.Items.Insert(0, objListDDLSelect); //ddlCompany.Items.Insert(0, new ListItem("0","Select")); } else { ddlCompany.DataSource = null; ddlCompany.DataBind(); // ddlCompany.Items.Insert(0, objListDDLSelect); } } } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; } }
protected void GridView_Delete_Click(object sender, EventArgs e) { try { RowIndex = ((sender as LinkButton).NamingContainer as GridViewRow).RowIndex; if (RowIndex > -1) { intCompanyID = Convert.ToInt32(gvMasterGrid.DataKeys[RowIndex].Value.ToString()); objBusinessFacadLayer = new BusinessFacadLayer(); objBusinessFacadLayer.DeleteorEnableDisableCompany(intCompanyID, Convert.ToBoolean(gvMasterGrid.Rows[RowIndex].Cells[7].Text), true); Fill_Master(); } } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; } }
private void Fill_ProductMaster(int CompanyID) { try { objBusinessFacadLayer = new BusinessFacadLayer(); using (dtRecords = new DataTable()) { dtRecords = objBusinessFacadLayer.getProductMaster(CompanyID); dvFilterRecords = new DataView(dtRecords); dvFilterRecords.RowFilter = "IsActive=true and FK_CompanyMasterID=" + CompanyID + ""; dtRecords = dvFilterRecords.ToTable(); if (dtRecords.Rows.Count > 0) { ddlcompanyProduct.DataSource = dtRecords; ddlcompanyProduct.DataValueField = dtRecords.Columns["ID"].ToString(); ddlcompanyProduct.DataTextField = dtRecords.Columns["ProductName"].ToString(); ddlcompanyProduct.DataBind(); ddlcompanyProduct.Items.Insert(0, objListDDLSelect); } else { ddlcompanyProduct.Items.Clear(); ddlcompanyProduct.DataSource = null; // ddlcompanyProduct.Items.Insert(0, objListDDLSelect); ddlcompanyProduct.DataBind(); ddlcompanyProduct.Items.Insert(0, objListDDLSelect); } } } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; } }
protected void GridView_Delete_Click(object sender, EventArgs e) { try { RowIndex = ((sender as LinkButton).NamingContainer as GridViewRow).RowIndex; if (RowIndex > -1) { intProductID = Convert.ToInt32(gvMasterGrid.DataKeys[RowIndex].Value.ToString()); objBusinessFacadLayer = new BusinessFacadLayer(); objBusinessFacadLayer.DeleteorEnableDisableCompanyProduct(intProductID, Convert.ToBoolean(gvMasterGrid.Rows[RowIndex].Cells[6].Text), true); Fill_Master(); } Response.Write("<script>$(\"#btnModal\").click(function () {$(\':input\', \'#modelAddCompany').val(\"\");$('#ContentPlaceHolder_chkIsActive').prop('checked', 'true');$('#modelAddCompany').modal({ backdrop: 'static', keyboard: false }, 'show');});</script>"); } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; } }
protected void GridView_Button_Click(object sender, EventArgs e) { try { int RowIndex = ((sender as LinkButton).NamingContainer as GridViewRow).RowIndex; if (RowIndex > -1) { int intItemID = Convert.ToInt32(gvBillItemDetails.DataKeys[RowIndex].Value.ToString()); objBusinessFacadLayer = new BusinessFacadLayer(); objBusinessFacadLayer.DeleteItemInBillDetailsTemp(Convert.ToInt64(intItemID), hdnGUID.Value.ToString()); ResetFormForAddBillItem_Temp(); } } catch (Exception ex) { throw ex; } finally { objBusinessFacadLayer = null; } }
protected void gvMasterGrid_RowCommand(object sender, GridViewCommandEventArgs e) { intProductID = 0; objBusinessFacadLayer = new BusinessFacadLayer(); try { if (e.CommandName == "EnableDisable") { // dtRecords = new DataTable(); RowIndex = Convert.ToInt32(e.CommandArgument.ToString()); if (RowIndex > -1) { intProductID = Convert.ToInt32(gvMasterGrid.DataKeys[RowIndex].Value.ToString()); if (gvMasterGrid.Rows[RowIndex].Cells[5].Text.ToUpper() == "TRUE") { blnEnableDisable = false; blnDelete = false; } else if (gvMasterGrid.Rows[RowIndex].Cells[5].Text.ToUpper() == "FALSE") { blnEnableDisable = true; blnDelete = false; } objBusinessFacadLayer.DeleteorEnableDisableCompanyProduct(intProductID, blnEnableDisable, blnDelete); Fill_Master(); } } else if (e.CommandName == "EditRow") { RowIndex = Convert.ToInt32(e.CommandArgument.ToString()); if (RowIndex > -1) { //intCompanyID = Convert.ToInt32(gvMasterGrid.DataKeys[RowIndex].Value); //hdnMasterName.Value = gvMasterGrid.Rows[RowIndex].Cells[1].Text; //hdnMasterID.Value = MasterID.ToString(); //objEcom_Entity.Mode = "GetBrandIDDetails"; //objEcom_Entity.MasterID = MasterID; //dtRecord = objEcom_BAL.GetBrandGroupCatSubCat(objEcom_Entity); //if (dtRecord.Rows.Count > 0) //{ // txtBrandName.Text = dtRecord.Rows[0]["BrandName"].ToString(); // txtBrandDescription.Text = dtRecord.Rows[0]["BrandDescription"].ToString(); // if (dtRecord.Rows[0][3].ToString().ToUpper() == "YES") // { // chkActive.Checked = true; // } // else // { // chkActive.Checked = false; // } // // hdnMasterName.Value = dtRecord.Rows[0][1].ToString(); // trAddNew.Visible = false; // trAddNewMaster.Visible = true; // trList.Visible = false; //} //else //{ // //trAddNew.Visible = true; // //trList.Visible = true; // //Fill_Master(); // //trAddNewMaster.Visible = false; //} } } else if (e.CommandName == "Del") { RowIndex = Convert.ToInt32(e.CommandArgument.ToString()); if (RowIndex > -1) { intProductID = Convert.ToInt32(gvMasterGrid.DataKeys[RowIndex].Value); objBusinessFacadLayer.DeleteorEnableDisableCompany(intProductID, false, true); Fill_Master(); } } } catch (Exception ex) { throw ex; } finally { //objEcom_Entity = null ; //objEcom_BAL = null ; // dtRecord.Dispose(); } }
protected void btnAddItemInInvoice_Click(object sender, EventArgs e) { try { if (Page.IsValid) { objBusinessFacadLayer = new BusinessFacadLayer(); if (Convert.ToInt32(ddlSearchBillingCustomer.SelectedItem.Value.ToString()) == 0 && hdnIsNewBillingCustomer.Value == "Yes") { objCustomerBillingAddress = new tbl_CustomerBillingAddress(); objCustomerBillingAddress.CustomerName = txtCustomerName.Text.Trim(); objCustomerBillingAddress.BillingProprietorName = txtProprietorName.Text.Trim(); objCustomerBillingAddress.BillingAddress1 = txtAddressLine1.Text.Trim(); objCustomerBillingAddress.BillingAddress2 = txtAddressLine2.Text.Trim(); objCustomerBillingAddress.BillingCity = txtCity.Text.Trim(); objCustomerBillingAddress.FK_StateID = Convert.ToInt32(ddlState.SelectedItem.Value.ToString()); objCustomerBillingAddress.Billingpin = txtPin.Text.Trim(); objCustomerBillingAddress.BillingPhone = txtPhoneNo.Text.Trim(); objCustomerBillingAddress.BillingEmail = txtEmail.Text.Trim(); objCustomerBillingAddress.BillingAadharNo = txtAadharNo.Text.Trim(); objCustomerBillingAddress.BillingGSTINNo = txtGSTINNo.Text.Trim(); objCustomerBillingAddress.GUID = hdnGUID.Value.ToString(); objCustomerBillingAddress.IsActive = true; objCustomerBillingAddress.IsDeleted = false; objCustomerBillingAddress.CreatedBy = "Admin"; objCustomerBillingAddress.CreatedOn = Convert.ToDateTime(DateTime.Now.ToString()); objBusinessFacadLayer.AddBillingCustomerDetails(objCustomerBillingAddress); hdnIsNewBillingCustomer.Value = Convert.ToString(objCustomerBillingAddress.Id); } if (Convert.ToInt32(ddlSearchShippingCustomer.SelectedItem.Value.ToString()) == 0 && hdnIsNewShippingCustomer.Value == "Yes") { objCustomerShippingAddress = new tbl_CustomerShippingAddress(); objCustomerShippingAddress.CustomerName = txtShippingCustomerName.Text.Trim(); objCustomerShippingAddress.ShippingProprietorName = txtShippingProprietorName.Text.Trim(); objCustomerShippingAddress.ShippingAddress1 = txtShippingAddressLine1.Text.Trim(); objCustomerShippingAddress.ShippingAddress2 = txtShippingAddressLine2.Text.Trim(); objCustomerShippingAddress.ShippingCity = txtShippingCity.Text.Trim(); objCustomerShippingAddress.FK_StateID = Convert.ToInt32(ddlShippingState.SelectedItem.Value.ToString()); objCustomerShippingAddress.Shippingpin = txtShippingPin.Text.Trim(); objCustomerShippingAddress.ShippingPhone = txtShippingPhoneNo.Text.Trim(); objCustomerShippingAddress.ShippingEmail = txtShippingEmail.Text.Trim(); objCustomerShippingAddress.ShippingAadharNo = txtShippingAadharNo.Text.Trim(); objCustomerShippingAddress.ShippingGSTINNo = txtShippingGSTINNo.Text.Trim(); objCustomerShippingAddress.GUID = hdnGUID.Value.ToString(); objCustomerShippingAddress.IsActive = true; objCustomerShippingAddress.IsDeleted = false; objCustomerShippingAddress.CreatedBy = "Admin"; objCustomerShippingAddress.CreatedOn = Convert.ToDateTime(DateTime.Now.ToString()); objBusinessFacadLayer.AddShippingCustomerDetails(objCustomerShippingAddress); hdnIsNewShippingCustomer.Value = Convert.ToString(objCustomerShippingAddress.Id); } mvwTaxInvoiceBill.SetActiveView(vwTaxInvoiceBillGeneration); #region Setting Billing Address lblBillingNameGSTIN.Text = txtCustomerName.Text + " [ <b>GSTIN No - " + txtGSTINNo.Text + "</b> ]"; lblBillingAddress.Text = txtAddressLine1.Text + ", " + txtAddressLine2.Text; lblBillingCityStatePin.Text = txtCity.Text + ", " + ddlState.SelectedItem.Text.ToString() + ", " + txtPin.Text; lblBillingContact.Text = txtPhoneNo.Text + ", " + txtEmail.Text; #endregion #region Setting Shipping Address lblShippingNameGSTIN.Text = txtShippingCustomerName.Text + " [ <b>GSTIN No - " + txtShippingGSTINNo.Text + "</b> ]"; lblShippingAddress.Text = txtShippingAddressLine1.Text + ", " + txtShippingAddressLine2.Text; lblShippingCityStatePin.Text = txtShippingCity.Text + ", " + ddlShippingState.SelectedItem.Text.ToString() + ", " + txtShippingPin.Text; lblShippingContact.Text = txtShippingPhoneNo.Text + ", " + txtShippingEmail.Text; #endregion Fill_BillDetailsGrid(hdnGUID.Value.ToString()); txtDatenTimeofSupply.Text = Convert.ToString(DateTime.Now.ToString()); txtDatenTimeofSupply.ReadOnly = true; } } catch (Exception ex) { throw ex; } finally { objCustomerBillingAddress = null; objCustomerShippingAddress = null; objBusinessFacadLayer = null; } }
protected void btnGenerateBill_Click(object sender, EventArgs e) { try { if (gvBillItemDetails.Rows.Count > 0) { objBillMaster = new tbl_BillMaster(); objBillMaster.FK_BillingCustomerID = Convert.ToInt32(hdnIsNewBillingCustomer.Value); objBillMaster.InvoiceDate = Convert.ToDateTime(DateTime.Now.ToString()); objBillMaster.FK_ShippingCustomerID = Convert.ToInt32(hdnIsNewShippingCustomer.Value); objBillMaster.InvoiceTotalAmount = Convert.ToDecimal(txtInvoiceTotal.Text.Trim()); objBillMaster.TotalDiscountonInvoice = Convert.ToDecimal(lblSummarytotaldiscount.Text); objBillMaster.TotalCollectedAmount = Convert.ToDecimal(txtTotalCollectedAmount.Value.ToString().Trim()); objBillMaster.LoadingnPackingCharges = Convert.ToDecimal(txtLOadingnPackingCharges.Text = string.IsNullOrEmpty(txtLOadingnPackingCharges.Text.Trim()) ? "0" : txtLOadingnPackingCharges.Text.Trim()); // objBillMaster.InsuranceCharges = Convert.ToDecimal(txtInsuranceCharges.Text.Trim()); objBillMaster.InsuranceCharges = Convert.ToDecimal(txtInsuranceCharges.Text = string.IsNullOrEmpty(txtInsuranceCharges.Text.Trim()) ? "0" : txtInsuranceCharges.Text.Trim()); // objBillMaster.OtherCharges = Convert.ToDecimal(txtOtherCharges.Text.Trim()); objBillMaster.OtherCharges = Convert.ToDecimal(txtOtherCharges.Text = string.IsNullOrEmpty(txtOtherCharges.Text.Trim()) ? "0" : txtOtherCharges.Text.Trim()); objBillMaster.TransportationMode = ddlTransportationType.SelectedItem.Value.ToString(); objBillMaster.VehivleNumber = txtVehicalNumber.Text.Trim(); // objBillMaster.FreightCharges = Convert.ToDecimal(txtFreightCharges.Text.Trim()); objBillMaster.FreightCharges = Convert.ToDecimal(txtFreightCharges.Text = string.IsNullOrEmpty(txtFreightCharges.Text.Trim()) ? "0" : txtFreightCharges.Text.Trim()); if (Convert.ToInt16(ddlTransportationType.SelectedItem.Value) > 0) { objBillMaster.DateNSupplyofTime = Convert.ToDateTime(DateTime.Now.ToString()); } objBillMaster.FinancialYear = get_FinancialYear(); objBillMaster.PlaceofSupply = txtPLaceofSupply.Text.Trim(); objBillMaster.GUID = hdnGUID.Value.ToString(); objBillMaster.InvoiceStatus = "Success"; objBillMaster.IsActive = true; objBillMaster.IsDeleted = false; objBillMaster.CreatedBy = "Admin"; objBillMaster.CreatedOn = Convert.ToDateTime(DateTime.Now.ToString()); objBillMaster.TotalCGSTAmount = Convert.ToDecimal(lblSummaryCGSTAmount.Text); objBillMaster.TotalSGSTAmount = Convert.ToDecimal(lblSummarySGSTAmount.Text); objBillMaster.TotalProductQuantity = Convert.ToInt32(lblSummaryTotalQuantity.Text); objBusinessFacadLayer = new BusinessFacadLayer(); intBillInvoiceNumber = objBusinessFacadLayer.CreateInvoicenGenerateInvoiceNo(objBillMaster); if (intBillInvoiceNumber > 0) { objBillDetails = new tbl_BillDetails(); for (int i = 0; i < gvBillItemDetails.Rows.Count; i++) { objBillDetails.FK_BillMasterID = intBillInvoiceNumber; objBillDetails.CompanyID = Convert.ToInt32(gvBillItemDetails.Rows[i].Cells[16].Text.ToString()); objBillDetails.ProductID = Convert.ToInt32(gvBillItemDetails.Rows[i].Cells[17].Text.ToString()); objBillDetails.HSNNo = gvBillItemDetails.Rows[i].Cells[5].Text.ToString(); objBillDetails.Qnty = Convert.ToInt32(gvBillItemDetails.Rows[i].Cells[6].Text.ToString()); objBillDetails.Rate = Convert.ToDecimal(gvBillItemDetails.Rows[i].Cells[8].Text.ToString()); objBillDetails.UOM = gvBillItemDetails.Rows[i].Cells[7].Text.ToString(); objBillDetails.Total = Convert.ToDecimal(gvBillItemDetails.Rows[i].Cells[9].Text.ToString()); objBillDetails.Discount = Convert.ToDecimal(gvBillItemDetails.Rows[i].Cells[10].Text.ToString()); objBillDetails.TaxableValue = Convert.ToDecimal(gvBillItemDetails.Rows[i].Cells[11].Text.ToString()); objBillDetails.SGSTRate = Convert.ToDecimal(gvBillItemDetails.Rows[i].Cells[12].Text.ToString()); objBillDetails.SGSTValue = Convert.ToDecimal(gvBillItemDetails.Rows[i].Cells[13].Text.ToString()); objBillDetails.CGSTRate = Convert.ToDecimal(gvBillItemDetails.Rows[i].Cells[14].Text.ToString()); objBillDetails.CGSTValue = Convert.ToDecimal(gvBillItemDetails.Rows[i].Cells[15].Text.ToString()); objBillDetails.GUID = hdnGUID.Value.ToString(); objBillDetails.IsActive = true; objBillDetails.IsDeleted = false; objBillDetails.CreatedBy = "Admin"; objBillDetails.CreatedOn = Convert.ToDateTime(DateTime.Now.ToString()); objBusinessFacadLayer.AddBillDetails(objBillDetails); } } else { } Response.Redirect("frmTaxInvoice.aspx", false); } else { } } catch (Exception ex) { } finally { objBusinessFacadLayer = null; } }