//Methord to Update record in database from app public bool updateSubject(ClassSubject 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 Subject SET SubjectCode=@txtSubCode,SubjectName=@txtSubName,OfferedYear=@txtOffYear,OfferedSem=@drpOffSem,NumLecHr=@NumLecHr,NumTuteHr=@NumTuteHr,NumLabHr=@NumLabHr,NumEveHr=@NumEveHr WHERE Id=@txtId"; SqlCommand cmd = new SqlCommand(sql, con); //Create parameter to ad data cmd.Parameters.AddWithValue("@txtId", s.ID); cmd.Parameters.AddWithValue("@txtOffYear", s.OfferYear); cmd.Parameters.AddWithValue("@drpOffSem", s.OfferSemester); cmd.Parameters.AddWithValue("@txtSubCode", s.SubCode); cmd.Parameters.AddWithValue("@txtSubName", s.SubName); cmd.Parameters.AddWithValue("@NumLecHr", s.NumLecHr); cmd.Parameters.AddWithValue("@NumTuteHr", s.NumTuteHr); cmd.Parameters.AddWithValue("@NumLabHr", s.NumLabHr); cmd.Parameters.AddWithValue("@NumEveHr", s.NumEveHr); //MessageBox.Show("" + s.ID + s.OfferYear + s.OfferSemester + s.SubName + s.SubCode + s.NumLecHr + s.NumTuteHr + s.NumLabHr + s.NumEveHr + "Update Called", "Informtion", MessageBoxButtons.OK, MessageBoxIcon.Error); 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); }
public bool insertSubject(ClassSubject 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 Subject (SubjectCode,SubjectName,OfferedYear,OfferedSem,NumLecHr,NumTuteHr,NumLabHr,NumEveHr) VALUES (@txtSubCode,@txtSubName,@txtOffYear,@drpOffSem,@NumLecHr,@NumTuteHr,@NumLabHr,@NumEveHr)"; SqlCommand cmd2 = new SqlCommand(sql2, con); //Create parameter to ad data cmd2.Parameters.AddWithValue("@txtOffYear", s.OfferYear); cmd2.Parameters.AddWithValue("@drpOffSem", s.OfferSemester); cmd2.Parameters.AddWithValue("@txtSubCode", s.SubCode); cmd2.Parameters.AddWithValue("@txtSubName", s.SubName); cmd2.Parameters.AddWithValue("@NumLecHr", s.NumLecHr); cmd2.Parameters.AddWithValue("@NumTuteHr", s.NumTuteHr); cmd2.Parameters.AddWithValue("@NumLabHr", s.NumLabHr); cmd2.Parameters.AddWithValue("@NumEveHr", s.NumEveHr); con.Open(); int rows2 = cmd2.ExecuteNonQuery(); if (rows2 > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { Console.WriteLine(ex); } finally { con.Close(); } return(isSuccess); }