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