public List <CategoryClass> GetCategoryClasses(string Id_Category)
{
string sql;
if (string.IsNullOrEmpty(Id_Category))
{
sql = "SELECT * FROM CourseManagerment";
}
else
{
sql = "SELECT * FROM CourseManagerment WHERE Id_CateCourse =" + Id_Category;
}
List <CategoryClass> cateList = new List <CategoryClass>();
DataTable dt = new DataTable();
SqlConnection con = db.GetConnection();
SqlDataAdapter da = new SqlDataAdapter(sql, con);
con.Open();
da.Fill(dt);
da.Dispose();
con.Close();
CategoryClass tmpCate;
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpCate = new CategoryClass();
tmpCate.Id_Cate = Convert.ToInt32(dt.Rows[i]["Id_CateCourse"].ToString());
tmpCate.Name = dt.Rows[i]["Name"].ToString();
tmpCate.Description = dt.Rows[i]["Description"].ToString();
cateList.Add(tmpCate);
}
return(cateList);
}
public void DeleteCategory(CategoryClass cate)
{
string sql = "DELETE CourseManagerment WHERE Id_CateCourse =" + cate.Id_Cate;
SqlConnection con = db.GetConnection();
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public void UpdateCategory(CategoryClass cate)
{
string sql = "UPDATE CourseManagerment SET Name='" + cate.Name + "',Description='" + cate.Description + "' WHERE Id_Account= " + cate.Id_Cate;
SqlConnection con = db.GetConnection();
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public void AddCategory(CategoryClass cate)
{
string sql = "INSERT INTO CourseManagerment(Name, Description) VALUES('" + cate.Name + "','" + cate.Description + "')";
SqlConnection con = db.GetConnection();
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}