public ProjectProp GetHomeProject()
{
ProjectProp p = new ProjectProp();
using (SqlConnection con = new SqlConnection(connect))
{
con.Open();
SqlCommand selectOneProject = new SqlCommand("SELECT TOP 1 * FROM Project", con);
SqlDataReader reader = selectOneProject.ExecuteReader();
reader.Read();
p.Project_Id = Convert.ToInt32(reader["Id"]);
p.Project_Name = reader["Name"].ToString();
p.Project_Description = reader["Description"].ToString();
p.Project_Publisher = reader["Publisher"].ToString();
p.Project_Image = reader["Image"].ToString();
}
return(p);
}
public ProjectProp GetOneProject(int id)
{
ProjectProp p = new ProjectProp();
using (SqlConnection con = new SqlConnection(connect))
{
con.Open();
SqlCommand selectProduct = new SqlCommand("SELECT * FROM Project WHERE Id = @id", con);
selectProduct.Parameters.AddWithValue("@id", id);
SqlDataReader reader = selectProduct.ExecuteReader();
p.Project_Id = Convert.ToInt32(reader["Id"]);
p.Project_Name = reader["Name"].ToString();
p.Project_Description = reader["Description"].ToString();
p.Project_Publisher = reader["Publisher"].ToString();
p.Project_Image = reader["Image"].ToString();
}
return(p);
}
public List <ProjectProp> GetProject()
{
List <ProjectProp> projects = new List <ProjectProp>();
using (SqlConnection con = new SqlConnection(connect))
{
con.Open();
SqlCommand selectProject = new SqlCommand("SELECT * FROM Project", con);
SqlDataReader reader = selectProject.ExecuteReader();
while (reader.Read())
{
ProjectProp p = new ProjectProp();
p.Project_Id = Convert.ToInt32(reader["Id"]);
p.Project_Name = reader["Name"].ToString();
p.Project_Description = reader["Description"].ToString();
p.Project_Publisher = reader["Publisher"].ToString();
p.Project_Image = reader["Image"].ToString();
projects.Add(p);
}
}
return(projects);
}
protected void Page_Load(object sender, EventArgs e)
{
project = db.GetHomeProject();
}
