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;
}
}
