// Get Default Page Data From Missing Thing Table.
public List <MissingThingPageObject> GetThingDataFromDatabase()
{
List <MissingThingPageObject> ls = new List <MissingThingPageObject>();
connection();
SqlCommand DisplayData = new SqlCommand("SelectDataForDisplayMissingThingReports", con);
DisplayData.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = DisplayData.ExecuteReader();
while (reader.Read())
{
MissingThingPageObject ob = new MissingThingPageObject();
ob.ThingID = Convert.ToInt16(reader["ThingID"]);
ob.OwnerName = reader["OwnerName"].ToString();
ob.ReferenceNumber = reader["ReferenceNumber"].ToString();
ob.ContactNumber = reader["ContactNumber"].ToString();
ob.MissingDate = reader["MissingDate"].ToString();
ob.Description = reader["Description"].ToString();
ob.Image = reader["Image"].ToString();
ls.Add(ob);
}
reader.Close();
con.Close();
return(ls);
}
// Get Data for User Profile From Missing Thing Table.
public List <MissingThingPageObject> GetThingDataFromDatabase()
{
List <MissingThingPageObject> ls = new List <MissingThingPageObject>();
connection();
SqlCommand DisplayData = new SqlCommand("SelectMissingThingDataForUserProfile", con);
DisplayData.CommandType = CommandType.StoredProcedure;
DisplayData.Parameters.AddWithValue("@RegistrationID", R_ID);
SqlDataReader reader = DisplayData.ExecuteReader();
while (reader.Read())
{
MissingThingPageObject ob = new MissingThingPageObject();
ob.ThingID = Convert.ToInt32(reader["ThingID"]);
ob.OwnerName = reader["OwnerName"].ToString();
ob.OwnerCNIC = reader["OwnerCNIC"].ToString();
ob.ReferenceNumber = reader["ReferenceNumber"].ToString();
ob.ContactNumber = reader["ContactNumber"].ToString();
ob.MissingDate = reader["MissingDate"].ToString();
ob.ThingName = reader["ThingName"].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);
}
// Select Favourite Missing Thing Posts.
public List <MissingThingPageObject> DisplayFavouriteMissingThingsPosts(int ThingID)
{
// Select Missing People Poss
List <MissingThingPageObject> ls = new List <MissingThingPageObject>();
connection();
SqlCommand SelectData = new SqlCommand("SelectFavouriteMissingThingPosts", con);
SelectData.CommandType = CommandType.StoredProcedure;
SelectData.Parameters.AddWithValue("@ThingsID", ThingID);
SqlDataReader reader = SelectData.ExecuteReader();
while (reader.Read())
{
MissingThingPageObject ob = new MissingThingPageObject();
ob.ThingID = Convert.ToInt32(reader["ThingID"]);
ob.OwnerName = reader["OwnerName"].ToString();
ob.OwnerCNIC = reader["OwnerCNIC"].ToString();
ob.ReferenceNumber = reader["ReferenceNumber"].ToString();
ob.ContactNumber = reader["ContactNumber"].ToString();
ob.MissingDate = reader["MissingDate"].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);
}
// Searching data for MIssing Thing in Filter.
public List <MissingThingPageObject> SearchDataForMissingThing(string Name, string FatherGuardianName, string Contact)
{
connection();
List <MissingThingPageObject> ls = new List <MissingThingPageObject>();
SqlCommand GetData = new SqlCommand("SelectMissingThingDataForSeekingInformation", 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())
{
MissingThingPageObject ob = new MissingThingPageObject();
ob.OwnerName = reader["OwnerName"].ToString();
ob.ThingID = Convert.ToInt32(reader["ThingID"]);
ob.ThingName = reader["ThingName"].ToString();
ob.ReferenceNumber = reader["ReferenceNumber"].ToString();
ob.ContactNumber = reader["ContactNumber"].ToString();
ob.FatherGuardianName = reader["FatherGuardianName"].ToString();
ob.MissingPlace = reader["MissingPlace"].ToString();
ob.MissingDate = reader["MissingDate"].ToString();
ob.CurrentAddress = reader["CurrentAddress"].ToString();
ob.Image = reader["Image"].ToString();
ls.Add(ob);
}
return(ls);
reader.Close();
con.Close();
}
// Select All Data for Missing Thing Table.
public List <MissingThingPageObject> SelectMissingThingMethod()
{
List <MissingThingPageObject> ls = new List <MissingThingPageObject>();
connection();
SqlCommand SelectData = new SqlCommand("SelectAllDataOFMissingThings", con);
SelectData.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = SelectData.ExecuteReader();
while (reader.Read())
{
MissingThingPageObject ob = new MissingThingPageObject();
ob.ThingID = Convert.ToInt16(reader["ThingID"]);
ob.Count = Convert.ToInt16(reader["Count"]);
ob.RegistrationID = Convert.ToInt16(reader["RegistrationID"]);
ob.ReferenceNumber = reader["ReferenceNumber"].ToString();
ob.OwnerName = reader["OwnerName"].ToString();
ob.OwnerCNIC = reader["OwnerCNIC"].ToString();
ob.FatherGuardianName = reader["FatherGuardianName"].ToString();
ob.FatherGuardianCNIC = reader["FatherGuardianCNIC"].ToString();
ob.ContactNumber = reader["ContactNumber"].ToString();
ob.AnotherContactNumber = reader["AnotherContactNumber"].ToString();
ob.PermanentAddress = reader["PermanentAddress"].ToString();
ob.CurrentAddress = reader["CurrentAddress"].ToString();
ob.ThingName = reader["ThingName"].ToString();
ob.CompanyName = reader["CompanyName"].ToString();
ob.MissingPlace = reader["MissingPlace"].ToString();
ob.MissingDate = reader["MissingDate"].ToString();
ob.BrandName = reader["BrandName"].ToString();
ob.EngineNumber = reader["EngineNumber"].ToString();
ob.ChassesNumber = reader["ChassesNumber"].ToString();
ob.Color = reader["Color"].ToString();
ob.Model = reader["Model"].ToString();
ob.IMEI = reader["IMEI"].ToString();
ob.CNICNumber = reader["CNICNumber"].ToString();
ob.UniqueIdentification = reader["UniqueIdentification"].ToString();
ob.DateOfBirth = reader["DateOfBirth"].ToString();
ob.FamilyNumber = reader["FamilyNumber"].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);
}
// Get Things Data Through Query String.
public List <MissingThingPageObject> GetThingsDataUsingQueryString(int ThingID)
{
connection();
List <MissingThingPageObject> ls = new List <MissingThingPageObject>();
SqlCommand GetData = new SqlCommand("SelectMissinfThingDataForQueryString", con);
GetData.CommandType = CommandType.StoredProcedure;
GetData.Parameters.AddWithValue("@ThingID", ThingID);
SqlDataReader reader = GetData.ExecuteReader();
if (reader.Read())
{
MissingThingPageObject ob = new MissingThingPageObject();
ob.ThingID = Convert.ToInt16(reader["ThingID"]);
ob.Count = Convert.ToInt16(reader["Count"]);
ob.RegistrationID = Convert.ToInt16(reader["RegistrationID"]);
ob.ReferenceNumber = reader["ReferenceNumber"].ToString();
ob.OwnerName = reader["OwnerName"].ToString();
ob.FatherGuardianName = reader["FatherGuardianName"].ToString();
ob.ContactNumber = reader["ContactNumber"].ToString();
ob.AnotherContactNumber = reader["AnotherContactNumber"].ToString();
ob.PermanentAddress = reader["PermanentAddress"].ToString();
ob.CurrentAddress = reader["CurrentAddress"].ToString();
ob.ThingName = reader["ThingName"].ToString();
ob.CompanyName = reader["CompanyName"].ToString();
ob.MissingPlace = reader["MissingPlace"].ToString();
ob.MissingDate = reader["MissingDate"].ToString();
ob.BrandName = reader["BrandName"].ToString();
ob.EngineNumber = reader["EngineNumber"].ToString();
ob.ChassesNumber = reader["ChassesNumber"].ToString();
ob.Color = reader["Color"].ToString();
ob.Model = reader["Model"].ToString();
ob.IMEI = reader["IMEI"].ToString();
ob.CNICNumber = reader["CNICNumber"].ToString();
ob.UniqueIdentification = reader["UniqueIdentification"].ToString();
ob.DateOfBirth = reader["DateOfBirth"].ToString();
ob.FamilyNumber = reader["FamilyNumber"].ToString();
ob.Description = reader["Description"].ToString();
ob.Gander = reader["Gander"].ToString();
ob.Status = reader["Status"].ToString();
ob.Image = reader["Image"].ToString();
ls.Add(ob);
}
reader.Close();
con.Close();
return(ls);
}
public List <MissingThingPageObject> SelectThingNameForEditPost(int ThingID)
{
connection();
List <MissingThingPageObject> ls = new List <MissingThingPageObject>();
SqlCommand cmd = new SqlCommand("SelectMissingThingDataOnID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ThingID", ThingID);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
MissingThingPageObject ob = new MissingThingPageObject();
ob.ThingName = reader["ThingName"].ToString();
ls.Add(ob);
}
con.Close();
reader.Close();
return(ls);
}
// Select Total Number of Posts From Missing Thing For Admin Panel.
public List <MissingThingPageObject> TotalMissingThingPosts()
{
List <MissingThingPageObject> ls = new List <MissingThingPageObject>();
connection();
SqlCommand SelectData = new SqlCommand("SelectMissingThingCountPosts", con);
SelectData.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = SelectData.ExecuteReader();
if (reader.Read())
{
MissingThingPageObject ob = new MissingThingPageObject();
ob.ThingID = Convert.ToInt32(reader["ThingID"]);
ls.Add(ob);
}
con.Close();
reader.Close();
return(ls);
}
// To Display a Most Viwed Missing Thing Post in Pouplar Section.
public List <MissingThingPageObject> GetDataForPopularThingPost()
{
connection();
List <MissingThingPageObject> ls = new List <MissingThingPageObject>();
SqlCommand DisplayData = new SqlCommand("SelectPopularThingPostData", con);
DisplayData.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = DisplayData.ExecuteReader();
if (reader.Read())
{
MissingThingPageObject ob = new MissingThingPageObject();
ob.ThingID = Convert.ToInt16(reader["ThingID"]);
ob.OwnerName = reader["OwnerName"].ToString();
ob.ContactNumber = reader["ContactNumber"].ToString();
ob.MissingPlace = reader["MissingPlace"].ToString();
ob.Image = reader["Image"].ToString();
ob.Description = reader["Description"].ToString();
ls.Add(ob);
}
reader.Close();
con.Close();
return(ls);
}
