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;
}