public static DatabaseViewModel GetDataFromDatabase() { DatabaseViewModel databaseViewModel = new DatabaseViewModel(); databaseViewModel.ContactList = DALHelpers.GetContacts(); databaseViewModel.DealerContactList = DALHelpers.GetDealerContacts(); databaseViewModel.MainDealerList = DALHelpers.GetDealers(); databaseViewModel.DealerBranchesList = DALHelpers.GetDealerBranchs(); databaseViewModel.ApplicationsList = DALHelpers.GetApplications(); databaseViewModel.AppLinksList = DALHelpers.GetAppLinks(); databaseViewModel.CountryList = DALHelpers.GetCountries(); return(databaseViewModel); }
private void frmContacts_Load(object sender, EventArgs e) { try { #region "Get App Version" //AppVersion appVersion = new AppVersion(); //appVersion = DALHelpers.GetVersion(); //string myVersion = Validation.AssemblyVersion; ////int result = string.Compare(myVersion, appVersion.LatestVersion.ToString()); //if (myVersion.ToString() != appVersion.LatestVersion.ToString()) //{ // System.Diagnostics.Process.Start(@"\\vcn.ds.volvo.net\it-cta\ITPROJ02\002378\DESENV\DBS\AUTOMATOR\LINKS FORM\release\setup.exe"); // notifyIcon.Visible = false; // Application.Exit(); //} #endregion #region "Loading Contacts" dtContacts.Columns.Add("ContactId", typeof(string)); dtContacts.Columns.Add("Name", typeof(string)); dtContacts.Columns.Add("Phone", typeof(string)); dtContacts.Columns.Add("CellPhone", typeof(string)); dtContacts.Columns.Add("TeamId", typeof(string)); dtContacts.Columns.Add("TeamName", typeof(string)); dtContacts.Columns.Add("Computer Name", typeof(string)); dtContacts.Columns.Add("StringToSearch", typeof(string)); contactList = DALHelpers.GetContacts(); loadContacts(); #endregion #region "Loading DealerContacts" dtDealerContacts.Columns.Add("DealerContactId", typeof(string)); dtDealerContacts.Columns.Add("MainDealerId", typeof(string)); dtDealerContacts.Columns.Add("Name", typeof(string)); dtDealerContacts.Columns.Add("Phone", typeof(string)); dtDealerContacts.Columns.Add("CellPhone", typeof(string)); dtDealerContacts.Columns.Add("Email", typeof(string)); dtDealerContacts.Columns.Add("DealerName", typeof(string)); dtDealerContacts.Columns.Add("Department", typeof(string)); dtDealerContacts.Columns.Add("CountryId", typeof(string)); dtDealerContacts.Columns.Add("CountryName", typeof(string)); dtDealerContacts.Columns.Add("StringToSearch", typeof(string)); dealerContactList = DALHelpers.GetDealerContacts(); //loadDealerContacts(); #endregion #region "Loading Dealers" dtDealers.Columns.Add("DealerId", typeof(string)); dtDealers.Columns.Add("Dealer", typeof(string)); dtDealers.Columns.Add("Branch", typeof(string)); dtDealers.Columns.Add("Phone Number", typeof(string)); dtDealers.Columns.Add("CTDI", typeof(string)); dtDealers.Columns.Add("BaldoPartner", typeof(string)); dtDealers.Columns.Add("CountryId", typeof(string)); dtDealers.Columns.Add("Country", typeof(string)); dtDealers.Columns.Add("CNPJ", typeof(string)); dtDealers.Columns.Add("IsActive", typeof(string)); dtDealers.Columns.Add("MainDealerId", typeof(string)); dtDealers.Columns.Add("StringToSearch", typeof(string)); dtDealers.Columns.Add("Sort", typeof(string)); dealerList = DALHelpers.GetDealers(); loadDealers(); #endregion #region "Loading AppLinks TreeView" ApplicationsList = DALHelpers.GetApplications(); AppLinksFromDatabase = DALHelpers.GetAppLinks(); loadTreeview(false, null); #endregion #region "MAIN WINDOW POSITION" left = this.DesktopLocation.X; top = this.DesktopLocation.Y; width = this.Width; height = this.Height; #endregion } catch (Exception ex) { MessageBox.Show("Error : " + ex.Message); } }