private void GetSalesManager() { DataTable ds = new DataTable(); try { ds = ClsPurchaseInvoice.Get_PurchaseOrderForPurchaseInvoiceApproval(Convert.ToDateTime(Txt_FromDate.Text.Trim()), Convert.ToDateTime(Txt_ToDate.Text.Trim())); if (ds.Rows.Count > 0) { GvwSalesRegister.Visible = true; GvwSalesRegister.DataSource = ds; GvwSalesRegister.DataBind(); ViewState["Data"] = ds; ds.Dispose(); if (ViewState["PageINdex"] != null) { GvwSalesRegister.PageIndex = Convert.ToInt32(ViewState["PageINdex"].ToString()); } lblmsg.Text = ""; } else { GvwSalesRegister.Visible = false; lblmsg.Text = "NO Data Found..."; // ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('NO Data Found...');</script>", false); } } catch (Exception ex) { } }
private void PoDetails(Int64 id) { DataTable ds = new DataTable(); ds = ClsPurchaseInvoice.Get_PurchaseOrderForInvoice(id); GvwSaleseOrderDetails.DataSource = ds; GvwSaleseOrderDetails.DataBind(); }
private void PoDetails(Int64 id) { DataTable ds = new DataTable(); ds = ClsPurchaseInvoice.Get_PurchaseOrderForInvoiceInInvoiceApproval(id); GvwPurchaseInvocie.DataSource = ds; GvwPurchaseInvocie.DataBind(); if (ds.Rows.Count > 0) { Txt_InvoiceNo.Text = ds.Rows[0]["InvoiceNumber"].ToString(); string Invoicedate = ds.Rows[0]["InvoiceDate"].ToString(); Txt_InvoiceDate.Text = GetDefaultStartDate(Convert.ToDateTime(Invoicedate)); } }
private void GetSalesManager() { DataTable ds = new DataTable(); try { ds = ClsPurchaseInvoice.Get_PurchaseOrderForPurchaseInvoice(Convert.ToDateTime(Txt_FromDate.Text.Trim()), Convert.ToDateTime(Txt_ToDate.Text.Trim())); GvwSalesRegister.DataSource = ds; GvwSalesRegister.DataBind(); ViewState["Data"] = ds; ds.Dispose(); if (ViewState["PageINdex"] != null) { GvwSalesRegister.PageIndex = Convert.ToInt32(ViewState["PageINdex"].ToString()); } } catch (Exception ex) { } }
private void GetSalesManagerSupport() { DataTable ds = new DataTable(); try { ds = ClsPurchaseInvoice.Get_PurchaseOrderForInvoice(value); GvwSaleseOrderDetailsSupport.DataSource = ds; GvwSaleseOrderDetailsSupport.DataBind(); ViewState["Data"] = ds; ds.Dispose(); if (ViewState["PageINdex"] != null) { GvwSaleseOrderDetailsSupport.PageIndex = Convert.ToInt32(ViewState["PageINdex"].ToString()); } } catch (Exception ex) { } }
private void GetSalesManager() { DataTable ds = new DataTable(); try { ds = ClsPurchaseInvoice.Get_PurchaseOrderForPurchaseInvoice(Convert.ToDateTime(Txt_FromDate.Text.Trim()), Convert.ToDateTime(Txt_ToDate.Text.Trim())); if (ds.Rows.Count > 0) { lblMsg.Text = ""; GvwSalesRegister.Visible = true; GvwSalesRegister.DataSource = ds; GvwSalesRegister.DataBind(); ViewState["Data"] = ds; ds.Dispose(); if (ViewState["PageINdex"] != null) { GvwSalesRegister.PageIndex = Convert.ToInt32(ViewState["PageINdex"].ToString()); } for (int i = 0; i < ds.Rows.Count; i++) { DataTable dtPartial = ClsPurchaseInvoice.GetPartialdataBasedOnPONum(ds.Rows[i]["GRN_Number"].ToString()); if (dtPartial.Rows.Count > 0) { GvwSalesRegister.Rows[i].Cells[1].BackColor = System.Drawing.Color.Yellow; } } } else { GvwSalesRegister.Visible = false; lblMsg.Text = "No Records Found"; // ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('NO Data Found...');</script>", false); } } catch (Exception ex) { } }
private void GetSalesManagerAMC1() { DataTable ds = new DataTable(); try { ds = ClsPurchaseInvoice.Get_PurchaseOrderForInvoicePDF(value); int count = ds.Rows.Count; double total = Convert.ToDouble(ds.Rows[count - 1]["TT"].ToString()); StrRupInWord = "Word: " + AmountInWords(Convert.ToDecimal(total)); GridView1.DataSource = ds; GridView1.DataBind(); ViewState["Data"] = ds; ds.Dispose(); if (ViewState["PageINdex"] != null) { GridView1.PageIndex = Convert.ToInt32(ViewState["PageINdex"].ToString()); } } catch (Exception ex) { } }
public void AddNewGridRow1() { BtnInvoiceSave0.Visible = true; double SubTotal = 0; double POSubTotal = 0; double Total = 0; foreach (GridViewRow row in GvwPurchaseInvocie.Rows) { if (row.RowType == DataControlRowType.DataRow) { if (((TextBox)row.Cells[3].FindControl("TxtInQuantity")).Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('please Enter Invoice Quantity.');</script>", false); return; } string HidCatagory0 = ((HiddenField)row.Cells[3].FindControl("HidCatagory0")).Value; string HidProduct0 = ((HiddenField)row.Cells[3].FindControl("HidProduct0")).Value; DataTable DT = ClsCheck.Get_PurchaseCheck(TxtPoNo.Text.Trim(), Convert.ToInt32(HidProduct0), Convert.ToInt32(HidCatagory0)); int POQUANTITY = Convert.ToInt32(((Label)row.Cells[2].FindControl("LblPendingQuantity")).Text); double POPrice = Convert.ToDouble(((Label)row.Cells[2].FindControl("LblPrice")).Text); // int POQUANTITY = Convert.ToInt32(DT.Rows[0]["PO_QUANTITY"].ToString()); // int PURCHASEIN = Convert.ToInt32(DT.Rows[0]["PURCHASE_INVOICE"].ToString()); int TxtInQuantity1 = Convert.ToInt32(((TextBox)row.Cells[3].FindControl("TxtInQuantity")).Text); if (POQUANTITY < TxtInQuantity1) { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Invoice Quantity is greater than Purchase Quantity..');</script>", false); return; } string PoNo = TxtPoNo.Text; int CategoryId = Convert.ToInt32(((HiddenField)row.FindControl("HidCatagory0")).Value); int ProductId = Convert.ToInt32(((HiddenField)row.FindControl("HidProduct0")).Value); Int32 Quantity = Convert.ToInt32(((TextBox)row.Cells[2].FindControl("TxtInQuantity")).Text); double totalprice = Convert.ToDouble(((TextBox)row.Cells[2].FindControl("TxtInPrice")).Text); // int lblSubTot = Convert.ToInt32(((TextBox)GvwPurchaseInvocie.FooterRow.FindControl("TxtInQuantity")).Text) * Convert.ToInt32(((TextBox)GvwPurchaseInvocie.FooterRow.FindControl("TxtInPrice")).Text); int TxtInQuantity = Convert.ToInt32(((TextBox)row.FindControl("TxtInQuantity")).Text); double TxtInPrice = Convert.ToDouble(((TextBox)row.FindControl("TxtInPrice")).Text); double TotalPrice = POQUANTITY * Convert.ToDouble(POPrice); Label lblPototalPrice = (Label)row.FindControl("LblPOTotalPrice"); lblPototalPrice.Text = Convert.ToString(TotalPrice.ToString("0.00")); double lblSubTot = TxtInQuantity * Convert.ToDouble(TxtInPrice); TextBox TxtInTotalPrice = (TextBox)row.FindControl("TxtInTotalPrice"); TxtInTotalPrice.Text = Convert.ToString(lblSubTot.ToString("0.00")); // int lblSubTot = Convert.ToInt32(((TextBox)row.FindControl("TxtInQuantity")).Text) * Convert.ToInt32(((TextBox)row.FindControl("TxtInPrice")).Text); DataTable DTTaxRate = new DataTable(); DTTaxRate = ClsPurchaseInvoice.GetInvoiceTaxRateBaseValue(PoNo, CategoryId, ProductId); // Label lblSubTot = (Label)GvwPurchaseOrder.FooterRow.FindControl("LblfttotalPrice"); double TaxValue = 0; double POTaxValue = 0; if (DTTaxRate.Rows.Count > 0) { for (int i = 0; i <= DTTaxRate.Rows.Count - 1; i++) { double POSubTotalbaseVal = Convert.ToDouble(TotalPrice) * Convert.ToDouble(DTTaxRate.Rows[i][2].ToString()) / 100; double SubTotonBaseVal = Convert.ToDouble(lblSubTot) * Convert.ToDouble(DTTaxRate.Rows[i][2].ToString()) / 100; POTaxValue = POTaxValue + (POSubTotalbaseVal * Convert.ToDouble(DTTaxRate.Rows[i][1].ToString()) / 100); TaxValue = TaxValue + (SubTotonBaseVal * Convert.ToDouble(DTTaxRate.Rows[i][1].ToString()) / 100); } } POTotalAmount = Convert.ToDouble(TotalPrice) + POTaxValue; TotalAmount = Convert.ToDouble(lblSubTot) + TaxValue; // double tax = Convert.ToDouble(((TextBox)row.Cells[2].FindControl("txttaxid")).Text); // Total = (((Convert.ToDouble(totalprice * Quantity)) * tax) / 100) + (((Convert.ToDouble(totalprice * Quantity)))); TextBox TxtInvTax = (TextBox)row.FindControl("txttaxid"); TxtInvTax.Text = Convert.ToString(TaxValue.ToString("0.00")); Label Lbltaxid = (Label)row.FindControl("Lbltaxid"); Lbltaxid.Text = Convert.ToString(POTaxValue.ToString("0.00")); Label LbltotalAmount = (Label)row.FindControl("LbltotalAmount"); LbltotalAmount.Text = POTotalAmount.ToString("0.00"); Label lbl = (Label)(row.Cells[2].FindControl("LblInvocietotalPrice")); lbl.Text = TotalAmount.ToString("0.00"); POSubTotal = POSubTotal + POTotalAmount; SubTotal = SubTotal + TotalAmount; } } // TxtInTotalAmount.Text = Math.Floor(POSubTotal + .49).ToString("0.00"); TxtInTotalAmount.Text = Convert.ToDouble(POSubTotal).ToString("0.00"); // Txt_SubTotal.Text = Math.Floor(SubTotal + .49).ToString("0.00"); Txt_SubTotal.Text = Convert.ToDouble(SubTotal).ToString("0.00"); }
protected void BtnInvoiceSave_Click(object sender, EventArgs e) { try { ClsPurchaseInvoice objclsinvc = new ClsPurchaseInvoice(); if (Txt_InvoiceNo.Text != string.Empty && Txt_InvoiceDate.Text != string.Empty) { foreach (GridViewRow row in GvwPurchaseInvocie.Rows) { if (((TextBox)row.Cells[3].FindControl("TxtInQuantity")).Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('please Enter Invoice Quantity.');</script>", false); return; } double TxtInPriceUpdate = Convert.ToDouble(((TextBox)row.FindControl("TxtInPrice")).Text); double TxtInTotalPriceUpdate = Convert.ToDouble(((TextBox)row.FindControl("TxtInTotalPrice")).Text); Int32 TxtInQuantityUpdate = Convert.ToInt32(((TextBox)row.Cells[3].FindControl("TxtInQuantity")).Text); double Sum = Convert.ToDouble((TxtInPriceUpdate * TxtInQuantityUpdate).ToString("0.00")); double prvSum = Convert.ToDouble(TxtInTotalPriceUpdate.ToString("0.00")); if (Sum != prvSum) { this.ClientScript.RegisterStartupScript(this.GetType(), "PopupScript", "<script type=text/javascript>alert('Please click on Update Button..')</script>"); Button BtnAdd = (Button)GvwPurchaseInvocie.FooterRow.FindControl("BtnAdd"); BtnAdd.Focus(); return; } } //Check point //--t_purchase order detail and t_purchareinvoicedetail //string pono = TxtPoNo.Text; foreach (GridViewRow row in GvwPurchaseInvocie.Rows) { if (row.RowType == DataControlRowType.DataRow) { string HidCatagory0 = ((HiddenField)row.Cells[3].FindControl("HidCatagory0")).Value; string HidProduct0 = ((HiddenField)row.Cells[3].FindControl("HidProduct0")).Value; DataTable DT = ClsCheck.Get_PurchaseCheck(TxtGRNNum.Text.Trim(), Convert.ToInt32(HidProduct0), Convert.ToInt32(HidCatagory0)); int POQUANTITY = Convert.ToInt32(((Label)row.Cells[2].FindControl("LblQuantity")).Text); //int POQUANTITY = Convert.ToInt32(DT.Rows[0]["PO_QUANTITY"].ToString()); //int PURCHASEIN = Convert.ToInt32(DT.Rows[0]["PURCHASE_INVOICE"].ToString()); int TxtInQuantity = Convert.ToInt32(((TextBox)row.Cells[3].FindControl("TxtInQuantity")).Text); if (POQUANTITY < TxtInQuantity) { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Invoice Quantity is greater than Purchase Quantity..');</script>", false); return; } } } string asd = hidDetails_ID.Value; DateTime PODATE = Convert.ToDateTime(TxtPoDate.Text); string GRNnumber = TxtGRNNum.Text; int invoiceid; DateTime invoicedate = DateTime.Now; string invoiceno = ""; string totalAmount = ""; invoicedate = Convert.ToDateTime(Txt_InvoiceDate.Text.Trim()); invoiceno = Txt_InvoiceNo.Text.Trim(); totalAmount = Txt_SubTotal.Text.Trim(); //taxid = Convert.ToInt32(DrpTaxType.SelectedItem.Value); result2 = ClsPurchaseInvoice.InsertPurchaseGRNInvoice(out invoiceid, Convert.ToInt32(asd), GRNnumber, PODATE, invoiceno, invoicedate, Convert.ToDouble(totalAmount), Convert.ToInt32(Session["Id"]), ""); if (result2) { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('invoice Saved Successfully...');</script>", false); } else { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('invoice Insertion Failed...');</script>", false); } foreach (GridViewRow row in GvwPurchaseInvocie.Rows) { if (row.RowType == DataControlRowType.DataRow) { string LblSlno = ((Label)row.Cells[0].FindControl("LblSlno")).Text; Int64 HidPODetId = Convert.ToInt32(((HiddenField)row.Cells[2].FindControl("HdfPODETID")).Value); string lblCatagory = ((Label)row.Cells[1].FindControl("lblCatagory")).Text; Int32 HidCatagory0 = Convert.ToInt32(((HiddenField)row.Cells[2].FindControl("HidCatagory0")).Value); string LblProduct = ((Label)row.Cells[3].FindControl("LblProduct")).Text; Int32 HidProduct0 = Convert.ToInt32(((HiddenField)row.Cells[4].FindControl("HidProduct0")).Value); Int32 LblQuantity = Convert.ToInt32(((Label)row.Cells[3].FindControl("LblQuantity")).Text); double LblPrice = Convert.ToDouble(((Label)row.Cells[3].FindControl("LblPrice")).Text); double POTaxPrice = Convert.ToDouble(((Label)row.Cells[3].FindControl("Lbltaxid")).Text); double pototalamount = Convert.ToDouble(((Label)row.Cells[3].FindControl("LbltotalAmount")).Text); string TxtInQuantity = ((TextBox)row.Cells[3].FindControl("TxtInQuantity")).Text; string TxtInPrice = ((TextBox)row.Cells[4].FindControl("TxtInPrice")).Text; double invoicetotalamount = Convert.ToDouble(((Label)row.Cells[3].FindControl("LblInvocietotalPrice")).Text); string InvoiceTaxPrice = ((TextBox)row.Cells[3].FindControl("txttaxid")).Text; string loaction = Txt_shippingAdress.Text.Trim(); string MainLocation = TxtPoLocation.Text; result1 = ClsPurchaseInvoice.InsertPurchaseGRNInvoicedetails(invoiceid, Convert.ToInt32(asd), HidCatagory0, HidProduct0, LblQuantity, LblPrice, POTaxPrice, pototalamount, Convert.ToInt32(TxtInQuantity), Convert.ToDouble(TxtInPrice), InvoiceTaxPrice, invoicetotalamount, Convert.ToInt32(Session["Id"].ToString()), loaction, LblProduct, invoicedate, MainLocation, Convert.ToInt32(Session["int_LocationId"]), HidPODetId); } } Txt_InvoiceNo.Text = ""; Txt_InvoiceDate.Text = ""; Txt_SubTotal.Text = "0.00"; TxtInTotalAmount.Text = "0.00"; GetSalesManager(); Panel1.Visible = false; Panel2.Visible = true; tbldate.Visible = true; } else { if (Txt_InvoiceNo.Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Enter Invoice Number.');</script>", false); Txt_InvoiceNo.Focus(); return; } if (Txt_InvoiceDate.Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select Invoice Date.');</script>", false); Txt_InvoiceDate.Focus(); return; } //if (Txt_InvoiceDate.Text != "") //{ // DateTime PODate = Convert.ToDateTime(TxtPoDate.Text); // DateTime PO_date = Convert.ToDateTime(PODate.ToString("dd/MM/yyyy")); // DateTime InvoiceDate = Convert.ToDateTime(Txt_InvoiceDate.Text); // DateTime Invoice_Date = Convert.ToDateTime(InvoiceDate.ToString("dd/MM/yyyy")); // if (PO_date > Invoice_Date) // { // ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Invoice Date Should be Greater Than PO Date.');</script>", false); // TxtPoDate.Focus(); // return; // } //} //if (TxtLorryRcptNum.Text == "") //{ // ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Enter Lorry receipt number.');</script>", false); // TxtLorryRcptNum.Focus(); // return; //} // ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Fill Invoice Number and Invoice Date...');</script>", false); } } catch (Exception ex) { } }
protected void BtnInvoiceSave_Click(object sender, EventArgs e) { try { ClsPurchaseInvoice objclsinvc = new ClsPurchaseInvoice(); if (Txt_InvoiceNo.Text != string.Empty && Txt_InvoiceDate.Text != string.Empty) { if (ddlInvoiceApproval.SelectedValue == "1") { string asd = hidDetails_ID.Value; DateTime PODATE = Convert.ToDateTime(TxtPoDate.Text); string ponumber = TxtPoNo.Text; int invoiceid; DateTime invoicedate = DateTime.Now; string invoiceno = ""; string totalAmount = ""; invoicedate = Convert.ToDateTime(Txt_InvoiceDate.Text.Trim()); invoiceno = Txt_InvoiceNo.Text.Trim(); totalAmount = Txt_SubTotal.Text.Trim(); //taxid = Convert.ToInt32(DrpTaxType.SelectedItem.Value); result2 = ClsPurchaseInvoice.InsertPurchaseInvoiceFromInvoiceApproval(out invoiceid, Convert.ToInt32(asd), ponumber, PODATE, invoiceno, invoicedate, Convert.ToDouble(totalAmount), Convert.ToInt32(Session["Id"]), Convert.ToInt32(ddlInvoiceApproval.SelectedValue)); if (result2) { //Panel1.Visible = false; //Panel2.Visible = true; //tbldate.Visible = true; ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('invoice Saved Successfully...');</script>", false); } else { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('invoice Insertion Failed...');</script>", false); } foreach (GridViewRow row in GvwPurchaseInvocie.Rows) { if (row.RowType == DataControlRowType.DataRow) { string LblSlno = ((Label)row.Cells[0].FindControl("LblSlno")).Text; string lblCatagory = ((Label)row.Cells[1].FindControl("lblCatagory")).Text; Int32 HidCatagory0 = Convert.ToInt32(((HiddenField)row.Cells[2].FindControl("HidCatagory0")).Value); string LblProduct = ((Label)row.Cells[3].FindControl("LblProduct")).Text; Int32 HidProduct0 = Convert.ToInt32(((HiddenField)row.Cells[4].FindControl("HidProduct0")).Value); Int32 LblQuantity = Convert.ToInt32(((Label)row.Cells[3].FindControl("LblQuantity")).Text); double LblPrice = Convert.ToDouble(((Label)row.Cells[3].FindControl("LblPrice")).Text); double POTaxPrice = Convert.ToDouble(((Label)row.Cells[3].FindControl("Lbltaxid")).Text); double pototalamount = Convert.ToDouble(((Label)row.Cells[3].FindControl("LbltotalAmount")).Text); string TxtInQuantity = ((TextBox)row.Cells[3].FindControl("TxtInQuantity")).Text; string TxtInPrice = ((TextBox)row.Cells[4].FindControl("TxtInPrice")).Text; double invoicetotalamount = Convert.ToDouble(((Label)row.Cells[3].FindControl("LblInvocietotalPrice")).Text); string InvoiceTaxPrice = ((TextBox)row.Cells[3].FindControl("txttaxid")).Text; string loaction = Txt_shippingAdress.Text.Trim(); string MainLocation = TxtPoLocation.Text; result1 = ClsPurchaseInvoice.InsertPurchaseInvoicedetails1(invoiceid, Convert.ToInt32(asd), HidCatagory0, HidProduct0, LblQuantity, LblPrice, POTaxPrice, pototalamount, Convert.ToInt32(TxtInQuantity), Convert.ToDouble(TxtInPrice), InvoiceTaxPrice, invoicetotalamount, Convert.ToInt32(Session["Id"].ToString()), loaction, LblProduct, invoicedate, MainLocation, Convert.ToInt32(Session["int_LocationId"])); } } } else { bool Reject; string HPOID = hidDetails_ID.Value; Reject = ClsPurchaseInvoice.PurchaseOrderInvoiceQuantityReject(Convert.ToInt32(HPOID), ddlInvoiceApproval.SelectedValue); if (Reject) { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('invoice Rejected...');</script>", false); } } //if(ddlInvoiceApproval.SelectedValue=="1") //{ string pono = TxtPoNo.Text; DataTable dtPOInvoice = new DataTable(); //foreach (GridViewRow row in GvwPurchaseInvocie.Rows) //{ // if (row.RowType == DataControlRowType.DataRow) // { // string HidProduct0 = ((HiddenField)row.Cells[3].FindControl("HidProduct0")).Value; // DataTable DT = ClsCheck.Get_PurchaseCheck(TxtPoNo.Text.Trim(), Convert.ToInt32(HidProduct0)); // int POQUANTITY = Convert.ToInt32(DT.Rows[0]["PO_QUANTITY"].ToString()); // int PURCHASEIN = Convert.ToInt32(DT.Rows[0]["PURCHASE_INVOICE"].ToString()); // int TxtInQuantity = Convert.ToInt32(((TextBox)row.Cells[3].FindControl("TxtInQuantity")).Text); // DataTable dtPOInvoice = new DataTable(); dtPOInvoice.Columns.Add("Catagory", typeof(string)); dtPOInvoice.Columns.Add("Product", typeof(string)); dtPOInvoice.Columns.Add("POQuantity", typeof(string)); dtPOInvoice.Columns.Add("POPrice", typeof(string)); dtPOInvoice.Columns.Add("POTax", typeof(string)); dtPOInvoice.Columns.Add("POTotalPrice", typeof(string)); dtPOInvoice.Columns.Add("InvoicQuantity", typeof(string)); dtPOInvoice.Columns.Add("InvoicePrice", typeof(string)); dtPOInvoice.Columns.Add("InvoiceTax", typeof(string)); dtPOInvoice.Columns.Add("InvoiceTotalPrice", typeof(string)); foreach (GridViewRow gvRow in GvwPurchaseInvocie.Rows) { DataRow drInvDet = dtPOInvoice.NewRow(); drInvDet["Catagory"] = ((Label)gvRow.FindControl("lblCatagory")).Text; drInvDet["Product"] = ((Label)gvRow.FindControl("LblProduct")).Text; drInvDet["POQuantity"] = ((Label)gvRow.FindControl("LblQuantity")).Text; int PO_Quantity = Convert.ToInt32(((Label)gvRow.FindControl("LblQuantity")).Text); drInvDet["POPrice"] = ((Label)gvRow.FindControl("LblPrice")).Text; drInvDet["POTax"] = ((Label)gvRow.FindControl("Lbltaxid")).Text; drInvDet["POTotalPrice"] = ((Label)gvRow.FindControl("LbltotalAmount")).Text; drInvDet["InvoicQuantity"] = ((TextBox)gvRow.FindControl("TxtInQuantity")).Text; int InvoiceQuantity = Convert.ToInt32(((TextBox)gvRow.FindControl("TxtInQuantity")).Text); drInvDet["InvoicePrice"] = ((TextBox)gvRow.FindControl("TxtInPrice")).Text; drInvDet["InvoiceTax"] = ((TextBox)gvRow.FindControl("txttaxid")).Text; drInvDet["InvoiceTotalPrice"] = ((Label)gvRow.FindControl("LblInvocietotalPrice")).Text; dtPOInvoice.Rows.Add(drInvDet); } // int i = objclsinvc.PurchaseOrderInvoiceQuantityApproval_RejectStatusFromPOM(TxtPoNo.Text, TxtPoLocation.Text, TxtPoDate.Text, dtPOInvoice,ddlInvoiceApproval.SelectedValue,Txt_InvoiceNo.Text); // this.ClientScript.RegisterStartupScript(this.GetType(), "PopupScript", "<script type=text/javascript>alert('Check Invoice Quantity')</script>"); // } // } int i = objclsinvc.PurchaseOrderInvoiceQuantityApproval_RejectStatusFromPOM(TxtPoNo.Text, TxtPoLocation.Text, TxtPoDate.Text, dtPOInvoice, ddlInvoiceApproval.SelectedValue, Txt_InvoiceNo.Text); // } Txt_InvoiceNo.Text = ""; Txt_InvoiceDate.Text = ""; Txt_SubTotal.Text = "0.00"; TxtInTotalAmount.Text = "0.00"; GetSalesManager(); Panel1.Visible = false; Panel2.Visible = true; tbldate.Visible = true; } else { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Fill Invoice Number and Invoice Date...');</script>", false); } } catch (Exception ex) { } }
protected void BtnGRNSave_Click(object sender, EventArgs e) { try { ClsPurchaseInvoice objclsinvc = new ClsPurchaseInvoice(); if (Txt_InvoiceDate.Text != string.Empty && TxtLorryRcptNum.Text != string.Empty) { foreach (GridViewRow row in GvwPurchaseInvocie.Rows) { if (((TextBox)row.FindControl("TxtInQuantity")).Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Enter GRN Quantity.');</script>", false); return; } if (((TextBox)row.FindControl("TxtInQuantity")).Text != "0") { if (((TextBox)row.FindControl("txtSupRefNo")).Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Enter Supplier Reference Number.');</script>", false); return; } else if (((TextBox)row.FindControl("txtSupRefDate")).Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select Supplier Reference Date.');</script>", false); return; } } //else if (Txt_InvoiceDate.Text != "") // { DateTime GRNDate = Convert.ToDateTime(Txt_InvoiceDate.Text); string TxtSupRefDate = ((TextBox)row.FindControl("txtSupRefDate")).Text; if (TxtSupRefDate.ToString() != string.Empty || TxtSupRefDate.ToString() != "") { DateTime SupRefDate = Convert.ToDateTime(TxtSupRefDate); if (SupRefDate > GRNDate) { // lblshowmsg.Text = "Supper reference date can't be greater than GRN date."; ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Supper reference date can not be greater than GRN date.');</script>", false); //ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Supper reference date can't be greater than GRN date.');</script>", false); ((TextBox)row.FindControl("txtSupRefDate")).Focus(); return; } } //} double TxtInPriceUpdate = Convert.ToDouble(((TextBox)row.FindControl("TxtInPrice")).Text); double TxtInTotalPriceUpdate = Convert.ToDouble(((TextBox)row.FindControl("TxtInTotalPrice")).Text); Int32 TxtInQuantityUpdate = Convert.ToInt32(((TextBox)row.Cells[3].FindControl("TxtInQuantity")).Text); double Sum = Convert.ToDouble((TxtInPriceUpdate * TxtInQuantityUpdate).ToString("0.00")); double prvSum = Convert.ToDouble(TxtInTotalPriceUpdate.ToString("0.00")); if (Sum != prvSum) { this.ClientScript.RegisterStartupScript(this.GetType(), "PopupScript", "<script type=text/javascript>alert('Please click on Update Button..')</script>"); Button BtnAdd = (Button)GvwPurchaseInvocie.FooterRow.FindControl("BtnAdd"); BtnAdd.Focus(); return; } } //Check point //--t_purchase order detail and t_purchareinvoicedetail //string pono = TxtPoNo.Text; foreach (GridViewRow row in GvwPurchaseInvocie.Rows) { if (row.RowType == DataControlRowType.DataRow) { string HidCatagory0 = ((HiddenField)row.Cells[3].FindControl("HidCatagory0")).Value; string HidProduct0 = ((HiddenField)row.Cells[3].FindControl("HidProduct0")).Value; DataTable DT = ClsCheck.Get_PurchaseCheck(TxtPoNo.Text.Trim(), Convert.ToInt32(HidProduct0), Convert.ToInt32(HidCatagory0)); int POQUANTITY = Convert.ToInt32(((Label)row.Cells[2].FindControl("LblQuantity")).Text); //int POQUANTITY = Convert.ToInt32(DT.Rows[0]["PO_QUANTITY"].ToString()); //int PURCHASEIN = Convert.ToInt32(DT.Rows[0]["PURCHASE_INVOICE"].ToString()); int TxtInQuantity = Convert.ToInt32(((TextBox)row.Cells[3].FindControl("TxtInQuantity")).Text); if (POQUANTITY < TxtInQuantity) { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('GRN Quantity is greater than Purchase Quantity..');</script>", false); return; } } } string POId = hidDetails_ID.Value; // string POId = ddlPONo.SelectedValue; DateTime PODATE = Convert.ToDateTime(TxtPoDate.Text); string ponumber = TxtPoNo.Text; int GRNid; DateTime GRNdate = DateTime.Now; string totalAmount = ""; GRNdate = Convert.ToDateTime(Txt_InvoiceDate.Text.Trim()); //invoiceno = Txt_InvoiceNo.Text.Trim(); totalAmount = Txt_SubTotal.Text.Trim(); //showing alert if grn value is 0 if (Txt_SubTotal.Text == "0" || Txt_SubTotal.Text == "0.0" || Txt_SubTotal.Text == "0.00") { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('GRN Total Amount can not be 0...');</script>", false); return; } //taxid = Convert.ToInt32(DrpTaxType.SelectedItem.Value); result2 = ClsGoodsReceiptNote.InsertPurchaseGRN(out GRNid, Convert.ToInt32(POId), ponumber, PODATE, GRNdate, Convert.ToDouble(totalAmount), Convert.ToInt32(Session["Id"]), TxtLorryRcptNum.Text.Trim(), txtVehicleNum.Text.Trim(), txtAWBNum.Text.Trim()); if (result2) { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('GRN Saved Successfully...');</script>", false); } else { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('GRN Insertion Failed...');</script>", false); } DataTable dtGRN = new DataTable(); dtGRN.Columns.Add("State", typeof(string)); dtGRN.Columns.Add("Location", typeof(string)); dtGRN.Columns.Add("Category", typeof(string)); dtGRN.Columns.Add("Product", typeof(string)); dtGRN.Columns.Add("RecvdQuantity", typeof(string)); foreach (GridViewRow row in GvwPurchaseInvocie.Rows) { if (row.RowType == DataControlRowType.DataRow) { string LblSlno = ((Label)row.Cells[0].FindControl("LblSlno")).Text; Int64 HidPODetId = Convert.ToInt32(((HiddenField)row.Cells[2].FindControl("HdfPODETID")).Value); string lblCatagory = ((Label)row.Cells[1].FindControl("lblCatagory")).Text; Int32 HidCatagory0 = Convert.ToInt32(((HiddenField)row.Cells[2].FindControl("HidCatagory0")).Value); string LblProduct = ((Label)row.Cells[3].FindControl("LblProduct")).Text; Int32 HidProduct0 = Convert.ToInt32(((HiddenField)row.Cells[4].FindControl("HidProduct0")).Value); Int32 LblQuantity = Convert.ToInt32(((Label)row.Cells[3].FindControl("LblQuantity")).Text); double LblPrice = Convert.ToDouble(((Label)row.Cells[3].FindControl("LblPrice")).Text); double POTaxPrice = Convert.ToDouble(((Label)row.Cells[3].FindControl("Lbltaxid")).Text); double pototalamount = Convert.ToDouble(((Label)row.Cells[3].FindControl("LbltotalAmount")).Text); string TxtInQuantity = ((TextBox)row.Cells[3].FindControl("TxtInQuantity")).Text; string TxtInPrice = ((TextBox)row.Cells[4].FindControl("TxtInPrice")).Text; double invoicetotalamount = Convert.ToDouble(((Label)row.Cells[3].FindControl("LblInvocietotalPrice")).Text); string InvoiceTaxPrice = ((TextBox)row.Cells[3].FindControl("txttaxid")).Text; string loaction = TxtShippingAddress.Text.Trim(); string MainLocation = TxtPoLocation.Text; //added by sita for getting supplier ref number and date as per the new changes. string SupRefNo = ((TextBox)row.FindControl("txtSupRefNo")).Text; // ((TextBox)row.Cells[3].FindControl("txtSupRefNo")).Text; string TxtSupRefDate = ((TextBox)row.FindControl("txtSupRefDate")).Text; DateTime SupRefDate = System.DateTime.Now; if (TxtSupRefDate.ToString() != string.Empty) { SupRefDate = Convert.ToDateTime(TxtSupRefDate); } //((TextBox)row.Cells[3].FindControl("txtSupRefDate")).Text; if (TxtInQuantity != "0") { result1 = ClsGoodsReceiptNote.Insert_Po_GRN_Details(GRNid, Convert.ToInt32(POId), HidCatagory0, HidProduct0, LblQuantity, LblPrice, POTaxPrice, pototalamount, Convert.ToInt32(TxtInQuantity), Convert.ToDouble(TxtInPrice), InvoiceTaxPrice, invoicetotalamount, Convert.ToInt32(Session["Id"].ToString()), loaction, LblProduct, GRNdate, MainLocation, Convert.ToInt32(Session["int_LocationId"]), HidPODetId, SupRefNo, SupRefDate); DataRow drGRN = dtGRN.NewRow(); drGRN["State"] = TxtPoSupplierState.Text; drGRN["Location"] = TxtPoLocation.Text; drGRN["Category"] = lblCatagory; drGRN["Product"] = LblProduct; drGRN["RecvdQuantity"] = TxtInQuantity; dtGRN.Rows.Add(drGRN); } } } if (dtGRN.Rows.Count > 0) { ClsSalesOrder objclsSo = new ClsSalesOrder(); int SentMailResult = objclsSo.Send_Mail_GRN_RecivedQuantity_Details(dtGRN); } // Txt_InvoiceNo.Text = ""; Txt_InvoiceDate.Text = ""; Txt_SubTotal.Text = "0.00"; txtAWBNum.Text = ""; TxtInTotalAmount.Text = "0.00"; GetGeneratePoDetails(); Panel1.Visible = false; Panel2.Visible = true; tbldate.Visible = true; } else { //if (Txt_InvoiceNo.Text == "") //{ // ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Enter Invoice Number.');</script>", false); // Txt_InvoiceNo.Focus(); // return; //} if (Txt_InvoiceDate.Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select GRN Date.');</script>", false); Txt_InvoiceDate.Focus(); return; } //if (Txt_InvoiceDate.Text != "") //{ // DateTime PODate = Convert.ToDateTime(TxtPoDate.Text); // DateTime PO_date = Convert.ToDateTime(PODate.ToString("dd/MM/yyyy")); // DateTime InvoiceDate = Convert.ToDateTime(Txt_InvoiceDate.Text); // DateTime Invoice_Date = Convert.ToDateTime(InvoiceDate.ToString("dd/MM/yyyy")); // if (PO_date > Invoice_Date) // { // ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Invoice Date Should be Greater Than PO Date.');</script>", false); // TxtPoDate.Focus(); // return; // } //} if (TxtLorryRcptNum.Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Enter Lorry receipt number.');</script>", false); TxtLorryRcptNum.Focus(); return; } // ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Fill Invoice Number and Invoice Date...');</script>", false); } } catch (Exception ex) { } }
protected void btnExport_Click(object sender, EventArgs e) { try { if (ddlPonumber.SelectedIndex != 0) { string MainCategory = ClsPurchaseInvoice.Get_MainCategory_BasedOn_POID(Convert.ToInt64(ddlPonumber.SelectedValue.ToString())); if (MainCategory != "Support") { Panel1.Visible = true; value = Convert.ToInt32(ddlPonumber.SelectedValue.ToString()); if (value != -1) { DataTable dt = ClsReportPurchaseOrder.Report_PurchaseOrder(value); lbl_Ponumber.Text = dt.Rows[0]["PO Number"].ToString(); lbl_PoDate.Text = Convert.ToDateTime(dt.Rows[0]["PO Date"]).ToString("dd-MM-yyyy"); lbl_PO_RaisedTO.Text = dt.Rows[0]["PO_Raise_TO"].ToString(); lbl_Bill_Address.Text = dt.Rows[0]["BillingAddress"].ToString(); lbl_Ship_Address.Text = dt.Rows[0]["ShippingAddress"].ToString(); //lbl_Footer_Address1.Text = dt.Rows[0]["BillingAddress"].ToString(); lbl_Term4.Text = "4. Warranty :" + dt.Rows[0]["Warranty"].ToString(); lblBillGST.Text = dt.Rows[0]["GST"].ToString(); lblBillPAN.Text = dt.Rows[0]["PAN"].ToString(); lblSPA.Text = dt.Rows[0]["SPANumber"].ToString(); // lblShipGST.Text= dt.Rows[0]["GST"].ToString(); lblShipPAN.Text = dt.Rows[0]["PAN"].ToString(); DataTable DT1 = ClsPurchaseInvoice.Get_PurchaseOrderForInvoice(value); int CategoryID = 0; //foreach (DataRow row in DT1.Rows) //{ //for (int i = 0; i < DT1.Rows.Count - 1; i++) //{ // CategoryID = Convert.ToInt32(DT1.Rows[i]["catagoryid"].ToString()); //if (CategoryID == 33) //{ //GetSalesManager(); GetSalesManagerAMC1(); //lbl_Term3.Text = ""; //} //else //{ // GetSalesManager(); //} // } //if (CategoryID == 33) //{ //foreach (GridViewRow row in GridView1.Rows) //{ // foreach (TableCell cell in row.Cells) // { // row.Cells[0].Width = 10; // } //} Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=PO.pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); GridView1.HeaderRow.Style.Add("width", "10%"); GridView1.HeaderRow.Style.Add("font-size", "10px"); GridView1.Style.Add("font-size", "8px"); Panel1.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A4, 20f, 20f, 100f, 100f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter pdfWriter = PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfWriter.PageEvent = new Comman.ITextEvents(); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); Response.Write(pdfDoc); // Response.End(); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.SuppressContent = true; HttpContext.Current.ApplicationInstance.CompleteRequest(); Panel1.Visible = false; GetMasterList(); #region old code //} //else //{ // Response.ContentType = "application/pdf"; // Response.AddHeader("content-disposition", "attachment;filename=PO.pdf"); // Response.Cache.SetCacheability(HttpCacheability.NoCache); // StringWriter sw = new StringWriter(); // HtmlTextWriter hw = new HtmlTextWriter(sw); // GvwSaleseOrderDetails.HeaderRow.Style.Add("width", "10%"); // GvwSaleseOrderDetails.HeaderRow.Style.Add("font-size", "10px"); // GvwSaleseOrderDetails.Style.Add("font-size", "8px"); // Panel1.RenderControl(hw); // StringReader sr = new StringReader(sw.ToString()); // Document pdfDoc = new Document(PageSize.A4, 20f, 20f, 20f, 20f); // HTMLWorker htmlparser = new HTMLWorker(pdfDoc); // PdfWriter.GetInstance(pdfDoc, Response.OutputStream); // pdfDoc.Open(); // htmlparser.Parse(sr); // pdfDoc.Close(); // Response.Write(pdfDoc); // // Response.End(); // HttpContext.Current.Response.Flush(); // HttpContext.Current.Response.SuppressContent = true; // HttpContext.Current.ApplicationInstance.CompleteRequest(); // Panel1.Visible = false; // GetMasterList(); //} #endregion } else { Panel1.Visible = false; ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select PO Number.');</script>", false); } } else { Panel2.Visible = true; value = Convert.ToInt32(ddlPonumber.SelectedValue.ToString()); if (value != -1) { DataTable dt = ClsReportPurchaseOrder.Report_PurchaseOrder(value); lbl_PonumberSupport.Text = dt.Rows[0]["PO Number"].ToString(); lbl_PoDateSupport.Text = Convert.ToDateTime(dt.Rows[0]["PO Date"]).ToString("dd-MM-yyyy"); lbl_PO_RaisedTO.Text = dt.Rows[0]["PO_Raise_TO"].ToString(); lbl_Bill_Address_Support.Text = dt.Rows[0]["BillingAddress"].ToString(); lbl_Ship_Address_Support.Text = dt.Rows[0]["ShippingAddress"].ToString(); lblSPA.Text = dt.Rows[0]["SPANumber"].ToString(); lblSupBilGST.Text = dt.Rows[0]["GST"].ToString(); lblSupBilPAN.Text = dt.Rows[0]["PAN"].ToString(); //lbl_Footer_Address1.Text = dt.Rows[0]["BillingAddress"].ToString(); DataTable DT1 = ClsPurchaseInvoice.Get_PurchaseOrderForInvoice(value); foreach (DataRow row in DT1.Rows) { int CategoryID = Convert.ToInt32(DT1.Rows[0]["catagoryid"].ToString()); if (CategoryID == 5 || CategoryID == 20 || CategoryID == 30 || CategoryID == 31 || CategoryID == 32 || CategoryID == 33 || CategoryID == 42) { //GetSalesManagerSupport(); GetSalesManagerAMC(); lbl_Term3.Text = ""; } else { GetSalesManagerSupport(); } } Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=PO.pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); GridView3.HeaderRow.Style.Add("width", "10%"); GridView3.HeaderRow.Style.Add("font-size", "10px"); GridView3.Style.Add("font-size", "8px"); Panel2.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A4, 20f, 20f, 130f, 100f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter pdfWriter = PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfWriter.PageEvent = new Comman.ITextEvents(); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); Response.Write(pdfDoc); // Response.End(); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.SuppressContent = true; HttpContext.Current.ApplicationInstance.CompleteRequest(); Panel2.Visible = false; GetMasterList(); } else { Panel2.Visible = false; ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select PO Number.');</script>", false); } } } else { Panel1.Visible = false; ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select PO Number.');</script>", false); } } catch (Exception ex) { } //ddlPonumber.SelectedItem.Value = "-1"; }