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