public double UpdateEmployeeSalary(SalaryUpdateModel salaryUpdateModel) { SqlConnection SalaryConnection = new SqlConnection(connectionString); double salary = 0; try { using (SalaryConnection) { SalaryDetailModel displayModel = new SalaryDetailModel(); SqlCommand command = new SqlCommand("spUpdateEmployeeSalary", SalaryConnection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@id", salaryUpdateModel.EmployeeId); command.Parameters.AddWithValue("@name", salaryUpdateModel.EmployeeName); command.Parameters.AddWithValue("@salary", salaryUpdateModel.EmployeeSalary); SalaryConnection.Open(); SqlDataReader dr = command.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { displayModel.EmployeeId = dr.GetInt32(0); displayModel.EmployeeName = dr.GetString(1); displayModel.SalaryId = dr.GetInt32(2); displayModel.EmployeeSalary = Convert.ToDouble(dr.GetDecimal(3)); Console.WriteLine("{0}, {1}, {2}, {3}", displayModel.EmployeeId, displayModel.EmployeeName, displayModel.SalaryId, displayModel.EmployeeSalary); Console.WriteLine("\n"); salary = displayModel.EmployeeSalary; } } else { Console.WriteLine("No data found"); } dr.Close(); SalaryConnection.Close(); } } catch (Exception e) { throw new Exception(e.Message); } finally { SalaryConnection.Close(); } return(salary); }
public int UpdateEmployeeSalary(SalaryUpdateModel salaryUpdateModel) { SqlConnection SalaryConnection = ConnectionSetup(); int salary = 0; try { using (SalaryConnection) { SalaryDetailModel displayModel = new SalaryDetailModel(); SqlCommand command = new SqlCommand("spUpdateEmployeeSalary", SalaryConnection); command.CommandType = System.Data.CommandType.StoredProcedure; var cmd = new SqlCommand("Select Id from Employee where Name='Terissa'", SalaryConnection); SalaryConnection.Open(); var reader = cmd.ExecuteReader(); if (reader.Read()) { salaryUpdateModel.SalaryId = Convert.ToInt32(reader.GetInt32(0)); } reader.Close(); command.Parameters.AddWithValue("@id", salaryUpdateModel.SalaryId); command.Parameters.AddWithValue("@salary", salaryUpdateModel.EmployeeSalary); SqlDataReader dr = command.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { displayModel.EmployeeId = Convert.ToInt32(dr["Id"]); displayModel.EmployeeName = dr["Name"].ToString(); displayModel.EmployeeSalary = Convert.ToInt32(dr["Salary"]); Console.WriteLine(displayModel.EmployeeId + " " + displayModel.EmployeeName + " " + displayModel.EmployeeSalary); Console.WriteLine("\n"); salary = displayModel.EmployeeSalary; } } else { Console.WriteLine("No data found."); } } return(salary); } catch (Exception e) { throw new Exception(e.Message); } finally { SalaryConnection.Close(); } }
/// <summary> /// Ability to update the salary i.e. the base pay for Employee Terisa to 3000000.00 and sync it with Database using ADO.NET ConnectionString /// </summary> /// <param name="updateModel"></param> /// <returns></returns> public int UpdateEmployeeSalary(SalaryUpdateModel updateModel) { int salary = 0; try { EmployeeModel employeeModel = new EmployeeModel(); using (this.sqlconnection) { SqlCommand command = new SqlCommand("spUpdateEmployeeSalary", sqlconnection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@SalaryId", updateModel.SalaryId); command.Parameters.AddWithValue("@SalaryMonth", updateModel.SalaryMonth); command.Parameters.AddWithValue("@Salary", updateModel.Salary); command.Parameters.AddWithValue("@EmpId", updateModel.EmpId); this.sqlconnection.Open(); SqlDataReader sqlDataReader = command.ExecuteReader(); if (sqlDataReader.HasRows) { while (sqlDataReader.Read()) { employeeModel.EmpId = Convert.ToInt32(sqlDataReader["EmpId"]); employeeModel.EmpName = sqlDataReader["EmpName"].ToString(); employeeModel.SalaryMonth = sqlDataReader["SalaryMonth"].ToString(); employeeModel.Salary = Convert.ToInt32(sqlDataReader["Salary"]); employeeModel.SalaryId = Convert.ToInt32(sqlDataReader["SalaryId"]); Console.WriteLine("{0},{1},{2},{3},{4}", employeeModel.EmpId, employeeModel.EmpName, employeeModel.SalaryMonth, employeeModel.Salary, employeeModel.SalaryId); salary = (int)employeeModel.Salary; } } } } catch (Exception exception) { throw new Exception(exception.Message); } finally { this.sqlconnection.Close(); } return(salary); }
public int UpdateEmployeeSalary(SalaryUpdateModel salaryUpdateModel) { SqlConnection SalaryConnection = ConnectionSetup(); try { using (SalaryConnection) { SalaryConnection.Open(); SqlCommand command = new SqlCommand("sqUpdateEmployeeSalary", SalaryConnection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@id", salaryUpdateModel.EmployeeId); command.Parameters.AddWithValue("@salary", salaryUpdateModel.EmployeeSalary); SqlDataReader dr = command.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { int empId = Convert.ToInt32(dr["empId"]); if (empId == salaryUpdateModel.EmployeeId) { return(Convert.ToInt32(dr["basicPay"])); } } } } } catch (Exception e) { throw new Exception(e.Message); } finally { SalaryConnection.Close(); } return(0); }
static void Main(string[] args) { Console.WriteLine("Welcome to Employee Payroll Service!"); EmployeeRepo employeeRepo = new EmployeeRepo(); EmployeeModel employeeModel = new EmployeeModel(); SalaryUpdateModel updateModel = new SalaryUpdateModel(); ///Get All Employee present in Employee_Payroll table employeeRepo.GetAllEmployee(); ///Update Employee Salary employeeModel.SalaryId = 1; employeeModel.SalaryMonth = "Jan"; employeeModel.Salary = 500000.00; employeeModel.EmpId = 2; employeeRepo.UpdateEmployeeSalary(updateModel); ///Get All Employee in a particular data range employeeRepo.GetAllEmployeeInADataRange(); ///Get data by Gender employeeRepo.GetDataByGroupByGender(); ///Add Employee Details employeeModel.EmpName = "Appu"; employeeModel.Salary = 500000.00; employeeModel.Start_Date = Convert.ToDateTime("12/05/2020"); employeeModel.Gender = 'F'; employeeModel.Phone_Number = "9877553212"; employeeModel.Employee_Address = "Kharadi"; employeeModel.Department = "Tetsing"; employeeModel.Basic_Pay = 8765.00; employeeModel.Deductions = 9876.00; employeeModel.Taxable_Pay = 97765.00; employeeModel.Income_Tax = 7654.00; employeeModel.Net_Pay = 6543.00; employeeModel.EmpId = 6; employeeModel.DeptId = 7; employeeModel.DeptName = "Development"; employeeModel.DeptLocation = "Pune"; employeeModel.SalaryMonth = "Jan"; ///Add Employee in Employee_Payroll table employeeRepo.AddEmployee(employeeModel); ///Remove particular employee entry using EmpId employeeRepo.RemoveEmployee(); ///Get Employee Details present in Employee table employeeRepo.GetAllEmployeeDetails(); ///Get Department details from Department table employeeRepo.GetAllDepartment(); ///Get Salary of Employee from Salary table employeeRepo.GetEmployeeSalary(); ///Get Data by Gender using joins employeeRepo.GetDataByGroupByGenderER(); Console.WriteLine("Employee Payroll using Threads"); ///retrieve url string[] words = CreateWordArray(@"http://www.gutenberg.org/files/54700/54700-0.txt"); #region ParallelTasks Parallel.Invoke (() => { Console.WriteLine("Begin First Task..."); GetLongestWord(words); }, () => { Console.WriteLine("Begin Second Task..."); GetMostCommonWords(words); }, //close second action () => { Console.WriteLine("Begin Third Task..."); GetCountForWord(words, "Sleep"); } //close third action ); //close parallel.invoke #endregion }