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
}
