protected void Page_LoadComplete(object sender, EventArgs e) { if (HttpContext.Current.Session["CurrentUser"] == null) { Response.Redirect("Logout.aspx"); } ltrSubMenu.Text = UtilMenu.StudentMenu("studentdocument"); if (!Utils.User.UserRoleByName("Student - Documents").allowView) { ltrGrid.Text = "You do not have rights to view."; return; } string ms = Request.QueryString["ms"]; this.ltrMScript.Text = Utils.MenuSelectScript(ms); string saveClicked = Request.Form["SaveClicked"] ?? ""; if (IsPostBack && saveClicked.Equals("1")) { BestDocuments bs = new BestDocuments(); string isnew = Request.Form["isnew"]; bool cansave = true; if (string.IsNullOrEmpty(isnew)) { List<BestField> bparams = new List<BestField>(); BestField guid = new BestField() { fieldName = "guidfield", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false }; guid.fieldValue = Request.Form["guidfield"]; bparams.Add(guid); if (!string.IsNullOrEmpty(guid.fieldValue)) { bs.LoadRows("guidfield=?", bparams); } else { string delguid = Request.Form["deleteguid"]; if (!string.IsNullOrEmpty(delguid)) { bparams[0].fieldValue = delguid; bs.LoadRows("guidfield=?", bparams); bs.CurrentRow.IsDelete = true; bs.CurrentRow.Save(); } cansave = false; } } if (cansave) { if (!string.IsNullOrEmpty(isnew)) { string guid = Request.Form["g_studentGuid"]; if (string.IsNullOrEmpty(guid)) { ltrValidateMsg.Text = Utils.WarningMessage("Student Name is Required."); cansave = false; } bs.studentGuid = new Guid(guid); } if (cansave) { bool showToStudent = (Request.Form["g_showToStudent"] ?? "").ToLower().Equals("true"); bs.showToStudent = showToStudent; string docdate = Request.Form["g_documentDate"]; if (!string.IsNullOrEmpty(docdate)) { bs.documentDate = Convert.ToDateTime(docdate); } bs.documentTitle = Request.Form["g_documentTitle"]; string expdate = Request.Form["g_documentExpiry"]; if (!string.IsNullOrEmpty(expdate)) { bs.documentExpiry = Convert.ToDateTime(expdate); } bs.CenterId = Utils.User.CenterId; BestStudents bestStd = new BestStudents(); bestStd.LoadRows("guidfield=?", "studentguid", bs.studentGuid, ""); bs.StudentId = bestStd.StudentId; if (!bs.CurrentRow.Save()) { ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError); } } } } /* Auto Student */ string autoSample = "{value:\"[paramValue]\", label:[paramLabel]}"; StringBuilder sb = new StringBuilder(); sb.AppendLine("autoStudents = ["); BestStudents bstd = new BestStudents(); bstd.LoadRows("CenterId=?", Utils.User.CIdParam); for (int s = 0; s < bstd.TableRows.Count; s++) { string result = autoSample; result = result.Replace("[paramValue]", bstd.TableRows[s].Fields["guidfield"].fieldValue); result = result.Replace("[paramLabel]", Utils.EnquoteJS((bstd.TableRows[s].Fields["firstName"].fieldValue ?? "") + " " + (bstd.TableRows[s].Fields["lastName"].fieldValue ?? ""))); sb.Append(result); if (s < bstd.TableRows.Count - 1) sb.AppendLine(","); } sb.AppendLine("];"); ltrScript.Text = @"<script type=""text/javascript""> $(document).ready(function(){ " + sb.ToString() + @" $('#studentTag1').autocomplete( { source:autoStudents, delay: 0, select : function( event, ui){ $('#studentGuid').val( ui.item.value ); $( this ).val( ui.item.label ); return false; } } ); }); </script>"; BestGrid bsGrid = new BestGrid(); bsGrid.PageRequest = Page.Request; bsGrid.Title = "Student Documents"; bsGrid.securityPage = "Student - Documents"; bsGrid.GridTable = new BestDocuments(); bsGrid.extraRowHTML = "<span><a href=\"javascript:void(0);\" onclick=\"showUploadDocument('[paramCID]','[paramSID]','[paramGuid]', [paramRowNum]);\" title=\"Upload Document\" ><img src=\"images\\folder_page.png\" alt=\"upload\" /></a></span><span><a href=\"javascript:void(0);\" onclick=\"DownloadDocument('[paramGuid]','[paramCID]','[paramSID]');\" title=\"Download Document\"><img src=\"images\\page_white_put.png\" alt=\"upload\" /></a></span>"; bsGrid.whereClause = ""; ltrGrid.Text = bsGrid.ToHTML(); }
protected void Page_Load(object sender, EventArgs e) { if (HttpContext.Current.Session["CurrentUser"] == null) { Response.Redirect("Logout.aspx"); } string centerid = Request.QueryString["cid"]; string studid = Request.QueryString["sid"]; string docGuid = Request.QueryString["guid"]; if (centerid.Equals(Utils.User.CenterId)) { if (string.IsNullOrEmpty(studid) && string.IsNullOrEmpty(docGuid)) { Response.Write("Document Details is not found"); } else { if (IsPostBack) { if (Request.Files.Count > 0) { BestField sid = new BestField() { fieldName = "studentid", fieldSize = 50, fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar }; sid.fieldValue = Request.QueryString["sid"]; BestField cid = new BestField() { fieldName = "centerid", fieldSize = 50, fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar }; cid.fieldValue = Request.QueryString["cid"]; BestField docguid = new BestField() { fieldType = "System.Guid", fieldSize = 50, fieldName = "guidfield", paramOledbType = OleDbType.Guid }; docguid.fieldValue = docGuid; BestDocuments bestDocs = new BestDocuments(); List<BestField> bparams = new List<BestField>(); bparams.Add(sid); bparams.Add(cid); bparams.Add(docguid); bestDocs.LoadRows("studentid = ? and centerid = ? and guidfield=?", bparams); OleDbCommand myCmd = bestDocs.dbCmd; if (bestDocs.CurrentRow.IsNew) { this.errorDisplay.Text = "<div class=\"err\">Document Details Not Found</div>"; } else { myCmd.CommandText = "update BestDocuments set documentFile = ?, documentFileSize = ?, documentFileName = ? where studentid=? and centerid=? and guidfield=?"; HttpPostedFile PostedFile = docFile.PostedFile; byte[] docBytes = new byte[PostedFile.ContentLength]; HttpPostedFile uploadedImage = PostedFile; uploadedImage.InputStream.Read(docBytes, 0, (int)PostedFile.ContentLength); object tvalue = docBytes; OleDbParameter p1 = new OleDbParameter("documentFile", OleDbType.LongVarBinary, -1, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, tvalue); OleDbParameter p2 = new OleDbParameter("documentFileSize", OleDbType.VarChar, 12); p2.Value = PostedFile.ContentLength; OleDbParameter p3 = new OleDbParameter("documentFileName", OleDbType.VarChar, 100); p3.Value = PostedFile.FileName; myCmd.Parameters.Clear(); myCmd.Parameters.Add(p1); myCmd.Parameters.Add(p2); myCmd.Parameters.Add(p3); myCmd.Parameters.Add(sid.Param); myCmd.Parameters.Add(cid.Param); myCmd.Parameters.Add(docguid.Param); try { myCmd.ExecuteNonQuery(); this.errorDisplay.Text = "<div>Document Uploaded.</div><script type=\"text/javascript\">window.parent.closeUploadDoc();</script>"; } catch (Exception ex) { this.errorDisplay.Text = "<div class=\"err\">There was an error saving the photo.<br />" + HttpUtility.HtmlEncode(ex.Message) + "</div>"; } } } } } } else { Response.Write("Center Information is not valid."); } }