private static List <EmailInfo> FillEmailCollection(IDataReader reader, out int totalRecords) { List <EmailInfo> retVal; totalRecords = 0; try { retVal = ObjectHelper.FillCollection <EmailInfo>(reader, false); //Get the next result (containing the total) reader.NextResult(); //Get the total no of records from the second result if (reader.Read()) { totalRecords = Convert.ToInt32(reader[0]); } } finally { //close datareader ObjectHelper.CloseDataReader(reader, true); } return(retVal); }
public static List <LevelInfo> Search(string keyword, int pageIndex, int pageSize, out int totalRecord) { var reader = DataProvider.Instance().Levels_Search(keyword, pageIndex, pageSize); var val = ObjectHelper.FillCollection <LevelInfo>(reader, false); totalRecord = 0; try { reader.NextResult(); //Get the total no of records from the second result if (reader.Read()) { totalRecord = Convert.ToInt32(reader[0]); } } catch (Exception) { //DotNetNuke.Services.Exceptions.Exceptions.LogException(exc); } finally { //close datareader ObjectHelper.CloseDataReader(reader, true); } return(val); }
private static List <GroupInfo> FillGroupCollection(IDataReader reader, out int totalRecords) { var retVal = ObjectHelper.FillCollection <GroupInfo>(reader, false); totalRecords = 0; try { //Get the next result (containing the total) reader.NextResult(); //Get the total no of records from the second result if (reader.Read()) { totalRecords = Convert.ToInt32(reader[0]); } } catch { //DotNetNuke.Services.Exceptions.Exceptions.LogException(exc); } finally { //close datareader ObjectHelper.CloseDataReader(reader, true); } return(retVal); }
private static List <BranchInfo> FillBranchCollection(IDataReader reader, out int totalRecords) { var retVal = new List <BranchInfo>(); totalRecords = 0; try { while (reader.Read()) { //fill business object var info = new BranchInfo(); info.BranchId = ConvertHelper.ToInt32(reader["BranchId"]); info.Code = ConvertHelper.ToString(reader["Code"]); info.Name = ConvertHelper.ToString(reader["Name"]); info.LocationID = ConvertHelper.ToInt32(reader["LocationID"]); info.Description = ConvertHelper.ToString(reader["Description"]); info.Status = ConvertHelper.ToInt32(reader["Status"]); info.CreatedBy = ConvertHelper.ToInt32(reader["CreatedBy"]); info.ChangedBy = ConvertHelper.ToInt32(reader["ChangedBy"]); info.CreatedDate = ConvertHelper.ToDateTime(reader["CreatedDate"]); info.ChangedDate = ConvertHelper.ToDateTime(reader["ChangedDate"]); retVal.Add(info); } //Get the next result (containing the total) reader.NextResult(); //Get the total no of records from the second result if (reader.Read()) { totalRecords = Convert.ToInt32(reader[0]); } } catch (Exception exc) { //DotNetNuke.Services.Exceptions.Exceptions.LogException(exc); } finally { //close datareader ObjectHelper.CloseDataReader(reader, true); } return(retVal); }
private static List <ImportExcelInfo> FillImportExcelCollection(IDataReader reader, out int totalRecords) { var retVal = new List <ImportExcelInfo>(); totalRecords = 0; try { while (reader.Read()) { //fill business object var info = new ImportExcelInfo(); info.ImportId = ConvertHelper.ToInt32(reader["ImportId"]); info.UserId = ConvertHelper.ToInt32(reader["UserId"]); info.TypeId = ConvertHelper.ToInt32(reader["TypeId"]); info.ChannelId = ConvertHelper.ToInt32(reader["ChannelId"]); info.CollectorId = ConvertHelper.ToInt32(reader["CollectorId"]); info.BranchId = ConvertHelper.ToInt32(reader["BranchId"]); info.Status = ConvertHelper.ToInt32(reader["Status"]); info.FilePath = ConvertHelper.ToString(reader["FilePath"]); info.TotalRow = ConvertHelper.ToInt32(reader["TotalRow"]); info.CheckCount = ConvertHelper.ToInt32(reader["CheckCount"]); info.ErrorCount = ConvertHelper.ToInt32(reader["ErrorCount"]); info.DuplicateCount = ConvertHelper.ToInt32(reader["DuplicateCount"]); retVal.Add(info); } //Get the next result (containing the total) reader.NextResult(); //Get the total no of records from the second result if (reader.Read()) { totalRecords = Convert.ToInt32(reader[0]); } } catch (Exception exc) { //DotNetNuke.Services.Exceptions.Exceptions.LogException(exc); } finally { //close datareader ObjectHelper.CloseDataReader(reader, true); } return(retVal); }
private static List <ContactLevelInfo> FillContactLevelInfoCollection(IDataReader reader, out int totalRecords) { var retVal = new List <ContactLevelInfo>(); totalRecords = 0; try { while (reader.Read()) { //fill business object var info = new ContactLevelInfo { ContactId = ConvertHelper.ToInt32(reader["ContactId"]), EducationSchoolName = ConvertHelper.ToString(reader["EducationLevelNotes"]), WantStudyEnglish = ConvertHelper.ToBoolean(reader["WantStudy"]), HasAppointment = ConvertHelper.ToBoolean(reader["Appointment"]), ApointmentType = ConvertHelper.ToInt32(reader["ApointmentType"]), ApointmentNotes = ConvertHelper.ToString(reader["ApointmentNotes"]), }; retVal.Add(info); } //Get the next result (containing the total) reader.NextResult(); //Get the total no of records from the second result if (reader.Read()) { totalRecords = Convert.ToInt32(reader[0]); } } catch { //DotNetNuke.Services.Exceptions.Exceptions.LogException(exc); } finally { //close datareader ObjectHelper.CloseDataReader(reader, true); } return(retVal); }
private static List <T> FillCollection <T>(IDataReader reader, out int totalRecords) { List <T> retVal; totalRecords = 0; try { retVal = ObjectHelper.FillCollection <T>(reader, false); reader.NextResult(); if (reader.Read()) { totalRecords = reader[0].ToInt32(); } } finally { ObjectHelper.CloseDataReader(reader, true); } return(retVal); }
public static List <RoleInfo> Search(string keyword, int pageIndex, int pageSize, out int totalRecord) { var reader = DataProvider.Instance().Role_Search(keyword, pageIndex, pageSize); var lst = ObjectHelper.FillCollection <RoleInfo>(reader, false); totalRecord = 0; try { reader.NextResult(); //Get the total no of records from the second result if (reader.Read()) { totalRecord = Convert.ToInt32(reader[0]); } } catch (Exception ex) { } finally { ObjectHelper.CloseDataReader(reader, true); } return(lst); }
public static IEnumerable <UserInfo> Search(string username, int pageIndex, int pageSize, out int totalrecord) { var reader = DataProvider.Instance().User_Search(username, pageIndex, pageSize); var lst = ObjectHelper.FillCollection <UserInfo>(reader, false); totalrecord = 0; try { reader.NextResult(); //Get the total no of records from the second result if (reader.Read()) { totalrecord = Convert.ToInt32(reader[0]); } } catch { } finally { ObjectHelper.CloseDataReader(reader, true); } return(lst); }
private static List <PhoneInfo> FillPhonCollection(IDataReader reader, out int totalRecords) { var retVal = new List <PhoneInfo>(); totalRecords = 0; try { while (reader.Read()) { //fill business object var info = new PhoneInfo(); /* * * * info.PhoneId = ConvertHelper.ToInt32(reader["PhoneId"]); * * * * * info.ContactId = ConvertHelper.ToInt32(reader["ContactId"]); * * * * info.PhoneType = ConvertHelper.ToString(reader["PhoneType"]); * * * * * info.PhoneNumber = ConvertHelper.ToString(reader["PhoneNumber"]); * * * * * * info.IsPrimary = ConvertHelper.ToInt32(reader["IsPrimary"]); * * * */ retVal.Add(info); } //Get the next result (containing the total) reader.NextResult(); //Get the total no of records from the second result if (reader.Read()) { totalRecords = Convert.ToInt32(reader[0]); } } catch (Exception exc) { //DotNetNuke.Services.Exceptions.Exceptions.LogException(exc); } finally { //close datareader ObjectHelper.CloseDataReader(reader, true); } return(retVal); }
private static List <AppointmentInterviewInfo> FillAppointmentInterviewCollection(IDataReader reader, out int totalRecords) { var retVal = new List <AppointmentInterviewInfo>(); totalRecords = 0; try { while (reader.Read()) { //fill business object var info = new AppointmentInterviewInfo(); /* * * * info.ContactId = ConvertHelper.ToInt32(reader["ContactId"]); * * * * * info.UserId = ConvertHelper.ToInt32(reader["UserId"]); * * * * * * * * * * info.TimeSlotId = ConvertHelper.ToInt32(reader["TimeSlotId"]); * * * * info.Notes = ConvertHelper.ToString(reader["Notes"]); * * * * * * info.StatusInterviewId = ConvertHelper.ToInt32(reader["StatusInterviewId"]); * * * * * info.TeacherTypeId = ConvertHelper.ToInt32(reader["TeacherTypeId"]); * * * * * info.CasecAccountId = ConvertHelper.ToInt32(reader["CasecAccountId"]); * * * */ retVal.Add(info); } //Get the next result (containing the total) reader.NextResult(); //Get the total no of records from the second result if (reader.Read()) { totalRecords = Convert.ToInt32(reader[0]); } } finally { //close datareader ObjectHelper.CloseDataReader(reader, true); } return(retVal); }