public int UpdateEmployeeSalary(SalaryUpdateModel model)
{
SqlConnection SalaryConnection = ConnectionSetup();
int salary = 0;
try
{
using (SalaryConnection)
{
SalaryDetailModel displayModel = new SalaryDetailModel();
//define the SqlCommand object
SqlCommand command = new SqlCommand("spUpdateEmployeeSalary", SalaryConnection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@id", model.SalaryId);
command.Parameters.AddWithValue("@month", model.Month);
command.Parameters.AddWithValue("@salary", model.EmployeeSalary);
command.Parameters.AddWithValue("@EmpId", model.EmployeeId);
SalaryConnection.Open();
SqlDataReader dr = command.ExecuteReader();
//check if there are records
if (dr.HasRows)
{
while (dr.Read())
{
displayModel.EmployeeId = Convert.ToInt32(dr["EmpId"]);
displayModel.EmployeeName = dr["ENAME"].ToString();
displayModel.JobDiscription = dr["JOB"].ToString();
displayModel.EmployeeSalary = Convert.ToInt32(dr["EMPSAL"]);
displayModel.Month = dr["SAL_MONTH"].ToString();
displayModel.SalaryId = Convert.ToInt32(dr["SALARYId"]);
//display retrieved record
Console.WriteLine("{0},{1},{2}", displayModel.EmployeeName, displayModel.EmployeeSalary, displayModel.Month);
Console.WriteLine("\n");
salary = displayModel.EmployeeSalary;
}
}
else
{
Console.WriteLine("No data found.");
}
//close data reader
dr.Close();
SalaryConnection.Close();
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
SalaryConnection.Close();
}
return(salary);
}
public void GivenSalaryDetails_AbleToUpdateSalaryDetails()
{
Salary salary = new Salary();
SalaryUpdateModel updateModel = new SalaryUpdateModel()
{
EmployeeId = 1,
EmployeeSalary = 10067,
};
int empsalary = salary.UpdateEmployeeSalary(updateModel);
Assert.AreEqual(10067, empsalary);
}
public void GivenSalaryDetails_AbleToUpdateDetails()
{
EmployeeRepo employeeRepo = new EmployeeRepo();
SalaryUpdateModel updateModel = new SalaryUpdateModel()
{
EmployeeId = 101,
EmployeeName = "Cyan",
EmployeeSalary = 1500.34
};
double EmpSalary = employeeRepo.UpdateEmployeeSalary(updateModel);
Assert.AreEqual(updateModel.EmployeeSalary, EmpSalary);
}
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;
command.Parameters.AddWithValue("@id", salaryUpdateModel.SalaryId);
command.Parameters.AddWithValue("@month", salaryUpdateModel.Month);
command.Parameters.AddWithValue("@salary", salaryUpdateModel.EmployeeSalary);
command.Parameters.AddWithValue("@EmpId", salaryUpdateModel.EmployeeId);
SalaryConnection.Open();
SqlDataReader dr = command.ExecuteReader();
//salary = salaryUpdateModel.EmployeeSalary;
if (dr.HasRows)
{
while (dr.Read())
{
displayModel.EmployeeId = Convert.ToInt32(dr["EmpId"]);
displayModel.EmployeeName = dr["ENAME"].ToString();
displayModel.JobDescription = dr["jOB"].ToString();
displayModel.EmployeeSalary = Convert.ToInt32(dr["EMPSAL"]);
displayModel.Month = dr["SAL_MONTH"].ToString();
displayModel.SalaryId = Convert.ToInt32(dr["SALARYId"]);
Console.WriteLine(displayModel.EmployeeName + " " + displayModel.EmployeeSalary + " " + displayModel.Month);
Console.WriteLine("\n");
salary = displayModel.EmployeeSalary;
}
}
else
{
Console.WriteLine("No data found.");
}
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
SalaryConnection.Close();
}
return(salary);
}
public int UpdateSalary(SalaryUpdateModel model)
{
try
{
int salary = 0;
using (this.connection)
{
SalaryDetailsModel displayModel = new SalaryDetailsModel();
SqlCommand command = new SqlCommand("dbo.spUpdateSalary", this.connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@id", model.SalaryId);
command.Parameters.AddWithValue("@month", model.Month);
command.Parameters.AddWithValue("@salary", model.EmployeeSalary);
command.Parameters.AddWithValue("@EmpId", model.EmployeeId);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
displayModel.EmployeeId = reader.GetInt32(0);
displayModel.EmployeeName = reader["EmployeeName"].ToString();
displayModel.JobDiscription = reader["JobDiscription"].ToString();
displayModel.Month = reader["Month"].ToString();
displayModel.SalaryId = reader.GetInt32(4);
displayModel.EmployeeSalary = reader.GetInt32(5);
Console.WriteLine("EmployeeId={0}\nEmployeeName={1}\nEmployeeSalary={2}\nMonth={3}\nSalaryId={5}\nJobDescription={4}", displayModel.EmployeeId, displayModel.EmployeeName, displayModel.EmployeeSalary, displayModel.Month, displayModel.JobDiscription, displayModel.SalaryId);
Console.WriteLine("\n");
salary = displayModel.EmployeeSalary;
}
}
else
{
Console.WriteLine("No data found");
}
reader.Close();
return(salary);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
connection.Close();
}
}
public void GivenSalaryDetails_AbleToUpdateSalaryDetails()
{
EmployeeRepo employeeRepo = new EmployeeRepo();
SalaryUpdateModel updateModel = new SalaryUpdateModel()
{
SalaryId = 1,
SalaryMonth = "Jan",
Salary = 500000,
EmpId = 2
};
int EmpSalary = employeeRepo.UpdateEmployeeSalary(updateModel);
Assert.AreEqual(updateModel.Salary, EmpSalary);
}
public void GivenSalaryDataAbleToUpdateSalaryDetails()
{
Salary salary = new Salary();
SalaryUpdateModel updateModel = new SalaryUpdateModel()
{
SalaryId = 2,
Month = "Jan",
EmployeeSalary = 1300,
EmployeeId = 5
};
int EmpSalary = salary.UpdateEmployeeSalary(updateModel);
Assert.AreEqual(updateModel.EmployeeSalary, EmpSalary);
}
public void GivenSalaryDetails_AbleToUpdateSalarayDetails()
{
EmployeeRepository salary = new EmployeeRepository();
SalaryUpdateModel updateModel = new SalaryUpdateModel()
{
SalaryId = 1,
Month = "Jan",
EmployeeSalary = 120,
EmployeeId = 1
};
int EmpSalary = salary.UpdateSalary(updateModel);
Assert.AreEqual(updateModel.EmployeeSalary, EmpSalary);
}
public void GivenSalaryDataAbleToUpdateSalaryDetails()
{
Salary salary = new Salary();
SalaryUpdateModel updateModel = new SalaryUpdateModel()
{
salaryId = 2,
Month = "Jan",
EmployeeSalary = 1300,
EmployeeId = 5
};
int EmpSalary = salary.UpdateEmployeeSalary(updateModel);
Microsoft.VisualStudio.TestTools.UnitTesting.Assert.AreEqual(updateModel.EmployeeSalary, EmpSalary);
}
