} //List Method public int Insert(CourseModal coursetOject) { //So that no white space coursetOject.CourseCode = coursetOject.CourseCode.Trim(); coursetOject.CourseName = coursetOject.CourseName.Trim(); bool isDuplicate = CheckPrimaryKeyViolation(coursetOject.SessionId, coursetOject.SemesterId, coursetOject.CourseName); if (isDuplicate) { return(0); } int rowsAffected = 0; using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Open(); SqlCommand com = new SqlCommand("spInsertCourse", connection); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@SessionId", coursetOject.SessionId); com.Parameters.AddWithValue("@Semesterid", coursetOject.SemesterId); com.Parameters.AddWithValue("@CourseCode", coursetOject.CourseCode); com.Parameters.AddWithValue("@CourseName", coursetOject.CourseName); com.Parameters.AddWithValue("@CreditHour", coursetOject.CreditHour); try { rowsAffected = com.ExecuteNonQuery(); } catch (Exception e) { return(0); } return(rowsAffected); } }
public int Update(CourseModal coursetOject) { int rowsAffected = 0; using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Open(); SqlCommand com = new SqlCommand("spUpdateCourse", connection); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@Id", coursetOject.Id); com.Parameters.AddWithValue("@SessionId", coursetOject.SessionId); com.Parameters.AddWithValue("@Semesterid", coursetOject.SemesterId); com.Parameters.AddWithValue("@CourseCode", coursetOject.CourseCode); com.Parameters.AddWithValue("@CourseName", coursetOject.CourseName); com.Parameters.AddWithValue("@CreditHour", coursetOject.CreditHour); try { rowsAffected = com.ExecuteNonQuery(); } catch (SqlException ex) { if (ex.Number == 547) { return(547); } return(0); } return(rowsAffected); } }
public JsonResult Insert(CourseModal courseOject) { return(Json(_databaseConnection.Insert(courseOject), JsonRequestBehavior.AllowGet)); }