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