public Employee Find(int id) { var com = new DaoComponent(); DataRow row = com.FindRecord(id); var emp = new Employee { EmpID = Convert.ToInt32(row[0]), EmpName = row[1].ToString(), EmpAddress = row[2].ToString(), EmpPhone = Convert.ToInt64(row[3]), EmpSalary = Convert.ToDouble(row[4]) }; return(emp); }
public List <Employee> GetAllEmployees() { var com = new DaoComponent(); var table = com.GetAllRecords(); List <Employee> list = new List <Employee>(); foreach (DataRow row in table.Rows) { var emp = new Employee { EmpID = Convert.ToInt32(row[0]), EmpName = row[1].ToString(), EmpAddress = row[2].ToString(), EmpPhone = Convert.ToInt64(row[3]), EmpSalary = Convert.ToDouble(row[4]) }; list.Add(emp); } return(list); }
public void InsertEmployee(Employee e) { var com = new DaoComponent(); com.InsertRecord(e.EmpID, e.EmpName, e.EmpAddress, e.EmpPhone, e.EmpSalary); }
public void Update(Employee e) { var com = new DaoComponent(); com.UpdateRecord(e.EmpID, e.EmpName, e.EmpAddress, e.EmpPhone, e.EmpSalary); }