コード例 #1
0
ファイル: DaoSession.cs プロジェクト: igorbc/PROJETO_FINAL_LC
        public Session createSessionFromDataReader(MySqlDataReader dr)
        {
            Session session;
            String userLogin;
            int code = 0;
            DateTime date;
            String dateString;
            Video video;
            String mode;
            String comment;

            float evaluetion;

            if (dr.Equals(DBNull.Value)) return null;

            if (!dr["comment"].Equals(DBNull.Value))
                comment = dr.GetString("comment");
            else
                comment = "";

            if (dr["code"].Equals(DBNull.Value)) return null;
            code = dr.GetInt32("code");

            if (dr["userLogin"].Equals(DBNull.Value)) return null;
            userLogin = dr.GetString("userLogin");

            if (!dr["evaluetion"].Equals(DBNull.Value))
                evaluetion = (float)Convert.ToDouble(dr.GetDecimal("evaluetion"));
            else
                evaluetion = 0;

            DaoVideo daoVideo = new DaoVideo();
            daoVideo.openConnection();

            video = daoVideo.getVideoByCode(dr.GetInt32("videoCode"));

            date = dr.GetDateTime("date");
            dateString = date.Day + "/" + date.Month + "/" + date.Year;

            if (!dr["modeCode"].Equals(DBNull.Value))
                mode = getModeByCode(dr.GetInt32("modeCode"));
            else
                mode = "";

            session = new Session(userLogin, video, dateString, evaluetion, mode, comment);
            session.setCode(code);
            return session;
        }
コード例 #2
0
 private void cbbVideoName_SelectedValueChanged(object sender, EventArgs e)
 {
     DaoVideo daoVideo = new DaoVideo();
     daoVideo.openConnection();
     if (cbbVideoName.SelectedValue != null)
     {
         if (cbbVideoName.SelectedValue is int)
         {
             int selectedVideoCode = (int)cbbVideoName.SelectedValue;
             if(!updating)
                 video = daoVideo.getVideoByCode((int)cbbVideoName.SelectedValue);
             if (video != null)
             {
                 btnEditVideo.Enabled = true;
      //                       MessageBox.Show("selected ... changed");
                 fillVideoInfo(video);
             }
         }
     }
     daoVideo.closeConnection();
 }