// Select Registration Data From Databse.
public List <RegistrationObjects> SelectRegistrationData(string username)
{
List <RegistrationObjects> ls = new List <RegistrationObjects>();
connection();
SqlCommand SelectData = new SqlCommand("SelectRegistrationData", con);
SelectData.CommandType = CommandType.StoredProcedure;
SelectData.Parameters.AddWithValue("@username", username);
SqlDataReader reader = SelectData.ExecuteReader();
if (reader.Read())
{
RegistrationObjects ob = new RegistrationObjects();
ob.RegistrationID = Convert.ToInt16(reader["RegistrationID"]);
ob.FullName = reader["FullName"].ToString();
ob.Nickname = reader["Nickname"].ToString();
ob.Username = reader["Username"].ToString();
ob.Email = reader["Email"].ToString();
ob.Password = reader["Password"].ToString();
ob.ContactNumber = reader["ContactNumber"].ToString();
ob.Age = reader["Age"].ToString();
ob.About = reader["About"].ToString();
ob.JoinDate = Convert.ToDateTime(reader["JoinDate"]).ToString();
ob.Gander = reader["Gander"].ToString();
ob.Image = reader["Image"].ToString();
ls.Add(ob);
}
reader.Close();
con.Close();
return(ls);
}
// Select Total Number of Posts From Missing People For Admin Panel.
public List <RegistrationObjects> TotalRegisterationPosts()
{
List <RegistrationObjects> ls = new List <RegistrationObjects>();
connection();
SqlCommand SelectData = new SqlCommand("SelectRegisteredCountPosts", con);
SelectData.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = SelectData.ExecuteReader();
if (reader.Read())
{
RegistrationObjects ob = new RegistrationObjects();
ob.RegistrationID = Convert.ToInt32(reader["RegistrationID"]);
ls.Add(ob);
}
con.Close();
reader.Close();
return(ls);
}
// Get Username and Image of Login User.
public List <RegistrationObjects> GetImageAndName(string username)
{
connection();
List <RegistrationObjects> ls = new List <RegistrationObjects>();
SqlCommand GetUserData = new SqlCommand("SelectRegistrationIDforMissinsgPeople", con);
GetUserData.CommandType = CommandType.StoredProcedure;
GetUserData.Parameters.AddWithValue("@username", username);
SqlDataReader reader = GetUserData.ExecuteReader();
if (reader.Read())
{
RegistrationObjects ob = new RegistrationObjects();
ob.FullName = reader["FullName"].ToString();
ob.Image = reader["Image"].ToString();
ls.Add(ob);
}
reader.Close();
con.Close();
return(ls);
}
