//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); }