protected void btnSave_Click(object sender, EventArgs e) { try { StudentRegistrationDAL s = new StudentRegistrationDAL(); String Body = ""; string AIPC = "NA"; if (rdbAIPC120.Checked == true) { AIPC = "120 HOURS"; } else if (rdbAIPC190.Checked == true) { AIPC = "190 HOURS"; } string Mathcrashcourse = "NA"; if (chkYesMath.Checked == true) { Mathcrashcourse = "YES"; } else if (chkNoMath.Checked == true) { Mathcrashcourse = "NO"; } if ((int.Parse(Session["DepId"].ToString()) == 32) || (int.Parse(Session["DepId"].ToString()) == 4) || (int.Parse(Session["DepId"].ToString()) == 2)) { string Result = s.InsertAdminCheckList(Request.QueryString["Id"].ToString(), lblExamType.Text, txtToeflScore.Text, txtMathScore.Text, Mathcrashcourse, txtScoreMaths.Text, AIPC, txtResultAIPC.Text, chkNoIELP.Checked, txtResultIELP.Text, txtFwType.Text, chkYesProof.Checked, txtProof.Text, txtFWAmount.Text, lblToc.Text, txtTOCAmount.Text, txtNoOfCourses.Text, lblVisaType.Text, lblHostelStatus.Text, txtAdminRemarks.Text, txtFinanceRemarks.Text, txtGeneralRemarks.Text, int.Parse(Session["EmpId"].ToString()), ""); if (Result == "Sucess") { lblMesag.Text = "Sucessfully Submitted"; lblMesag.ForeColor = System.Drawing.Color.Blue; // newlyadded for mail if (int.Parse(Session["DepId"].ToString()) == 4) { Body = "Admin Checklist is completed by Admin Department for the Registration No : " + s.GetRegNo(Request.QueryString["Id"].ToString()) + " Kindly Verify the Checklist"; SendEmails.SendEmail("*****@*****.**", "*****@*****.**", "AdminChecklist Stud ID - " + s.GetRegNo(Request.QueryString["Id"].ToString()), Body, ""); } if (int.Parse(Session["DepId"].ToString()) == 2) { if (lblFeewaiver.Text == "YES") { Body = "Admin Checklist is completed by Finance Department for the Registration No : " + s.GetRegNo(Request.QueryString["Id"].ToString()) + " Kindly Verify the Checklist"; SendEmails.SendEmail("*****@*****.**", "*****@*****.**", "AdminChecklist Stud ID - " + s.GetRegNo(Request.QueryString["Id"].ToString()), Body, ""); } } if (int.Parse(Session["DepId"].ToString()) == 32) { Body = "Admin Checklist is completed by COEC Office for the Registration No : " + s.GetRegNo(Request.QueryString["Id"].ToString()); SendEmails.SendEmail("*****@*****.**", "*****@*****.**", "AdminChecklist Stud ID - " + s.GetRegNo(Request.QueryString["Id"].ToString()), Body, ""); } } else { lblMesag.Text = "Please try again!"; lblMesag.ForeColor = System.Drawing.Color.Blue; } } else { lblMesag.Text = "Not Authorized!"; lblMesag.ForeColor = System.Drawing.Color.Blue; } } catch { } }
protected void btnverifyemail_Click(object sender, EventArgs e) { try { string Id = Request.QueryString["Id"].ToString(); int userid1 = 0; StudentRegistrationDAL s = new StudentRegistrationDAL(); try { userid1 = int.Parse(Session["EMPID"].ToString()); } catch { userid1 = userid; } DataTable RegisterNo1 = s.InsertStudentMailVerifyLogs(int.Parse(Id), userid1, txtEmailID.Text, "INSCHECK"); if (RegisterNo1.Rows[0][0].ToString().Contains("1") == true) { lblMesag.Text = "Mail Already send on -" + RegisterNo1.Rows[0][1].ToString(); lblMesag.ForeColor = System.Drawing.Color.Red; return; } string FromEmail = "*****@*****.**"; // tblEmpMaster from Session EmapId >> Emp Email Address string mailids = txtEmailID.Text; mailids = mailids + "," + Session["Emailid"].ToString(); string ToEmail = mailids; string Subject = "Registration Details"; string Body = ""; //string CC = txtEmailID.Text; string CC = ""; string Message = ""; Subject = "Welcome to Skyline University College"; Message = "<table> <tbody>"; Message = Message + "<tr><td colspan=2>Welcome to Skyline University College!!!</td>"; Message = Message + "</tr><tr><td colspan=2><br /></td>"; Message = Message + "</tr><tr><td colspan=2>Kindly reply on this email to confirm your email id for official correspondence with Skyline University College in future.</td>"; Message = Message + "</tr><tr><td colspan=2><br /></td>"; Message = Message + "<tr><td colspan=2>" + "Best Regards," + "</td></tr>"; Message = Message + "<tr><td colspan=2>" + "Skyline University College" + "</td></tr>"; Message = Message + "<tr><td colspan=2>" + "University City of Sharjah, Sharjah" + "</td></tr>"; Message = Message + "<tr><td colspan=2>" + "P.O. Box: 1797, Sharjah, U.A.E" + "</td></tr>"; Message = Message + "<tr><td colspan=2>" + "Tel. : 971-6-5441155, Fax.: 971-6-5441166" + "</td></tr>"; Message = Message + "<tr><td colspan=2>" + "Email: [email protected]" + "</td></tr>"; Message = Message + "</td></tr></tbody></table>"; Body = Message; try { DataTable RegisterNo = s.InsertStudentMailVerifyLogs(int.Parse(Id), userid1, txtEmailID.Text, "INSERT"); if (RegisterNo.Rows[0][0].ToString().Contains("1") == true) { try { SendEmails.SendEmail(FromEmail, ToEmail, Subject, Body, CC); lblMesag.Text = "Verification Mail send to Student"; lblMesag.ForeColor = System.Drawing.Color.Green; } catch { //DataTable RegisterNo1 = s.InsertStudentMailVerifyLogs(int.Parse(Id), int.Parse(Session["EMPID"].ToString()), txtEmailID.Text, "DELETE"); lblMesag.Text = "Mail not send."; lblMesag.ForeColor = System.Drawing.Color.Red; } } } catch { lblMesag.Text = "Mail not send."; lblMesag.ForeColor = System.Drawing.Color.Red; } } catch { } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { StudentRegistrationDAL s = new StudentRegistrationDAL(); if (txtRemarks.Text != "") { try { StudentRegistrationDAL d = new StudentRegistrationDAL(); string RegNo = d.GetRegNo1(Request.QueryString["Id"].ToString()); if (Session["DepId"].ToString() != "4") { DataTable dt = d.GetCheckEmails(RegNo); bool IsPresent = false; if (dt.Rows.Count == 1) { IsPresent = true; } if (IsPresent == true) { lblMesag.Text = "Please contact Admin for Cancellation or postponed"; lblMesag.ForeColor = System.Drawing.Color.Red; return; } } string Result = s.InsertIpdateStatus(Request.QueryString["Id"].ToString(), DateTime.Parse(txtCallDate.Text), ddlStudentStatus.SelectedValue, txtRemarks.Text, int.Parse(Session["EMPID"].ToString()), int.Parse(ddlTerm.SelectedValue)); if (Result == "RegisterNo") { DataSet ds = s.ProcSetProgramForCancel(Request.QueryString["Id"].ToString(), Session["EMPID"].ToString()); DataTable dtStudentDetails = ds.Tables[0]; DataTable dtEmail = ds.Tables[1]; string FromEmail = dtEmail.Rows[0]["OFFICEEMAID"].ToString(); string ToEmail = "*****@*****.**"; string Subject = "Postponed / Cancel / Active Student Detail"; string CC = "[email protected],[email protected]"; string Message = ""; Message = "<table style=background-color:#FAF1E7; text-transform:uppercase; border-color:#C67E7E; border=1><tbody>"; Message = Message + "<tr><td colspan=2><h3><font size=5>Postpond / Cancel / Actiive Student Detail</font></h3>"; Message = Message + "</td></tr><tr><td>REF NO </td><td>" + RegNo.ToUpper(); Message = Message + "</td></tr><tr><td>DATE </td><td>" + txtCallDate.Text.ToUpper(); Message = Message + "</td></tr><tr><td>NAME</td><td>" + txtName.Text.ToUpper(); Message = Message + "</td></tr><tr><td>PROCESSED BY</td><td>" + Session["Name"].ToString().ToUpper(); Message = Message + "</td></tr><tr><td>REMARKS</td><td>" + txtRemarks.Text.ToUpper(); Message = Message + "</td></tr><tr><td>STATUS</td><td>" + ddlStudentStatus.SelectedItem.Text.ToUpper(); Message = Message + "</td></tr><tr><td>PROGRAM</td><td>" + dtStudentDetails.Rows[0]["DegreeCode"].ToString().ToUpper(); Message = Message + "</td></tr><tr><td>SHIFT</td><td>" + dtStudentDetails.Rows[0]["Shift"].ToString().ToUpper(); if (ddlStudentStatus.SelectedValue == "P") { Message = Message + "</td></tr><tr><td>CURRENT TERM</td><td>" + dtStudentDetails.Rows[0]["TermName"].ToString().ToUpper(); Message = Message + "</td></tr><tr><td>POSTPONED TERM</td><td>" + ddlTerm.SelectedItem.Text.ToUpper(); } else { Message = Message + "</td></tr><tr><td>TERM</td><td>" + dtStudentDetails.Rows[0]["TermName"].ToString().ToUpper(); } Message = Message + "</td></tr></tr></tbody></table></p><p></p>"; ToEmail = "*****@*****.**"; SendEmails.SendEmail(FromEmail, ToEmail, Subject, Message, CC); lblMesag.Text = "Sucessfully Updated!!!"; lblMesag.ForeColor = System.Drawing.Color.Blue; } else { lblMesag.Text = "Try Again"; lblMesag.ForeColor = System.Drawing.Color.Red; return; } } catch { lblMesag.Text = "Try Again"; lblMesag.ForeColor = System.Drawing.Color.Red; return; } } else { lblMesag.Text = "Remarks Required"; lblMesag.ForeColor = System.Drawing.Color.Red; return; } } catch { lblMesag.Text = "Try Again!"; lblMesag.ForeColor = System.Drawing.Color.Red; } }