//Delete Method
public bool Delete(SubjectClass s, int id)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(myconnstring);
try
{
string sql = "DELETE FROM Subject_Table WHERE SubjectID = @SubjectID";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@SubjectID", id);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Open();
cmd.ExecuteNonQuery();
isSuccess = true;
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return(isSuccess);
}
//Insert Method
public bool Insert(SubjectClass s)
{
bool isSuccess = true;
SqlConnection conn = new SqlConnection(myconnstring);
try
{
string sql = "insert into Subject_Table( OfferedYear, OfferedSemester, SubjectName, SubjectCode, LectureHours, TutorialHours, LabHours, EvaluationHours, OfferedLecturer) " +
"values (@OfferedYear, @OfferedSemester, @SubjectName, @SubjectCode, @LectureHours, @TutorialHours, @LabHours, @EvaluationHours, @OfferedLecturer)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@OfferedYear", s.OfferedYear);
cmd.Parameters.AddWithValue("@OfferedSemester", s.OfferedSemester);
cmd.Parameters.AddWithValue("@SubjectName", s.SubjectName);
cmd.Parameters.AddWithValue("@SubjectCode", s.SubjectCode);
cmd.Parameters.AddWithValue("@LectureHours", s.LectureHours);
cmd.Parameters.AddWithValue("@TutorialHours", s.TutorialHours);
cmd.Parameters.AddWithValue("@LabHours", s.LabHours);
cmd.Parameters.AddWithValue("@EvaluationHours", s.EvaluationHours);
cmd.Parameters.AddWithValue("@OfferedLecturer", s.OfferedLecturer);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return(isSuccess);
}
//Update Method
public bool Update(SubjectClass s, int id)
{
SqlConnection conn = new SqlConnection(myconnstring);
try
{
string sql = "UPDATE Subject_Table SET OfferedYear = @OfferedYear, OfferedSemester = @OfferedSemester, SubjectName = @SubjectName, SubjectCode = @SubjectCode, LectureHours = @LectureHours, TutorialHours = @TutorialHours, LabHours = @LabHours, EvaluationHours = @EvaluationHours, OfferedLecturer = @OfferedLecturer WHERE SubjectID = @SubjectID";
SqlCommand cmd = new SqlCommand(sql, conn);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
cmd.Parameters.AddWithValue("@SubjectID", id);
cmd.Parameters.AddWithValue("@OfferedYear", s.OfferedYear);
cmd.Parameters.AddWithValue("@OfferedSemester", s.OfferedSemester);
cmd.Parameters.AddWithValue("@SubjectName", s.SubjectName);
cmd.Parameters.AddWithValue("@SubjectCode", s.SubjectCode);
cmd.Parameters.AddWithValue("@LectureHours", s.LectureHours);
cmd.Parameters.AddWithValue("@TutorialHours", s.TutorialHours);
cmd.Parameters.AddWithValue("@LabHours", s.LabHours);
cmd.Parameters.AddWithValue("@EvaluationHours", s.EvaluationHours);
cmd.Parameters.AddWithValue("@OfferedLecturer", s.OfferedLecturer);
conn.Open();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
conn.Close();
}
}
