private void PoDetails(Int64 id) { DataTable ds = new DataTable(); ds = ClsPurchaseInvoice.Get_PurchaseOrderForInvoiceInInvoice(id); GvwPurchaseInvocie.DataSource = ds; GvwPurchaseInvocie.DataBind(); }
private void SoDetails(Int64 id) { DataTable ds = new DataTable(); ds = ClsSalesRegister.Get_SalesOrderforInvocie(id); GvwPurchaseInvocie.DataSource = ds; GvwPurchaseInvocie.DataBind(); }
//protected void GvwSalesRegister_RowCommand(object sender, GridViewCommandEventArgs e) //{ // try // { // if (e.CommandName == "Edit1") // { // TxtLorryRcptNum.Text = ""; // Txt_InvoiceDate.Text = ""; // Panel1.Visible = true; // Panel2.Visible = false; // tbldate.Visible = false; // int index = Convert.ToInt32(e.CommandArgument); // GridViewRow row = GvwSalesRegister.Rows[index]; // Label lbl = (Label)row.FindControl("hidennID"); // // hidDetails_ID.Value = e.CommandArgument.ToString(); // string ID = lbl.Text.Trim(); // hidDetails_ID.Value = ID; // DataTable dtItem = (DataTable)ViewState["Data"]; // DataRow[] drModel = dtItem.Select("PO_ID='" + ID + "'"); // DataTable dtNew = new DataTable(); // dtNew = dtItem.Clone(); // if (drModel.Length > 0) // { // foreach (DataRow dr in drModel) // { // dtNew.ImportRow(dr); // } // dtNew.AcceptChanges(); // int supp_id = Convert.ToInt32(dtNew.Rows[0]["suppilerid"]); // DataTable dtsup = BusinessLogicLayer.ClsSalesManagerChecking.get_reversecharges(supp_id); // TxtPoDate.Text = dtNew.Rows[0]["PO_Date"].ToString(); // TxtPoNo.Text = dtNew.Rows[0]["PO_Number"].ToString(); // TxtPoLocation.Text = dtNew.Rows[0]["Location"].ToString(); // TxtPoSupplier.Text = dtNew.Rows[0]["Supplier"].ToString(); // // TxtTotalAmount.Text = dtNew.Rows[0]["PO_NetAmount"].ToString(); // Txt_SubTotal.Text = dtNew.Rows[0]["PO_NetAmount"].ToString(); // TxtInTotalAmount.Text = dtNew.Rows[0]["PO_NetAmount"].ToString(); // TxtType.Text = dtNew.Rows[0]["M_CategoryName"].ToString(); // txt_hsnac.Text = dtNew.Rows[0]["HSN_SAC_NUM"].ToString(); // TxtPurchaseType.Text= dtNew.Rows[0]["Purchase_Type"].ToString(); // if (TxtType.Text.Trim() == "Service" || TxtType.Text.Trim() == "Support" || TxtType.Text.Trim() == "Rental") // { // lbl_hsnac.Text = "SAN Code"; // } // else // { // lbl_hsnac.Text = "HSN Code"; // } // if (TxtType.Text.Trim() == "Scanners" || TxtType.Text.Trim() == "Support" || TxtType.Text.Trim() == "Software") // { // TrWarranty.Visible = true; // TxtWarranty.Text = dtNew.Rows[0]["Warranty"].ToString(); // } // else // { // TrWarranty.Visible = false; // } // if (TxtPoSupplier.Text.Trim() == "Others") // { // TrVendor.Visible = true; // TxtVendor.Text = dtNew.Rows[0]["VendorName"].ToString(); // } // else // { // TrVendor.Visible = false; // } // TxtBillingAddress.Text = dtNew.Rows[0]["BillingAddress"].ToString(); // TxtShippingAddress.Text = dtNew.Rows[0]["ShippingAddress"].ToString(); // int_LocationId = Convert.ToInt32(dtNew.Rows[0]["locationID"].ToString()); // Session["int_LocationId"] = int_LocationId; // TxtPoSupplierState.Text= dtNew.Rows[0]["State_Name"].ToString(); // TxtGST.Text= dtNew.Rows[0]["Sup_Vat_Cst"].ToString(); // txtPaymentterms.Text= dtNew.Rows[0]["Sup_PaymentTerms"].ToString(); // txtTermsOfDelivery.Text = dtNew.Rows[0]["TermOfDelv"].ToString(); // TxtSupplierState.Text= dtNew.Rows[0]["Sup_StateName"].ToString(); // txtrevers.Text = dtsup.Rows[0]["Reverse_Charge"].ToString(); // TxtPanNum.Text = dtsup.Rows[0]["PAN"].ToString(); // } // PoDetails(Convert.ToInt64(ID)); // AddNewGridRow1(); // GetGeneratePoDetails(); // ViewState["PageINdex"] = GvwSalesRegister.PageIndex; // } // } // catch (Exception ex) // { } //} private void PoDetails(Int64 id) { DataTable ds = new DataTable(); ds = ClsGoodsReceiptNote.Get_PurchaseOrderDetailsForGRN(id); GvwPurchaseInvocie.DataSource = ds; GvwPurchaseInvocie.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)); } }
protected void GvwPurchaseInvocie_RowDeleting(object sender, GridViewDeleteEventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add("category"); dt.Columns.Add("catagoryid"); dt.Columns.Add("Product"); dt.Columns.Add("productid"); dt.Columns.Add("PO_Quantity"); dt.Columns.Add("PO_UnitPrice"); dt.Columns.Add("taxID"); dt.Columns.Add("TT"); dt.Columns.Add("PO_Quantity1"); dt.Columns.Add("PO_UnitPrice1"); dt.Columns.Add("taxID1"); dt.Columns.Add("TT1"); foreach (GridViewRow gvRow in GvwPurchaseInvocie.Rows) { DataRow dr = dt.NewRow(); dr["category"] = ((Label)gvRow.FindControl("lblCatagory")).Text; dr["catagoryid"] = ((HiddenField)gvRow.FindControl("HidCatagory0")).Value; dr["Product"] = ((Label)gvRow.FindControl("LblProduct")).Text; dr["productid"] = ((HiddenField)gvRow.FindControl("HidProduct0")).Value; dr["PO_Quantity"] = ((Label)gvRow.FindControl("LblQuantity")).Text; dr["PO_UnitPrice"] = ((Label)gvRow.FindControl("LblPrice")).Text; dr["taxID"] = ((Label)gvRow.FindControl("Lbltaxid")).Text; dr["TT"] = ((Label)gvRow.FindControl("LbltotalAmount")).Text; dr["PO_Quantity1"] = ((TextBox)gvRow.FindControl("TxtInQuantity")).Text; dr["PO_UnitPrice1"] = ((TextBox)gvRow.FindControl("TxtInPrice")).Text; dr["taxID1"] = ((TextBox)gvRow.FindControl("txttaxid")).Text; dr["TT1"] = ((Label)gvRow.FindControl("LblInvocietotalPrice")).Text; dt.Rows.Add(dr); } dt.Rows[e.RowIndex].Delete(); GvwPurchaseInvocie.DataSource = dt; GvwPurchaseInvocie.DataBind(); this.GvwPurchaseInvocie.Columns[2].Visible = false; this.GvwPurchaseInvocie.Columns[4].Visible = false; this.GvwPurchaseInvocie.Columns[0].Visible = false; double tt = 0.00; foreach (GridViewRow gvRow in GvwPurchaseInvocie.Rows) { DataRow dr = dt.NewRow(); dr["category"] = ((Label)gvRow.FindControl("lblCatagory")).Text; dr["catagoryid"] = ((HiddenField)gvRow.FindControl("HidCatagory0")).Value; dr["Product"] = ((Label)gvRow.FindControl("LblProduct")).Text; dr["productid"] = ((HiddenField)gvRow.FindControl("HidProduct0")).Value; dr["PO_Quantity"] = ((Label)gvRow.FindControl("LblQuantity")).Text; dr["PO_UnitPrice"] = ((Label)gvRow.FindControl("LblPrice")).Text; dr["taxID"] = ((Label)gvRow.FindControl("Lbltaxid")).Text; dr["TT"] = ((Label)gvRow.FindControl("LbltotalAmount")).Text; dr["PO_Quantity1"] = ((TextBox)gvRow.FindControl("TxtInQuantity")).Text; dr["PO_UnitPrice1"] = ((TextBox)gvRow.FindControl("TxtInPrice")).Text; dr["taxID1"] = ((TextBox)gvRow.FindControl("txttaxid")).Text; dr["TT1"] = ((Label)gvRow.FindControl("LblInvocietotalPrice")).Text; tt = Convert.ToDouble(((Label)gvRow.FindControl("LblInvocietotalPrice")).Text) + tt; } Txt_SubTotal.Text = tt.ToString(); }