// Select Favourite Unidentified People Posts.
public List <UnidentifiedPeoplePageObject> DisplayFavouriteUnidentifiedPeoplePosts(int UnidentifiedID)
{
// Select Missing People Poss
List <UnidentifiedPeoplePageObject> ls = new List <UnidentifiedPeoplePageObject>();
connection();
SqlCommand SelectData = new SqlCommand("SelectFavouriteUnidentifiedPosts", con);
SelectData.CommandType = CommandType.StoredProcedure;
SelectData.Parameters.AddWithValue("@UnidentifiedID", UnidentifiedID);
SqlDataReader reader = SelectData.ExecuteReader();
while (reader.Read())
{
UnidentifiedPeoplePageObject ob = new UnidentifiedPeoplePageObject();
ob.UnindentifiedID = Convert.ToInt32(reader["UnindentifiedID"]);
ob.FullName = reader["FullName"].ToString();
ob.ReferenceNumber = reader["ReferenceNumber"].ToString();
ob.ContactNumber = reader["ContactNumber"].ToString();
ob.FoundPlace = reader["FoundPlace"].ToString();
ob.Religion = reader["Religion"].ToString();
ob.Image = reader["Image"].ToString();
ob.Status = reader["Status"].ToString();
ob.Count = Convert.ToInt32(reader["Count"]);
ls.Add(ob);
}
reader.Close();
con.Close();
return(ls);
}
// Get Data for User Profile From Unidentified People Table.
public List <UnidentifiedPeoplePageObject> GetUnidentifiedPeopleDataFromDatabase()
{
List <UnidentifiedPeoplePageObject> ls = new List <UnidentifiedPeoplePageObject>();
connection();
SqlCommand DisplayData = new SqlCommand("SelectUnidentifiedPeopleDataForUserProfile", con);
DisplayData.CommandType = CommandType.StoredProcedure;
DisplayData.Parameters.AddWithValue("@RegistrationID", R_ID);
SqlDataReader reader = DisplayData.ExecuteReader();
while (reader.Read())
{
UnidentifiedPeoplePageObject ob = new UnidentifiedPeoplePageObject();
ob.UnindentifiedID = Convert.ToInt32(reader["UnindentifiedID"]);
ob.FullName = reader["FullName"].ToString();
ob.ReferenceNumber = reader["ReferenceNumber"].ToString();
ob.ContactNumber = reader["ContactNumber"].ToString();
ob.FoundPlace = reader["FoundPlace"].ToString();
ob.Religion = reader["Religion"].ToString();
ob.Image = reader["Image"].ToString();
ob.Status = reader["Status"].ToString();
ob.Count = Convert.ToInt32(reader["Count"]);
ls.Add(ob);
}
reader.Close();
con.Close();
return(ls);
}
// Get Default Page Data From Unidentified People Table.
public List <UnidentifiedPeoplePageObject> GetUnidentifiedPeopleDataFromDatabase()
{
List <UnidentifiedPeoplePageObject> ls = new List <UnidentifiedPeoplePageObject>();
connection();
SqlCommand DisplayData = new SqlCommand("SelectDataForDisplayUnidentifiedPeople", con);
DisplayData.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = DisplayData.ExecuteReader();
while (reader.Read())
{
UnidentifiedPeoplePageObject ob = new UnidentifiedPeoplePageObject();
ob.UnindentifiedID = Convert.ToInt16(reader["UnindentifiedID"]);
ob.FullName = reader["FullName"].ToString();
ob.ReferenceNumber = reader["ReferenceNumber"].ToString();
ob.ContactNumber = reader["ContactNumber"].ToString();
ob.FoundPlace = reader["FoundPlace"].ToString();
ob.Description = reader["Description"].ToString();
ob.Image = reader["Image"].ToString();
ls.Add(ob);
}
reader.Close();
con.Close();
return(ls);
}
// Searching data for Unidentified People in Filter.
public List <UnidentifiedPeoplePageObject> SearchDataForUnidentifiedPeople(string Name, string FatherGuardianName, string Contact)
{
connection();
List <UnidentifiedPeoplePageObject> ls = new List <UnidentifiedPeoplePageObject>();
SqlCommand GetData = new SqlCommand("SelectUnidentifiedPeopleDataForSeekingInformation", con);
GetData.CommandType = CommandType.StoredProcedure;
GetData.Parameters.AddWithValue("@Name", Name);
GetData.Parameters.AddWithValue("@FatherGuardianName", FatherGuardianName);
GetData.Parameters.AddWithValue("@Contact", Contact);
SqlDataReader reader = GetData.ExecuteReader();
while (reader.Read())
{
UnidentifiedPeoplePageObject ob = new UnidentifiedPeoplePageObject();
ob.FullName = reader["FullName"].ToString();
ob.UnindentifiedID = Convert.ToInt32(reader["UnindentifiedID"]);
ob.ReferenceNumber = reader["ReferenceNumber"].ToString();
ob.ContactNumber = reader["ContactNumber"].ToString();
ob.FatherGuardianName = reader["FatherGuardianName"].ToString();
ob.FoundPlace = reader["FoundPlace"].ToString();
ob.Language = reader["Language"].ToString();
ob.ClothColor = reader["ClothColor"].ToString();
ob.Age = reader["Age"].ToString();
ob.Gander = reader["Gander"].ToString();
ob.Image = reader["Image"].ToString();
ls.Add(ob);
}
return(ls);
reader.Close();
con.Close();
}
// Select Total Number of Posts From Unidentified People For Admin Panel.
public List <UnidentifiedPeoplePageObject> TotalUnidentifiedPeoplePosts()
{
List <UnidentifiedPeoplePageObject> ls = new List <UnidentifiedPeoplePageObject>();
connection();
SqlCommand SelectData = new SqlCommand("SelectUnidentifiedPeopleCountPosts", con);
SelectData.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = SelectData.ExecuteReader();
if (reader.Read())
{
UnidentifiedPeoplePageObject ob = new UnidentifiedPeoplePageObject();
ob.UnindentifiedID = Convert.ToInt32(reader["UnindentifiedID"]);
ls.Add(ob);
}
con.Close();
reader.Close();
return(ls);
}
// Searching data for Unidentified People in Admin Panel.
public List <UnidentifiedPeoplePageObject> SearchUnidentifiedPeopleDataInAdminPanel(string Name)
{
connection();
List <UnidentifiedPeoplePageObject> ls = new List <UnidentifiedPeoplePageObject>();
SqlCommand GetData = new SqlCommand("SelectUnidentifiedPeopleDataForSearch", con);
GetData.CommandType = CommandType.StoredProcedure;
GetData.Parameters.AddWithValue("@Name", Name);
SqlDataReader reader = GetData.ExecuteReader();
while (reader.Read())
{
UnidentifiedPeoplePageObject ob = new UnidentifiedPeoplePageObject();
ob.UnindentifiedID = Convert.ToInt16(reader["UnindentifiedID"]);
ob.Count = Convert.ToInt16(reader["Count"]);
ob.RegistrationID = Convert.ToInt16(reader["RegistrationID"]);
ob.ReferenceNumber = reader["ReferenceNumber"].ToString();
ob.FullName = reader["FullName"].ToString();
ob.FatherGuardianName = reader["FatherGuardianName"].ToString();
ob.ContactNumber = reader["ContactNumber"].ToString();
ob.Religion = reader["Religion"].ToString();
ob.Age = reader["Age"].ToString();
ob.UniqueIdentification = reader["UniqueIdentification"].ToString();
ob.FoundPlace = reader["FoundPlace"].ToString();
ob.Language = reader["Language"].ToString();
ob.ClothColor = reader["ClothColor"].ToString();
ob.EyesColor = reader["EyesColor"].ToString();
ob.Description = reader["Description"].ToString();
ob.Gander = reader["Gander"].ToString();
ob.Status = reader["Status"].ToString();
ob.Image = reader["Image"].ToString();
ls.Add(ob);
}
return(ls);
reader.Close();
con.Close();
}
// Select All Data for Unidentified People.
public List <UnidentifiedPeoplePageObject> SelectUnidentifiedPeopleMethod()
{
List <UnidentifiedPeoplePageObject> ls = new List <UnidentifiedPeoplePageObject>();
connection();
SqlCommand SelectData = new SqlCommand("SelectAllDataOFUnidetifiedPeople", con);
SelectData.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = SelectData.ExecuteReader();
while (reader.Read())
{
UnidentifiedPeoplePageObject ob = new UnidentifiedPeoplePageObject();
ob.UnindentifiedID = Convert.ToInt16(reader["UnindentifiedID"]);
ob.Count = Convert.ToInt16(reader["Count"]);
ob.RegistrationID = Convert.ToInt16(reader["RegistrationID"]);
ob.ReferenceNumber = reader["ReferenceNumber"].ToString();
ob.FullName = reader["FullName"].ToString();
ob.FatherGuardianName = reader["FatherGuardianName"].ToString();
ob.ContactNumber = reader["ContactNumber"].ToString();
ob.Religion = reader["Religion"].ToString();
ob.Age = reader["Age"].ToString();
ob.UniqueIdentification = reader["UniqueIdentification"].ToString();
ob.FoundPlace = reader["FoundPlace"].ToString();
ob.Language = reader["Language"].ToString();
ob.ClothColor = reader["ClothColor"].ToString();
ob.EyesColor = reader["EyesColor"].ToString();
ob.Description = reader["Description"].ToString();
ob.Gander = reader["Gander"].ToString();
ob.Image = reader["Image"].ToString();
ob.Status = reader["Status"].ToString();
ls.Add(ob);
}
con.Close();
reader.Close();
return(ls);
}
