private void btnUploadCW_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (openFileDialogCW.ShowDialog().Equals(DialogResult.OK)) { List<string> fileDir = new List<string>(openFileDialogCW.FileNames); frmUpload upload = new frmUpload(string.Empty,string.Empty,string.Empty,string.Empty,string.Empty,string.Empty,string.Empty,string.Empty,fileDir,"CW"); upload.Show(); } }
private void Add(string actFiledir) { string fileName = Path.GetFileName(actFiledir); List<string> dir = new List<string>(); dir.Add(actFiledir); List<MySqlParameter> param = new List<MySqlParameter>(); param.Add(new MySqlParameter("@act_id", act_id)); param.Add(new MySqlParameter("@fileNamewExt", fileName)); if (!MySQLCommands.DoesExist("select concat(file_name,file_ext) from tbl_activityfile INNER JOIN tbl_files on tbl_activityfile.FID = tbl_files.FID where tbl_activityfile.activity_id = @act_id and concat(file_name,file_ext) = @fileNamewExt",param)) { frmUpload uploadAct = new frmUpload(string.Empty,string.Empty,string.Empty,string.Empty,string.Empty,string.Empty,act_id,string.Empty,dir,"eACTFILE"); uploadAct.ShowDialog(); } else { XtraMessageBox.Show("Duplicate of the file " + fileName + " is found","File Duplicate",MessageBoxButtons.OK,MessageBoxIcon.Information); } }
private void btnSubmit_Click(object sender, EventArgs e) { List<MySqlParameter> param = new List<MySqlParameter>(); param.Add(new MySqlParameter("@uid", insClass.log)); param.Add(new MySqlParameter("@act_id", act_id)); param.Add(new MySqlParameter("@respond_message", memoEditMessage.Text)); if (MySQLCommands.TestConnection()) { if (string.IsNullOrWhiteSpace(memoEditMessage.Text) && lstFiles.ItemCount.Equals(0)) { XtraMessageBox.Show("Please enter a valid message or enter atleast 1 file to submit","Invalid Value",MessageBoxButtons.OK,MessageBoxIcon.Information); } else { string val = MySQLCommands.GetValue("SELECT if (@act_id IN (SELECT tbl_respondactivity.activity_id FROM tbl_respondactivity WHERE tbl_respondactivity.respond_id IN (SELECT tbl_studentrespond.respond_id FROM tbl_studentrespond WHERE tbl_studentrespond.UID = @uid)),'TRUE',NULL) AS result", param); if (!hasDeadline)//if deadline is disabled { if (val.Equals(string.Empty)) { if (XtraMessageBox.Show("This is a one time respond only, you are not \nallowed to edit or respond again in this activity after you click submit", "Continue ?", MessageBoxButtons.YesNo, MessageBoxIcon.Question).Equals(DialogResult.Yes)) { //insert ang reply long respond_id = MySQLCommands.Insert("insert into tbl_respond (respond_message) values (@respond_message)", param); param.Add(new MySqlParameter("@respond_id", respond_id)); MySQLCommands.Insert("insert into tbl_studentrespond (UID,respond_id) values (@uid,@respond_id)", param); MySQLCommands.Insert("insert into tbl_respondactivity (respond_id,activity_id) values (@respond_id,@act_id)", param); if (lstFiles.ItemCount > 0) { List<string> item = lstFiles.Items.Cast<String>().ToList(); frmUpload replyFile = new frmUpload(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, act_id, respond_id.ToString(), item, "ACTREPLY"); replyFile.ShowDialog(); } closeNow = true; this.Close(); } } else { XtraMessageBox.Show("You've already submitted this activity", "Reply Blocked", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else //deadline is enabled { string deadTime = MySQLCommands.GetValue("SELECT if ((time(CURRENT_TIMESTAMP)) >= (SELECT tbl_activity.activity_deadtime FROM tbl_activity WHERE tbl_activity.activity_id = @act_id),'TRUE','FALSE') AS is_deadlinetime", param); string deadDate = MySQLCommands.GetValue("SELECT if ((SELECT tbl_activity.activity_deaddate FROM tbl_activity WHERE tbl_activity.activity_id = @act_id) >= (select date(CURRENT_TIMESTAMP)),'FALSE','TRUE') AS is_deadline", param); string equal = MySQLCommands.GetValue("SELECT if ((SELECT tbl_activity.activity_deaddate FROM tbl_activity WHERE tbl_activity.activity_id = @act_id) > (select date(CURRENT_TIMESTAMP)),'FALSE','TRUE') AS is_Equal", param); if (deadDate.Equals("FALSE")) { if (equal.Equals("TRUE")) { //check time if (deadTime.Equals("TRUE")) { //di na reply coz deadline na XtraMessageBox.Show("Deadline has expired", "Reply Blocked", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { if (val.Equals(string.Empty)) { if (XtraMessageBox.Show("This is a one time respond, only you are not \nallowed to edit or respond again in this activity after you click submit", "Continue ?", MessageBoxButtons.YesNo, MessageBoxIcon.Question).Equals(DialogResult.Yes)) { //insert ang reply long respond_id = MySQLCommands.Insert("insert into tbl_respond (respond_message) values (@respond_message)", param); param.Add(new MySqlParameter("@respond_id", respond_id)); MySQLCommands.Insert("insert into tbl_studentrespond (UID,respond_id) values (@uid,@respond_id)", param); MySQLCommands.Insert("insert into tbl_respondactivity (respond_id,activity_id) values (@respond_id,@act_id)", param); if (lstFiles.ItemCount > 0) { List<string> item = lstFiles.Items.Cast<String>().ToList(); frmUpload replyFile = new frmUpload(insClass.log,string.Empty,string.Empty,string.Empty,string.Empty,string.Empty,act_id,respond_id.ToString(),item,"ACTREPLY"); replyFile.ShowDialog(); } closeNow = true; this.Close(); } } else { XtraMessageBox.Show("You've already submitted this activity", "Reply Blocked", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else { if (val.Equals(string.Empty)) { if (XtraMessageBox.Show("This is a one time respond, only you are not \nallowed to edit or respond again in this activity after you click submit", "Continue ?", MessageBoxButtons.YesNo, MessageBoxIcon.Question).Equals(DialogResult.Yes)) { //insert ang reply long respond_id = MySQLCommands.Insert("insert into tbl_respond (respond_message) values (@respond_message)", param); param.Add(new MySqlParameter("@respond_id", respond_id)); MySQLCommands.Insert("insert into tbl_studentrespond (UID,respond_id) values (@uid,@respond_id)", param); MySQLCommands.Insert("insert into tbl_respondactivity (respond_id,activity_id) values (@respond_id,@act_id)", param); if (lstFiles.ItemCount > 0) { List<string> item = lstFiles.Items.Cast<String>().ToList(); frmUpload replyFile = new frmUpload(insClass.log, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, act_id, respond_id.ToString(), item, "ACTREPLY"); replyFile.ShowDialog(); } closeNow = true; this.Close(); } } else { XtraMessageBox.Show("You've already submitted this activity", "Reply Blocked", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else { //di na reply coz deadline na XtraMessageBox.Show("Deadline has expired", "Reply Blocked", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } else { XtraMessageBox.Show("Can't connect to the remote server", "Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void btnUpload_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (ownerUserlvl.Equals("STUDENT")) { if (barEditItemArea.EditValue == null) { XtraMessageBox.Show("Please select an area","No area selected",MessageBoxButtons.OK,MessageBoxIcon.Information); } else { if (openFileDialogMain.ShowDialog().Equals(DialogResult.OK)) { List<string> fileDir = new List<string>(openFileDialogMain.FileNames); string area = barEditItemArea.EditValue.ToString(); frmUpload upload = new frmUpload(ownerUID, ownerUserlvl, area, editorUID, editorUserlvl, string.Empty, string.Empty, string.Empty, fileDir, "USERFILE"); upload.Show(); } } } else { if (openFileDialogMain.ShowDialog().Equals(DialogResult.OK)) { List<string> fileDir = new List<string>(openFileDialogMain.FileNames); frmUpload upload = new frmUpload(ownerUID, ownerUserlvl, ownerArea, editorUID, editorUserlvl, string.Empty, string.Empty, string.Empty, fileDir, "USERFILE"); upload.Show(); } } }
private void btnSave_Click(object sender, EventArgs e) { ValidateControls(); if (!errProv.HasErrors) { if (MySQLCommands.TestConnection()) { List<MySqlParameter> param = new List<MySqlParameter>(); param.Add(new MySqlParameter("@activity_title",txtTitle.Text)); param.Add(new MySqlParameter("@activity_message",memoEditMessage.Text)); param.Add(new MySqlParameter("@CID", CID)); if (!MySQLCommands.DoesExist("SELECT tbl_activity.activity_title FROM tbl_classactivity INNER JOIN tbl_activity ON tbl_classactivity.activity_id = tbl_activity.activity_id WHERE tbl_classactivity.CID = @CID and tbl_activity.activity_title = @activity_title and tbl_activity.status = 1", param)) { long activity_id = new long(); if (cboDeadLine.Checked) { param.Add(new MySqlParameter("@deadtime", timeEditDeadline.Time.ToString("HH:mm:ss"))); param.Add(new MySqlParameter("@deaddate", dateEditDeadline.DateTime.ToString("yyyy-MM-dd"))); activity_id = MySQLCommands.Insert("insert into tbl_activity (activity_title,activity_message,activity_deadtime,activity_deaddate) values (@activity_title,@activity_message,@deadtime,@deaddate)", param); param.Add(new MySqlParameter("@activity_id", activity_id)); MySQLCommands.Insert("insert into tbl_classactivity (activity_id,CID) values (@activity_id,@CID)", param); } else { activity_id = MySQLCommands.Insert("insert into tbl_activity (activity_title,activity_message) values (@activity_title,@activity_message)", param); param.Add(new MySqlParameter("@activity_id", activity_id)); MySQLCommands.Insert("insert into tbl_classactivity (activity_id,CID) values (@activity_id,@CID)", param); } if (lstFiles.ItemCount > 0) { List<string> item = lstFiles.Items.Cast<String>().ToList(); frmUpload actFile = new frmUpload(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, activity_id.ToString(), string.Empty, item, "ACTFILE"); actFile.ShowDialog(); } this.Close(); } else { errProv.SetError(txtTitle, "This activity title is currently in use"); } } else { XtraMessageBox.Show("Can't connect to the remote server", "Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } }
private void btnUpload_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (openFileDialogMain.ShowDialog().Equals(DialogResult.OK)) { List<string> fileDir = new List<string>(openFileDialogMain.FileNames); frmUpload upload = new frmUpload(ownerUID, ownerUserlvl, ownerArea, editorUID, editorUserlvl, string.Empty, string.Empty, string.Empty, fileDir, "FILE"); upload.Show(); } }