protected void btnSave_Click(object sender, EventArgs e) { string sReturn = ""; string studID = ""; lblUnselectCheck.Text = ""; int iCount = 0; if (hidRightsFlag.Value == "0") { DataGridItemCollection items = DG_University.Items; for (int i = 0; i < items.Count; i++) { CheckBox cb = (CheckBox)items[i].FindControl("chkSelect"); if ((cb != null) && (cb.Checked == true)) { studID += DG_University.DataKeys[i].ToString().Trim() + ","; iCount = iCount + 1; } } } else { if (DG_College.Items.Count > 0) { iCount = DG_College.Items.Count; } } sReturn = clsEligibilityRights.Bulk_Process_Eligibility_Data(hidUniID.Value, hidYear.Value, hidInstID.Value, hidCrMoLrnPtrnID.Value, hidCrPrID.Value, studID, hidCollege_Eligibility_Flag.Value, "1", "", sUser); if (sReturn == "Y") { string SMSreturn = ""; string SMSMessage = ""; clsUser u = (clsUser)Session["User"]; //Added By Saroj on 1st Nov 2007 try { SendSMS objSendSMS = new SendSMS(); DataSet ds = clsEligibilityRights.FetchRegisteredStudentDetailsForSMS(hidUniID.Value, hidYear.Value, hidInstID.Value, hidCrMoLrnPtrnID.Value, hidCrPrID.Value, studID); if (ds != null) { //if (ds.Tables.Count > 0) //{ // for (int i = 0; i < ds.Tables.Count; i++) // { // SMSMessage = "Congrats " + ds.Tables[i].Rows[0]["FirstName"].ToString() + ",U R elgble for " + ds.Tables[i].Rows[0]["CrAbbr"].ToString() + ",PRN:" + ds.Tables[i].Rows[0]["PRN"].ToString() + ",Collect eSuvidha LoginId,Password from college and visit " + UniversityPortal.clsGetSettings.SitePath.Replace("http://",""); // objSendSMS.epMessage = SMSMessage; // SMSreturn = objSendSMS.SendPersonalizedSMS(ds.Tables[i].Rows[0]["MobileNumber"].ToString().Trim(), "ELG" + ds.Tables[i].Rows[0]["EligibilityFormNo"].ToString()); // } //} if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { //SMSMessage = "Congrats " + hidSMSFirstName.Value + ",You are eligible for " + hidSMSCrAbbr.Value + " of " + TripleDESEncryption.clsAppSettings.DecryptAppsettings().AppSettings["SMSPcode"].ToString().ToUpper() + ". Your PRN:" + PRN + "."; SMSMessage = "Congrats " + ds.Tables[0].Rows[i]["FirstName"].ToString() + ",You are eligible for " + ds.Tables[0].Rows[i]["CrAbbr"].ToString() + " of " + TripleDESEncryption.clsAppSettings.DecryptAppsettings().AppSettings["SMSPcode"].ToString().ToUpper() + ". Your PRN:" + ds.Tables[0].Rows[i]["PRN"].ToString(); objSendSMS.epMessage = SMSMessage; objSendSMS.epUser = u.User_ID; //Added By Saroj on 1st Nov 2007 SMSreturn = objSendSMS.SendPersonalizedSMS(ds.Tables[0].Rows[i]["MobileNumber"].ToString().Trim(), "ELG" + ds.Tables[0].Rows[i]["EligibilityFormNo"].ToString()); } } } } catch (Exception ex) { string sMsg = ex.Message; string strScript = "<script language=JavaScript>alert('" + sMsg + "');</Script>"; ClientScript.RegisterStartupScript(this.GetType(), "key1", strScript); } lblSave.Visible = true; lblSave.CssClass = "SaveNote"; lblSave.Text = "Eligibility processed for " + iCount + " students and PRN generated successfully.<br>To view list of eligible students and PRN generated click on \"View Eligible Students With PRN\" link."; lblUniCollPrn.Text = ""; displayGrids(); } else { lblSave.CssClass = "ErrorNote"; lblSave.Text = "System has encountered an error during Process.<br>Please try again later"; } }
protected void btnSubmit_Click(object sender, System.EventArgs e) { divEligibilityDecision.Style.Add("display", "none"); //if (rbPending.Checked == true) //{ // divPRN.Style.Add("display", "block"); // lblPRN.Text = "<Font color='#c00000' size='3'>Selected record has already been processed for 'Pending Eligible' decision.</font><br>The SMS regarding the same is already been sent to the student."; //} if (GoToDataBase == 1) { string sReason = ""; string PRN, ElgLabel = ""; string flag = "0"; DataSet dsDocs = new DataSet(); DataRow dr; dsDocs.Tables.Add("StudentDocs"); dsDocs.Tables["StudentDocs"].Columns.Add("fk_Doc_ID"); dsDocs.Tables["StudentDocs"].Columns.Add("RecvdBy_Uni"); dsDocs.Tables["StudentDocs"].Columns.Add("ValidityBy_Uni"); int j = 0; for (int i = 0; i < hidDocXML.Value.Length; i += 2) { if (hidDocXML.Value[i] == '1') //if checkbox checked = true { dr = dsDocs.Tables["StudentDocs"].NewRow(); dr["fk_Doc_ID"] = DGSubmittedDocs1.Rows[j].Cells[5].Text.Trim(); dr["RecvdBy_Uni"] = '1'; dr["ValidityBy_Uni"] = hidDocXML.Value[i + 1]; dsDocs.Tables["StudentDocs"].Rows.Add(dr); } else if (hidDocXML.Value[i] == '0') //if checkbox checked = false { dr = dsDocs.Tables["StudentDocs"].NewRow(); dr["fk_Doc_ID"] = DGSubmittedDocs1.Rows[j].Cells[5].Text.Trim(); dr["RecvdBy_Uni"] = '0'; dr["ValidityBy_Uni"] = ""; dsDocs.Tables["StudentDocs"].Rows.Add(dr); } j++; } sReason = tbOldReason.Text.Replace("'", ""); System.Text.StringBuilder sb = new System.Text.StringBuilder(1000); //contains XML fmt of Docs System.IO.StringWriter sw = new System.IO.StringWriter(sb); dsDocs.WriteXml(sw, XmlWriteMode.IgnoreSchema); //string sbuilder = ""; //if(sb.Length==14) //if empty contains "</newdataset>" // sb = (System.Text.StringBuilder)null; //sb = (System.Text.StringBuilder)Convert.DBNull; if (rbEligible.Checked) //Eligible { divReason.Attributes.Add("style", "display:none"); flag = "1"; ElgLabel = "Eligible"; lblPendingReason.Text = ""; sReason = tbOldReason.Text.Replace("\r\n", "") + "[Resolved]"; } else if (rbDefaulter.Checked) //Not Eligible { flag = "2"; ElgLabel = "Not Eligible"; sReason = tbOldReason.Text.Replace("\r\n", "") + "===" + DateTime.Now.ToString("MM/dd/yy HH:mm") + "===" + tbReason.Text.ToString().Trim(); } else if (rbPending.Checked) //Pending { flag = "3"; ElgLabel = "Pending"; sReason = tbOldReason.Text.Replace("\r\n", "") + "===" + DateTime.Now.ToString("MM/dd/yy HH:mm") + "===" + tbReason.Text.ToString().Trim(); divPRN.Style.Add("display", "block"); lblPRN.Text = "<Font color='#c00000' size='3'>Selected record has already been processed for 'Pending Eligible' decision with probably some changes in the Student Document details.</font>"; //<br>The SMS regarding the same is already been sent to the student."; } else if (rbProvisional.Checked) //Provisionally Eligible { flag = "5"; ElgLabel = "Provisionally Eligible"; sReason = tbOldReason.Text.Replace("\r\n", "") + "===" + DateTime.Now.ToString("MM/dd/yy HH:mm") + "===" + tbReason.Text.ToString().Trim(); } tbOldReason.Text = FormatReason(sReason).Replace("<br/>", Environment.NewLine); hidElgFlag.Value = flag; if (lblPermRegNo.Text == "" || lblPermRegNo.Text == null || lblPermRegNo.Text == "-" || lblPermRegNo.Text == "Not Generated") { lblPermRegNo.Text = "00"; } RefIDarr = hidElgFormNo.Value.Split('-'); //PRN = clsEligibilityDBAccess.REG_PendingEStudEligibilityDecision(Convert.ToInt32(ConfigurationSettings.AppSettings["UniversityID"].ToString()),Convert.ToInt32(Session["pk_Year"].ToString()),Convert.ToInt32(Session["pk_Student_ID"].ToString()),Convert.ToInt32(Session["pk_CrMoLrnPtrn_ID"].ToString()),flag,sb,tbReason.Text.Trim(),lblPermRegNo.Text.Trim(),userid); string[] strArr = new string[2]; int Error; //string DCServer = TripleDESEncryption.clsAppSettings.DecryptAppsettings().AppSettings["DCServer"].ToString(); //string DCDataBase = TripleDESEncryption.clsAppSettings.DecryptAppsettings().AppSettings["DCDataBase"].ToString(); string DCServer = Convert.ToString(clsGetSettings.DCServer); string DCDataBase = Convert.ToString(clsGetSettings.DCDatabase); strArr = clsEligibilityDBAccess.REG_PendingStudentEligibilityDecision(Convert.ToInt32(Classes.clsGetSettings.UniversityID.ToString()), Convert.ToInt32(hidpkYear.Value), Convert.ToInt32(hidpkStudentID.Value), Convert.ToInt32(RefIDarr[0].ToString()), Convert.ToInt32(RefIDarr[1].ToString()), Convert.ToInt32(RefIDarr[2].ToString()), Convert.ToInt32(RefIDarr[3].ToString()), Convert.ToInt32(hidpkFacID.Value), Convert.ToInt32(hidpkCrID.Value), Convert.ToInt32(hidpkMoLrnID.Value), Convert.ToInt32(hidpkPtrnID.Value), Convert.ToInt32(hidpkBrnID.Value), Convert.ToInt32(hidpkCrPrDetailsID.Value), Convert.ToInt32(hid_fk_AcademicYr_ID.Value), flag, sb, lblPermRegNo.Text.Trim(), sReason, userid, DCServer, DCDataBase); PRN = strArr[0]; Error = Convert.ToInt32(strArr[1]); lblPermRegNo.Text = PRN; //FetchStudentDetails(); clsUser u = (clsUser)Session["User"]; //Added By Saroj on 1st Nov 2007 if (Error == 0 && flag != "3") { string SMSreturn = ""; string SMSMessage = ""; try { SendSMS objSendSMS = new SendSMS(); divPRN.Style.Add("Display", "block"); //lblPRN.Text ="The Student is Marked as <br><Font color='red' size='2'>"+ElgLabel+"</font><br> for the Course "+lblCourse.Text +" ."; lblPRN.Text = "The Student is Marked as <br><Font color='red' size='2'>" + ElgLabel + "</font><br>"; if (flag == "1") { if (lblPermRegNo.Text != "" && lblPermRegNo.Text != "00" && lblPermRegNo.Text != null) { lblPRN.Text += " The " + lblPermanentRegistrationNumber.Text + " for the Student "; lblPRN.Text += "<i>" + lblNameOfStudent.Text + "</i> is <br><Font color='red' size='3'>" + PRN + "</Font><br>Please write " + lblPRNNomenclature.Text + " on the Admission/Eligibility form."; Cache["PRN"] = lblPRN.Text; Cache["GeneratedPRN"] = PRN; } else { lblPRN.Text += " \nThe " + lblPermanentRegistrationNumber.Text + " for the Student "; lblPRN.Text += "<i>" + lblNameOfStudent.Text + "</i> is same<br><Font color='red' size='3'>" + lblPermRegNo.Text + "</Font><br>Please write " + lblPRNNomenclature.Text + " on the Admission/Eligibility form."; Cache["PRN"] = lblPRN.Text; Cache["GeneratedPRN"] = PRN; } //========================================================================================== // To fetch Student login credentials for displaying in SMS string userName = string.Empty, password = string.Empty; DataSet Ds = clsEligibilityRights.GetStudentCredentialsForSMS(hidUniID.Value, hidpkYear.Value, hidpkStudentID.Value); if (Ds != null && Ds.Tables[0] != null && Ds.Tables[0].Rows.Count > 0) { userName = Ds.Tables[0].Rows[0]["UserName"].ToString(); password = Ds.Tables[0].Rows[0]["Password"].ToString(); } //========================================================================================== //SMSMessage = "Congrats " + hidSMSFirstName.Value + ",You are eligible for " + hidSMSCrAbbr.Value + " for Academic Year " + hidAcademicYr.Value + " of " + TripleDESEncryption.clsAppSettings.DecryptAppsettings().AppSettings["SMSPcode"].ToString().ToUpper() + ". Your " + lblPRNNomenclature.Text + ":" + PRN + "."; //SMSMessage = clsEligibilityRights.GetSMSBody("24", hidSMSFirstName.Value, hidSMSCrAbbr.Value, hidAcademicYr.Value, hidUniAbbrv.Value, PRN, TripleDESEncryption.clsAppSettings.DecryptAppsettings().AppSettings["SitePath"].ToString(), userName, password, string.Empty); SMSMessage = clsEligibilityRights.GetSMSBody("24", hidSMSFirstName.Value, hidSMSCrAbbr.Value, hidAcademicYr.Value, hidUniAbbrv.Value, PRN, clsGetSettings.SitePath, userName, password, string.Empty); objSendSMS.epMessage = SMSMessage; objSendSMS.epUser = u.User_ID;//Added By Saroj on 1st Nov 2007 lblPendingReason.Text = FormatReason(tbOldReason.Text); } else if (flag == "5") { if (PRN != null && PRN != "") { lblPRN.Text = "The Student is Marked as <Font color='red' size='2'><b>" + ElgLabel + "</b></font><br>"; lblPRN.Text += "The " + lblPermanentRegistrationNumber.Text + " for the Student "; lblPRN.Text += "<b><i>" + lblNameOfStudent.Text + "</i></b> is <br><Font color='#c00000' size='3'>" + PRN + "</Font><br><Font size=2>Please write " + lblPRNNomenclature.Text + " on the Admission/Eligibility form.</Font>"; Cache["PRN"] = lblPRN.Text; Cache["GeneratedPRN"] = PRN; //========================================================================================== // To fetch Student login credentials for displaying in SMS string userName = string.Empty, password = string.Empty; DataSet Ds = clsEligibilityRights.GetStudentCredentialsForSMS(hidUniID.Value, hidpkYear.Value, hidpkStudentID.Value); if (Ds != null && Ds.Tables[0] != null && Ds.Tables[0].Rows.Count > 0) { userName = Ds.Tables[0].Rows[0]["UserName"].ToString(); password = Ds.Tables[0].Rows[0]["Password"].ToString(); } //========================================================================================== //SMSMessage = "Dear " + hidSMSFirstName.Value + ",You are provisionally eligible for " + hidSMSCrAbbr.Value + " for Academic Year " + hidAcademicYr.Value + " of " + TripleDESEncryption.clsAppSettings.DecryptAppsettings().AppSettings["SMSPcode"].ToString().ToUpper() + ". Your " + lblPRNNomenclature.Text + ":" + PRN + ". Discrepancy is available in " + lblCollege.Text.ToLower() + "'s login on Digital " + lblUniversity.Text + " Portal of eSuvidha."; SMSMessage = clsEligibilityRights.GetSMSBody("3", hidSMSFirstName.Value, hidSMSCrAbbr.Value, hidAcademicYr.Value, hidUniAbbrv.Value, PRN, clsGetSettings.SitePath, userName, password, string.Empty); objSendSMS.epMessage = SMSMessage; objSendSMS.epUser = u.User_ID; //Added By Saroj on 1st Nov 2007 } else { lblPRN.Text = "System has encountered an error in the registration process. Hence, Registration failed !!!<br>Please try again later."; } lblPendingReason.Text = FormatReason(tbOldReason.Text); } else if ((flag == "2") || (flag == "3")) { if (lblPermRegNo.Text != "" && lblPermRegNo.Text != "00" && lblPermRegNo.Text != null) { lblPRN.Text += "\nThe " + lblPermanentRegistrationNumber.Text + " for the Student "; lblPRN.Text += "<i>" + lblNameOfStudent.Text + "</i> is same<br><Font color='red' size='3'>" + lblPermRegNo.Text + "</Font><br>Please write " + lblPRNNomenclature.Text + " on the Admission/Eligibility form."; Cache["PRN"] = lblPRN.Text; Cache["GeneratedPRN"] = PRN; } else { lblPRN.Text = "The Student <i>" + lblNameOfStudent.Text + "</i> is marked <br><Font color='#c00000' size='2'>" + ElgLabel + "</Font><br> for the " + lblCr.Text + " " + lblCourse.Text; Cache["PRN"] = lblPRN.Text; } lblPendingReason.Text = FormatReason(tbOldReason.Text); if (flag == "2") { //SMSMessage = "Dear " + hidSMSFirstName.Value + ", You are found ineligible for " + hidSMSCrAbbr.Value + " for Academic Year " + hidAcademicYr.Value + ". For more details contact your " + lblCollege.Text.ToLower() + "."; SMSMessage = clsEligibilityRights.GetSMSBody("5", hidSMSFirstName.Value, hidSMSCrAbbr.Value, hidAcademicYr.Value, hidUniAbbrv.Value, "", clsGetSettings.SitePath, "", "", string.Empty); } else if (flag == "3") { //SMSMessage = "Dear " + hidSMSFirstName.Value + ", your eligibility for " + hidSMSCrAbbr.Value + " for Academic Year " + hidAcademicYr.Value + " is pending. Discrepancy is available in " + lblCollege.Text.ToLower() + "'s login on Digital " + lblUniversity.Text.ToLower() + " Portal of eSuvidha."; SMSMessage = clsEligibilityRights.GetSMSBody("4", hidSMSFirstName.Value, hidSMSCrAbbr.Value, hidAcademicYr.Value, hidUniAbbrv.Value, "", clsGetSettings.SitePath, "", "", string.Empty); } objSendSMS.epMessage = SMSMessage; objSendSMS.epUser = u.User_ID; //Added By Saroj on 1st Nov 2007 } SMSreturn = objSendSMS.SendPersonalizedSMS(hidSMSMobileNumber.Value.Trim(), "ELG" + hidElgFormNo.Value); if (SMSreturn.Substring(0, 7) == "Invalid") { lblSMSError.Text = "SMS could not be sent because of following reason:<br><font size=2>" + SMSreturn + "</font>"; } else { lblSMSError.Text = "<font size=2>Following SMS has been sent to Student on:" + hidSMSMobileNumber.Value.Trim() + "<br><font size=2> (" + SMSMessage + ")</font>"; } } catch (Exception ex) { lblSMSError.Text = ex.Message; } } else if (Error != 0) { lblPRN.Text = "System has encountered an error in the registration process. Hence, Registration failed !!!<br>Please try again later."; } divEligibilityDecision.Attributes.Add("display", "none"); int k = 0; for (int l = 0; l < hidDocXML.Value.Length; l += 2) { if (hidDocXML.Value[l] == '1') //if checkbox checked = true { if (hidDocXML.Value[l + 1] == '1') { ((RadioButton)DGSubmittedDocs1.Rows[k].Cells[4].Controls[1]).Checked = true; ((RadioButton)DGSubmittedDocs1.Rows[k].Cells[4].Controls[1]).Enabled = false; } else { ((RadioButton)DGSubmittedDocs1.Rows[k].Cells[4].Controls[3]).Checked = true; ((RadioButton)DGSubmittedDocs1.Rows[k].Cells[4].Controls[3]).Enabled = false; } } k++; } if (lblPermRegNo.Text == "" || lblPermRegNo.Text == null || lblPermRegNo.Text == "00") { lblPermRegNo.Text = "-"; } GoToDataBase = 0; Session["GoToDataBase"] = GoToDataBase; } else { divPRN.Style.Add("display", "block"); lblPermRegNo.Text = Cache["GeneratedPRN"].ToString(); if (Cache["GeneratedPRN"] != null && Cache["GeneratedPRN"].ToString() != "") { divReason.Attributes.Add("style", "display:none"); } lblPRN.Text = "<Font color='#c00000' size='3'>Selected Record has Already been Processed</font><br>" + Cache["PRN"].ToString(); } for (int i = 0; i < DGSubmittedDocs1.Rows.Count; i++) { ((CheckBox)DGSubmittedDocs1.Rows[i].Cells[3].Controls[1]).Enabled = false; ((RadioButton)DGSubmittedDocs1.Rows[i].Cells[4].Controls[1]).Enabled = false; ((RadioButton)DGSubmittedDocs1.Rows[i].Cells[4].Controls[3]).Enabled = false; } }