public bool Delete(ClassNotAvailableTimes NoTimes)
{
bool c = false;
SqlConnection conn = new SqlConnection(myconnstring);
try
{
string sql = "DELETE FROM TimeT WHERE Id = @id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@id", NoTimes.Id);
conn.Open();
int row = cmd.ExecuteNonQuery();
if (row > 0)
{
c = true;
}
else
{
c = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(c);
}
public bool Update(ClassNotAvailableTimes NoTimes)
{
//Create a default return type and set its default value to false
bool isSuccess = false;
//Step 1 : Connect database
SqlConnection conn = new SqlConnection(myconnstring);
try
{
//Sql command to update data in the database
string sql = "update TimeT set SeLecturer=@comboBoxNo1, SeGroup=@comboBoxNo2, SeSubGroup=@comboBoxNo3, SeSessionID=@comboBoxNo4, SeTimeDuration=@comboBoxNo5 where Id = @id";
//Creating cmd using sql & conn
SqlCommand cmd = new SqlCommand(sql, conn);
//Create Parameters to Add Data
cmd.Parameters.AddWithValue("@id", NoTimes.Id);
cmd.Parameters.AddWithValue("@comboBoxNo1", NoTimes.SeLecturer);
cmd.Parameters.AddWithValue("@comboBoxNo2", NoTimes.SeGroup);
cmd.Parameters.AddWithValue("@comboBoxNo3", NoTimes.SeSubGroup);
cmd.Parameters.AddWithValue("@comboBoxNo4", NoTimes.SeSessionID);
cmd.Parameters.AddWithValue("@comboBoxNo5", NoTimes.SeTimeDuration);
//Connection Open
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show("Error!!!");
}
finally
{
conn.Close();
}
return(isSuccess);
}
//Inserting Data into Database
public bool Insert(ClassNotAvailableTimes NoTimes)
{
//Creating a default return type and setting its value to false
bool isSuccess = false;
//Step 1 : Connect database
SqlConnection conn = new SqlConnection(myconnstring);
try
{
//Step 2: Create sql query to inert data
String sql = "Insert Into TimeT(SeLecturer, SeGroup, SeSubGroup, SeSessionID, SeTimeDuration) Values(@comboBoxNo1, @comboBoxNo2, @comboBoxNo3, @comboBoxNo4, @comboBoxNo5)";
//Creating cmd using sql & conn
SqlCommand cmd = new SqlCommand(sql, conn);
//Create Parameters to Add Data
cmd.Parameters.AddWithValue("@comboBoxNo1", NoTimes.SeLecturer);
cmd.Parameters.AddWithValue("@comboBoxNo2", NoTimes.SeGroup);
cmd.Parameters.AddWithValue("@comboBoxNo3", NoTimes.SeSubGroup);
cmd.Parameters.AddWithValue("@comboBoxNo4", NoTimes.SeSessionID);
cmd.Parameters.AddWithValue("@comboBoxNo5", NoTimes.SeTimeDuration);
//Connection Open
conn.Open();
int rows = cmd.ExecuteNonQuery();
//If the query runs successfully then the value of rows will be greater than 0 else its value will be 0
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
finally
{
conn.Close();
}
return(isSuccess);
}