public void FillCollegeList() { dtCollege = new System.Data.DataTable(); oclsEligibilityDBAccess = new clsEligibilityDBAccess(); int uniID = Convert.ToInt32(clsGetSettings.UniversityID); try { dtCollege = oclsEligibilityDBAccess.ListColleges(uniID); if (dtCollege.Rows.Count > 0) { foreach (DataRow drCollege in dtCollege.Rows) { string itemValue = drCollege["pk_Inst_ID"].ToString() + "|" + drCollege["Inst_Code"].ToString(); ddlCollegeName.Items.Add(new ListItem(drCollege["Inst_Name"].ToString() + "," + drCollege["Inst_City"].ToString(), itemValue)); } foreach (ListItem li in this.ddlCollegeName.Items) { li.Attributes.Add("title", li.Text); } ddlCollegeName.Items.Insert(0, new ListItem("--- Select ---", "0")); } ddlCollegeName.Attributes.Add("onmouseover", "this.title=this.options[this.selectedIndex].title"); } catch (Exception) { dtCollege = null; } }
/// <summary> /// Delete button click event /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btDel_Click(object sender, EventArgs e) { if (hid_Del_New_Identity.Value != string.Empty) { oclsEligibilityDBAccess = new clsEligibilityDBAccess(); user = (clsUser)Session["user"]; //Get the student IDs by splitting button ID string[] delIDs = ((Button)sender).ID.Split('-'); string[] baseIDs = hid_Del_New_Identity.Value.Split('-'); int iRet = oclsEligibilityDBAccess.DeleteDuplicateProfile(delIDs[1], delIDs[2], delIDs[3], Convert.ToString(user.User_ID), baseIDs[0], baseIDs[1], baseIDs[2]); if (iRet > 0) { //lblMsg.Text = "Profile deleted successfully."; //lblMsg.CssClass = "saveNote"; hid_FromPage.Value = "MatchingProfile__2.aspx"; GetRecords(); } else { lblMsg.Text = "Error occured while deleting Profile."; lblMsg.CssClass = "errorNote"; } oclsEligibilityDBAccess = null; } else { lblMsg.Text = "Profile cannot be deleted. Please contact administrator."; lblMsg.CssClass = "errorNote"; } }
protected void GV_DeleteProfile_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteProfile") { string[] IDs = e.CommandArgument.ToString().Split('|'); oclsEligibilityDBAccess = new clsEligibilityDBAccess(); string sRet = string.Empty; Classes.clsUser user = (Classes.clsUser)Session["User"]; // //DeleteDanglingStudent(uniID, year, studentID, userID, New identity); // sRet = oclsEligibilityDBAccess.DeleteDanglingStudent(IDs[0], IDs[1], IDs[2], user.User_ID, string.Empty); if (sRet == "Y") { lblMsg.Text = "Profile deleted successfully."; lblMsg.CssClass = "saveNote"; GetRecords(hid_pindex.Value); } else { lblMsg.Text = "Profile could be deleted. Please contact the administrator."; lblMsg.CssClass = "errorNote"; } } }
protected void btnMerge_Click(object sender, EventArgs e) { if (hid_MergeFlag.Value == "N") { lblMsg.Text = "These profiles could not be merged.<BR>Selected profile has opted the Additional Paper of the " + (string)GetLocalResourceObject("Course") + " Part/Term which is already available with the Base Profile. "; lblMsg.CssClass = "errorNote"; btnMerge.Enabled = false; GetRecords(); return; } else { string[] arrBaseStudentIDs = hid_BaseStudentIDs.Value.Split('-'); string[] arrMergeStudentIDs = hid_ProfileToBeMerged.Value.Split('-'); StringBuilder sb = new StringBuilder("<Student>"); foreach (GridViewRow row in GVTermRetain.Rows) { string[] courseIds = row.Cells[3].Text.Split('|'); if (((RadioButtonList)row.FindControl("rblMergeRemove")).SelectedValue == "M") { sb.Append("<Term Base_Uni_ID=\"" + arrBaseStudentIDs[0] + "\" Base_Year=\"" + arrBaseStudentIDs[1] + "\" Base_Student_ID=\"" + arrBaseStudentIDs[2] + "\" ToMerge_Uni_ID=\"" + arrMergeStudentIDs[0] + "\" ToMerge_Year=\"" + arrMergeStudentIDs[1] + "\" ToMerge_Student_ID=\"" + arrMergeStudentIDs[2] + "\" "); sb.Append("pk_Fac_ID=\"" + courseIds[0] + "\" pk_Cr_ID=\"" + courseIds[1] + "\" pk_MoLrn_ID=\"" + courseIds[2] + "\" pk_Ptrn_ID=\"" + courseIds[3] + "\" pk_Brn_ID=\"" + courseIds[4] + "\" pk_CrPr_Details_ID=\"" + courseIds[5] + "\" pk_CrPrCh_ID=\"" + courseIds[6] + "\" />"); } } sb.Append("</Student>"); oclsEligibilityDBAccess = new clsEligibilityDBAccess(); user = (clsUser)Session["user"]; /// <param name="base_Uni_ID"></param> /// <param name="base_Year"></param> /// <param name="base_Student_ID"></param> /// <param name="toMerge_Uni_ID"></param> /// <param name="toMerge_Year"></param> /// <param name="toMerge_Student_ID"></param> /// <param name="termsToBeMerge"></param> /// <param name="uSERID"></param> /// <param name="new_Identity"></param> string sReturn = oclsEligibilityDBAccess.ConfirmMerge(arrBaseStudentIDs[0], arrBaseStudentIDs[1], arrBaseStudentIDs[2], arrMergeStudentIDs[0], arrMergeStudentIDs[1], arrMergeStudentIDs[2], sb.ToString(), Convert.ToString(user.User_ID), hid_BaseStudentIDs.Value); oclsEligibilityDBAccess = null; if (hid_FromPage.Value == "MatchingProfile__1.aspx") { hid_BaseStudentIDs.Value = string.Empty; hid_ProfileToBeMerged.Value = string.Empty; hid_FromPage.Value = "MatchingProfile__3.aspx"; Server.Transfer("MatchingProfile__1.aspx"); } else { hid_FromPage.Value = "MatchingProfile__3.aspx"; Server.Transfer("MatchingProfile__2.aspx"); } } }
public void ProcessRequest(HttpContext context) { string imgType = context.Request.QueryString["img"]; string UniId = context.Request.QueryString["UniID"]; string StudentId = context.Request.QueryString["StudentID"]; string Year = context.Request.QueryString["YearID"]; oclsElgDBAccess = new clsEligibilityDBAccess(); DataTable odt = new DataTable(); odt = oclsElgDBAccess.ShowPhotoSign(UniId, Year, StudentId); context.Response.ContentType = "image/jpeg"; System.Drawing.Image img; if (odt.Rows.Count > 0) { if (imgType == "Photo") { byte[] Bytes = (byte[])odt.Rows[0]["Photograph"]; System.IO.Stream s = new System.IO.MemoryStream(Bytes); img = System.Drawing.Image.FromStream(s); MemoryStream ms = new MemoryStream(); img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); img = clsResizeImage.ResizeImage(ms, 55, 80); // Save the image to the OutputStream. if (img != null) { img.Save(context.Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg); } } else if (imgType == "Sign") { byte[] Bytes = (byte[])odt.Rows[0]["Signature"]; System.IO.Stream s = new System.IO.MemoryStream(Bytes); img = System.Drawing.Image.FromStream(s); MemoryStream ms = new MemoryStream(); img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); img = clsResizeImage.ResizeImage(ms, 80, 55); // Save the image to the OutputStream. if (img != null) { img.Save(context.Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg); } } } }
/// <summary> /// Repeater data binding method. /// </summary> /// <param name="crTable"></param> private void BindRepeater() { clsEligibilityDBAccess oclsEligibilityDBAccess = new clsEligibilityDBAccess(); crTable = oclsEligibilityDBAccess.GetStudentsCourseProfile(uniID, year, studentID); if (crTable != null && crTable.Rows.Count > 0) { RptCourse.DataSource = crTable; RptCourse.DataBind(); divCourseProfile.Visible = true; } else { divCourseProfile.Visible = false; } }
/// <summary> /// Repeater data binding method. /// </summary> /// <param name="crTable"></param> public void BindRepeater() { clsEligibilityDBAccess oclsEligibilityDBAccess = new clsEligibilityDBAccess(); crTable = oclsEligibilityDBAccess.GetStudentsCourseProfileForCancelAdmission(uniID, year, studentID); if (crTable != null && crTable.Rows.Count > 0) { RptCourse.DataSource = crTable; RptCourse.DataBind(); divCourseProfile.Visible = true; divCourse.Visible = true; hid_Term_Count.Value = crTable.Rows.Count.ToString(); } else { divCourseProfile.Visible = false; divCourse.Visible = false; } }
/// <summary> /// Get records of Dangling students /// </summary> /// <param name="p_index">Paging index</param> void GetRecords(string p_index) { oclsEligibilityDBAccess = new clsEligibilityDBAccess(); DataTable dt = oclsEligibilityDBAccess.GetDanglingStudent(hidUniID.Value, p_index); if (dt != null && dt.Rows.Count > 0) { GV_DeleteProfile.DataSource = dt; GV_DeleteProfile.DataBind(); GV_DeleteProfile.Visible = true; lblGridTitle.Visible = true; } else { lblMsg.Text = "No record(s) found."; lblMsg.CssClass = "errorNote"; GV_DeleteProfile.Visible = false; lnkViewFullList.Visible = false; lblGridTitle.Visible = false; } }
public void DisPlayData() { oDt = new DataTable(); clsEligibilityDBAccess oclsElgDBAcess = new clsEligibilityDBAccess(); oDt = oclsElgDBAcess.getMergeAndCancelAdmissionRequestStatus(); if (oDt != null && oDt.Rows.Count > 0) { lblNodata.Visible = false; lblNodata.Text = ""; GV_MergeProfileStat.Visible = true; GV_MergeProfileStat.DataSource = oDt; GV_MergeProfileStat.DataBind(); } else { GV_MergeProfileStat.Visible = false; lblNodata.Text = "No any request is in process or pending."; lblNodata.Visible = true; } }
/// <summary> /// Get records for the given match profile ID /// </summary> private void GetRecords() { // //Datatable 1 lists top 5 profiles //Datatable 2 gets all the details of profile // oclsEligibilityDBAccess = new clsEligibilityDBAccess(); ds = oclsEligibilityDBAccess.GetMatchProfileForStudentIDs(hid_MatchingStudentIDs.Value, hid_BaseStudentIDs.Value); if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0) { //Listing profiles and categories FillFilter(ds.Tables[0]); //Rendering profile details RenderTable(ds.Tables[1]); //Check for locked profile if (ds.Tables[2] != null && Convert.ToInt32(ds.Tables[2].Rows[0][0]) > 0) { hidLockedProfile.Value = "1"; //Display request submitted message if (hid_FromPage.Value == "MatchingProfile__3.aspx" || hid_FromPage.Value == "MatchingProfile__2.aspx") { lblInfo.Text = "Your request has been submitted and is currently in process.<br/>You cannot perform any actions on this profile i.e. Delete Profile or Merge Profile.<br/>However you can compare the profiles if available."; lblInfo.Visible = true; //lblMsg.Text = "."; //lblMsg.CssClass = "saveNote"; } else { lblInfo.Text = "Request related to this profile is already submitted and is in process.<br/>You cannot perform any actions on this profile i.e. Delete Profile or Merge Profile.<br/>However you can compare the profiles if available."; lblInfo.Visible = true; } } } else { lblMsg.Text = "No records found."; lblMsg.CssClass = "errorNote"; } ds = null; }
protected void Page_Load(object sender, EventArgs e) { try { hidIsPRNValidationRequired.Value = Classes.clsGetSettings.IsPRNValidationRequired; } catch { if (hidIsPRNValidationRequired.Value == "") { hidIsPRNValidationRequired.Value = "N"; } } if (!IsPostBack) { oElg = new clsEligibilityDBAccess(); dt = new DataTable(); dt = oElg.ListMatchingProfiles(); if (dt.Rows.Count > 0) { DataView odv = dt.DefaultView; ViewState["AutoGeneratedData"] = dt; lblcnt.Text = "Total Profiles matched by the system: " + Convert.ToString(dt.Rows.Count); rptStudNameIntials.DataSource = odv.ToTable(true, "StudentNameIntials"); rptStudNameIntials.DataBind(); bindGrid(null); } else { lblcnt.Text = "Total Profiles matched by the system: 0"; divGridHead.Attributes.Add("style", "display:none;"); } } }
void GetRecords() { oclsEligibilityDBAccess = new clsEligibilityDBAccess(); ds = oclsEligibilityDBAccess.GetMatchProfileForStudentIDs(hid_ProfileToBeMerged.Value + "," + hid_BaseStudentIDs.Value, hid_BaseStudentIDs.Value); if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0) { //Rendering profile details RenderTable(ds.Tables[1]); } string[] arrBaseStudentIDs = hid_BaseStudentIDs.Value.Split('-'); string[] arrMergeStudentIDs = hid_ProfileToBeMerged.Value.Split('-'); ds = oclsEligibilityDBAccess.GetCourseDetailsForConfirmMerge(arrMergeStudentIDs[0], arrMergeStudentIDs[1], arrMergeStudentIDs[2], arrBaseStudentIDs[0], arrBaseStudentIDs[1], arrBaseStudentIDs[2]); if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { //lblPName.Text = Convert.ToString(ds.Tables[0].Rows[0]["StudentName"]); //lblBName.Text = Convert.ToString(ds.Tables[0].Rows[1]["StudentName"]); //lblPPRN.Text = Convert.ToString(ds.Tables[0].Rows[0]["PRN"]); //lblBPRN.Text = Convert.ToString(ds.Tables[0].Rows[1]["PRN"]); //string[] MergeArr = hid_ProfileToBeMerged.Value.Split('-'); //string[] BaseArr = hid_BaseStudentIDs.Value.Split('-'); //MPImg.ImageUrl = "PhotoSignHandler.ashx?img=Photo&UniID=" + MergeArr[0] + "&StudentID=" + MergeArr[2] + "&YearID=" + MergeArr[1]; //MSImg.ImageUrl = "PhotoSignHandler.ashx?img=Sign&UniID=" + MergeArr[0] + "&StudentID=" + MergeArr[2] + "&YearID=" + MergeArr[1]; //BPImg.ImageUrl = "PhotoSignHandler.ashx?img=Photo&UniID=" + BaseArr[0] + "&StudentID=" + BaseArr[2] + "&YearID=" + BaseArr[1]; //BSImg.ImageUrl = "PhotoSignHandler.ashx?img=Sign&UniID=" + BaseArr[0] + "&StudentID=" + BaseArr[2] + "&YearID=" + BaseArr[1]; } if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0) { DataView dv1 = ds.Tables[1].DefaultView; dv1.RowFilter = "MergeStatus = 'N'"; if (dv1.ToTable().Rows.Count > 0) { GVTermRemove.DataSource = dv1.ToTable(); GVTermRemove.DataBind(); divGridRemoveTitle.Visible = true; divGridRemoveTitle.InnerText = "List of Terms already available with Base profile"; } else { divGridRemoveTitle.Visible = false; } DataView dv2 = ds.Tables[1].DefaultView; dv2.RowFilter = "MergeStatus = 'Y'"; if (dv2.ToTable().Rows.Count > 0) { GVTermRetain.DataSource = dv2.ToTable(); GVTermRetain.DataBind(); divGridRetainTitle.Visible = true; divGridRetainTitle.InnerText = "List of Terms to be retained with Base profile"; } else { divGridRetainTitle.Visible = false; } } if (ds.Tables[2].Rows.Count > 0) { DataView dvFilter = ds.Tables[2].DefaultView; dvFilter.RowFilter = "AddPaperStatus = 'Y'"; if (dvFilter.ToTable().Rows.Count > 0) { hid_MergeFlag.Value = "N"; } } }
/// <summary> /// Bind grid for manual match /// </summary> private void bindManualSearchGrid() { CreateHashTable(); oElg = new clsEligibilityDBAccess(); ds = new DataSet(); ds = oElg.ManualProfileMatch(ht); if (ds.Tables[0].Rows.Count == 1) { if (ds.Tables[0].Rows[0]["LockedProfile"].ToString() == "1") { ManualSearch.Attributes.Add("style", "display:inline;width:100%"); lblSmplSrch.Attributes.Add("style", "display:inline"); lblSmplSrch.Text = "(Match Profile Automatically)"; divNote.Attributes.Add("style", "display:none"); ManualSrchGrid.Attributes.Add("style", "display:none"); lblErrorMsg.Attributes.Add("style", "display:inline"); string sCriteria = string.Empty; if (txtPRN.Text != string.Empty) { sCriteria = sCriteria + lblPRN.Text + ", "; } if (txtOldPRN.Text != string.Empty) { sCriteria = sCriteria + Label2.Text + ", "; } if (txtElgFrmNo.Text != string.Empty) { sCriteria = sCriteria + "Eligibility form number,"; } sCriteria = sCriteria.Remove(sCriteria.LastIndexOf(',')); lblErrorMsg.Text = "Merge/Delete Profile request for this profile is already submitted and is in process."; return; } if (Convert.ToString(ds.Tables[0].Rows[0]["PRN_Number"]).Trim() == string.Empty || Convert.ToString(ds.Tables[0].Rows[0]["PRN_Number"]).Trim() == "Not Available") { ManualSearch.Attributes.Add("style", "display:inline;width:100%"); lblSmplSrch.Attributes.Add("style", "display:inline"); lblSmplSrch.Text = "(Match Profile Automatically)"; divNote.Attributes.Add("style", "display:none"); ManualSrchGrid.Attributes.Add("style", "display:none"); lblErrorMsg.Attributes.Add("style", "display:inline"); string sCriteria = string.Empty; if (txtPRN.Text != string.Empty) { sCriteria = sCriteria + lblPRN.Text + ", "; } if (txtOldPRN.Text != string.Empty) { sCriteria = sCriteria + Label2.Text + ", "; } if (txtElgFrmNo.Text != string.Empty) { sCriteria = sCriteria + "Eligibility form number,"; } sCriteria = sCriteria.Remove(sCriteria.LastIndexOf(',')); lblErrorMsg.Text = (string)GetLocalResourceObject("lblPRNResource1.Text") + " does not exists for the searched student."; return; } lblSubHeader.Text = "<B>Student: </B>" + Convert.ToString(ds.Tables[0].Rows[0]["StudentName"]) + ", <B>" + lblPRN.Text + ": </B>" + Convert.ToString(ds.Tables[0].Rows[0]["PRN_Number"]) + ", <B>" + Label2.Text + ": </B>" + Convert.ToString(ds.Tables[0].Rows[0]["OldPRN_Number"]); if (ds.Tables[1].Rows.Count > 1) { ManualSrchGrid.Attributes.Add("style", "display:inline"); divMCriteria.Attributes.Add("style", "display:inline"); Mcriteria.InnerText = hid_MatchingCriteria.Value; int TotalMatchingCount = Convert.ToInt32(ds.Tables[2].Rows[0][0]); if (TotalMatchingCount > 5) { gCaption.InnerHtml = "<b>Showing Top 5 Student Profiles out of " + TotalMatchingCount + " Matching Profiles found.</b>"; } lblErrorMsg.Attributes.Add("style", "display:none"); divNote.Attributes.Add("style", "display:inline"); ManualInfo.Attributes.Add("style", "display:inline"); AutoGeneratedInfo.Attributes.Add("style", "display:none"); hid_BaseStudentIDs.Value = ds.Tables[0].Rows[0][0].ToString(); gVSearchDuplicate.DataSource = ds.Tables[1]; gVSearchDuplicate.DataBind(); } else { lblErrorMsg.Attributes.Add("style", "display:inline"); lblErrorMsg.Text = "No Matching Profile Found."; ManualSrchGrid.Attributes.Add("style", "display:none"); divMCriteria.Attributes.Add("style", "display:none"); divNote.Attributes.Add("style", "display:none"); ManualSearch.Attributes.Add("style", "display:inline;width:100%"); lblSmplSrch.Attributes.Add("style", "display:inline"); lblSmplSrch.Text = "(Match Profile Automatically)"; } } else { ManualSearch.Attributes.Add("style", "display:inline;width:100%"); lblSmplSrch.Attributes.Add("style", "display:inline"); lblSmplSrch.Text = "(Match Profile Automatically)"; divNote.Attributes.Add("style", "display:none"); ManualSrchGrid.Attributes.Add("style", "display:none"); lblErrorMsg.Attributes.Add("style", "display:inline"); string sCriteria = string.Empty; if (txtPRN.Text != string.Empty) { sCriteria = sCriteria + lblPRN.Text + ", "; } if (txtOldPRN.Text != string.Empty) { sCriteria = sCriteria + Label2.Text + ", "; } if (txtElgFrmNo.Text != string.Empty) { sCriteria = sCriteria + "Eligibility form number,"; } sCriteria = sCriteria.Remove(sCriteria.LastIndexOf(',')); lblErrorMsg.Text = "Given " + sCriteria + " doesn't exists."; } }