public static List <EmployeeSalary> FindByEmployee(decimal Id)
{
List <EmployeeSalary> list = new List <EmployeeSalary>();
string cmdText = "FindEmployeeSalaryByEmployee_sp";
SqlConnection con = new SqlConnection(CommonConstant.CONNECTIONSTRING);
SqlCommand cmd = new SqlCommand(cmdText, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("EmpSal_Employee", Id);
SqlDataReader dr;
con.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
EmployeeSalary obj = new EmployeeSalary();
obj.EmpSal_Id = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("EmpSal_Id")));
obj.EmpSal_Employee = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("EmpSal_Employee")));
obj.EmpSal_EmployeeName = Convert.ToString(dr.GetValue(dr.GetOrdinal("EmpSal_EmployeeName")));
obj.EmpSal_Salary = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("EmpSal_Salary")));
obj.EmpSal_StartDate = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("EmpSal_StartDate")));
obj.EmpSal_EndDate = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("EmpSal_EndDate")));
list.Add(obj);
}
if (!dr.IsClosed)
{
dr.Close();
}
con.Close();
return(list);
}
public static decimal Add(EmployeeSalary obj)
{
decimal Id = 0;
string cmdText = "AddEmployeeSalary_sp";
SqlConnection con = new SqlConnection(CommonConstant.CONNECTIONSTRING);
SqlCommand cmd = new SqlCommand(cmdText, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("EmpSal_Employee", obj.EmpSal_Employee);
cmd.Parameters.AddWithValue("EmpSal_Salary", obj.EmpSal_Salary);
cmd.Parameters.AddWithValue("EmpSal_StartDate", obj.EmpSal_StartDate);
cmd.Parameters.AddWithValue("EmpSal_EndDate", obj.EmpSal_EndDate);
con.Open();
Id = Convert.ToDecimal(cmd.ExecuteScalar());
con.Close();
return(Id);
}
public static int Update(EmployeeSalary obj)
{
int count = 0;
string cmdText = "UpdateEmployeeSalary_sp";
SqlConnection con = new SqlConnection(CommonConstant.CONNECTIONSTRING);
SqlCommand cmd = new SqlCommand(cmdText, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("EmpSal_Id", obj.EmpSal_Id);
cmd.Parameters.AddWithValue("EmpSal_Employee", obj.EmpSal_Employee);
cmd.Parameters.AddWithValue("EmpSal_Salary", obj.EmpSal_Salary);
cmd.Parameters.AddWithValue("EmpSal_StartDate", obj.EmpSal_StartDate);
cmd.Parameters.AddWithValue("EmpSal_EndDate", obj.EmpSal_EndDate);
con.Open();
count = cmd.ExecuteNonQuery();
con.Close();
return(count);
}