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