Exemplo n.º 1
0
        public void EditSession(int SessionID, string SessionName, DateTime SessionDate, string StartTime, string EndTime, int StudioID, int ProgID, int CourseID, int SubjectID, int FacultyID, string PlannedCoverage, string StreamKey)
        {
            SessionModel SessionObj1 = new SessionModel();

            SqlParameter[] SParam = new SqlParameter[12];

            SParam[0]        = new SqlParameter("@SessionID", SqlDbType.Int);
            SParam[0].Value  = SessionID;
            SParam[1]        = new SqlParameter("@SessionName", SqlDbType.VarChar);
            SParam[1].Value  = SessionName;
            SParam[2]        = new SqlParameter("@SessionDate", SqlDbType.DateTime);
            SParam[2].Value  = SessionDate;
            SParam[3]        = new SqlParameter("@StartTime", SqlDbType.VarChar);
            SParam[3].Value  = StartTime;
            SParam[4]        = new SqlParameter("@EndTime", SqlDbType.VarChar);
            SParam[4].Value  = EndTime;
            SParam[5]        = new SqlParameter("@StudioID", SqlDbType.Int);
            SParam[5].Value  = StudioID;
            SParam[6]        = new SqlParameter("@ProgID", SqlDbType.Int);
            SParam[6].Value  = ProgID;
            SParam[7]        = new SqlParameter("@CourseID", SqlDbType.Int);
            SParam[7].Value  = CourseID;
            SParam[8]        = new SqlParameter("@SubjectID", SqlDbType.Int);
            SParam[8].Value  = SubjectID;
            SParam[9]        = new SqlParameter("@FacultyID", SqlDbType.Int);
            SParam[9].Value  = FacultyID;
            SParam[10]       = new SqlParameter("@Key", SqlDbType.VarChar);
            SParam[10].Value = StreamKey;
            SParam[11]       = new SqlParameter("@PlannedCoverage", SqlDbType.Text);
            SParam[11].Value = PlannedCoverage;
            SessionObj1.EditSession(SParam);
        }