private void btnSave_Click(object sender, EventArgs e)
{
hasTheSaveButtonPressed = true;
bool ok;
UsernameToBeReturned = txtUsername.Text;
if (!string.IsNullOrEmpty(txtPassword.Text) || txtPassword.Text.Length > 2)
{
Credential credential = new Credential();
credential.CredentialId = GlobalCredentialId;
credential.CredentialDescription = txtDescription.Text;
credential.Username = txtUsername.Text;
credential.Password = txtPassword.Text;
//UPDATE
ok = DALHelpers.UpdateCredential(credential);
if (ok == false)
{
MessageBox.Show("Error: An error has ocurred when trying to update the Password!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
this.Close();
}
}
private void btnDeleteDealer_Click(object sender, EventArgs e)
{
if (dgvDealer.Rows.Count > 0)
{
DealerBranch dealerBranch = new DealerBranch();
dealerBranch.DealerBranchId = Convert.ToInt32(dgvDealer.CurrentRow.Cells[0].Value.ToString());
dealerBranch.CTDI = Convert.ToInt32(dgvDealer.CurrentRow.Cells[1].Value.ToString());
dealerBranch.DealerName = dgvDealer.CurrentRow.Cells[2].Value.ToString();
dealerBranch.BranchName = dgvDealer.CurrentRow.Cells[3].Value.ToString();
dealerBranch.PhoneNumber = dgvDealer.CurrentRow.Cells[4].Value.ToString();
dealerBranch.BaldoPartner = dgvDealer.CurrentRow.Cells[5].Value.ToString();
dealerBranch.CountryId = Convert.ToInt32(dgvDealer.CurrentRow.Cells[6].Value.ToString());
dealerBranch.CountryName = dgvDealer.CurrentRow.Cells[7].Value.ToString();
dealerBranch.DealerId = Convert.ToInt32(dgvDealer.CurrentRow.Cells[8].Value.ToString());
if (MessageBox.Show("Are you sure you want to delete the Dealer Branch: " + dealerBranch.BranchName + "?", "Delete Dealer Branch", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
DALHelpers.DeleteDealerBranch(dealerBranch.DealerBranchId);
ActivityLog.DealerBranchLogger(dealerBranch, "DELETE", "Dealer Branch", Environment.UserName);
Validation.LocalDatabaseConfig(true);
dealerBranchesList = loadDealerBranches();
}
dgvDealer.ClearSelection();
txtSearchDealer.Clear();
btnDeleteDealerBranch.Enabled = false;
btnEditDealerBranch.Enabled = false;
}
}
private List <App> loadApplications()
{
var countryList = new List <App>();
applicationList = DALHelpers.GetApplications();
dgvApplications.DataSource = null;
dgvApplications.Rows.Clear();
dtApplications.Clear();
foreach (App app in applicationList)
{
dtApplications.Rows.Add(
app.ApplicationId.ToString(),
app.ApplicationName.ToString(),
app.ApplicationId.ToString() + app.ApplicationName.ToString());
}
dgvApplications.DataSource = dtApplications;
dgvApplications.Columns[0].Width = 100;
dgvApplications.Columns[1].Width = 280;
dgvApplications.Columns[0].Visible = false;
dgvApplications.Columns[2].Visible = false;
dgvApplications.Sort(dgvApplications.Columns["Application Name"], ListSortDirection.Ascending);
return(applicationList);
}
private void btnDeleteApplication_Click(object sender, EventArgs e)
{
if (dgvApplications.Rows.Count > 0)
{
int CountryId = Convert.ToInt32(dgvApplications.CurrentRow.Cells[0].Value.ToString());
string CountryName = dgvApplications.CurrentRow.Cells[1].Value.ToString();
if (MessageBox.Show("Are you sure you want to delete the Application " + CountryName + "?", "Delete Application", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
App app = new App();
app.ApplicationId = Convert.ToInt32(dgvApplications.CurrentRow.Cells[0].Value.ToString());
app.ApplicationName = dgvApplications.CurrentRow.Cells[1].Value.ToString();
DALHelpers.DeleteApplication(CountryId);
ActivityLog.ApplicationLogger(app, "DELETE", "", Environment.UserName);
Validation.LocalDatabaseConfig(true);
//databaseViewModel = Services.GetDataFromDatabase();
loadApplications();
}
dgvApplications.ClearSelection();
txtSearchApplication.Clear();
btnEditApplication.Enabled = false;
btnDeleteApplication.Enabled = false;
}
}
private void btnDeleteCredential_Click(object sender, EventArgs e)
{
if (dgvCredentials.Rows.Count > 0)
{
int CredentialId = Convert.ToInt32(dgvCredentials.CurrentRow.Cells[0].Value.ToString());
string CredentialDescription = dgvCredentials.CurrentRow.Cells[1].Value.ToString();
if (MessageBox.Show("Are you sure you want to delete the credential " + CredentialDescription + "?", "Delete Credential", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Credential credential = new Credential();
credential.CredentialId = Convert.ToInt32(dgvCredentials.CurrentRow.Cells[0].Value.ToString());
credential.CredentialDescription = dgvCredentials.CurrentRow.Cells[1].Value.ToString();
credential.Username = dgvCredentials.CurrentRow.Cells[2].Value.ToString();
credential.Password = dgvCredentials.CurrentRow.Cells[3].Value.ToString();
DALHelpers.DeleteCredential(CredentialId);
ActivityLog.CredentialLogger(credential, "DELETE", "Credential", Environment.UserName);
Validation.LocalDatabaseConfig(true);
//databaseViewModel = Services.GetDataFromDatabase();
loadCredentials();
}
dgvCredentials.ClearSelection();
txtSearchCredential.Clear();
btnEditCredential.Enabled = false;
btnDeleteCredential.Enabled = false;
}
}
public frmShowDealerContacts(int MainDealerId, string DealerName, string Branch, string CNPJ, string CTDI, int CountryId)
{
InitializeComponent();
dealerContactList = DALHelpers.GetDealerContactByDealerId(MainDealerId);
dtDealerContacts.Columns.Add("DealerContactId", typeof(string));
dtDealerContacts.Columns.Add("MainDealerId", typeof(string));
dtDealerContacts.Columns.Add("Description", typeof(string));
dtDealerContacts.Columns.Add("Department", typeof(string));
dtDealerContacts.Columns.Add("Phone", typeof(string));
dtDealerContacts.Columns.Add("CellPhone", typeof(string));
dtDealerContacts.Columns.Add("Email", typeof(string));
if (MainDealerId > 0)
{
GlobalDealerId = MainDealerId;
this.Text = "Dealer Contacts for: " + DealerName;
if (CountryId == 55)
{
grpDealer.Text = "Branch Specific Details: " + Branch;
txtCNPJ.Text = CNPJ;
txtCTDI.Text = CTDI;
this.Height = 348;
}
loadDealerContacts(MainDealerId);
}
}
private List <Credential> loadCredentials()
{
var credentialList = new List <Credential>();
credentialList = DALHelpers.GetCredentials();
dgvCredentials.DataSource = null;
dgvCredentials.Rows.Clear();
dtCredentials.Clear();
foreach (Credential credential in credentialList)
{
dtCredentials.Rows.Add(
credential.CredentialId.ToString(),
credential.CredentialDescription.ToString(),
credential.Username.ToString(),
Encryption.Decrypt(credential.Password.ToString()),
credential.Username.ToString() + credential.CredentialDescription.ToString());
}
dgvCredentials.DataSource = dtCredentials;
dgvCredentials.Columns[1].Width = 189;
dgvCredentials.Columns[2].Width = 140;
dgvCredentials.Columns[3].Width = 140;
dgvCredentials.Columns[0].Visible = false;
dgvCredentials.Columns[4].Visible = false;
dgvCredentials.Sort(dgvCredentials.Columns["Description"], ListSortDirection.Ascending);
return(credentialList);
}
private List <Country> loadCountries()
{
var countryList = new List <Country>();
countryList = DALHelpers.GetCountries();
dgvCountries.DataSource = null;
dgvCountries.Rows.Clear();
dtCountries.Clear();
foreach (Country country in countryList)
{
dtCountries.Rows.Add(
country.CountryId.ToString(),
country.CountryName.ToString(),
country.CountryId.ToString() + country.CountryName.ToString());
}
dgvCountries.DataSource = dtCountries;
dgvCountries.Columns[0].Width = 100;
dgvCountries.Columns[1].Width = 210;
dgvCountries.Columns[2].Visible = false;
dgvCountries.Columns["Country Code"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvCountries.Sort(dgvCountries.Columns["Country Code"], ListSortDirection.Ascending);
return(countryList);
}
private List <Dealer> loadDealers()
{
var dealerlList = new List <Dealer>();
dealerlList = DALHelpers.GetDealers();
dgvDealer.DataSource = null;
dgvDealer.Rows.Clear();
dtDealers.Clear();
foreach (Dealer dealer in dealerlList)
{
dtDealers.Rows.Add(
dealer.DealerId.ToString(),
dealer.DealerName.ToString(),
dealer.CountryId.ToString(),
dealer.CountryName.ToString(),
dealer.DealerName.ToString() + dealer.CountryId.ToString() + dealer.CountryName.ToString());
}
dgvDealer.DataSource = dtDealers;
dgvDealer.Columns[1].Width = 300;
dgvDealer.Columns[3].Width = 100;
dgvDealer.Columns[0].Visible = false;
dgvDealer.Columns[2].Visible = false;
dgvDealer.Columns[4].Visible = false;
dgvDealer.Sort(dgvDealer.Columns["Country Name"], ListSortDirection.Ascending);
return(dealerlList);
}
private void btnSave_Click(object sender, EventArgs e)
{
hasTheSaveButtonPressed = true;
Credential credential = new Credential();
bool ok = false;
if (Validation.CredentialDataValidation(txtUsername.Text, txtPassword.Text))
{
MessageBox.Show("Please enter the Credential details.");
return;
}
else
{
credential.CredentialDescription = txtDescription.Text;
credential.Username = txtUsername.Text;
credential.Password = txtPassword.Text;
}
if (CredentialId > 0)
{
//UPDATE
credential.CredentialId = CredentialId;
ok = DALHelpers.UpdateCredential(credential);
if (ok == true)
{
MessageBox.Show("The record was successfully saved!");
}
else
{
MessageBox.Show("Error: An error has ocurred when trying to update the Credential!");
}
this.Close();
}
else //NEW CREDENTIAL
{
List <Credential> credentialList = new List <Credential>();
credentialList = DALHelpers.GetCredentialByUsername(credential.Username);
if (credentialList.Count > 0)
{
MessageBox.Show("Error: The ID: " + credential.Username + " ,already exists in the database!");
}
else
{
//credential.CredentialId = DALHelpers.GetCredentialMaxId() + 1;
ok = DALHelpers.AddCredential(credential);
if (ok == true)
{
MessageBox.Show("The record was successfully saved!");
}
}
this.Close();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
hasTheSaveButtonPressed = true;
Country country = new Country();
bool ok = false;
country.CountryId = Convert.ToInt32(txtCountryCode.Text);
country.CountryName = txtCountryName.Text;
if (Validation.CountryDataValidation(country))
{
MessageBox.Show("Please enter the Contact details.");
return;
}
if (CountryID > 0)
{
//UPDATE
ok = DALHelpers.UpdateCountry(country, CountryID);
if (ok == true)
{
MessageBox.Show("The record was successfully saved!");
}
else
{
MessageBox.Show("Error: An error has ocurred when trying to update the Country!");
}
ActivityLog.CountryLogger(country, "UPDATE", CountryName, CountryID, Environment.UserName);
this.Close();
}
else //NEW COUNTRY
{
List <Country> countryList = new List <Country>();
countryList = DALHelpers.GetCountryById(country.CountryId);
if (countryList.Count > 0)
{
MessageBox.Show("Error: The ID: " + country.CountryId + " already exists in the database!");
return;
}
else
{
ok = DALHelpers.AddCrountry(country);
if (ok == true)
{
ActivityLog.CountryLogger(country, "CREATE", "", 0, Environment.UserName);
MessageBox.Show("The record was successfully saved!");
}
}
this.Close();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Contact contact = new Contact();
bool ok = false;
if (Validation.ContactDataValidation(txtUserID.Text, txtName.Text, txtPhone.Text))
{
MessageBox.Show("Please enter the Contact details.");
return;
}
else
{
contact.Id = txtUserID.Text;
contact.Name = txtName.Text;
contact.Phone = txtPhone.Text;
contact.Computer = txtComputer.Text;
}
if (txtUserID.Enabled == false)
{
//UPDATE
ok = DALHelpers.UpdateContact(contact);
if (ok == true)
{
MessageBox.Show("The record was successfully saved!");
}
else
{
MessageBox.Show("Error: An error has ocurred when trying to update the Contact!");
}
this.Close();
}
else //NEW CONTACT
{
List <Contact> contactList = new List <Contact>();
contactList = DALHelpers.GetContactById(contact.Id);
if (contactList.Count > 0)
{
MessageBox.Show("Error: The ID: " + contact.Id + " ,already exists in the database!");
}
else
{
ok = DALHelpers.AddContact(contact);
if (ok == true)
{
MessageBox.Show("The record was successfully saved!");
}
}
this.Close();
}
}
private void loadAppLinks()
{
try
{
var appLinksList = new List <AppLinks>();
appLinksList.Clear();
appLinksList = DALHelpers.GetAppLinks();
dgvAppLinks.DataSource = null;
dgvAppLinks.Rows.Clear();
dtAppLinks.Clear();
foreach (AppLinks link in appLinksList)
{
string tempPassword = link.Password.ToString();
if (!string.IsNullOrEmpty(tempPassword))
{
tempPassword = Encryption.Decrypt(tempPassword);
}
dtAppLinks.Rows.Add(link.ListId.ToString(), link.Description.ToString(), link.Link.ToString(),
link.AppCategoryId.ToString(), link.AppCategoryName.ToString(),
link.ApplicationId.ToString(), link.ApplicationName.ToString(),
link.CountryId.ToString(), link.CountryName.ToString(),
link.CredentialId.ToString(), link.CredentialDescription.ToString(), link.Username.ToString(), tempPassword,
link.AppCategoryName.ToString() + link.ApplicationName.ToString() + link.CountryName.ToString() + link.Description.ToString() + link.Link.ToString() + link.CredentialDescription.ToString() + link.Username.ToString());
}
dgvAppLinks.DataSource = dtAppLinks;
dgvAppLinks.Columns[0].Visible = false;
dgvAppLinks.Columns[3].Visible = false;
dgvAppLinks.Columns[5].Visible = false;
dgvAppLinks.Columns[7].Visible = false;
dgvAppLinks.Columns[9].Visible = false;
dgvAppLinks.Columns[13].Visible = false;
dgvAppLinks.Columns[1].Width = 200;
dgvAppLinks.Columns[2].Width = 300;
dgvAppLinks.Columns[4].Width = 70;
dgvAppLinks.Columns[6].Width = 70;
dgvAppLinks.Columns[8].Width = 70;
dgvAppLinks.Columns[10].Width = 140;
dgvAppLinks.Columns[11].Width = 70;
dgvAppLinks.Sort(dgvAppLinks.Columns["Link Description"], ListSortDirection.Ascending);
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
hasTheSaveButtonPressed = true;
Dealer dealer = new Dealer();
bool ok = false;
if (Validation.DealerDataValidation(txtDealerName.Text, cmbCountries.Text))
{
MessageBox.Show("All fields are required.");
return;
}
foreach (Country country in countryList)
{
if (cmbCountries.Text == country.CountryName)
{
dealer.CountryId = country.CountryId;
}
}
dealer.DealerName = txtDealerName.Text;
if (GlobalDealerId != 0)
{
dealer.DealerId = GlobalDealerId;
//UPDATE
ok = DALHelpers.UpdateMainDealer(dealer);
if (ok == true)
{
MessageBox.Show("The record was successfully saved!");
}
else
{
MessageBox.Show("Error: An error has ocurred when trying to update the Dealer Contact!");
}
ActivityLog.DealerLogger(dealer, "UPDATE", "Main Dealer", Environment.UserName);
this.Close();
}
else //NEW MAIN DEALER
{
ok = DALHelpers.AddMainDealer(dealer);
if (ok == true)
{
MessageBox.Show("The record was successfully saved!");
}
ActivityLog.DealerLogger(dealer, "CREATE", "Main Dealer", Environment.UserName);
this.Close();
}
}
public frmAddOrUpdateDealer(int DealerId, string DealerCode, string DealerName, int CountryId)
{
InitializeComponent();
GlobalDealerId = DealerId;
#region "DEALER - UPDATE"
if (!string.IsNullOrEmpty(DealerName))
{
int counter = 0;
this.Text = "Update Dealer";
txtDealerCode.Text = DealerCode;
txtDealerName.Text = DealerName;
countryList = DALHelpers.GetCountries();
Dictionary <int, Dealer> comboDealer = new Dictionary <int, Dealer>();
Dictionary <int, Country> comboBox = new Dictionary <int, Country>();
foreach (Country country in countryList)
{
cmbCountries.Items.Add(country.CountryName.ToString());
comboBox.Add(counter, country);
if (CountryId == country.CountryId)
{
cmbCountries.SelectedIndex = counter;
}
counter++;
}
}
#endregion
#region "DEALER - NEW"
else
{
//LOAD DATA FOR NEW SUBDEALER
countryList = DALHelpers.GetCountries();
foreach (Country country in countryList)
{
cmbCountries.Items.Add(country.CountryName.ToString());
}
}
#endregion
}
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 btnSave_Click(object sender, EventArgs e)
{
hasTheSaveButtonPressed = true;
App application = new App();
bool ok = false;
if (string.IsNullOrEmpty(txtApplicationName.Text))
{
MessageBox.Show("Please enter the Application name.");
return;
}
else
{
application.ApplicationId = GlobalApplicationId;
application.ApplicationName = txtApplicationName.Text;
}
if (GlobalEditOrNew == "Edit")
{
//UPDATE APPLICATION
ok = DALHelpers.UpdateApplication(application);
if (ok == true)
{
MessageBox.Show("The record was successfully saved!");
}
else
{
MessageBox.Show("Error: An error has ocurred when trying to update the Application!");
}
ActivityLog.ApplicationLogger(application, "UPDATE", GlobalApplicationName, Environment.UserName);
this.Close();
}
else //NEW APPLICATION
{
ok = DALHelpers.AddApplication(application);
if (ok == true)
{
ActivityLog.ApplicationLogger(application, "CREATE", "", Environment.UserName);
MessageBox.Show("The record was successfully saved!");
}
this.Close();
}
}
private void loadDealerContacts(int DealerId)
{
var dealerContactList = new List <DealerContact>();
dealerContactList = DALHelpers.GetDealerContactByDealerId(DealerId);
dgvDealerContacts.DataSource = null;
dgvDealerContacts.Rows.Clear();
dtDealerContacts.Clear();
foreach (DealerContact dealerContact in dealerContactList)
{
//dtDealerContacts.Columns.Add("DealerContactId", typeof(string));
//dtDealerContacts.Columns.Add("MainDealerId", typeof(string));
//dtDealerContacts.Columns.Add("Description", typeof(string));
//dtDealerContacts.Columns.Add("Department", typeof(string));
//dtDealerContacts.Columns.Add("Phone", typeof(string));
//dtDealerContacts.Columns.Add("CellPhone", typeof(string));
//dtDealerContacts.Columns.Add("Email", typeof(string));
dtDealerContacts.Rows.Add(
dealerContact.DealerContactId.ToString(),
dealerContact.MainDealerId.ToString(),
dealerContact.Description.ToString(),
dealerContact.Department.ToString(),
dealerContact.Phone.ToString(),
dealerContact.CellPhone.ToString(),
dealerContact.Email.ToString()
);
}
dgvDealerContacts.DataSource = dtDealerContacts;
dgvDealerContacts.Columns[0].Visible = false;
dgvDealerContacts.Columns[1].Visible = false;
dgvDealerContacts.Columns[2].Width = 140;
dgvDealerContacts.Columns[3].Width = 100;
dgvDealerContacts.Columns[4].Width = 100;
dgvDealerContacts.Columns[5].Width = 100;
dgvDealerContacts.Columns[6].Width = 180;
dgvDealerContacts.Sort(dgvDealerContacts.Columns["Description"], ListSortDirection.Ascending);
dgvDealerContacts.ClearSelection();
}
private void cmbCountries_SelectionChangeCommitted(object sender, EventArgs e)
{
foreach (Country country in countryList)
{
if (cmbCountries.SelectedItem.ToString() == country.CountryName)
{
cmbMainDealer.Items.Clear();
dealerList.Clear();
dealerList = DALHelpers.GetDealersByCountry(country.CountryId);
}
}
foreach (Dealer dealer in dealerList)
{
cmbMainDealer.Items.Add(dealer.DealerName.ToString());
}
}
public List <DealerBranch> loadDealerBranches()
{
dgvDealer.DataSource = null;
dgvDealer.Rows.Clear();
dtDealers.Clear();
dealerBranchesList = DALHelpers.GetDealerBranchs();
foreach (DealerBranch dealer in dealerBranchesList)
{
dtDealers.Rows.Add(
dealer.DealerBranchId.ToString(),
dealer.CTDI.ToString(),
dealer.DealerName.ToString(),
dealer.BranchName.ToString(),
dealer.PhoneNumber.ToString(),
dealer.BaldoPartner.ToString(),
dealer.CountryId.ToString(),
dealer.CountryName.ToString(),
dealer.DealerId.ToString(),
dealer.CTDI.ToString() + dealer.PhoneNumber.ToString() + dealer.BaldoPartner.ToString() + dealer.CountryName.ToString() + dealer.DealerName.ToString() + Validation.RemoveDiacritics(dealer.DealerName.ToString()) + dealer.BranchName.ToString() + Validation.RemoveDiacritics(dealer.BranchName.ToString()),
dealer.DealerName.ToString() + dealer.BranchName.ToString());
}
dgvDealer.DataSource = dtDealers;
dgvDealer.Columns[0].Visible = false;
dgvDealer.Columns[6].Visible = false;
dgvDealer.Columns[8].Visible = false;
dgvDealer.Columns[9].Visible = false;
dgvDealer.Columns[10].Visible = false;
dgvDealer.Columns[1].Width = 50;
dgvDealer.Columns[2].Width = 150;
dgvDealer.Columns[3].Width = 150;
dgvDealer.Columns[4].Width = 110;
dgvDealer.Columns[5].Width = 70;
dgvDealer.Columns[7].Width = 70;
dgvDealer.Sort(dgvDealer.Columns["Sort"], ListSortDirection.Ascending);
dgvDealer.ClearSelection();
return(dealerBranchesList);
}
public frmUpdatePassword(int CredentialId)
{
InitializeComponent();
hasTheSaveButtonPressed = false;
//NEW OBJECT credential
Credential credential = new Credential();
//GETTING THE CREDENTIAL FROM THE DABASE, SEARCHING BY THE ID
credential = DALHelpers.GetCredentialById(CredentialId);
//LOADING THE DATA TO THE FORM
GlobalCredentialId = credential.CredentialId;
txtDescription.Text = credential.CredentialDescription.ToString();
txtUsername.Text = credential.Username.ToString();
txtPassword.Text = credential.Password.ToString();
}
public frmAddOrUpdateDealer(Dealer dealer)
{
InitializeComponent();
GlobalDealerId = dealer.DealerId;
countryList = DALHelpers.GetCountries();
hasTheSaveButtonPressed = false;
int counter = 0;
if (dealer.DealerId != 0)
{
foreach (Country _country in countryList)
{
cmbCountries.Items.Add(_country.CountryName.ToString());
if (dealer.CountryId == _country.CountryId)
{
cmbCountries.SelectedIndex = counter;
}
counter++;
}
counter = 0;
this.Text = "Update Dealer";
txtDealerName.Text = dealer.DealerName;
}
else
{
foreach (Country country in countryList)
{
cmbCountries.Items.Add(country.CountryName.ToString());
}
counter = 0;
this.Text = "New Dealer";
}
cmbCountries.Focus();
}
public frmAddOrUpdateContact(Contact contact)
{
InitializeComponent();
teamList = DALHelpers.GetTeams();
hasTheSaveButtonPressed = false;
int counter = 0;
if (!string.IsNullOrEmpty(contact.Id))
{
foreach (Team team in teamList)
{
cmbTeam.Items.Add(team.TeamName.ToString());
if (contact.TeamId == team.TeamId)
{
cmbTeam.SelectedIndex = counter;
}
counter++;
}
this.Text = "Update Contact";
txtUserID.Text = contact.Id;
txtUserID.Enabled = false;
txtName.Text = contact.Name;
txtPhone.Text = contact.Phone;
txtCellPhone.Text = contact.CellPhone;
txtComputer.Text = contact.Computer;
}
else
{
foreach (Team team in teamList)
{
cmbTeam.Items.Add(team.TeamName.ToString());
}
this.Text = "New Contact";
txtUserID.Enabled = Enabled;
}
cmbTeam.Focus();
}
private void btnDeleteCountry_Click(object sender, EventArgs e)
{
if (dgvCountries.Rows.Count > 0)
{
int CountryId = Convert.ToInt32(dgvCountries.CurrentRow.Cells[0].Value.ToString());
string CountryName = dgvCountries.CurrentRow.Cells[1].Value.ToString();
if (MessageBox.Show("Are you sure you want to delete the country " + CountryId.ToString() + "?", "Delete Country", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
var dealerList = new List <Dealer>();
var appLinksList = new List <AppLinks>();
dealerList = DALHelpers.GetDealersByCountry(CountryId);
appLinksList = DALHelpers.GetAppLinksByCountryId(CountryId);
if (countryList.Count == 0 || appLinksList.Count == 0)
{
Country country = new Country();
country.CountryId = Convert.ToInt32(dgvCountries.CurrentRow.Cells[0].Value.ToString());
country.CountryName = dgvCountries.CurrentRow.Cells[1].Value.ToString();
DALHelpers.DeleteCountry(CountryId);
ActivityLog.CountryLogger(country, "DELETE", "", 0, Environment.UserName);
Validation.LocalDatabaseConfig(true);
//databaseViewModel = Services.GetDataFromDatabase();
countryList = loadCountries();
}
else
{
MessageBox.Show("Unable to Delete the Country: " + CountryName + ". This record is used by: " + dealerList.Count + " Main Dealers and " + appLinksList.Count + " Application Links.", "Unable to Delete the Main Dealer!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
dgvCountries.ClearSelection();
txtSearchCountry.Clear();
btnDeleteCountry.Enabled = false;
btnEditCountry.Enabled = false;
}
}
private void btnDeleteDealer_Click(object sender, EventArgs e)
{
if (dgvDealer.Rows.Count > 0)
{
int DealerId = Convert.ToInt32(dgvDealer.CurrentRow.Cells[0].Value.ToString());
string DealerName = dgvDealer.CurrentRow.Cells[1].Value.ToString();
if (MessageBox.Show("Are you sure you want to delete the Main Dealer: " + DealerName.ToString() + "?", "Delete Main Dealer", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
var dealerList = new List <DealerBranch>();
dealerList = DALHelpers.GetDealerBranchByDealerId(DealerId);
if (dealerList.Count == 0)
{
Dealer dealer = new Dealer();
dealer.DealerId = Convert.ToInt32(dgvDealer.CurrentRow.Cells[0].Value.ToString());
dealer.CountryName = dgvDealer.CurrentRow.Cells[1].Value.ToString();
dealer.CountryId = Convert.ToInt32(dgvDealer.CurrentRow.Cells[2].Value.ToString());
DALHelpers.DeleteMainDealer(DealerId);
ActivityLog.DealerLogger(dealer, "DELETE", "Main Dealer", Environment.UserName);
Validation.LocalDatabaseConfig(true);
//databaseViewModel = Services.GetDataFromDatabase();
dealerlList = loadDealers();
}
else
{
MessageBox.Show("Unable to Delete the Main Dealer: " + DealerName.ToString() + ". Found " + dealerList.Count + " Dealer Branches created for this Main Dealer", "Unable to Delete the Main Dealer!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
dgvDealer.ClearSelection();
txtSearchDealer.Clear();
btnEditDealer.Enabled = false;
btnDeleteDealer.Enabled = false;
}
}
private void updatePasswordToolStripMenuItem_Click(object sender, EventArgs e)
{
foreach (var password in PasswordList)
{
TreeNode tn = treeView1.SelectedNode;
if (tn != null)
{
if (treeView1.SelectedNode.Text.ToString() == password.Value.ToString())
{
frmUpdatePassword _frmUpdatePassword = new frmUpdatePassword(password.Key, left, top, width, height);
this.TopMost = false;
_frmUpdatePassword.ShowDialog();
//loadAppLinks();
setTopMostWindowSetting();
_frmUpdatePassword.Dispose();
PasswordList.Clear();
ApplicationsList = DALHelpers.GetApplications();
AppLinksFromDatabase = DALHelpers.GetAppLinks();
if (txtAppSearch.Text.Length > 1)
{
loadAppsFromSearchBox();
}
else
{
loadTreeview(false, null);
}
break;
}
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if ((dgvAppLinks.Rows.Count > 0) && (dgvAppLinks.SelectedRows.Count > 0))
{
int LinkId;
string Description = dgvAppLinks.CurrentRow.Cells[1].Value.ToString();
LinkId = Convert.ToInt32(dgvAppLinks.CurrentRow.Cells[0].Value.ToString());
if (MessageBox.Show("Are you sure you want to delete the App Link: " + Description, "Delete App Link", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
DALHelpers.DeleteAppLink(LinkId);
System.Threading.Thread.Sleep(1000);
loadAppLinks();
dgvAppLinks.ClearSelection();
}
else
{
dgvAppLinks.ClearSelection();
}
txtAppLinkSearch.Clear();
}
}
public frmUpdatePassword(int CredentialId, int left, int top, int width, int height)
{
InitializeComponent();
//SETTING THE FORM LOCATION
left = left + (width / 4);
top = top + (height / 4);
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(left, top);
//NEW OBJECT credential
Credential credential = new Credential();
//GETTING THE CREDENTIAL FROM THE DABASE, SEARCHING BY THE ID
credential = DALHelpers.GetCredentialById(CredentialId);
//LOADING THE DATA TO THE FORM
GlobalCredentialId = credential.CredentialId;
txtDescription.Text = credential.CredentialDescription.ToString();
txtUsername.Text = credential.Username.ToString();
txtPassword.Text = credential.Password.ToString();
}
private void btnSave_Click(object sender, EventArgs e)
{
bool ok;
if (!string.IsNullOrEmpty(txtPassword.Text) || txtPassword.Text.Length > 2)
{
Credential credential = new Credential();
credential.CredentialId = GlobalCredentialId;
credential.CredentialDescription = txtDescription.Text;
credential.Username = txtUsername.Text;
credential.Password = txtPassword.Text;
//UPDATE
ok = DALHelpers.UpdateCredential(credential);
if (ok == false)
{
MessageBox.Show("Error: An error has ocurred when trying to update the Password!");
}
this.Close();
}
}
private async Task ExecuteJobAsync(string processID, string jobID, MethodInfo methodInfo, string parameters, object instance, CancellationToken?token, bool isSync)
{
try
{
//Set job to Running
if (isSync)
{
jobDAL.SetToRunning(processID, jobID);
}
else
{
await jobDAL.SetToRunningAsync(processID, jobID);
}
jobDAL.SetCachedProgressStatusAsync(jobID, JobStatus.Running);
var progress = isSync ? UpdateProgressEventAsync(jobID, true).GetAwaiter().GetResult() : await UpdateProgressEventAsync(jobID, false); //Need this to update the progress of the job's
//Invoke Method
if (token == null)
{
var tokenSource = new CancellationTokenSource(); //not doing anything when using thread.Start()
token = tokenSource.Token;
}
var args = DALHelpers.DeserializeArguments(token.Value, progress, methodInfo, parameters);
methodInfo.Invoke(instance, args);
}
catch (TargetInvocationException exc)
{
if (exc.InnerException is OperationCanceledException)
{
if (isSync)
{
SetToStoppedAsync(new List <string> {
jobID
}, isSync).GetAwaiter().GetResult();
}
else
{
await SetToStoppedAsync(new List <string> {
jobID
}, isSync);
}
throw exc.InnerException;
}
else
{
var job = isSync ? jobDAL.GetJob(jobID) : await jobDAL.GetJobAsync(jobID);
if (job != null)
{
var error = job.Error + " " + exc.ToString();
var count = isSync ? SetErrorAsync(processID, job.JobID, error, isSync).GetAwaiter().GetResult()
: await SetErrorAsync(processID, job.JobID, error, isSync);
}
throw exc;
}
}
catch (Exception exc)
{
var job = isSync ? jobDAL.GetJob(jobID) : await jobDAL.GetJobAsync(jobID);
if (job != null)
{
var error = job.Error + " " + exc.ToString();
var count = isSync ? SetErrorAsync(processID, job.JobID, error, isSync).GetAwaiter().GetResult()
: await SetErrorAsync(processID, job.JobID, error, isSync);
}
throw exc;
}
//Completed successfully with no error
if (isSync)
{
jobDAL.SetCompleted(processID, jobID);
}
else
{
await jobDAL.SetCompletedAsync(processID, jobID);
}
jobDAL.SetCachedProgressStatusAsync(jobID, JobStatus.Completed);
}
