// Search Report Sighting Data. public List <ReportSightingPageObjects> SearchReportSightingData(string Name) { List <ReportSightingPageObjects> ls = new List <ReportSightingPageObjects>(); connection(); SqlCommand SelectData = new SqlCommand("SelectReportSightingDataForAdminPanelSearch", con); SelectData.CommandType = CommandType.StoredProcedure; SelectData.Parameters.AddWithValue("@Name", Name); SqlDataReader reader = SelectData.ExecuteReader(); while (reader.Read()) { ReportSightingPageObjects ob = new ReportSightingPageObjects(); ob.SightingID = Convert.ToInt32(reader["SightingID"]); ob.RegistrationID = Convert.ToInt32(reader["RegistrationID"]); ob.ReferenceNumber = reader["ReferenceNumber"].ToString(); ob.MissingThingName = reader["MissingThingName"].ToString(); ob.MissingPersonName = reader["MissingPersonName"].ToString(); ob.CompanyName = reader["CompanyName"].ToString(); ob.BrandName = reader["BrandName"].ToString(); ob.Color = reader["Color"].ToString(); ob.CNICNumber = reader["CNICNumber"].ToString(); ob.CNICFamilyNumber = reader["CNICFamilyNumber"].ToString(); ob.FoundDate = reader["FoundDate"].ToString(); ob.FoundPlace = reader["FoundPlace"].ToString(); ob.CCTVCamera = reader["CCTVCamera"].ToString(); ob.Clothes = reader["Clothes"].ToString(); ob.Advertisement = reader["Advertisement"].ToString(); ob.Image = reader["Image"].ToString(); ob.Gander = reader["Gander"].ToString(); ob.YourName = reader["YourName"].ToString(); ob.EmailAddress = reader["EmailAddress"].ToString(); ob.ContactNumber = reader["ContactNumber"].ToString(); ob.CurrentAddress = reader["CurrentAddress"].ToString(); ob.AskQuestion = reader["AskQuestions"].ToString(); ls.Add(ob); } con.Close(); reader.Close(); return(ls); }
// Select Total Number of Posts From Report SIghting For Admin Panel. public List <ReportSightingPageObjects> TotalReportSightingPosts() { List <ReportSightingPageObjects> ls = new List <ReportSightingPageObjects>(); connection(); SqlCommand SelectData = new SqlCommand("SelectSightingReportsCountPosts", con); SelectData.CommandType = CommandType.StoredProcedure; SqlDataReader reader = SelectData.ExecuteReader(); if (reader.Read()) { ReportSightingPageObjects ob = new ReportSightingPageObjects(); ob.SightingID = Convert.ToInt32(reader["SightingID"]); ls.Add(ob); } con.Close(); reader.Close(); return(ls); }