//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;
}
}
