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