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