//Methord to Update record in database from app
public bool updatesession(ClassSession s)
{
//Creating a deult return type and setting its value to false
bool isSuccess = false;
//Database Connection
SqlConnection con = new SqlConnection(myconstr);
try
{
//Update query
String sql = "UPDATE Session SET Faculty=@faculty,Lecturer1=@txtLecturer1,Lecturer2=@txtLecturer2,SubjectCode=@subcode,SubjectName=@subname,GroupID=@gid,SubGroupID=@subgid,Tag=@tag,Year=@year,NumOfStu=@noofstu,Duration=@duration,SessionCode=@generate WHERE Id=@txtId";
SqlCommand cmd = new SqlCommand(sql, con);
//Create parameter to ad data
cmd.Parameters.AddWithValue("@txtId", s.ID);
cmd.Parameters.AddWithValue("@faculty", s.Faculty);
cmd.Parameters.AddWithValue("@txtLecturer1", s.lecturer1);
cmd.Parameters.AddWithValue("@txtLecturer2", s.lecturer2);
cmd.Parameters.AddWithValue("@subcode", s.SubjectCode);
cmd.Parameters.AddWithValue("@subname", s.SubjectName);
cmd.Parameters.AddWithValue("@gid", s.GID);
cmd.Parameters.AddWithValue("@subgid", s.SubGID);
cmd.Parameters.AddWithValue("@tag", s.Tag);
cmd.Parameters.AddWithValue("@year", s.Year);
cmd.Parameters.AddWithValue("@noofstu", s.noOfStu);
cmd.Parameters.AddWithValue("@duration", s.Duration);
cmd.Parameters.AddWithValue("@generate", s.Generate);
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
finally
{
con.Close();
}
return(isSuccess);
}
//Methord to Insert record into database
public bool insertSession(ClassSession s)
{
//Creating a deult return type and setting its value to false
bool isSuccess = false;
//Database Connection
SqlConnection con = new SqlConnection(myconstr);
try
{
//Insert query
String sql2 = "INSERT INTO Session (Faculty,Lecturer1,Lecturer2,SubjectCode,SubjectName,GroupID,SubGroupID,Tag,Year,NumOfStu,Duration,SessionCode) VALUES (@faculty,@txtLecturer1,@txtLecturer2,@subcode,@subname,@gid,@subgid,@tag,@year,@noofstu,@duration,@generate)";
SqlCommand cmd = new SqlCommand(sql2, con);
//Create parameter to ad data
cmd.Parameters.AddWithValue("@faculty", s.Faculty);
cmd.Parameters.AddWithValue("@txtLecturer1", s.lecturer1);
cmd.Parameters.AddWithValue("@txtLecturer2", s.lecturer2);
cmd.Parameters.AddWithValue("@subcode", s.SubjectCode);
cmd.Parameters.AddWithValue("@subname", s.SubjectName);
cmd.Parameters.AddWithValue("@gid", s.GID);
cmd.Parameters.AddWithValue("@subgid", s.SubGID);
cmd.Parameters.AddWithValue("@tag", s.Tag);
cmd.Parameters.AddWithValue("@year", s.Year);
cmd.Parameters.AddWithValue("@noofstu", s.noOfStu);
cmd.Parameters.AddWithValue("@duration", s.Duration);
cmd.Parameters.AddWithValue("@generate", s.Generate);
con.Open();
int rows2 = cmd.ExecuteNonQuery();
if (rows2 > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
finally
{
con.Close();
}
return(isSuccess);
}
