public List <StudentLogEntityDC> GetAllStudentLogs(string Search, string AccountID, string StartDate, string EndDate, int PageIndex, int PageSize, out int Count) { List <StudentLogEntityDC> productResponse = new List <StudentLogEntityDC>(); StudentLogEntityDC member = new StudentLogEntityDC(); LogDAL LogsDAL = new LogDAL(); productResponse = LogsDAL.GetAllStudentLogs(Search, AccountID, StartDate, EndDate, PageIndex, PageSize, out Count); return(productResponse); }
public List <StudentLogEntityDC> GetAllStudentLogs(string Search, string AccountID, string StartDate, string EndDate, int PageIndex, int PageSize, out int Count) { StudentLogListEntity Members = new StudentLogListEntity(); List <StudentLogEntityDC> MemberList = new List <StudentLogEntityDC>(); using (DbConnection conn = Reedley.CreateConnection()) { conn.Open(); try { using (DbCommand sprocCmd = conn.CreateCommand()) { sprocCmd.CommandType = CommandType.StoredProcedure; sprocCmd.CommandText = sp_GetAllStudentLogs; sprocCmd.Parameters.Add(new SqlParameter("@Search", Search.ToStringDefault()) { SqlDbType = SqlDbType.NVarChar }); if (AccountID != "") { sprocCmd.Parameters.Add(new SqlParameter("@AccountID", AccountID.ToGuid()) { SqlDbType = SqlDbType.UniqueIdentifier }); } if (StartDate != "" && StartDate != null) { sprocCmd.Parameters.Add(new SqlParameter("@DateTimeStart", StartDate.ToDateTime()) { SqlDbType = SqlDbType.DateTime }); } if (EndDate != "" && EndDate != null) { sprocCmd.Parameters.Add(new SqlParameter("@DateTimeEnd", EndDate.ToDateTime()) { SqlDbType = SqlDbType.DateTime }); } sprocCmd.Parameters.Add(new SqlParameter("@PageIndex", PageIndex.ToInt()) { SqlDbType = SqlDbType.Int }); sprocCmd.Parameters.Add(new SqlParameter("@PageSize", PageSize.ToInt()) { SqlDbType = SqlDbType.Int }); var CountResult = sprocCmd.CreateParameter(); CountResult.ParameterName = "@Count"; CountResult.Direction = ParameterDirection.Output; CountResult.DbType = DbType.Int32; sprocCmd.Parameters.Add(CountResult); using (IDataReader sprocReader = Reedley.ExecuteReader(sprocCmd)) { while (sprocReader.Read()) { StudentLogEntityDC Member = new StudentLogEntityDC(); Member.MemberID = sprocReader["MemberID"].ToGuid(); Member.FirstName = sprocReader["FirstName"].ToStringDefault(); Member.LastName = sprocReader["LastName"].ToStringDefault(); Member.IDNumber = sprocReader["IDNumber"].ToStringDefault(); Member.Affiliation = sprocReader["Affiliation"].ToStringDefault(); Member.Department = sprocReader["Department"].ToStringDefault(); Member.RFID = sprocReader["RFID"].ToStringDefault(); Member.DateTimeStamp = sprocReader["DateTimeStamp"].ToStringDefault(); Member.LogType = sprocReader["LogType"].ToStringDefault(); Member.GateTerminalName = sprocReader["GateTerminalName"].ToStringDefault(); MemberList.Add(Member); } } Members.StudentLogList = MemberList; Count = CountResult.Value.ToInt(); } } catch (Exception ex) { throw ex; } finally { if (conn != null) { conn.Close(); } } } return(MemberList); }