Exemple #1
0
        }// end get next code

        //insert the academic offer

        public Int32 insert(Entities.AcademicOffer oAcademicOffer)
        {
            String oSql = "SP_INSERTACADEMIC_OFFER";

            try
            {
                SqlCommand oCommand = new SqlCommand(oSql);
                oCommand.CommandType = CommandType.StoredProcedure;
                oCommand.Parameters.AddWithValue("@ID", oAcademicOffer.code);
                oCommand.Parameters.AddWithValue("@TEACHER_ID", oAcademicOffer.oteacher.code);
                oCommand.Parameters.AddWithValue("@PERIOD_ID", oAcademicOffer.oPeriod.code);
                oCommand.Parameters.AddWithValue("@PROGRAM_ID", oAcademicOffer.oProgram.code);
                oCommand.Parameters.AddWithValue("@COURSE_ID", oAcademicOffer.oCourse.id);
                oCommand.Parameters.AddWithValue("@PRICE", oAcademicOffer.price);
                oCommand.Parameters.AddWithValue("@CLASSROOM_ID", oAcademicOffer.oClassRoom.code);
                oCommand.Parameters.AddWithValue("@SCHEDULE_ID", oAcademicOffer.oSchedule.code);
                oCommand.Parameters.AddWithValue("@HOURS", oAcademicOffer.hours);

                return(DAO.getInstance().executeSQL(oCommand));
            }
            catch (Exception)
            {
                throw;
            }
            finally { }
        }
        //this method insert the new schedule for the teacher
        public void insertTeacherSchedule(Entities.AcademicOffer oAcademic)
        {
            Int32 cod = Convert.ToInt32(cboSchedule.SelectedValue);

            Entities.Schedule oSchedule = BLL.ScheduleBLL.getInstance().getSchedule(cod);
            int[]             days      = selectDays(oSchedule.codday);

            for (int i = 0; i < days.Count(); i++)
            {
                if (Convert.ToInt32(days[i]) != 9)
                {
                    int newCod = Convert.ToInt32(TeacherScheduleBLL.getInstance().getNextCode().ToString());
                    TeacherScheduleBLL.getInstance().insert(oAcademic, oSchedule, newCod, Convert.ToInt32(days[i]));
                }
            }
        }
        protected void btnSave_Click(object sender, ImageClickEventArgs e)
        {
            Int32 records = 0;

            if (validateData())
            {
                Entities.Period    oPeriod    = new Entities.Period();
                Entities.Program   oProgram   = new Entities.Program();
                Entities.Course    oCourse    = new Entities.Course();
                Entities.ClassRoom oClassRoom = new Entities.ClassRoom();
                Entities.Schedule  oSchedule  = new Entities.Schedule();
                Entities.Teacher   oteacher   = new Entities.Teacher();
                Int32 code = Convert.ToInt32(txtCode.Text.ToString());
                oPeriod.code  = Convert.ToInt32(cboPeriod.SelectedValue.ToString());
                oProgram.code = Convert.ToInt32(cboProgram.SelectedValue.ToString());
                oCourse.id    = Convert.ToInt32(cboCourse.SelectedValue.ToString());
                Decimal price = Convert.ToDecimal(txtPrice.Text.ToString());
                oSchedule.code  = Convert.ToInt32(cboSchedule.SelectedValue.ToString());
                oClassRoom.code = Convert.ToInt32(cboRoom.SelectedValue.ToString());
                oteacher.code   = Convert.ToInt32(cboTeacher.SelectedValue.ToString());
                Int32 hour = Convert.ToInt32(cboHours.SelectedValue.ToString());
                Entities.AcademicOffer oAcademicOffer = new Entities.AcademicOffer(code, oPeriod, oProgram, oCourse, price, oClassRoom, oSchedule, oteacher, hour);
                if (BLL.AcademicOfferBLL.getInstance().exists(code))
                {
                    lblMessage.Text = "Esta solicitud no puede ser procesada";
                }
                else
                {
                    records = BLL.AcademicOfferBLL.getInstance().insert(oAcademicOffer);
                    insertClasroomSchedule(oAcademicOffer);
                    insertTeacherSchedule(oAcademicOffer);
                }

                blockControls();
                loadData();

                if (records > 0)
                {
                    lblMessage.Text = "Datos almacenados correactamente";
                }
            }
        }
Exemple #4
0
        } // getNextCode End

        public Int32 insert(Entities.AcademicOffer oAcademicOffer, Entities.Schedule oSchedule, int cod, int day)
        {
            String     oSql     = "SP_INSERTCLASSROOM_SCHEDULE";
            SqlCommand oCommand = new SqlCommand(oSql);

            oCommand.CommandType = CommandType.StoredProcedure;
            oCommand.Parameters.AddWithValue("@CLASSROOM_ID", oAcademicOffer.oClassRoom.code);
            oCommand.Parameters.AddWithValue("@CLASSROOM_SCHEDULE_ID", cod);
            oCommand.Parameters.AddWithValue("@PERIOD_ID", oAcademicOffer.oPeriod.code);
            oCommand.Parameters.AddWithValue("@Course_ID", oAcademicOffer.oCourse.id);
            oCommand.Parameters.AddWithValue("@DIA_ID", day);
            oCommand.Parameters.AddWithValue("@INITIAL_HOUR", oSchedule.startTime);
            oCommand.Parameters.AddWithValue("@FINAL_HOUR", oSchedule.endTime);
            oCommand.Parameters.AddWithValue("@ACADEMICOFFER_ID", oAcademicOffer.code);
            try
            {
                return(DAO.getInstance().executeSQL(oCommand));
            }
            catch (Exception)
            {
                throw;
            }
            finally { }
        }
Exemple #5
0
 public void modify(Entities.AcademicOffer oAcademicOffer)
 {
     throw new NotImplementedException();
 }