//001 public static List <Model.mdlEmployee> LoadEmployeelistReport2(string lEmployee, string lBranch) { List <String> listEmployee = new List <String>(); List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@Employee", SqlDbType = SqlDbType.NVarChar, Value = "%" + lEmployee + "%" }, new SqlParameter() { ParameterName = "@BranchID", SqlDbType = SqlDbType.NVarChar, Value = lBranch }, new SqlParameter() { ParameterName = "@DateNow", SqlDbType = SqlDbType.DateTime, Value = DateTime.Now.Date }, }; var lEmployeelist = new List <Model.mdlEmployee>(); DataTable dtEmployee = Manager.DataFacade.DTSQLCommand("SELECT EmployeeID, EmployeeName FROM Employee WHERE (EmployeeID LIKE @Employee OR EmployeeName LIKE @Employee) AND BranchID = @BranchID and (OutDate = '2000-01-01' or OutDate = '1900-01-01' or OutDate >= @DateNow) AND EmployeeTypeID='0'", sp); foreach (DataRow drEmployee in dtEmployee.Rows) { var mdllEmployee = new Model.mdlEmployee(); mdllEmployee.EmployeeID = drEmployee["EmployeeID"].ToString(); mdllEmployee.EmployeeName = drEmployee["EmployeeID"].ToString() + " - " + drEmployee["EmployeeName"].ToString(); lEmployeelist.Add(mdllEmployee); } return(lEmployeelist); }
public static List <Model.mdlEmployee> GetSearchEmployeeByBranch(string keyword, string branch) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@DateNow", SqlDbType = SqlDbType.DateTime, Value = DateTime.Now.Date }, }; var mdlEmployeeList = new List <Model.mdlEmployee>(); DataTable dtEmployee = Manager.DataFacade.DTSQLCommand(@"SELECT EmployeeID, EmployeeName, EmployeeTypeID from Employee Where BranchID IN (" + branch + ") and (EmployeeID LIKE '%" + keyword + "%' or EmployeeName LIKE '%" + keyword + "%') and (OutDate = '2000-01-01' or OutDate = '1900-01-01' or OutDate >= @DateNow) AND EmployeeTypeID='0'", sp); foreach (DataRow row in dtEmployee.Rows) { var mdlEmployee = new Model.mdlEmployee(); mdlEmployee.EmployeeID = row["EmployeeID"].ToString(); mdlEmployee.EmployeeName = row["EmployeeName"].ToString(); mdlEmployee.EmployeeTypeID = row["EmployeeTypeID"].ToString(); mdlEmployeeList.Add(mdlEmployee); } return(mdlEmployeeList); }
public static Model.mdlEmployeeList LoadEmployee() { var mdlEmployeeListnew = new Model.mdlEmployeeList(); var mdlEmployeeList = new List <Model.mdlEmployee>(); List <SqlParameter> sp = new List <SqlParameter>() { }; DataTable dtEmployee = Manager.DataFacade.DTSQLCommand("SELECT * FROM Employee", sp); foreach (DataRow drEmployee in dtEmployee.Rows) { var mdlEmployee = new Model.mdlEmployee(); mdlEmployee.EmployeeID = drEmployee["EmployeeID"].ToString(); mdlEmployee.EmployeeName = drEmployee["EmployeeName"].ToString(); mdlEmployee.EmployeeTypeID = drEmployee["EmployeeTypeID"].ToString(); mdlEmployeeList.Add(mdlEmployee); } mdlEmployeeListnew.EmployeeList = mdlEmployeeList; return(mdlEmployeeListnew); }