private void UpdateRecord()
{
dbo_DimResellerClass oclsdbo_DimReseller = new dbo_DimResellerClass();
dbo_DimResellerClass clsdbo_DimReseller = new dbo_DimResellerClass();
oclsdbo_DimReseller.ResellerKey = System.Convert.ToInt32(Session["ResellerKey"]);
oclsdbo_DimReseller = dbo_DimResellerDataClass.Select_Record(oclsdbo_DimReseller);
if (VerifyData() == true)
{
SetData(clsdbo_DimReseller);
bool bSucess = false;
bSucess = dbo_DimResellerDataClass.Update(oclsdbo_DimReseller, clsdbo_DimReseller);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_DimReseller");
LoadGriddbo_DimReseller();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Dim Reseller ");
}
}
}
private void Edit()
{
try {
dbo_DimResellerClass clsdbo_DimReseller = new dbo_DimResellerClass();
Label lblResellerKey = (Label)grddbo_DimReseller.Rows[grddbo_DimReseller.EditIndex].FindControl("lblResellerKey");
clsdbo_DimReseller.ResellerKey = System.Convert.ToInt32(lblResellerKey.Text);
clsdbo_DimReseller = dbo_DimResellerDataClass.Select_Record(clsdbo_DimReseller);
Session["GeographyKey_SelectedValue"] = clsdbo_DimReseller.GeographyKey;
LoadGriddbo_DimReseller();
} catch {
}
}
private void DeleteRecord()
{
dbo_DimResellerClass clsdbo_DimReseller = new dbo_DimResellerClass();
Label lblResellerKey = (Label)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblResellerKey");
clsdbo_DimReseller.ResellerKey = System.Convert.ToInt32(lblResellerKey.Text);
clsdbo_DimReseller = dbo_DimResellerDataClass.Select_Record(clsdbo_DimReseller);
bool bSucess = false;
bSucess = dbo_DimResellerDataClass.Delete(clsdbo_DimReseller);
if (bSucess == true)
{
Session.Remove("dvdbo_DimReseller");
LoadGriddbo_DimReseller();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Dim Reseller ");
}
}
private void InsertRecord()
{
dbo_DimResellerClass clsdbo_DimReseller = new dbo_DimResellerClass();
if (VerifyData() == true)
{
SetData(clsdbo_DimReseller);
bool bSucess = false;
bSucess = dbo_DimResellerDataClass.Add(clsdbo_DimReseller);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_DimReseller");
LoadGriddbo_DimReseller();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Dim Reseller ");
}
}
}
private void UpdateRecord()
{
try {
TextBox txtResellerKey = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtResellerKey");
DropDownList txtGeographyKey = (DropDownList)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtGeographyKey");
TextBox txtResellerAlternateKey = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtResellerAlternateKey");
TextBox txtPhone = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtPhone");
TextBox txtBusinessType = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtBusinessType");
TextBox txtResellerName = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtResellerName");
TextBox txtNumberEmployees = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtNumberEmployees");
TextBox txtOrderFrequency = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtOrderFrequency");
TextBox txtOrderMonth = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtOrderMonth");
TextBox txtFirstOrderYear = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFirstOrderYear");
TextBox txtLastOrderYear = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtLastOrderYear");
TextBox txtProductLine = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtProductLine");
TextBox txtAddressLine1 = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtAddressLine1");
TextBox txtAddressLine2 = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtAddressLine2");
TextBox txtAnnualSales = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtAnnualSales");
TextBox txtBankName = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtBankName");
TextBox txtMinPaymentType = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtMinPaymentType");
TextBox txtMinPaymentAmount = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtMinPaymentAmount");
TextBox txtAnnualRevenue = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtAnnualRevenue");
TextBox txtYearOpened = (TextBox)grddbo_DimReseller.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtYearOpened");
dbo_DimResellerClass oclsdbo_DimReseller = new dbo_DimResellerClass();
dbo_DimResellerClass clsdbo_DimReseller = new dbo_DimResellerClass();
oclsdbo_DimReseller.ResellerKey = System.Convert.ToInt32(txtResellerKey.Text);
oclsdbo_DimReseller = dbo_DimResellerDataClass.Select_Record(oclsdbo_DimReseller);
if (VerifyData() == true)
{
if (string.IsNullOrEmpty(txtGeographyKey.SelectedValue))
{
clsdbo_DimReseller.GeographyKey = null;
}
else
{
clsdbo_DimReseller.GeographyKey = System.Convert.ToInt32(txtGeographyKey.SelectedValue);
}
if (string.IsNullOrEmpty(txtResellerAlternateKey.Text))
{
clsdbo_DimReseller.ResellerAlternateKey = null;
}
else
{
clsdbo_DimReseller.ResellerAlternateKey = txtResellerAlternateKey.Text;
}
if (string.IsNullOrEmpty(txtPhone.Text))
{
clsdbo_DimReseller.Phone = null;
}
else
{
clsdbo_DimReseller.Phone = txtPhone.Text;
}
clsdbo_DimReseller.BusinessType = System.Convert.ToString(txtBusinessType.Text);
clsdbo_DimReseller.ResellerName = System.Convert.ToString(txtResellerName.Text);
if (string.IsNullOrEmpty(txtNumberEmployees.Text))
{
clsdbo_DimReseller.NumberEmployees = null;
}
else
{
clsdbo_DimReseller.NumberEmployees = System.Convert.ToInt32(txtNumberEmployees.Text);
}
if (string.IsNullOrEmpty(txtOrderFrequency.Text))
{
clsdbo_DimReseller.OrderFrequency = null;
}
else
{
clsdbo_DimReseller.OrderFrequency = txtOrderFrequency.Text;
}
if (string.IsNullOrEmpty(txtOrderMonth.Text))
{
clsdbo_DimReseller.OrderMonth = null;
}
else
{
clsdbo_DimReseller.OrderMonth = System.Convert.ToByte(txtOrderMonth.Text);
}
if (string.IsNullOrEmpty(txtFirstOrderYear.Text))
{
clsdbo_DimReseller.FirstOrderYear = null;
}
else
{
clsdbo_DimReseller.FirstOrderYear = System.Convert.ToInt32(txtFirstOrderYear.Text);
}
if (string.IsNullOrEmpty(txtLastOrderYear.Text))
{
clsdbo_DimReseller.LastOrderYear = null;
}
else
{
clsdbo_DimReseller.LastOrderYear = System.Convert.ToInt32(txtLastOrderYear.Text);
}
if (string.IsNullOrEmpty(txtProductLine.Text))
{
clsdbo_DimReseller.ProductLine = null;
}
else
{
clsdbo_DimReseller.ProductLine = txtProductLine.Text;
}
if (string.IsNullOrEmpty(txtAddressLine1.Text))
{
clsdbo_DimReseller.AddressLine1 = null;
}
else
{
clsdbo_DimReseller.AddressLine1 = txtAddressLine1.Text;
}
if (string.IsNullOrEmpty(txtAddressLine2.Text))
{
clsdbo_DimReseller.AddressLine2 = null;
}
else
{
clsdbo_DimReseller.AddressLine2 = txtAddressLine2.Text;
}
if (string.IsNullOrEmpty(txtAnnualSales.Text))
{
clsdbo_DimReseller.AnnualSales = null;
}
else
{
clsdbo_DimReseller.AnnualSales = System.Convert.ToDecimal(txtAnnualSales.Text);
}
if (string.IsNullOrEmpty(txtBankName.Text))
{
clsdbo_DimReseller.BankName = null;
}
else
{
clsdbo_DimReseller.BankName = txtBankName.Text;
}
if (string.IsNullOrEmpty(txtMinPaymentType.Text))
{
clsdbo_DimReseller.MinPaymentType = null;
}
else
{
clsdbo_DimReseller.MinPaymentType = System.Convert.ToByte(txtMinPaymentType.Text);
}
if (string.IsNullOrEmpty(txtMinPaymentAmount.Text))
{
clsdbo_DimReseller.MinPaymentAmount = null;
}
else
{
clsdbo_DimReseller.MinPaymentAmount = System.Convert.ToDecimal(txtMinPaymentAmount.Text);
}
if (string.IsNullOrEmpty(txtAnnualRevenue.Text))
{
clsdbo_DimReseller.AnnualRevenue = null;
}
else
{
clsdbo_DimReseller.AnnualRevenue = System.Convert.ToDecimal(txtAnnualRevenue.Text);
}
if (string.IsNullOrEmpty(txtYearOpened.Text))
{
clsdbo_DimReseller.YearOpened = null;
}
else
{
clsdbo_DimReseller.YearOpened = System.Convert.ToInt32(txtYearOpened.Text);
}
bool bSucess = false;
bSucess = dbo_DimResellerDataClass.Update(oclsdbo_DimReseller, clsdbo_DimReseller);
if (bSucess == true)
{
Session.Remove("dvdbo_DimReseller");
grddbo_DimReseller.EditIndex = -1;
LoadGriddbo_DimReseller();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Dim Reseller ");
}
}
} catch {
}
}
private void InsertRecord()
{
try {
DropDownList txtNewGeographyKey = (DropDownList)grddbo_DimReseller.FooterRow.FindControl("txtNewGeographyKey");
TextBox txtNewResellerAlternateKey = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewResellerAlternateKey");
TextBox txtNewPhone = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewPhone");
TextBox txtNewBusinessType = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewBusinessType");
TextBox txtNewResellerName = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewResellerName");
TextBox txtNewNumberEmployees = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewNumberEmployees");
TextBox txtNewOrderFrequency = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewOrderFrequency");
TextBox txtNewOrderMonth = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewOrderMonth");
TextBox txtNewFirstOrderYear = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewFirstOrderYear");
TextBox txtNewLastOrderYear = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewLastOrderYear");
TextBox txtNewProductLine = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewProductLine");
TextBox txtNewAddressLine1 = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewAddressLine1");
TextBox txtNewAddressLine2 = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewAddressLine2");
TextBox txtNewAnnualSales = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewAnnualSales");
TextBox txtNewBankName = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewBankName");
TextBox txtNewMinPaymentType = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewMinPaymentType");
TextBox txtNewMinPaymentAmount = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewMinPaymentAmount");
TextBox txtNewAnnualRevenue = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewAnnualRevenue");
TextBox txtNewYearOpened = (TextBox)grddbo_DimReseller.FooterRow.FindControl("txtNewYearOpened");
dbo_DimResellerClass clsdbo_DimReseller = new dbo_DimResellerClass();
if (VerifyDataNew() == true)
{
if (string.IsNullOrEmpty(txtNewGeographyKey.SelectedValue))
{
clsdbo_DimReseller.GeographyKey = null;
}
else
{
clsdbo_DimReseller.GeographyKey = System.Convert.ToInt32(txtNewGeographyKey.SelectedValue);
}
if (string.IsNullOrEmpty(txtNewResellerAlternateKey.Text))
{
clsdbo_DimReseller.ResellerAlternateKey = null;
}
else
{
clsdbo_DimReseller.ResellerAlternateKey = txtNewResellerAlternateKey.Text;
}
if (string.IsNullOrEmpty(txtNewPhone.Text))
{
clsdbo_DimReseller.Phone = null;
}
else
{
clsdbo_DimReseller.Phone = txtNewPhone.Text;
}
clsdbo_DimReseller.BusinessType = System.Convert.ToString(txtNewBusinessType.Text);
clsdbo_DimReseller.ResellerName = System.Convert.ToString(txtNewResellerName.Text);
if (string.IsNullOrEmpty(txtNewNumberEmployees.Text))
{
clsdbo_DimReseller.NumberEmployees = null;
}
else
{
clsdbo_DimReseller.NumberEmployees = System.Convert.ToInt32(txtNewNumberEmployees.Text);
}
if (string.IsNullOrEmpty(txtNewOrderFrequency.Text))
{
clsdbo_DimReseller.OrderFrequency = null;
}
else
{
clsdbo_DimReseller.OrderFrequency = txtNewOrderFrequency.Text;
}
if (string.IsNullOrEmpty(txtNewOrderMonth.Text))
{
clsdbo_DimReseller.OrderMonth = null;
}
else
{
clsdbo_DimReseller.OrderMonth = System.Convert.ToByte(txtNewOrderMonth.Text);
}
if (string.IsNullOrEmpty(txtNewFirstOrderYear.Text))
{
clsdbo_DimReseller.FirstOrderYear = null;
}
else
{
clsdbo_DimReseller.FirstOrderYear = System.Convert.ToInt32(txtNewFirstOrderYear.Text);
}
if (string.IsNullOrEmpty(txtNewLastOrderYear.Text))
{
clsdbo_DimReseller.LastOrderYear = null;
}
else
{
clsdbo_DimReseller.LastOrderYear = System.Convert.ToInt32(txtNewLastOrderYear.Text);
}
if (string.IsNullOrEmpty(txtNewProductLine.Text))
{
clsdbo_DimReseller.ProductLine = null;
}
else
{
clsdbo_DimReseller.ProductLine = txtNewProductLine.Text;
}
if (string.IsNullOrEmpty(txtNewAddressLine1.Text))
{
clsdbo_DimReseller.AddressLine1 = null;
}
else
{
clsdbo_DimReseller.AddressLine1 = txtNewAddressLine1.Text;
}
if (string.IsNullOrEmpty(txtNewAddressLine2.Text))
{
clsdbo_DimReseller.AddressLine2 = null;
}
else
{
clsdbo_DimReseller.AddressLine2 = txtNewAddressLine2.Text;
}
if (string.IsNullOrEmpty(txtNewAnnualSales.Text))
{
clsdbo_DimReseller.AnnualSales = null;
}
else
{
clsdbo_DimReseller.AnnualSales = System.Convert.ToDecimal(txtNewAnnualSales.Text);
}
if (string.IsNullOrEmpty(txtNewBankName.Text))
{
clsdbo_DimReseller.BankName = null;
}
else
{
clsdbo_DimReseller.BankName = txtNewBankName.Text;
}
if (string.IsNullOrEmpty(txtNewMinPaymentType.Text))
{
clsdbo_DimReseller.MinPaymentType = null;
}
else
{
clsdbo_DimReseller.MinPaymentType = System.Convert.ToByte(txtNewMinPaymentType.Text);
}
if (string.IsNullOrEmpty(txtNewMinPaymentAmount.Text))
{
clsdbo_DimReseller.MinPaymentAmount = null;
}
else
{
clsdbo_DimReseller.MinPaymentAmount = System.Convert.ToDecimal(txtNewMinPaymentAmount.Text);
}
if (string.IsNullOrEmpty(txtNewAnnualRevenue.Text))
{
clsdbo_DimReseller.AnnualRevenue = null;
}
else
{
clsdbo_DimReseller.AnnualRevenue = System.Convert.ToDecimal(txtNewAnnualRevenue.Text);
}
if (string.IsNullOrEmpty(txtNewYearOpened.Text))
{
clsdbo_DimReseller.YearOpened = null;
}
else
{
clsdbo_DimReseller.YearOpened = System.Convert.ToInt32(txtNewYearOpened.Text);
}
bool bSucess = false;
bSucess = dbo_DimResellerDataClass.Add(clsdbo_DimReseller);
if (bSucess == true)
{
Session.Remove("dvdbo_DimReseller");
LoadGriddbo_DimReseller();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Dim Reseller ");
}
}
} catch {
}
}
private void SetData(dbo_DimResellerClass clsdbo_DimReseller)
{
if (string.IsNullOrEmpty(txtGeographyKey.SelectedValue))
{
clsdbo_DimReseller.GeographyKey = null;
}
else
{
clsdbo_DimReseller.GeographyKey = System.Convert.ToInt32(txtGeographyKey.SelectedValue);
}
if (string.IsNullOrEmpty(txtResellerAlternateKey.Text))
{
clsdbo_DimReseller.ResellerAlternateKey = null;
}
else
{
clsdbo_DimReseller.ResellerAlternateKey = txtResellerAlternateKey.Text;
}
if (string.IsNullOrEmpty(txtPhone.Text))
{
clsdbo_DimReseller.Phone = null;
}
else
{
clsdbo_DimReseller.Phone = txtPhone.Text;
}
clsdbo_DimReseller.BusinessType = System.Convert.ToString(txtBusinessType.Text);
clsdbo_DimReseller.ResellerName = System.Convert.ToString(txtResellerName.Text);
if (string.IsNullOrEmpty(txtNumberEmployees.Text))
{
clsdbo_DimReseller.NumberEmployees = null;
}
else
{
clsdbo_DimReseller.NumberEmployees = System.Convert.ToInt32(txtNumberEmployees.Text);
}
if (string.IsNullOrEmpty(txtOrderFrequency.Text))
{
clsdbo_DimReseller.OrderFrequency = null;
}
else
{
clsdbo_DimReseller.OrderFrequency = txtOrderFrequency.Text;
}
if (string.IsNullOrEmpty(txtOrderMonth.Text))
{
clsdbo_DimReseller.OrderMonth = null;
}
else
{
clsdbo_DimReseller.OrderMonth = System.Convert.ToByte(txtOrderMonth.Text);
}
if (string.IsNullOrEmpty(txtFirstOrderYear.Text))
{
clsdbo_DimReseller.FirstOrderYear = null;
}
else
{
clsdbo_DimReseller.FirstOrderYear = System.Convert.ToInt32(txtFirstOrderYear.Text);
}
if (string.IsNullOrEmpty(txtLastOrderYear.Text))
{
clsdbo_DimReseller.LastOrderYear = null;
}
else
{
clsdbo_DimReseller.LastOrderYear = System.Convert.ToInt32(txtLastOrderYear.Text);
}
if (string.IsNullOrEmpty(txtProductLine.Text))
{
clsdbo_DimReseller.ProductLine = null;
}
else
{
clsdbo_DimReseller.ProductLine = txtProductLine.Text;
}
if (string.IsNullOrEmpty(txtAddressLine1.Text))
{
clsdbo_DimReseller.AddressLine1 = null;
}
else
{
clsdbo_DimReseller.AddressLine1 = txtAddressLine1.Text;
}
if (string.IsNullOrEmpty(txtAddressLine2.Text))
{
clsdbo_DimReseller.AddressLine2 = null;
}
else
{
clsdbo_DimReseller.AddressLine2 = txtAddressLine2.Text;
}
if (string.IsNullOrEmpty(txtAnnualSales.Text))
{
clsdbo_DimReseller.AnnualSales = null;
}
else
{
clsdbo_DimReseller.AnnualSales = System.Convert.ToDecimal(txtAnnualSales.Text);
}
if (string.IsNullOrEmpty(txtBankName.Text))
{
clsdbo_DimReseller.BankName = null;
}
else
{
clsdbo_DimReseller.BankName = txtBankName.Text;
}
if (string.IsNullOrEmpty(txtMinPaymentType.Text))
{
clsdbo_DimReseller.MinPaymentType = null;
}
else
{
clsdbo_DimReseller.MinPaymentType = System.Convert.ToByte(txtMinPaymentType.Text);
}
if (string.IsNullOrEmpty(txtMinPaymentAmount.Text))
{
clsdbo_DimReseller.MinPaymentAmount = null;
}
else
{
clsdbo_DimReseller.MinPaymentAmount = System.Convert.ToDecimal(txtMinPaymentAmount.Text);
}
if (string.IsNullOrEmpty(txtAnnualRevenue.Text))
{
clsdbo_DimReseller.AnnualRevenue = null;
}
else
{
clsdbo_DimReseller.AnnualRevenue = System.Convert.ToDecimal(txtAnnualRevenue.Text);
}
if (string.IsNullOrEmpty(txtYearOpened.Text))
{
clsdbo_DimReseller.YearOpened = null;
}
else
{
clsdbo_DimReseller.YearOpened = System.Convert.ToInt32(txtYearOpened.Text);
}
}
private void GetData()
{
ClearRecord();
dbo_DimResellerClass clsdbo_DimReseller = new dbo_DimResellerClass();
clsdbo_DimReseller.ResellerKey = System.Convert.ToInt32(Session["ResellerKey"]);
clsdbo_DimReseller = dbo_DimResellerDataClass.Select_Record(clsdbo_DimReseller);
if ((clsdbo_DimReseller != null))
{
try {
txtResellerKey.Text = System.Convert.ToString(clsdbo_DimReseller.ResellerKey);
if (clsdbo_DimReseller.GeographyKey == null)
{
txtGeographyKey.SelectedValue = default(string);
}
else
{
txtGeographyKey.SelectedValue = System.Convert.ToString(clsdbo_DimReseller.GeographyKey);
}
if (clsdbo_DimReseller.ResellerAlternateKey == null)
{
txtResellerAlternateKey.Text = default(string);
}
else
{
txtResellerAlternateKey.Text = System.Convert.ToString(clsdbo_DimReseller.ResellerAlternateKey);
}
if (clsdbo_DimReseller.Phone == null)
{
txtPhone.Text = default(string);
}
else
{
txtPhone.Text = System.Convert.ToString(clsdbo_DimReseller.Phone);
}
txtBusinessType.Text = System.Convert.ToString(clsdbo_DimReseller.BusinessType);
txtResellerName.Text = System.Convert.ToString(clsdbo_DimReseller.ResellerName);
if (clsdbo_DimReseller.NumberEmployees == null)
{
txtNumberEmployees.Text = default(string);
}
else
{
txtNumberEmployees.Text = System.Convert.ToString(clsdbo_DimReseller.NumberEmployees);
}
if (clsdbo_DimReseller.OrderFrequency == null)
{
txtOrderFrequency.Text = default(string);
}
else
{
txtOrderFrequency.Text = System.Convert.ToString(clsdbo_DimReseller.OrderFrequency);
}
if (clsdbo_DimReseller.OrderMonth == null)
{
txtOrderMonth.Text = default(string);
}
else
{
txtOrderMonth.Text = System.Convert.ToString(clsdbo_DimReseller.OrderMonth);
}
if (clsdbo_DimReseller.FirstOrderYear == null)
{
txtFirstOrderYear.Text = default(string);
}
else
{
txtFirstOrderYear.Text = System.Convert.ToString(clsdbo_DimReseller.FirstOrderYear);
}
if (clsdbo_DimReseller.LastOrderYear == null)
{
txtLastOrderYear.Text = default(string);
}
else
{
txtLastOrderYear.Text = System.Convert.ToString(clsdbo_DimReseller.LastOrderYear);
}
if (clsdbo_DimReseller.ProductLine == null)
{
txtProductLine.Text = default(string);
}
else
{
txtProductLine.Text = System.Convert.ToString(clsdbo_DimReseller.ProductLine);
}
if (clsdbo_DimReseller.AddressLine1 == null)
{
txtAddressLine1.Text = default(string);
}
else
{
txtAddressLine1.Text = System.Convert.ToString(clsdbo_DimReseller.AddressLine1);
}
if (clsdbo_DimReseller.AddressLine2 == null)
{
txtAddressLine2.Text = default(string);
}
else
{
txtAddressLine2.Text = System.Convert.ToString(clsdbo_DimReseller.AddressLine2);
}
if (clsdbo_DimReseller.AnnualSales == null)
{
txtAnnualSales.Text = default(string);
}
else
{
txtAnnualSales.Text = System.Convert.ToString(clsdbo_DimReseller.AnnualSales);
}
if (clsdbo_DimReseller.BankName == null)
{
txtBankName.Text = default(string);
}
else
{
txtBankName.Text = System.Convert.ToString(clsdbo_DimReseller.BankName);
}
if (clsdbo_DimReseller.MinPaymentType == null)
{
txtMinPaymentType.Text = default(string);
}
else
{
txtMinPaymentType.Text = System.Convert.ToString(clsdbo_DimReseller.MinPaymentType);
}
if (clsdbo_DimReseller.MinPaymentAmount == null)
{
txtMinPaymentAmount.Text = default(string);
}
else
{
txtMinPaymentAmount.Text = System.Convert.ToString(clsdbo_DimReseller.MinPaymentAmount);
}
if (clsdbo_DimReseller.AnnualRevenue == null)
{
txtAnnualRevenue.Text = default(string);
}
else
{
txtAnnualRevenue.Text = System.Convert.ToString(clsdbo_DimReseller.AnnualRevenue);
}
if (clsdbo_DimReseller.YearOpened == null)
{
txtYearOpened.Text = default(string);
}
else
{
txtYearOpened.Text = System.Convert.ToString(clsdbo_DimReseller.YearOpened);
}
}
catch (Exception ex)
{
ec.ShowMessage(ex.Message, " Dbo. Dim Reseller ");
}
}
}
