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