// Select Feedback Data For Admin Panel.
public List <FeedbackPageObjects> SelectFeedbackDataForAdminPanel()
{
List <FeedbackPageObjects> ls = new List <FeedbackPageObjects>();
connection();
SqlCommand SelectData = new SqlCommand("SelectAllDataOfFeedback", con);
SelectData.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = SelectData.ExecuteReader();
while (reader.Read())
{
FeedbackPageObjects ob = new FeedbackPageObjects();
ob.FeedbackID = Convert.ToInt32(reader["FeedbackID"]);
ob.RegistrationID = Convert.ToInt32(reader["RegistrationID"]);
ob.VisitWebsite = reader["VisitWebsite"].ToString();
ob.FindYourNeed = reader["FindYourNeed"].ToString();
ob.EasyToFind = reader["EasyToFind"].ToString();
ob.YourOpinion = reader["YourOpinion"].ToString();
ob.Likelihood = reader["Likelihood"].ToString();
ob.Suggestions = reader["Suggestions"].ToString();
ls.Add(ob);
}
con.Close();
reader.Close();
return(ls);
}
// Select Total Number of Posts From Missing People For Admin Panel.
public List <FeedbackPageObjects> TotalFeedbacks()
{
List <FeedbackPageObjects> ls = new List <FeedbackPageObjects>();
connection();
SqlCommand SelectData = new SqlCommand("SelectFeedbackCountPosts", con);
SelectData.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = SelectData.ExecuteReader();
if (reader.Read())
{
FeedbackPageObjects ob = new FeedbackPageObjects();
ob.FeedbackID = Convert.ToInt32(reader["FeedbackID"]);
ls.Add(ob);
}
con.Close();
reader.Close();
return(ls);
}
