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); }