private void ShowData()
{
try
{
DataSet ds = vendor.GetVendorData(VendorId);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
txtVendorCode.Text = item["VendorCode"].ToString();
txtName.Text = item["VendorName"].ToString();
txtPhoneNumber.Text = item["PhoneNumber"].ToString();
txtFax.Text = item["Fax"].ToString();
txtContactPerson.Text = item["ContactPerson"].ToString();
txtCity.Text = item["City"].ToString();
txtAdress.Text = item["Address"].ToString();
txtEmail.Text = item["Email"].ToString();
txtVat.Text = item["VAT"].ToString();
if (item["VendorTypeId"].ToString() != "0")
{
lstVendorType.EditValue = Convert.ToInt32(item["VendorTypeId"].ToString());
}
if (item["CountryId"].ToString() != "0")
{
lstCountry.EditValue = Convert.ToInt32(item["CountryId"].ToString());
}
txtCRNo.Text = item["CrNo"].ToString();
txtGosiNo.Text = item["GosiNo"].ToString();
txtZakaat.Text = item["Zakaat"].ToString();
txtChamberNo.Text = item["ChamberNo"].ToString();
txtVATExpiry.Text = item["VATExpiry"].ToString() != "" ? Convert.ToDateTime(item["VATExpiry"].ToString()).ToString("dd/MMM/yyyy"):"";
txtChamberExpiry.Text = item["ChamberNoExpiry"].ToString() != "" ? Convert.ToDateTime(item["ChamberNoExpiry"].ToString()).ToString("dd/MMM/yyyy"):"";
txtCRExpiry.Text = item["CrNoExpiry"].ToString() != "" ? Convert.ToDateTime(item["CrNoExpiry"].ToString()).ToString("dd/MMM/yyyy") : "";
txtGosiExpiry.Text = item["GosiNoExpiry"].ToString() != "" ? Convert.ToDateTime(item["GosiNoExpiry"].ToString()).ToString("dd/MMM/yyyy") : "";
txtZakaatExpiry.Text = item["ZakaatExpiry"].ToString() != "" ? Convert.ToDateTime(item["ZakaatExpiry"].ToString()).ToString("dd/MMM/yyyy") : "";
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.InnerException != null ? ex.InnerException.Message : ex.Message);
}
}