private void DeleteAllAssignedEmployeesByWorksheetID(int worksheetID) { SqlCommand command = new SqlCommand("spDeleteAllAssignedEmployeesByWorksheetID"); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@WorksheetID", worksheetID)); DatabaseController.ExecuteNonQuerySP(command); }
private void CreateEmployeeQualification(int employeeID, QualificationType qualificationType) { SqlCommand command = new SqlCommand("spInsertEmployeeQualification"); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@EmployeeID", employeeID)); command.Parameters.Add(new SqlParameter("@QualificationType", qualificationType.ToString())); DatabaseController.ExecuteNonQuerySP(command); }
public void Delete(Employee employee) { SqlCommand command = new SqlCommand("spDeleteEmployee"); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@ID", employee.ID)); DatabaseController.ExecuteNonQuerySP(command); }
public void Delete(Worksheet worksheet) { SqlCommand command = new SqlCommand("spDeleteWorksheet"); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@ID", worksheet.ID)); DatabaseController.ExecuteNonQuerySP(command); }
public void Delete(Customer customer) { SqlCommand command = new SqlCommand("spDeleteCustomer"); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@ID", customer.ID)); DatabaseController.ExecuteNonQuerySP(command); }
private void CreateAssignedEmployee(int employeeID, int worksheetID) { SqlCommand command = new SqlCommand("spInsertAssignedEmployee"); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@WorksheetID", worksheetID)); command.Parameters.Add(new SqlParameter("@EmployeeID", employeeID)); DatabaseController.ExecuteNonQuerySP(command); }
public void Update(Employee employee) { SqlCommand command = new SqlCommand("spUpdateEmployee"); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@ID", employee.ID)); command.Parameters.Add(new SqlParameter("@FirstName", employee.Name.FirstName)); command.Parameters.Add(new SqlParameter("@LastName", employee.Name.LastName)); UpdateQualificationsForEmployee(employee); DatabaseController.ExecuteNonQuerySP(command); }
private void UpdateQualificationsForEmployee(Employee employee) { SqlCommand command = new SqlCommand("spDeleteAllEmployeeQualificationsByID"); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@EmployeeID", employee.ID)); DatabaseController.ExecuteNonQuerySP(command); foreach (QualificationType qualificationType in employee.Qualifications) { CreateEmployeeQualification(employee.ID, qualificationType); } }
public void Update(Customer customer) { SqlCommand command = new SqlCommand("spUpdateCustomer"); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@ID", customer.ID)); command.Parameters.Add(new SqlParameter("@FirstName", customer.Name.FirstName)); command.Parameters.Add(new SqlParameter("@LastName", customer.Name.LastName)); command.Parameters.Add(new SqlParameter("@Address", customer.Address.Street)); command.Parameters.Add(new SqlParameter("@City", customer.Address.City)); command.Parameters.Add(new SqlParameter("@ZIPcode", customer.Address.ZIPcode)); command.Parameters.Add(new SqlParameter("@PhoneNumber", customer.PhoneNumber)); command.Parameters.Add(new SqlParameter("@Email", customer.Email)); DatabaseController.ExecuteNonQuerySP(command); }
public void Update(Worksheet worksheet) { SqlCommand command = new SqlCommand("spUpdateWorksheet"); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@WorksheetID", worksheet.ID)); command.Parameters.Add(new SqlParameter("@CustomerID", worksheet.Customer.ID)); command.Parameters.Add(new SqlParameter("@Workplace", worksheet.Workplace)); command.Parameters.Add(new SqlParameter("@StartDateTime", worksheet.StartDateTime)); command.Parameters.Add(new SqlParameter("@EndDateTime", worksheet.EndDateTime)); command.Parameters.Add(new SqlParameter("@WorkDescription", worksheet.WorkDescription)); command.Parameters.Add(new SqlParameter("@IsGuarantee", worksheet.IsGuarantee)); command.Parameters.Add(new SqlParameter("@StatusType", worksheet.Status.ToString())); UpdateAssignedEmployees(worksheet); DatabaseController.ExecuteNonQuerySP(command); }