public string EditInvoice(string _invId) { invObj = new InvoiceClass(); invObj.invId = Convert.ToInt32(_invId); DataSet dsInv = invObj.GetInvoiceDetailsByInvId(); if (dsInv.Tables[0].Rows.Count > 0) { dsInv.Tables[1].Columns["prodDescription"].ColumnName = "product"; dsInv.Tables[1].Columns["prodPrice"].ColumnName = "unitPrice"; dsInv.Tables[1].Columns.Add("arrId"); string json = JsonConvert.SerializeObject(dsInv, Newtonsoft.Json.Formatting.Indented); return(json); } else { return(""); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["invId"])) { invObj = new InvoiceClass(); invObj.invId = Convert.ToInt32(Request.QueryString["invId"]); DataSet dsInv = invObj.GetInvoiceDetailsByInvId(); if (dsInv.Tables[0].Rows.Count > 0) { lblCustomerName.Text = dsInv.Tables[0].Rows[0]["custName"].ToString(); lblInvoiceNo.Text = dsInv.Tables[0].Rows[0]["invoiceNo"].ToString(); lblInvoiceDate.Text = Convert.ToDateTime(dsInv.Tables[0].Rows[0]["invoiceDate"].ToString()).ToString("dd-MM-yyyy"); rptInvoiceDetails.DataSource = dsInv.Tables[1]; rptInvoiceDetails.DataBind(); lblVat1.Text = lblVat2.Text = dsInv.Tables[2].Rows[0]["vatPer"].ToString(); lblAmtExVatSR.Text = dsInv.Tables[2].Rows[0]["totalExVat"].ToString().Split('.')[0]; lblAmtExVatH.Text = dsInv.Tables[2].Rows[0]["totalExVat"].ToString().Split('.')[1]; lblVatAmtSR.Text = dsInv.Tables[2].Rows[0]["vatAmt"].ToString().Split('.')[0]; lblVatAmtH.Text = dsInv.Tables[2].Rows[0]["vatAmt"].ToString().Split('.')[1]; lblTotalInWords.Text = ConvertNumbertoWords(Convert.ToInt32(dsInv.Tables[2].Rows[0]["totalInTax"])); lblAmtInVatSR.Text = dsInv.Tables[2].Rows[0]["totalInTax"].ToString().Split('.')[0]; lblAmtInVatH.Text = dsInv.Tables[2].Rows[0]["totalInTax"].ToString().Split('.')[1]; lblTermsAndConditions.Text = dsInv.Tables[2].Rows[0]["termsAndContions"].ToString(); btnEdit.CommandArgument = Request.QueryString["invId"]; } } } } catch (Exception ex) { ex.Message.ToString(); } }