public void UpdateEmployee(EmployeeModal employee)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand("updateEmployee", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EmpId", employee.EmpId);
cmd.Parameters.AddWithValue("@EmpName", employee.EmpName);
cmd.Parameters.AddWithValue("@Email", employee.Email);
cmd.Parameters.AddWithValue("@Salary", employee.Salary);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
public List <EmployeeModal> getData()
{
List <EmployeeModal> employeeList = new List <EmployeeModal>();
using (SqlConnection conn = new SqlConnection(connectionString))
{
string query = "select * from [dbo].[Employee]";
conn.Open();
using (SqlCommand command = new SqlCommand(query, conn))
{
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
EmployeeModal emp = new EmployeeModal();
emp.EmpId = Convert.ToInt32(reader.GetValue(0).ToString());
emp.EmpName = reader.GetValue(1).ToString();
emp.Email = reader.GetValue(2).ToString();
emp.Salary = Convert.ToInt32(reader.GetValue(3).ToString());
employeeList.Add(emp);
}
}
}
return(employeeList);
}
