public void PopulateData()
{
int iCurrencyTypeID = 0;
Invoice.Invoice objInvoice = new Invoice.Invoice();
Company objCompany = new Company();
grdInvoiceDetails.DataSource = rsInvoiceDetail.ParentTable;
grdInvoiceDetails.DataBind();
if (rsInvoiceHead["InvoiceNo"] != DBNull.Value)
{
strInvoiceNo = rsInvoiceHead["InvoiceNo"].ToString().Trim();
}
if (rsInvoiceHead["InvoiceDate"] != DBNull.Value)
{
strInvoiceDate = Convert.ToDateTime(rsInvoiceHead["InvoiceDate"]).ToString("dd/MM/yyyy");
}
if (rsInvoiceHead["SellerVATNo"] != DBNull.Value)
{
strSellerVatRegNo = rsInvoiceHead["SellerVATNo"].ToString().Trim();
}
if (rsInvoiceHead["New_TaxCountryNumber"] != DBNull.Value)
{
strCountryTaxNo = rsInvoiceHead["New_TaxCountryNumber"].ToString().Trim();
}
strTradersReference = objCompany.GetTradersReference(Convert.ToInt32(rsInvoiceHead["SupplierCompanyID"]));
if (rsInvoiceHead["CurrencyTypeID"] != DBNull.Value)
{
iCurrencyTypeID = Convert.ToInt32(rsInvoiceHead["CurrencyTypeID"]);
strCurrency = objInvoice.GetCurrencyName(Convert.ToInt32(rsInvoiceHead["CurrencyTypeID"]));
}
#region Manipulating VAT IN GBP amount
if (Session["StrVATAmt_CN"] != null)
{
if (Utility.IsNumeric(Session["StrVATAmt_CN"].ToString().Trim()))
{
strVatInGBP = Convert.ToString(Math.Round(Convert.ToDouble(Session["StrVATAmt_CN"].ToString().Trim()), 2));
}
}
else
{
Invoice.Invoice oInvoice = new Invoice.Invoice();
Double dGBPEquivalentAmount = 0;
dGBPEquivalentAmount = oInvoice.GetGBPEquivalentAmount(invoiceID);
if (dGBPEquivalentAmount != 0)
{
strVatInGBP = dGBPEquivalentAmount.ToString();
if (Utility.IsNumeric(strVatInGBP))
{
strVatInGBP = Convert.ToString(Math.Round(Convert.ToDouble(strVatInGBP), 2));
}
}
oInvoice = null;
}
#endregion
}