public DataSet Admission_Online_SelectAll(AdmissionProperties oAdmission)
{
oDataHelper = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("AdmissionGrade", oAdmission.AdmissionGrade));
return(oDataHelper.DAL_Select("Admission_online_select", arrParameter));
}
public DataSet Admission_Select_admissionapprovallist(AdmissionProperties oAdmission)
{
oDataHelper = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("AdmissionGrade", oAdmission.AdmissionGrade));
return(oDataHelper.DAL_Select("Admission_Select_admissionapprovallist", arrParameter));
}
private void BindGrid()
{
AdmissionProperties oAdmissionProperties = new AdmissionProperties();
BAL_Admission oBAL_Admission = new BAL_Admission();
DataSet ods = oBAL_Admission.Admission_Select_GetDashboardCountData(Convert.ToString(ViewState["Type"]), AdmissionGradeFilter.Value);
lvstudent.DataSource = ods;
lvstudent.DataBind();
}
private void BindGrid()
{
AdmissionProperties oAdmissionProperties = new AdmissionProperties();
BAL_Admission oBAL_Admission = new BAL_Admission();
DataSet ods = oBAL_Admission.Admission_Select_AdmissionFeesAndDocument(AdmissionGradeFilter.Value);
lvstudent.DataSource = ods;
lvstudent.DataBind();
}
private void BindGrid()
{
AdmissionProperties oAdmissionProperties = new AdmissionProperties();
BAL_Admission oBAL_Admission = new BAL_Admission();
oAdmissionProperties.AdmissionGrade = AdmissionGradeFilter.Value;
DataSet ods = oBAL_Admission.Admission_Select_interactionlist(oAdmissionProperties);
lvstudent.DataSource = ods;
lvstudent.DataBind();
if (ods.Tables[0].Rows.Count > 0)
{
btnSendInteraction.Visible = true;
}
else
{
btnSendInteraction.Visible = false;
}
}
protected void btnGetHistory_Click(object sender, EventArgs e)
{
string admissionid = hdnCurrentAdmissionid.Value;
string admissiongrade = hdnCurrentAdmissionGrade.Value;
string referencenumber = hdnCurrentReferenceNumber.Value;
string Nationality = hdnCurrentNationality.Value;
AdmissionProperties oAdmissionProperties = new AdmissionProperties();
BAL_Admission oBAL_Admission = new BAL_Admission();
chkdocumentlist.Items.Clear();
DataSet ods = oBAL_Admission.Admission_Select_AdmissionFeesAndDocument_ByAdmissionId(admissionid);
if (ods.Tables[0].Rows.Count > 0)
{
ListItem li = new ListItem("Fees");
li.Selected = Convert.ToBoolean(ods.Tables[0].Rows[0]["Fees"]);
chkdocumentlist.Items.Add(li);
li = new ListItem("Birth Certificate");
li.Selected = Convert.ToBoolean(ods.Tables[0].Rows[0]["BirthCertificate"]);
chkdocumentlist.Items.Add(li);
li = new ListItem("Admission Acceptance Form");
li.Selected = Convert.ToBoolean(ods.Tables[0].Rows[0]["AdmissionAcceptanceForm"]);
chkdocumentlist.Items.Add(li);
li = new ListItem("Parents Testimonials");
li.Selected = Convert.ToBoolean(ods.Tables[0].Rows[0]["ParentsTestimonials"]);
chkdocumentlist.Items.Add(li);
switch (admissiongrade)
{
case "Nursery":
case "Jr KG":
case "Sr KG":
li = new ListItem("Bonafide Certificate");
li.Selected = Convert.ToBoolean(ods.Tables[0].Rows[0]["BonafiedCertificate"]);
chkdocumentlist.Items.Add(li);
break;
case "1":
case "2":
case "3":
case "4":
case "5":
case "6":
case "7":
case "8":
case "9":
case "10":
case "11":
li = new ListItem("School Leaving Certificate");
li.Selected = Convert.ToBoolean(ods.Tables[0].Rows[0]["SchoolLeavingCertificate"]);
chkdocumentlist.Items.Add(li);
break;
default:
break;
}
if (Nationality == "Other")
{
li = new ListItem("Reference letter/TC");
li.Selected = Convert.ToBoolean(ods.Tables[0].Rows[0]["ReferenceletterTC"]);
chkdocumentlist.Items.Add(li);
li = new ListItem("Copy of Passport");
li.Selected = Convert.ToBoolean(ods.Tables[0].Rows[0]["CopyofPassport"]);
chkdocumentlist.Items.Add(li);
}
}
fdpopup.Attributes["class"] = "overlayone";
}
protected void submit_click(object sender, EventArgs e)
{
BAL_Admission oBAL_Admission = new BAL_Admission();
AdmissionProperties oAdmissionProperties = new AdmissionProperties();
//Admission criteria
oAdmissionProperties.AdmissionGrade = AdmissionGrade.Value;
#region Admission board value
switch (oAdmissionProperties.AdmissionGrade)
{
case "Nursery":
if (radioboardNursery_1.Checked)
{
oAdmissionProperties.ApplicantType = radioboardNursery_1.Value;
oAdmissionProperties.AccessCode = accesscode.Value;
string response = ValidateAccessCode(accesscode.Value);
if (response == "invalidtoddenaccesscode")
{
btnPrint.Visible = false;
AdmissionGrade.Value = "";
mainpopup.Attributes["class"] = "overlayone";
msg.InnerText = "Sorry, Requested Access Code is already used by other user.";
return;
}
}
else if (radioboardNursery_2.Checked)
{
oAdmissionProperties.ApplicantType = radioboardNursery_2.Value;
}
break;
case "8":
if (radioboard8_1.Checked)
{
oAdmissionProperties.ChoiceofBoard = radioboard8_1.Value;
}
else if (radioboard8_2.Checked)
{
oAdmissionProperties.ChoiceofBoard = radioboard8_2.Value;
}
break;
case "9":
if (radioboard9_1.Checked)
{
oAdmissionProperties.ChoiceofBoard = radioboard9_1.Value;
}
break;
case "11":
if (radioboard11_1.Checked)
{
oAdmissionProperties.ChoiceofBoard = radioboard11_1.Value;
}
else if (radioboard11_2.Checked)
{
oAdmissionProperties.ChoiceofBoard = radioboard11_2.Value;
}
break;
default:
break;
}
#endregion
oAdmissionProperties.FormType = GetValue(hdnwaitlistform.Value);
//Personal information
oAdmissionProperties.FirstName = GetValue(FirstName.Value);
oAdmissionProperties.MiddleName = GetValue(MiddleName.Value);
oAdmissionProperties.LastName = GetValue(LastName.Value);
oAdmissionProperties.Addressline1 = GetValue(Addressline1.Value);
oAdmissionProperties.Addressline2 = GetValue(Addressline2.Value);
oAdmissionProperties.Country = GetValue(Country.Value);
oAdmissionProperties.State = GetValue(State.Value);
oAdmissionProperties.City = GetValue(City.Value);
oAdmissionProperties.Pincode = GetValue(Pincode.Value);
oAdmissionProperties.TelephoneNo = GetValue(stdcode.Value + '-' + TelephoneNo.Value);
oAdmissionProperties.EmergencyMobileNo = GetValue(EmergencyMobileNo.Value);
if (Gender_1.Checked)
{
oAdmissionProperties.Gender = "Male";
}
else if (Gender_2.Checked)
{
oAdmissionProperties.Gender = "Female";
}
oAdmissionProperties.DateOfBirth = GetValue(DateOfBirth.Text);
oAdmissionProperties.PlaceOfBirth = GetValue(PlaceOfBirth.Value);
oAdmissionProperties.Nationality = GetValue(Nationality.Value);
oAdmissionProperties.OtherNationality = GetValue(OtherNationality.Value);
oAdmissionProperties.PassportNumber = GetValue(PassportNumber.Value);
oAdmissionProperties.Caste = GetValue(Caste.Value);
oAdmissionProperties.LastSchoolAttended = GetValue(LastSchoolAttended.Value);
oAdmissionProperties.OtherLastSchoolAttended = GetValue(OtherLastSchoolAttended.Value);
//Father information
oAdmissionProperties.FatherName = GetValue(FatherName.Value);
oAdmissionProperties.Fathergraduationdegree = GetValue(Fathergraduationdegree.Value);
oAdmissionProperties.FatherPostGraduationDegree = GetValue(FatherPostGraduationDegree.Value);
oAdmissionProperties.FatherOccupation = GetValue(FatherOccupation.Value);
oAdmissionProperties.FatherOfficeAddress = GetValue(FatherOfficeAddress.Value);
oAdmissionProperties.FatherMobileNumber = GetValue(FatherMobileNumber.Value);
oAdmissionProperties.FatherEmailId = GetValue(FatherEmailId.Value);
oAdmissionProperties.FatherSchoolAttended = GetValue(FatherSchoolAttended.Value);
oAdmissionProperties.FatherCollegeAttended = GetValue(FatherCollegeAttended.Value);
//Mother information
oAdmissionProperties.MotherName = GetValue(MotherName.Value);
oAdmissionProperties.MotherGraduationDegree = GetValue(MotherGraduationDegree.Value);
oAdmissionProperties.MotherPostGraduationDegree = GetValue(MotherPostGraduationDegree.Value);
oAdmissionProperties.MotherOccupation = GetValue(MotherOccupation.Value);
oAdmissionProperties.MotherOfficeAddress = GetValue(MotherOfficeAddress.Value);
oAdmissionProperties.MotherMobileNumber = GetValue(MotherMobileNumber.Value);
oAdmissionProperties.ResidenceOrLandlineNumber = GetValue(rorlstdcode.Value + '-' + ResidenceOrLandlineNumber.Value);
oAdmissionProperties.MotherEmailId = GetValue(MotherEmailId.Value);
oAdmissionProperties.MotherSchoolAttended = GetValue(MotherSchoolAttended.Value);
oAdmissionProperties.MotherCollegeAttended = GetValue(MotherCollegeAttended.Value);
//For communication
oAdmissionProperties.MobileNumberForCommunication = GetValue(MobileNumberForCommunication.Value);
oAdmissionProperties.EmailIdForCommunication = GetValue(EmailIdForCommunication.Value);
if (radiosibling_Applicable.Checked)
{
//Siblings-1
oAdmissionProperties.Siblingname = GetValue(siblingname.Value);
oAdmissionProperties.Siblingage = GetValue(siblingage.Text);
oAdmissionProperties.Siblingschoolcollege = GetValue(siblingschoolcollege.Value);
if (siblingschoolcollege.Value == "AIS")
{
oAdmissionProperties.Siblingschoolcollegegrade = GetValue(siblingschoolcollegegrade.Value);
oAdmissionProperties.Siblingschoolcollegedivision = GetValue(siblingschoolcollegedivision.Value);
}
else if (siblingschoolcollege.Value == "Other")
{
oAdmissionProperties.Siblingschoolcollegegrade = GetValue(Othersiblingschoolcollegegrade.Value);
}
//Siblings-2
if (!string.IsNullOrEmpty(siblingnamesecond.Value))
{
oAdmissionProperties.Siblingnamesecond = GetValue(siblingnamesecond.Value);
oAdmissionProperties.Siblingagesecond = GetValue(siblingagesecond.Text);
oAdmissionProperties.Siblingschoolcollegesecond = GetValue(siblingschoolcollegesecond.Value);
if (siblingschoolcollegesecond.Value == "AIS")
{
oAdmissionProperties.Siblingschoolcollegegradesecond = GetValue(siblingschoolcollegegradesecond.Value);
oAdmissionProperties.Siblingschoolcollegedivisionsecond = GetValue(siblingschoolcollegedivisionsecond.Value);
}
else if (siblingschoolcollegesecond.Value == "Other")
{
oAdmissionProperties.Siblingschoolcollegegradesecond = GetValue(Othersiblingschoolcollegegradesecond.Value);
}
}
}
//Other Information
oAdmissionProperties.MotherTongue = GetValue(MotherTongue.Value);
oAdmissionProperties.OtherLanguagesSpokenAtHome = GetValue(OtherLanguagesSpokenAtHome.Value);
if (IsNuclearOrJointFamily_1.Checked)
{
oAdmissionProperties.IsNuclearOrJointFamily = IsNuclearOrJointFamily_1.Value;
}
else if (IsNuclearOrJointFamily_2.Checked)
{
oAdmissionProperties.IsNuclearOrJointFamily = IsNuclearOrJointFamily_2.Value;
}
oAdmissionProperties.HowDoYouHearAboutAIS = GetValue(HowDoYouHearAboutAIS.Value);
#region Future Option value
switch (oAdmissionProperties.AdmissionGrade)
{
case "8":
if (OptionOfferedByAISafterGradeX_1.Checked)
{
oAdmissionProperties.OptionOfferedByAISafterGradeX = OptionOfferedByAISafterGradeX_1.Value;
}
else if (OptionOfferedByAISafterGradeX_2.Checked)
{
oAdmissionProperties.OptionOfferedByAISafterGradeX = OptionOfferedByAISafterGradeX_2.Value;
}
break;
case "9":
if (OptionOfferedByAISafterGradeX_1.Checked)
{
oAdmissionProperties.OptionOfferedByAISafterGradeX = OptionOfferedByAISafterGradeX_1.Value;
}
else if (OptionOfferedByAISafterGradeX_2.Checked)
{
oAdmissionProperties.OptionOfferedByAISafterGradeX = OptionOfferedByAISafterGradeX_2.Value;
}
break;
case "10": break;
case "11": break;
default:
if (OptionOfferedByAISafterGradeVII_1.Checked)
{
oAdmissionProperties.OptionOfferedByAISafterGradeVII = OptionOfferedByAISafterGradeVII_1.Value;
}
else if (OptionOfferedByAISafterGradeVII_2.Checked)
{
oAdmissionProperties.OptionOfferedByAISafterGradeVII = OptionOfferedByAISafterGradeVII_2.Value;
}
if (OptionOfferedByAISafterGradeX_1.Checked)
{
oAdmissionProperties.OptionOfferedByAISafterGradeX = OptionOfferedByAISafterGradeX_1.Value;
}
else if (OptionOfferedByAISafterGradeX_2.Checked)
{
oAdmissionProperties.OptionOfferedByAISafterGradeX = OptionOfferedByAISafterGradeX_2.Value;
}
else if (OptionOfferedByAISafterGradeX_3.Checked)
{
oAdmissionProperties.OptionOfferedByAISafterGradeX = OptionOfferedByAISafterGradeX_3.Value;
}
break;
}
#endregion
#region ExamDay Option
switch (oAdmissionProperties.AdmissionGrade)
{
case "5":
case "6":
case "7":
case "8":
case "9":
case "10":
case "11":
oAdmissionProperties.ExamDay = ExamDay.Value;
oAdmissionProperties.ExamTime = "9.00 am - 11.00 am";
break;
default:
break;
}
#endregion
#region Send Nautification Mail for exam
ArrayList ArrMailTo = new ArrayList();
ArrMailTo.Add(EmailIdForCommunication.Value);
string MailSubject = "AIS Entrance Exam Notification";
string MailBody = "Dear Student,<br /><br /><br />Your entrance exam is scheduled on " + oAdmissionProperties.ExamDay + " at " + oAdmissionProperties.ExamTime + ".<br /><br /><br />Thanks,<br />AIS Team.";
string FailiurReason = string.Empty;
switch (AdmissionGrade.Value)
{
case "5":
case "6":
case "7":
case "8":
case "9":
case "10":
case "11":
oAdmissionProperties.MailBody = MailBody;
oAdmissionProperties.IsSendMailSuccess = EmailUtility.SendEmail(ArrMailTo, MailSubject, MailBody, out FailiurReason);
oAdmissionProperties.FailiurReason = GetValue(FailiurReason);
break;
default:
break;
}
#endregion
string ReferenceNumber = oBAL_Admission.Admission_Insert(oAdmissionProperties, "ReferenceNumber");
if (!string.IsNullOrEmpty(ReferenceNumber))
{
hdnmb.Value = MobileNumberForCommunication.Value;
hdnrn.Value = ReferenceNumber;
btnPrint.Visible = true;
mainpopup.Attributes["class"] = "overlayone";
msg.InnerHtml = "Your application has been successfully submitted. Thank you for your interest in Ahmedabad International School.<br /><br /> Your application reference number is <span style='color:#3db5d8;'>" + ReferenceNumber + "</span>, Please use this reference number for all further correspondence.";
ResetControl();
}
else
{
btnPrint.Visible = false;
mainpopup.Attributes["class"] = "overlayone";
msg.InnerText = "Sorry, There is some problem in admission application submission, please try again.";
}
}
public string Admission_Insert(AdmissionProperties AdmissionProperties, string OutParameter)
{
this.oDataHelper = new DataAccess();
this.arrParameter = new ArrayList();
this.arrParameter.Add(new parameter("AdmissionGrade", AdmissionProperties.AdmissionGrade));
this.arrParameter.Add(new parameter("FormType", AdmissionProperties.FormType));
this.arrParameter.Add(new parameter("ApplicantType", AdmissionProperties.ApplicantType));
this.arrParameter.Add(new parameter("AccessCode", AdmissionProperties.AccessCode));
this.arrParameter.Add(new parameter("ChoiceofBoard", AdmissionProperties.ChoiceofBoard));
this.arrParameter.Add(new parameter("FirstName", AdmissionProperties.FirstName));
this.arrParameter.Add(new parameter("MiddleName", AdmissionProperties.MiddleName));
this.arrParameter.Add(new parameter("LastName", AdmissionProperties.LastName));
this.arrParameter.Add(new parameter("Addressline1", AdmissionProperties.Addressline1));
this.arrParameter.Add(new parameter("Addressline2", AdmissionProperties.Addressline2));
this.arrParameter.Add(new parameter("Country", AdmissionProperties.Country));
this.arrParameter.Add(new parameter("State", AdmissionProperties.State));
this.arrParameter.Add(new parameter("City", AdmissionProperties.City));
this.arrParameter.Add(new parameter("Pincode", AdmissionProperties.Pincode));
this.arrParameter.Add(new parameter("TelephoneNo", AdmissionProperties.TelephoneNo));
this.arrParameter.Add(new parameter("EmergencyMobileNo", AdmissionProperties.EmergencyMobileNo));
this.arrParameter.Add(new parameter("Gender", AdmissionProperties.Gender));
this.arrParameter.Add(new parameter("DateOfBirth", AdmissionProperties.DateOfBirth));
this.arrParameter.Add(new parameter("PlaceOfBirth", AdmissionProperties.PlaceOfBirth));
this.arrParameter.Add(new parameter("Nationality", AdmissionProperties.Nationality));
this.arrParameter.Add(new parameter("OtherNationality", AdmissionProperties.OtherNationality));
this.arrParameter.Add(new parameter("PassportNumber", AdmissionProperties.PassportNumber));
this.arrParameter.Add(new parameter("Caste", AdmissionProperties.Caste));
this.arrParameter.Add(new parameter("LastSchoolAttended", AdmissionProperties.LastSchoolAttended));
this.arrParameter.Add(new parameter("OtherLastSchoolAttended", AdmissionProperties.OtherLastSchoolAttended));
this.arrParameter.Add(new parameter("FatherName", AdmissionProperties.FatherName));
this.arrParameter.Add(new parameter("Fathergraduationdegree", AdmissionProperties.Fathergraduationdegree));
this.arrParameter.Add(new parameter("FatherPostGraduationDegree", AdmissionProperties.FatherPostGraduationDegree));
this.arrParameter.Add(new parameter("FatherOccupation", AdmissionProperties.FatherOccupation));
this.arrParameter.Add(new parameter("FatherOfficeAddress", AdmissionProperties.FatherOfficeAddress));
this.arrParameter.Add(new parameter("FatherMobileNumber", AdmissionProperties.FatherMobileNumber));
this.arrParameter.Add(new parameter("FatherEmailId", AdmissionProperties.FatherEmailId));
this.arrParameter.Add(new parameter("FatherSchoolAttended", AdmissionProperties.FatherSchoolAttended));
this.arrParameter.Add(new parameter("FatherCollegeAttended", AdmissionProperties.FatherCollegeAttended));
this.arrParameter.Add(new parameter("MotherName", AdmissionProperties.MotherName));
this.arrParameter.Add(new parameter("Mothergraduationdegree", AdmissionProperties.MotherGraduationDegree));
this.arrParameter.Add(new parameter("MotherPostGraduationDegree", AdmissionProperties.MotherPostGraduationDegree));
this.arrParameter.Add(new parameter("MotherOccupation", AdmissionProperties.MotherOccupation));
this.arrParameter.Add(new parameter("MotherOfficeAddress", AdmissionProperties.MotherOfficeAddress));
this.arrParameter.Add(new parameter("MotherMobileNumber", AdmissionProperties.MotherMobileNumber));
this.arrParameter.Add(new parameter("ResidenceOrLandlineNumber", AdmissionProperties.ResidenceOrLandlineNumber));
this.arrParameter.Add(new parameter("MotherEmailId", AdmissionProperties.MotherEmailId));
this.arrParameter.Add(new parameter("MotherSchoolAttended", AdmissionProperties.MotherSchoolAttended));
this.arrParameter.Add(new parameter("MotherCollegeAttended", AdmissionProperties.MotherCollegeAttended));
this.arrParameter.Add(new parameter("MobileNumberForCommunication", AdmissionProperties.MobileNumberForCommunication));
this.arrParameter.Add(new parameter("EmailIdForCommunication", AdmissionProperties.EmailIdForCommunication));
this.arrParameter.Add(new parameter("Siblingname", AdmissionProperties.Siblingname));
this.arrParameter.Add(new parameter("Siblingage", AdmissionProperties.Siblingage));
this.arrParameter.Add(new parameter("Siblingschoolcollege", AdmissionProperties.Siblingschoolcollege));
this.arrParameter.Add(new parameter("Siblingschoolcollegegrade", AdmissionProperties.Siblingschoolcollegegrade));
this.arrParameter.Add(new parameter("Siblingschoolcollegedivision", AdmissionProperties.Siblingschoolcollegedivision));
this.arrParameter.Add(new parameter("Siblingnamesecond", AdmissionProperties.Siblingnamesecond));
this.arrParameter.Add(new parameter("Siblingagesecond", AdmissionProperties.Siblingagesecond));
this.arrParameter.Add(new parameter("Siblingschoolcollegesecond", AdmissionProperties.Siblingschoolcollegesecond));
this.arrParameter.Add(new parameter("Siblingschoolcollegegradesecond", AdmissionProperties.Siblingschoolcollegegradesecond));
this.arrParameter.Add(new parameter("Siblingschoolcollegedivisionsecond", AdmissionProperties.Siblingschoolcollegedivisionsecond));
this.arrParameter.Add(new parameter("MotherTongue", AdmissionProperties.MotherTongue));
this.arrParameter.Add(new parameter("OtherLanguagesSpokenAtHome", AdmissionProperties.OtherLanguagesSpokenAtHome));
this.arrParameter.Add(new parameter("IsNuclearOrJointFamily", AdmissionProperties.IsNuclearOrJointFamily));
this.arrParameter.Add(new parameter("HowDoYouHearAboutAIS", AdmissionProperties.HowDoYouHearAboutAIS));
this.arrParameter.Add(new parameter("OptionOfferedByAISafterGradeVII", AdmissionProperties.OptionOfferedByAISafterGradeVII));
this.arrParameter.Add(new parameter("OptionOfferedByAISafterGradeX", AdmissionProperties.OptionOfferedByAISafterGradeX));
this.arrParameter.Add(new parameter("ExamDay", AdmissionProperties.ExamDay));
this.arrParameter.Add(new parameter("ExamTime", AdmissionProperties.ExamTime));
this.arrParameter.Add(new parameter("MailBody", AdmissionProperties.MailBody));
this.arrParameter.Add(new parameter("IsSendMailSuccess", AdmissionProperties.IsSendMailSuccess));
this.arrParameter.Add(new parameter("FailiurReason", AdmissionProperties.FailiurReason));
return(this.oDataHelper.DAL_InsertWithOutParameter("Admission_Insert", this.arrParameter, OutParameter));
}
