public int CreateClassroom(Classroom_lkpInfo info) { if (info == null) { throw new Exception(ExceptionMessage.InputParameterNull); } using (SqlConnectionManager cm = new SqlConnectionManager()) { Nullable<int> classroom_id = null; using(var cmd = new Classroom_lkp_Save_p()) { cmd.Parameters.IsInsert = true; cmd.Parameters.Classroom_id = info.Classroom_id; cmd.Parameters.School_id = info.School_id; cmd.Parameters.IsDeleted = info.IsDeleted; cmd.Parameters.ClassroomName = info.ClassroomName; cmd.Parameters.Classroom_Blurb_id = info.Classroom_Blurb_id; cmd.Parameters.DefaultPhysicalCapacity = info.DefaultPhysicalCapacity; cmd.Parameters.DisplayOrder = info.DisplayOrder; cmd.Parameters.Insertby = info.Insertby; cmd.Parameters.Updateby = info.Updateby; cmd.Parameters.IsHidden = info.IsHidden; cm.ExecuteNonQuery(cmd, _context); classroom_id = cmd.Parameters.Classroom_id; if (!classroom_id.HasValue) { throw new Exception(ExceptionMessage.NoIdReturnedForCreatedObject); } } return classroom_id.Value; } }
public void UpdateClassroom(Classroom_lkpInfo info) { if (info == null) { throw new Exception(ExceptionMessage.InputParameterNull); } using (SqlConnectionManager cm = new SqlConnectionManager()) { using (var cmd = new Classroom_lkp_Save_p()) { cmd.Parameters.IsInsert = false; cmd.Parameters.Classroom_id = info.Classroom_id; cmd.Parameters.School_id = info.School_id; cmd.Parameters.IsDeleted = info.IsDeleted; cmd.Parameters.ClassroomName = info.ClassroomName; cmd.Parameters.Classroom_Blurb_id = info.Classroom_Blurb_id; cmd.Parameters.DefaultPhysicalCapacity = info.DefaultPhysicalCapacity; cmd.Parameters.DisplayOrder = info.DisplayOrder; cmd.Parameters.Insertby = info.Insertby; cmd.Parameters.Updateby = info.Updateby; cmd.Parameters.IsHidden = info.IsHidden; cm.ExecuteNonQuery(cmd, _context); } } }