public List <CourseClass> GetCourseClasses(string Id_Course) { string sql; if (string.IsNullOrEmpty(Id_Course)) { sql = "SELECT Course.Id_Course, Course.Name, Course.Description, Course.Id_CateCourse, CourseManagerment.Name FROM Course LEFT JOIN CourseManagerment on Course.Id_CateCourse=CourseManagerment.Id_CateCourse"; } else { sql = "SELECT Course.Id_Course, Course.Name, Course.Description, Course.Id_CateCourse, CourseManagerment.Name FROM Course LEFT JOIN CourseManagerment on Course.Id_CateCourse=CourseManagerment.Id_CateCoursee WHERE Course.Id_Course=" + Id_Course; } List <CourseClass> cList = new List <CourseClass>(); DataTable dt = new DataTable(); SqlConnection con = db.GetConnection(); SqlDataAdapter da = new SqlDataAdapter(sql, con); con.Open(); da.Fill(dt); da.Dispose(); con.Close(); CourseClass tmpC; for (int i = 0; i < dt.Rows.Count; i++) { tmpC = new CourseClass(); tmpC.Id_Course = Convert.ToInt32(dt.Rows[i]["Id_Course"].ToString()); tmpC.Name = dt.Rows[i]["Name"].ToString(); tmpC.Description = dt.Rows[i]["Description"].ToString(); tmpC.Id_CateCourse = Convert.ToInt32(dt.Rows[i]["Id_CateCourse"].ToString()); tmpC.CateCourse = dt.Rows[i]["Name"].ToString(); cList.Add(tmpC); } return(cList); }
public void AddCourse(CourseClass c) { string sql = "INSERT INTO Course (Name, Description, Id_CateCourse) VALUES('" + c.Name + "','" + c.Description + "','" + c.Id_CateCourse + "')"; SqlConnection con = db.GetConnection(); SqlCommand cmd = new SqlCommand(sql, con); con.Open(); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }
public void DeleteCourse(CourseClass c) { string sql = "DELETE Course WHERE Id_Course =" + c.Id_Course; SqlConnection con = db.GetConnection(); SqlCommand cmd = new SqlCommand(sql, con); con.Open(); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }
public void UpdateCourse(CourseClass c) { string sql = "UPDATE Course SET Name='" + c.Name + "',Description='" + c.Description + "',Id_CateCourse='" + c.Id_CateCourse + "' WHERE Id_Account= " + c.Id_Course; SqlConnection con = db.GetConnection(); SqlCommand cmd = new SqlCommand(sql, con); con.Open(); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }