public List <JCS_DataInterface.Models.Administration.UserAccount> dbSearch(string searchKey)
{
List <DbParameter> parameters = new List <DbParameter>();
parameters.Add(_sqlConn.GetParameter("middlename", searchKey));
parameters.Add(_sqlConn.GetParameter("lastname", searchKey));
parameters.Add(_sqlConn.GetParameter("firstname", searchKey));
List <JCS_DataInterface.Models.Administration.UserAccount> result = new List <JCS_DataInterface.Models.Administration.UserAccount>();
JCS_DataInterface.Models.Administration.UserAccount resultItem = new JCS_DataInterface.Models.Administration.UserAccount();
try
{
using (DbDataReader dataReader = _sqlConn.GetDataReader("SELECT user_account_id ,user_level ,user_branch ,user_login ,user_accesskey ,user_status ,firstname " +
" ,middlename ,lastname ,address ,created_on ,updated_on ,created_by ,updated_by ,employee_reference, password_reset,phone, isAir, isSea, isBranch FROM User_Account WHERE middlename LIKE '%'+@middlename+'%' OR firstname LIKE '%'+@firstname+'%' OR lastname LIKE '%'+@lastname+'%'", parameters, System.Data.CommandType.Text))
{
while (dataReader.Read())
{
resultItem = new Models.Administration.UserAccount();
resultItem._userAccountID = dataReader["user_account_id"].ToString();
resultItem._userLevel = dataReader["user_level"].ToString();
resultItem._userBranch = dataReader["user_branch"].ToString();
resultItem._userLogin = dataReader["user_login"].ToString();
resultItem._userAccessKey = dataReader["user_accesskey"].ToString();
resultItem._userStatus = dataReader["user_status"].ToString();
resultItem._firstname = dataReader["firstname"].ToString();
resultItem._middlename = dataReader["middlename"].ToString();
resultItem._lastname = dataReader["lastname"].ToString();
resultItem._address = dataReader["address"].ToString();
resultItem._createdOn = dataReader["created_on"].ToString();
resultItem._updatedOn = dataReader["updated_on"].ToString();
resultItem._createdBy = dataReader["created_by"].ToString();
resultItem._updatedBy = dataReader["employee_reference"].ToString();
resultItem._passwordReset = dataReader["password_reset"].ToString();
resultItem._phoneNumber = dataReader["phone"].ToString();
resultItem._isAir = dataReader["isAir"].ToString();
resultItem._isSea = dataReader["isSea"].ToString();
resultItem._isBranch = dataReader["isBranch"].ToString();
result.Add(resultItem);
}
return(result);
}
}
catch (Exception ex)
{
resultItem._firstname = "Error on JCS_DataInterface.iUserAccount.dbSearch :=> " + ex.Message.ToString();
result.Add(resultItem);
return(result);
}
}
public UserView(JCS_DataInterface.Models.Administration.UserAccount ua)
{
branch = new JCS_DataInterface.Interface.Administration.iSystemBranch("").dbGet(ua._userBranch);
}