private async void TapGestureRecognizer_Tapped(object sender, EventArgs e)
{
DOBpicker.IsShowPicker = false;
DOBpicker.IsVisible = false;
DOBpicker.Unfocus();
await vM.SaveTestSessionOverView();
await PopupNavigation.Instance.PopAsync();
}
void OpenDob(object sender, EventArgs e)
{
if (Device.RuntimePlatform == Device.UWP)
{
DOBpicker.ShowDatePicker();
}
else
{
DOBpicker.Focus();
}
}
private void RegisterButton_Click(object sender, EventArgs e)
{
//sets connection
var connectionString = ConfigurationManager.ConnectionStrings["EmployeeManagement"].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
//opens connection
con.Open();
//Creates a command/sql query to select the userid from the database
SqlCommand checkUserName = new SqlCommand("Select * from Employees where UserID=@Username", con);
SqlCommand checkEmail = new SqlCommand("Select * from Employees where Email=@Email", con);
//Trys to add the current data in the UserID text box to the database
checkUserName.Parameters.AddWithValue("@Username", this.Username.Text);
// same checks for the user id the only diffrence is its the email
checkEmail.Parameters.AddWithValue("@Email", this.EmailBox.Text);
var result = checkUserName.ExecuteScalar();
var emailResult = checkEmail.ExecuteScalar();
//checks to see if any textboxes are empty if so then it carrys on
if (FirstNameBox.Text == "" || LastNameBox.Text == "" || DOBpicker.Text == "" || JobTitleBox.Text == "" || EmailBox.Text == "" || Username.Text == "" || Password.Text == "")
{
// if a empty a message box shows to ask to enter all fields
MessageBox.Show("Please enter all fields!");
//simple return function as we dont want the rest of the code to continue
return;
}
// if both useername and email are not empty and are equal to values in the database it does the following commands
if (result != null || emailResult != null)
{
//if the user name and email is null then set them to red
if (result != null && emailResult != null)
{
Username.BackColor = Color.LightCoral;
EmailBox.BackColor = Color.LightCoral;
MessageBox.Show("This Username & Email already exist!");
}
//if the username is null set the email to green but the username to red
else if (result != null)
{
EmailBox.BackColor = Color.LightGreen;
Username.BackColor = Color.LightCoral;
MessageBox.Show("This Username already exist!");
}
//if the email is null set the email to red and the username to green
else if (emailResult != null)
{
EmailBox.BackColor = Color.LightCoral;
Username.BackColor = Color.LightGreen;
MessageBox.Show("This Email already exist!");
}
//close connection to database
con.Close();
}
//if no duplicates are found it will move on to adding the data to the database
else
{
// creates a new connection
{
//creates the new command to insert values into the database but uses values for neater code
Random rnd = new Random();
int ID = rnd.Next(2000, 4000);
int Employeeid = ID;
//SAME AS REGISTER PAGE
SqlCommand EmployeeCheck = new SqlCommand("SELECT * from Employees where EmployeeID='" + Employeeid + "'", con);
SqlCommand cmd = new SqlCommand("insert into Employees (EmployeeID, FirstName, LastName, DOB, Address, Salary, Department, JobTitle, Role, Email, UserID, Password) " + " values(@EmployeeID, @FirstName, @LastName, @DOB, @Address, @Salary, @Department, @JobTitle, @Role, @Email, @UserID, @Password)", con);
SqlDataAdapter da = new SqlDataAdapter(EmployeeCheck);
DataSet ds = new DataSet();
da.Fill(ds);
int i = ds.Tables[0].Rows.Count;
if (i > 0)
{
MessageBox.Show(i.ToString());
//create a new id
int newID = rnd.Next(2000, 10000);
cmd.Parameters.AddWithValue("@EmployeeID", newID);
cmd.Parameters.AddWithValue("@FirstName", FirstNameBox.Text);
cmd.Parameters.AddWithValue("@LastName", LastNameBox.Text);
cmd.Parameters.AddWithValue("@DOB", DOBpicker.Text);
cmd.Parameters.AddWithValue("@Address", Address.Text);
//sets the salary value to the variable based on which role is selected
// CLEAN UP ALL IFS STATEMENTS
if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Manager")
{
cmd.Parameters.AddWithValue("@Salary", Manager);
}
else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Engineer")
{
cmd.Parameters.AddWithValue("@Salary", Engineer);
}
else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Team Leader")
{
cmd.Parameters.AddWithValue("@Salary", TeamLeader);
}
else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Engineer Scheduler")
{
cmd.Parameters.AddWithValue("@Salary", EngineerScheduler);
}
else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Senior Developer")
{
cmd.Parameters.AddWithValue("@Salary", SeniorDevelopment);
}
else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Programmer")
{
cmd.Parameters.AddWithValue("@Salary", Programmer);
}
else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Anaylst")
{
cmd.Parameters.AddWithValue("@Salary", Anaylst);
}
cmd.Parameters.AddWithValue("@Department", DepartmentBox.GetItemText(DepartmentBox.SelectedItem));
cmd.Parameters.AddWithValue("@JobTitle", JobTitleBox.Text);
cmd.Parameters.AddWithValue("@Role", RoleBox.GetItemText(RoleBox.SelectedItem));
cmd.Parameters.AddWithValue("@Email", EmailBox.Text);
cmd.Parameters.AddWithValue("@UserID", Username.Text);
decryptedPassword = Password.Text;
//adds the password as normal but adds it as an encrypted value
cmd.Parameters.AddWithValue("@Password", PasswordLogin.encryptPassword(Password.Text.Trim()));
//passing id
cmd.ExecuteNonQuery();
//shows a succesful message
MessageBox.Show("Succesfully Registerd!");
FirstNameBox.Clear();
LastNameBox.Clear();
JobTitleBox.Clear();
EmailBox.Clear();
Username.Clear();
Password.Clear();
Address.Clear();
DOBpicker.ResetText();
RoleBox.ResetText();
DepartmentBox.ResetText();
}
else
{
cmd.Parameters.AddWithValue("@EmployeeID", Employeeid);
cmd.Parameters.AddWithValue("@FirstName", FirstNameBox.Text);
cmd.Parameters.AddWithValue("@LastName", LastNameBox.Text);
cmd.Parameters.AddWithValue("@DOB", DOBpicker.Text);
cmd.Parameters.AddWithValue("@Address", Address.Text);
//sets the salary value to the variable based on which role is selected
// CLEAN UP ALL IFS STATEMENTS
if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Manager")
{
cmd.Parameters.AddWithValue("@Salary", Manager);
}
else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Engineer")
{
cmd.Parameters.AddWithValue("@Salary", Engineer);
}
else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Team Leader")
{
cmd.Parameters.AddWithValue("@Salary", TeamLeader);
}
else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Engineer Scheduler")
{
cmd.Parameters.AddWithValue("@Salary", EngineerScheduler);
}
else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Senior Developer")
{
cmd.Parameters.AddWithValue("@Salary", SeniorDevelopment);
}
else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Programmer")
{
cmd.Parameters.AddWithValue("@Salary", Programmer);
}
else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Anaylst")
{
cmd.Parameters.AddWithValue("@Salary", Anaylst);
}
cmd.Parameters.AddWithValue("@Department", DepartmentBox.GetItemText(DepartmentBox.SelectedItem));
cmd.Parameters.AddWithValue("@JobTitle", JobTitleBox.Text);
cmd.Parameters.AddWithValue("@Role", RoleBox.GetItemText(RoleBox.SelectedItem));
cmd.Parameters.AddWithValue("@Email", EmailBox.Text);
cmd.Parameters.AddWithValue("@UserID", Username.Text);
decryptedPassword = Password.Text;
//adds the password as normal but adds it as an encrypted value
cmd.Parameters.AddWithValue("@Password", PasswordLogin.encryptPassword(Password.Text.Trim()));
cmd.ExecuteNonQuery();
//closes connection
con.Close();
//shows a succesful message
MessageBox.Show("Succesfully Registerd!");
FirstNameBox.Clear();
LastNameBox.Clear();
JobTitleBox.Clear();
EmailBox.Clear();
Username.Clear();
Password.Clear();
Address.Clear();
DOBpicker.ResetText();
RoleBox.ResetText();
DepartmentBox.ResetText();
}
}
}
}
private void VM_DatePicketSelectedEvent(object sender, TestSessionModel e)
{
Device.BeginInvokeOnMainThread(() =>
{
this.DomainCode = e.DomainCode;
DOBpicker.IsShowPicker = true;
var success = DateTime.TryParse(e.TestDate, out DateTime dateTime);
if (success) //on inital load value will be mm/dd/yyyy
{
if (vM.Records != null)
{
var selectedTestRecord = vM.Records.FirstOrDefault(p => p.DomainCode == e.DomainCode);
if (selectedTestRecord != null)
{
var maxDateItem = vM.Records.Where(p => p.IsDateVisible).OrderByDescending(p => p.DateOfTest).FirstOrDefault();
var mindateItem = vM.Records.Where(p => p.IsDateVisible).OrderBy(p => p.DateOfTest).FirstOrDefault();
var dataservice = DependencyService.Get <ICommonDataService>();
var dobSpliteDate = dataservice.DOB.Split('/');
DateTime dobDateTime = new DateTime(Convert.ToInt32(dobSpliteDate[2]), Convert.ToInt32(dobSpliteDate[0]), Convert.ToInt32(dobSpliteDate[1]));
if (maxDateItem != null && mindateItem != null)
{
var dateDiff = maxDateItem.DateOfTest - mindateItem.DateOfTest;
if (dateDiff.TotalDays == 0)
{
var mindate = mindateItem.DateOfTest.AddDays(-30);
if (mindate < dobDateTime.Date)
{
vM.MinimumDate = dobDateTime.Date;
}
else
{
vM.MinimumDate = mindate;
}
var maxDate = maxDateItem.DateOfTest.AddDays(30);
if (maxDate > DateTime.Now.Date)
{
vM.MaximumDate = DateTime.Now;
}
else
{
vM.MaximumDate = maxDate;
}
}
else if (dateDiff.TotalDays == 30)
{
vM.MinimumDate = mindateItem.DateOfTest;
vM.MaximumDate = maxDateItem.DateOfTest;
}
else
{
var diffDays = 30 - dateDiff.TotalDays;
var mindate = mindateItem.DateOfTest.AddDays(-diffDays);
if (mindate < dobDateTime.Date)
{
vM.MinimumDate = dobDateTime.Date;
}
else
{
vM.MinimumDate = mindate;
}
var maxDate = maxDateItem.DateOfTest.AddDays(diffDays);
if (maxDate > DateTime.Now.Date)
{
vM.MaximumDate = DateTime.Now;
}
else
{
vM.MaximumDate = maxDate.Date;
}
}
}
}
}
DOBpicker.Date = dateTime;
DOBpicker.ManualMaxDate = true;
DOBpicker.ManualMinDate = true;
DOBpicker.MaximumDate = vM.MaximumDate;
DOBpicker.MinimumDate = vM.MinimumDate;
}
else
{
DOBpicker.Date = DateTime.Now;
}
DOBpicker.IsVisible = true;
if (Device.RuntimePlatform == Device.UWP)
{
DOBpicker.ShowDatePicker();
}
else
{
DOBpicker.Focus();
}
//DOBpicker.Focus();
});
}