public int Update(SessionModal session)
{
int noOfRowsAffected = 0;
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand("spUpdateSession", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Id", session.Id);
command.Parameters.AddWithValue("@SessionId", session.SessionId);
command.Parameters.AddWithValue("@Program", session.SessionProgram);
command.Parameters.AddWithValue("@SessionStartDay", session.SessionStartDay);
command.Parameters.AddWithValue("@SessionStartMonth", session.SessionStartMonth);
command.Parameters.AddWithValue("@SessionStartYear", session.SessionStartYear);
command.Parameters.AddWithValue("@SessionEndDay", session.SessionEndDay);
command.Parameters.AddWithValue("@SessionEndMonth", session.SessionEndMonth);
command.Parameters.AddWithValue("@SessionEndYear", session.SessionEndYear);
try
{
noOfRowsAffected = command.ExecuteNonQuery();
}
catch (SqlException exc)
{
return(0);
}
}
return(noOfRowsAffected);
}
public JsonResult Update(SessionModal updatedSession)
{
if ((int.Parse(updatedSession.SessionEndYear) - int.Parse(updatedSession.SessionStartYear)) != 4)
{
return(Json('4', JsonRequestBehavior.AllowGet));
}
return(Json(_databaseConnection.Update(updatedSession), JsonRequestBehavior.AllowGet));
}
}//List Method
//Insert
public int Insert(SessionModal session)
{
if (CheckPrimaryKeyViolation(session.SessionId))
{
return(0);
}
int noOfRowsAffected = 0;
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand("spInsertSession", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@SessionId", session.SessionId);
command.Parameters.AddWithValue("@Program", session.SessionProgram);
command.Parameters.AddWithValue("@SessionStartDay", session.SessionStartDay);
command.Parameters.AddWithValue("@SessionStartMonth", session.SessionStartMonth);
command.Parameters.AddWithValue("@SessionStartYear", session.SessionStartYear);
command.Parameters.AddWithValue("@SessionEndDay", session.SessionEndDay);
command.Parameters.AddWithValue("@SessionEndMonth", session.SessionEndMonth);
command.Parameters.AddWithValue("@SessionEndYear", session.SessionEndYear);
try
{
noOfRowsAffected = command.ExecuteNonQuery();
}
catch (SqlException ex)
{
if (ex.Number == 2627)
{
return(0);
}
}
}
return(noOfRowsAffected);
}
