public List<EmployeeMaster> GetEmployeeList() { List<EmployeeMaster> emplist = new List<EmployeeMaster>(); DataSet ds = new DataSet(); string strconn = "";// cons.GetConnectionString; OleDbConnection conn = new OleDbConnection(strconn); OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM vw_GetEmployeeMaster", conn); da.Fill(ds, "EmployeeMaster"); foreach (DataRow dr in ds.Tables[0].Rows) { EmployeeMaster emp = new EmployeeMaster() { EmpId = Convert.ToInt32(dr["EmpId"].ToString()), FirstName = dr["FirstName"].ToString(), MiddleName = dr["MiddleName"].ToString(), LastName = dr["LastName"].ToString(), RoleId = Convert.ToInt32(dr["RoleId"].ToString()), RoleName = dr["RoleName"].ToString(), BranchId = Convert.ToInt32(dr["BranchId"].ToString()), BranchName = dr["BranchName"].ToString() }; emplist.Add(emp); } return emplist; }
public EmployeeMaster GetEmployeeByEmpId(int EmpId) { EmployeeMaster emp = new EmployeeMaster(); DataSet ds = new DataSet(); OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\VJLomiDB.mdb;Jet OLEDB:Database Password=vj@dmin"); OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM vw_GetEmployeeMaster WHERE EmpId=" + EmpId, conn); da.Fill(ds, "EmployeeMaster"); EmployeeMaster objemp = new EmployeeMaster(); foreach (DataRow dr in ds.Tables[0].Rows) { emp.EmpId = Convert.ToInt32(dr["EmpId"].ToString()); emp.FirstName = dr["FirstName"].ToString(); emp.MiddleName = dr["MiddleName"].ToString(); emp.LastName = dr["LastName"].ToString(); emp.RoleId = Convert.ToInt32(dr["RoleId"].ToString()); emp.RoleName = dr["RoleName"].ToString(); emp.BranchId = Convert.ToInt32(dr["BranchId"].ToString()); emp.BranchName = dr["BranchName"].ToString(); } return emp; }
public EmployeeMaster GetEmployeeByEmpId(int empid) { EmployeeMaster emp = new EmployeeMaster(); DAEmployeeMaster daemp = new DAEmployeeMaster(); emp = daemp.GetEmployeeByEmpId(empid); return emp; }
public List<EmployeeMaster> GetEmployeeNameList() { List<EmployeeMaster> emplist = new List<EmployeeMaster>(); DataSet ds = new DataSet(); OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\VJLomiDB.mdb;Jet OLEDB:Database Password=vj@dmin"); OleDbDataAdapter da = new OleDbDataAdapter("SELECT EmpId, FirstName, MiddleName, LastName FROM EmployeeMaster WHERE Status = 'A' AND RoleId <> 1 ORDER BY LastName", conn); da.Fill(ds, "EmployeeMaster"); foreach (DataRow dr in ds.Tables[0].Rows) { EmployeeMaster emp = new EmployeeMaster() { EmpId = Convert.ToInt32(dr["EmpId"].ToString()), FirstName = dr["FirstName"].ToString(), MiddleName = dr["MiddleName"].ToString(), LastName = dr["LastName"].ToString(), }; emplist.Add(emp); } return emplist; }
private void LoadEmployeeByEmpId(int empid) { EmployeeMaster emp = new EmployeeMaster(); BSEmployeeMaster bsemp = new BSEmployeeMaster(); emp = bsemp.GetEmployeeByEmpId(empid); txtBranchName.Text = emp.BranchName; }