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