public int UpdateEmployee(SalaryDetailModel model) { int salary = 0; try { using (connection) { connection = new SqlConnection(connectionstring); SalaryDetailModel displayModel = new SalaryDetailModel(); SqlCommand command = new SqlCommand("Sp_UpdateEmployee_Payroll", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@S_id", model.SalaryId); //command.Parameters.AddWithValue("@EmployeeName", model.EmployeeName); //command.Parameters.AddWithValue("@Designation", model.Designation); command.Parameters.AddWithValue("@salary", model.Salary); command.Parameters.AddWithValue("@month", model.Month); command.Parameters.AddWithValue("@E_id", model.EmployeeId); connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { displayModel.EmployeeId = reader.GetInt32(0); displayModel.EmployeeName = reader.GetString(1); displayModel.Designation = reader.GetString(2); displayModel.Month = reader.GetString(3); displayModel.SalaryId = reader.GetInt32(4); displayModel.Salary = reader.GetInt32(5); salary = displayModel.Salary; } } else { Console.WriteLine("No Data found"); } reader.Close(); return(salary); } } catch (Exception e) { Console.WriteLine(e.Message); connection.Close(); return(0); } finally { connection.Close(); } }
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(); } }
public SalaryDetailModel getEmployeeObject(string empName) { SalaryDetailModel salaryDetail = new SalaryDetailModel(); SqlConnection SalaryConnection = ConnectionSetup(); try { using (SalaryConnection) { SalaryConnection.Open(); SqlCommand command = new SqlCommand("sqRetrieveEmployeeSalary", SalaryConnection); SqlDataReader dr = command.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { String Employeename = dr["empName"].ToString(); if (Employeename.Equals(empName)) { salaryDetail.EmployeeName = empName; salaryDetail.EmployeeId = (int)dr["empId"]; salaryDetail.EmployeeSalary = Convert.ToDouble(dr["basicPay"]); salaryDetail.Deductions = Convert.ToDouble(dr["deductions"]); salaryDetail.TaxablePay = Convert.ToDouble(dr["taxablePay"]); salaryDetail.NetPay = Convert.ToDouble(dr["netPay"]); salaryDetail.tax = Convert.ToDouble(dr["tax"]); } } } } } catch (Exception exception) { throw new Exception(exception.Message); } finally { SalaryConnection.Close(); } return(salaryDetail); }