public int Create(EmployeeSalary obj) { SqlConnection sqlcon = new SqlConnection(Constants.ConnectionString); try { SqlCommand cmd = new SqlCommand("CreateEmployeeSalary", sqlcon); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Es_Emp_Id", obj.Es_Emp_Id); cmd.Parameters.AddWithValue("@Es_Date", obj.Es_Date); cmd.Parameters.AddWithValue("@Es_Salary", obj.Es_Salary); sqlcon.Open(); return(Convert.ToInt32(cmd.ExecuteScalar())); } catch (SqlException ex) { throw ex; } catch (Exception ex) { throw ex; } finally { sqlcon.Close(); } }
public static ArrayList List(string FromDate, string ToDate, int EmpId, string Department) { ArrayList list = new ArrayList(); SqlConnection sqlcon = new SqlConnection(Constants.ConnectionString); try { SqlCommand cmd = new SqlCommand("ListEmployeeSalary", sqlcon); cmd.Parameters.AddWithValue("@FromDate", FromDate); cmd.Parameters.AddWithValue("@ToDate", ToDate); cmd.Parameters.AddWithValue("@EmpId", EmpId); cmd.Parameters.AddWithValue("@Department", Department); cmd.CommandType = CommandType.StoredProcedure; sqlcon.Open(); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { EmployeeSalary obj = new EmployeeSalary(); obj.Es_Emp_Id = Convert.ToInt32(rd["Emp_Id"]); obj.EmployeeName = Convert.ToString(rd["Emp_Name"]); obj.Department = Convert.ToString(rd["Emp_Department"]); obj.Average = Convert.ToDecimal(rd["Average"]); list.Add(obj); } } catch (SqlException ex) { throw ex; } catch (Exception ex) { throw ex; } finally { sqlcon.Close(); } return(list); }