public AddScreeningForm(User user, Session session)
: this(user)
{
if (session != null)
{
this.session = session;
this.video = session.getVideo();
updating = true;
rtbComment.Text = session.getComment();
fillVideoInfo(video);
btnSaveScreening.Text = "Alterar";
btnSaveScreening.TextAlign = ContentAlignment.MiddleCenter;
}
}
public Boolean insertSession(Session session, Type type, String errorMethod)
{
int modeCode;
modeCode = getModeCode(session.getMode());
String[] dateStrings = new String[2];
String[] videoCodeStrings = new String[2];
String[] userLoginStrings = new String[2];
String[] evaluetionStrings = new String[2];
String[] modeStrings = new String[2];
String[] commentStrings = new String[2];
if (session.getDate() != null)
{
dateStrings[0] = "date";
dateStrings[1] = "'" + session.getDate() + "'";
}
else
return false;
if (session.getVideoCode() != -1)
{
videoCodeStrings[0] = ", videoCode";
videoCodeStrings[1] = ", " + session.getVideoCode();
}
else
return false;
if (!session.getUserLogin().Equals(""))
{
userLoginStrings[0] = ", userLogin";
userLoginStrings[1] = ", '" + session.getUserLogin() + "'";
}
else
return false;
if (session.getEvaluetion() != -1)
{
evaluetionStrings[0] = ", evaluetion";
evaluetionStrings[1] = ", " + session.getEvaluetion().ToString().Replace(",",".") + "";
}
if (modeCode != 0)
{
modeStrings[0] = ", modeCode";
modeStrings[1] = ", " + modeCode;
}
if (!session.getComment().Equals(""))
{
commentStrings[0] = ", comment";
commentStrings[1] = ", '" + session.getComment() + "'";
}
String insertSessionString = "INSERT INTO SESSION (" +
dateStrings[0] +
videoCodeStrings[0] +
userLoginStrings[0] +
evaluetionStrings[0] +
modeStrings[0] +
commentStrings[0] + ") VALUES (" +
dateStrings[1] +
videoCodeStrings[1] +
userLoginStrings[1] +
evaluetionStrings[1] +
modeStrings[1] +
commentStrings[1] + ")";
// MessageBox.Show(insertSessionString);
Boolean insertionResult =
executeNonQuery(insertSessionString, type, errorMethod, "Insert session failed.");
session.setCode(getLastVideoCode());
return insertionResult;
}