//Update the existing data
public bool Update(GroupClass gc)
{
bool isSuccess = false;
SqlConnection con = new SqlConnection(myconnString);
try
{
//SQL to update in the database
String sql = "UPDATE student_groups SET academicyearsemester=@academicyearsemester, programme=@programme, groupNumber=@groupNumber, subGroupNumber=@subGroupNumber, subGroupId=@subGroupId, groupID=@groupID " +
"WHERE id = @id";
//bind values
SqlCommand cmd = new SqlCommand(sql, con);
// Console.WriteLine(gc.id);
//onsole.WriteLine(gc.yearSemester);
//Console.WriteLine(gc.programme);
//Console.WriteLine(gc.groupNumber);
cmd.Parameters.AddWithValue("@academicyearsemester", gc.yearSemester);
cmd.Parameters.AddWithValue("@programme", gc.programme);
cmd.Parameters.AddWithValue("@groupNumber", gc.groupNumber);
cmd.Parameters.AddWithValue("@subGroupNumber", gc.subgroupNumber);
cmd.Parameters.AddWithValue("@subGroupId", gc.subGroupID);
cmd.Parameters.AddWithValue("@groupID", gc.groupID);
cmd.Parameters.AddWithValue("@id", gc.id);
//Open Databse Connection
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
finally
{
con.Close();
}
return(isSuccess);
}
//Inserting data to Database
public bool Insert(GroupClass gc)
{
//Creating default return type and setting it's value to false
bool isSuccess = false;
//Connect Databse
SqlConnection con = new SqlConnection(myconnString);
try
{
//SQL query to data insert
String sql = "INSERT INTO student_groups (academicyearsemester, programme, groupNumber, subGroupNumber, subGroupId, groupID) VALUES (@academicyearsemester, @programme, " +
"@groupNumber, @subGroupNumber, @subGroupId, @groupID)";
//Creating SQL Command using sql and conn
SqlCommand cmd = new SqlCommand(sql, con);
//bind values
cmd.Parameters.AddWithValue("@academicyearsemester", gc.yearSemester);
cmd.Parameters.AddWithValue("@programme", gc.programme);
cmd.Parameters.AddWithValue("@groupNumber", gc.groupNumber);
cmd.Parameters.AddWithValue("@subGroupNumber", gc.subgroupNumber);
cmd.Parameters.AddWithValue("@subGroupId", gc.subGroupID);
cmd.Parameters.AddWithValue("@groupID", gc.groupID);
//Connection open here
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception e)
{
}
finally
{
con.Close();
}
return(isSuccess);
}
//insert consecutive sessions
public bool insert(GroupClass gs)
{
bool isSuccess = false;
//Database connection
SqlConnection con = new SqlConnection(myconnString);
try
{
//table connection
string sql = "insert into consecutive (lecture_name1, lecture_name2, tags, subject_code) select Lecture_name1, Lecture_name2, Tag, Subject_code from Session_Details ";
//Creating SQL Command using sql and conn
SqlCommand cmd = new SqlCommand(sql, con);
//bind values
cmd.Parameters.AddWithValue("@lecture_name1", gs.slec1);
cmd.Parameters.AddWithValue("@lecture_name1", gs.slec2);
cmd.Parameters.AddWithValue("@tags", gs.tags);
cmd.Parameters.AddWithValue("@subject_code", gs.subjectCode);
//Connection open here
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception e)
{
Console.WriteLine("This is the error in consecutive sessions:" + e.ToString());
}
finally
{
con.Close();
}
return(isSuccess);
}
//Delete the existing data
public bool DeleteGroups(GroupClass gc)
{
bool isSuccess = false;
SqlConnection con = new SqlConnection(myconnString);
try
{
String sql = "DELETE FROM student_groups WHERE id = @id ";
SqlCommand cmd = new SqlCommand(sql, con);
//bind values
cmd.Parameters.AddWithValue("@id", gc.id);
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception e)
{
}
finally
{
con.Close();
}
return(isSuccess);
}
