//Delete Method
public bool Delete(LecturerClass l, int id)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(myconnstring);
try
{
string sql = "DELETE FROM Lecturer_Table WHERE ID = @ID";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@ID", id);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Open();
cmd.ExecuteNonQuery();
isSuccess = true;
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return(isSuccess);
}
//Update Method
public Boolean Update(LecturerClass l, int id)
{
SqlConnection conn = new SqlConnection(myconnstring);
try
{
string sql = "UPDATE Lecturer_Table SET Title = @Title, FirstName = @FirstName, LastName = @LastName, Faculty = @Faculty, Department = @Department, LecturerID = @LecturerID, Center = @Center, Building = @Building, LecturerLevel = @LecturerLevel, Rank = @Rank, ActiveDays=@ActiveDays, ActiveTimes=@ActiveTimes WHERE ID = @ID";
SqlCommand cmd = new SqlCommand(sql, conn);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
cmd.Parameters.AddWithValue("@ID", id);
cmd.Parameters.AddWithValue("@Title", l.Title);
cmd.Parameters.AddWithValue("@FirstName", l.FirstName);
cmd.Parameters.AddWithValue("@LastName", l.LastName);
cmd.Parameters.AddWithValue("@Faculty", l.Faculty);
cmd.Parameters.AddWithValue("@Department", l.Department);
cmd.Parameters.AddWithValue("@LecturerID", l.LecturerID);
cmd.Parameters.AddWithValue("@Center", l.Center);
cmd.Parameters.AddWithValue("@Building", l.Building);
cmd.Parameters.AddWithValue("@LecturerLevel", l.LecturerLevel);
cmd.Parameters.AddWithValue("@Rank", l.Rank);
cmd.Parameters.AddWithValue("@ActiveDays", l.ActiveDays);
cmd.Parameters.AddWithValue("@ActiveTimes", l.ActiveTimes);
conn.Open();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
conn.Close();
}
}
//Insert Method
public bool Insert(LecturerClass l)
{
SqlConnection conn = new SqlConnection(myconnstring);
try
{
string sql = "insert into Lecturer_Table(Title, FirstName, LastName, Faculty, Department, LecturerID, Center, Building, LecturerLevel, Rank , ActiveDays, ActiveTimes) " +
"values (@Title, @FirstName, @LastName, @Faculty, @Department, @LecturerID, @Center, @Building, @LecturerLevel, @Rank , @ActiveDays, @ActiveTimes)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Title", l.Title);
cmd.Parameters.AddWithValue("@FirstName", l.FirstName);
cmd.Parameters.AddWithValue("@LastName", l.LastName);
cmd.Parameters.AddWithValue("@Faculty", l.Faculty);
cmd.Parameters.AddWithValue("@Department", l.Department);
cmd.Parameters.AddWithValue("@LecturerID", l.LecturerID);
cmd.Parameters.AddWithValue("@Center", l.Center);
cmd.Parameters.AddWithValue("@Building", l.Building);
cmd.Parameters.AddWithValue("@LecturerLevel", l.LecturerLevel);
cmd.Parameters.AddWithValue("@Rank", l.Rank);
cmd.Parameters.AddWithValue("@ActiveDays", l.ActiveDays);
cmd.Parameters.AddWithValue("@ActiveTimes", l.ActiveTimes);
conn.Open();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
conn.Close();
}
}
