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();
}
