public bool DeleteAssoc(StudentCourseAssocModel assocModel) { var deleted = false; try { // Step 1 - Initialize the connection and set the sproc var conn = new SqlConnection(connStr); var command = new SqlCommand(StoredProcedures.StudentCourseAssoc_Delete, conn); command.CommandType = CommandType.StoredProcedure; conn.Open(); // Step 2 - Set the Parameters command.Parameters.AddWithValue("@IdCourse", assocModel.IdCourse); command.Parameters.AddWithValue("@IdStudent", assocModel.IdStudent); // Step 3 - Execute the sproc and set deleted to true var sqlReader = command.ExecuteReader(); deleted = true; } catch (Exception e) { Console.WriteLine(e.Message); deleted = false; } return(deleted); }
public IStudentCourseAssocModel InsertAssoc(StudentCourseAssocModel assocModel) { var addedAssoc = new StudentCourseAssocModel(); try { // Step 1 - Initialize the connection and set the sproc var conn = new SqlConnection(connStr); var command = new SqlCommand(StoredProcedures.StudentCourseAssoc_Insert, conn); command.CommandType = CommandType.StoredProcedure; conn.Open(); // Step 2 - Set the Parameters command.Parameters.AddWithValue("@IdCourse", assocModel.IdCourse); command.Parameters.AddWithValue("@IdStudent", assocModel.IdStudent); // Step 3 - Execute the sproc and store the new Association in an object var sqlReader = command.ExecuteReader(); while (sqlReader.Read()) { addedAssoc.IdCourse = sqlReader.GetInt32(0); addedAssoc.IdStudent = sqlReader.GetInt32(1); } sqlReader.Close(); } catch (Exception e) { Console.WriteLine(e.Message); } return(addedAssoc); }
public List<StudentCourseAssocModel> ListAssocs(StudentCourseAssocModel assocModel) { var assocs = new List<StudentCourseAssocModel>(); try { // Get list of all associations assocs = StudentCourseAssocRepository.ListAssocs(assocModel).ConvertAll(c => (StudentCourseAssocModel)c); } catch (Exception e) { Console.Write(e.Message); } return assocs; }
public bool DeleteAssoc(StudentCourseAssocModel assocModel) { var deleted = false; try { // Null check the parameters, then get the association if (assocModel.IdCourse > 0 && assocModel.IdStudent > 0) { deleted = StudentCourseAssocRepository.DeleteAssoc(assocModel); } } catch (Exception e) { Console.Write(e.Message); } return deleted; }
public StudentCourseAssocModel GetAssoc(StudentCourseAssocModel assocModel) { var assoc = new StudentCourseAssocModel(); try { // Null check the parameters, then get the association if (assocModel.IdCourse > 0 && assocModel.IdStudent > 0) { assoc = StudentCourseAssocRepository.GetAssoc(assocModel) as StudentCourseAssocModel; } } catch (Exception e) { Console.Write(e.Message); } return assoc; }
public StudentCourseAssocModel InsertAssoc(StudentCourseAssocModel assocModel) { var addedAssoc = new StudentCourseAssocModel(); try { // Null check the model, then insert the association if (assocModel.IdCourse > 0 && assocModel.IdStudent > 0) { addedAssoc = StudentCourseAssocRepository.InsertAssoc(assocModel) as StudentCourseAssocModel; } } catch(Exception e) { Console.Write(e.Message); } return addedAssoc; }
public List <IStudentCourseAssocModel> ListAssocs(StudentCourseAssocModel assocModel) { var associations = new List <IStudentCourseAssocModel>(); try { // Step 1 - Initialize the connection and set the sproc var conn = new SqlConnection(connStr); var command = new SqlCommand(StoredProcedures.StudentCourseAssoc_List, conn); command.CommandType = CommandType.StoredProcedure; conn.Open(); // Step 2 - Set the Parameters // Null int for parameter assignment int?nullInt = null; command.Parameters.AddWithValue("@IdCourse", assocModel.IdCourse == 0 ? nullInt : assocModel.IdCourse); command.Parameters.AddWithValue("@IdStudent", assocModel.IdStudent == 0 ? nullInt : assocModel.IdStudent); // Step 3 - Execute the sproc and store the Courses in an object var sqlReader = command.ExecuteReader(); while (sqlReader.Read()) { // Add each association to the list associations.Add(new StudentCourseAssocModel { IdCourse = sqlReader.GetInt32(0), IdStudent = sqlReader.GetInt32(1) }); } sqlReader.Close(); } catch (Exception e) { Console.WriteLine(e.Message); } return(associations); }