private void AddJob() { if (listBoxAllJobs.SelectedItem == null) { return; } double?payRate = PosDialogWindow.PromptCurrency(Strings.EmployeeJobEditorPayRate, 0.0); if (payRate == null) { return; } FormattedListBoxItem item = listBoxAllJobs.SelectedItem as FormattedListBoxItem; if (item != null) { EmployeeJob job = item.ReferenceObject as EmployeeJob; if (job != null) { EmployeePayRate rate = EmployeePayRate.Add(SelectedEmployee.Id, job.Id, payRate.Value, 0); listBoxAllJobs.Items.Remove(listBoxAllJobs.SelectedItem); item = GetJobListBoxItem(job, rate); listBoxSelectedJobs.Items.Add(item); listBoxSelectedJobs.SelectedItem = item; listBoxSelectedJobs.ScrollToEnd(); } } buttonAdd.IsEnabled = false; buttonRemove.IsEnabled = true; }
public int AddPayEmployeePayRate(EmployeePayRate employeePayRate) { int returnValue = 0; try { var connectionString = ConfigurationManager.AppSettings["PayMe-Connectionstring"]; SqlConnection connection = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("AddEmployeePayRate", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@EmployeeID", employeePayRate.ID); cmd.Parameters.AddWithValue("@StartDate", employeePayRate.StartDate); cmd.Parameters.AddWithValue("@EndDate", employeePayRate.EndDate); cmd.Parameters.AddWithValue("@PayRateID", employeePayRate.PayRateTypeID); cmd.Parameters.AddWithValue("@RegularRate", employeePayRate.RegularRate); cmd.Parameters.AddWithValue("@OTRate", employeePayRate.OTRate); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); } catch (Exception ex) { throw new ApplicationException(ex.Message.ToString()); } return(returnValue); }
public ActionResult AddPayRate(EmployeePayRate collection) { UserManager userManager = new UserManager(); userManager.AddPayEmployeePayRate(collection); //TempData["Message"] = "Pay Rate Added Successfully"; return(RedirectToAction("edit", "Employee", new { id = collection.ID })); //return RedirectToAction("/Employee/"+ collection.ID); }
private void EditEmployeePayRate() { double?payRate = PosDialogWindow.PromptCurrency(Strings.EmployeeJobEditorPayRate, 0.0); if (payRate != null) { FormattedListBoxItem item = listBoxSelectedJobs.SelectedItem as FormattedListBoxItem; if (item != null) { EmployeeJob job = item.ReferenceObject as EmployeeJob; EmployeePayRate rate = EmployeePayRate.GetEmployeePayRateForJob(SelectedEmployee.Id, job.Id); rate.SetWage(payRate.Value); rate.Update(); item.Set(job, job.Description + Environment.NewLine + rate.Wage.ToString("C2")); } } }
private void InitializeJobsList() { List <EmployeeJob> employeeJobs = new List <EmployeeJob>(SelectedEmployee.GetJobs()); List <EmployeeJob> filterList = ( from job in EmployeeJob.GetAll() let found = employeeJobs.Any(employeeJob => employeeJob.Id == job.Id) where !found select job).ToList(); foreach (FormattedListBoxItem item in filterList .Select(job => new FormattedListBoxItem(job, job.Description, true))) { listBoxAllJobs.Items.Add(item); } foreach (FormattedListBoxItem item in from employeeJob in employeeJobs let pay = EmployeePayRate.GetEmployeePayRateForJob(SelectedEmployee.Id, employeeJob.Id) select GetJobListBoxItem(employeeJob, pay)) { listBoxSelectedJobs.Items.Add(item); } }
public IEnumerable <EmployeePayRate> GetPayrateByEmployeeID(int id) { try { var connectionString = ConfigurationManager.AppSettings["PayMe-Connectionstring"]; SqlConnection connection = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("GetPayRateByEmployeeID", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@EmployeeID", id); connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); List <EmployeePayRate> EmployeePayRateList = new List <EmployeePayRate>(); if (reader.HasRows) { while (reader.Read()) { EmployeePayRate employeePayRate = new EmployeePayRate(); employeePayRate.ID = Convert.ToInt32(reader["ID"].ToString()); employeePayRate.EmployeeID = Convert.ToInt32(reader["EmployeeID"].ToString()); employeePayRate.StartDate = Convert.ToDateTime(reader["StartDate"].ToString()); employeePayRate.EndDate = Convert.ToDateTime(reader["EndDate"].ToString()); employeePayRate.PayRateTypeID = Convert.ToInt32(reader["PayRateTypeID"].ToString()); employeePayRate.RegularRate = Convert.ToDecimal(reader["RegularRate"] == DBNull.Value ? 0 : reader["RegularRate"]); employeePayRate.OTRate = Convert.ToDecimal(reader["OTRate"] == DBNull.Value ? 0 : reader["OTRate"]); employeePayRate.Name = reader["Name"].ToString(); EmployeePayRateList.Add(employeePayRate); } } reader.Close(); connection.Close(); return(EmployeePayRateList); } catch (Exception ex) { throw new ApplicationException(ex.Message.ToString()); } }
private void RemoveJob() { if (listBoxSelectedJobs.SelectedItem == null) { return; } FormattedListBoxItem item = listBoxSelectedJobs.SelectedItem as FormattedListBoxItem; if (item != null) { EmployeeJob job = item.ReferenceObject as EmployeeJob; if (job != null) { EmployeePayRate.Delete(SelectedEmployee.Id, job.Id); listBoxSelectedJobs.Items.Remove(listBoxSelectedJobs.SelectedItem); item = new FormattedListBoxItem(job, job.Description, true); listBoxAllJobs.Items.Add(item); listBoxAllJobs.SelectedItem = item; listBoxAllJobs.ScrollToEnd(); } } buttonRemove.IsEnabled = false; buttonAdd.IsEnabled = true; }
private FormattedListBoxItem GetJobListBoxItem(EmployeeJob employeeJob, EmployeePayRate pay) { return(new FormattedListBoxItem(employeeJob, employeeJob.Description + Environment.NewLine + pay.Wage.ToString("C2"), true)); }