private static string GetDashboardCount(string Type)
    {
        BAL_Admission oBAL_Admission = new BAL_Admission();
        DataSet       ods            = oBAL_Admission.Admission_Select_GetDashboardCount(Type);

        return(Convert.ToString(ods.Tables[0].Rows[0][0]));
    }
    protected void btnSendInteraction_click(object sender, EventArgs e)
    {
        foreach (ListViewItem item in lvstudent.Items)
        {
            string    InteractionDate = string.Empty;
            string    InteractionTime = string.Empty;
            string    AdmissionID     = string.Empty;
            string    MailFrom        = string.Empty;
            string    MailTo          = string.Empty;
            string    MailSubject     = string.Empty;
            string    MailBody        = string.Empty;
            string    FailiurReason   = string.Empty;
            ArrayList ArrMailTo       = new ArrayList();

            HtmlInputCheckBox interactioncheck = (HtmlInputCheckBox)item.FindControl("interactioncheck");
            if (interactioncheck.Checked)
            {
                TextBox interactiondate = (TextBox)item.FindControl("interactiondate");
                InteractionDate = interactiondate.Text;
                TextBox interactiontime = (TextBox)item.FindControl("interactiontime");
                InteractionTime = interactiontime.Text;
                Label       communicationemail = (Label)item.FindControl("communicationemail");
                HiddenField hdnAdmissionID     = (HiddenField)item.FindControl("hdnAdmissionID");

                AdmissionID = hdnAdmissionID.Value;
                MailFrom    = EmailUtility.SMTPEmailAddress;
                MailTo      = communicationemail.Text;
                MailSubject = GetMailSubject();
                MailBody    = GetMailBody(InteractionDate, InteractionTime);

                if (!string.IsNullOrEmpty(InteractionDate) && !string.IsNullOrEmpty(InteractionTime) && !string.IsNullOrEmpty(MailTo) && !string.IsNullOrEmpty(AdmissionID))
                {
                    ArrMailTo.Add(MailTo);
                    bool IsSendSuccess = EmailUtility.SendEmail(ArrMailTo, MailSubject, MailBody, out FailiurReason);

                    BAL_Admission        oBAL_Admission        = new BAL_Admission();
                    AdmissionInteraction oAdmissionInteraction = new AdmissionInteraction();

                    oAdmissionInteraction.AdmissionId     = AdmissionID;
                    oAdmissionInteraction.InteractionDate = InteractionDate;
                    oAdmissionInteraction.InteractionTime = InteractionTime;
                    oAdmissionInteraction.MailFrom        = MailFrom;
                    oAdmissionInteraction.MailTo          = MailTo;
                    oAdmissionInteraction.MailSubject     = MailSubject;
                    oAdmissionInteraction.MailBody        = MailBody;
                    oAdmissionInteraction.IsSendSuccess   = IsSendSuccess;
                    oAdmissionInteraction.FailureReasons  = GetValue(FailiurReason);
                    oAdmissionInteraction.CreatedBy       = Convert.ToString(AppSessions.EmpolyeeID);

                    oBAL_Admission.AdmissionInteraction_Insert(oAdmissionInteraction);
                }
            }
        }
        BindGrid();

        mainpopup.Attributes["class"] = "overlayone";
        msg.InnerHtml = "Your operation has been successfully completed.";
    }
    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();
    }
Пример #4
0
    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();
    }
Пример #5
0
    private void BindExamDates()
    {
        BAL_Admission oBAL_Admission = new BAL_Admission();

        DataSet ods = oBAL_Admission.Admission_ExamDays_SelectALL();

        DataSet ds = new DataSet();

        ExamDay.DataSource     = ods.Tables[0];
        ExamDay.DataTextField  = "ExamDays";
        ExamDay.DataValueField = "ExamDays";
        ExamDay.DataBind();

        ExamDay.Items.Insert(0, new ListItem("-- Select --", ""));
    }
    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;
        }
    }
Пример #7
0
    public static string ValidateAccessCode(string accesscode)
    {
        string returnvalue = "invalidtoddenaccesscode";

        if (!string.IsNullOrEmpty(accesscode))
        {
            Match match = Regex.Match(accesscode, @"^16TN(100|\d{2})$", RegexOptions.IgnoreCase);
            if (match.Success)
            {
                BAL_Admission oBAL_Admission = new BAL_Admission();

                DataSet ods = oBAL_Admission.Admission_ValidateAccesscode(accesscode);
                if (ods.Tables.Count > 0)
                {
                    if (ods.Tables[0].Rows.Count > 0)
                    {
                        returnvalue = "invalidtoddenaccesscode";
                    }
                    else
                    {
                        returnvalue = "validtoddenaccesscode";
                    }
                }
                else
                {
                    returnvalue = "invalidtoddenaccesscode";
                }
            }
            else
            {
                returnvalue = "invalidtoddenaccesscode";
            }
        }
        else
        {
            returnvalue = "invalidtoddenaccesscode";
        }
        return(returnvalue);
    }
Пример #8
0
    protected void btnsubmitadmission_click(object sender, EventArgs e)
    {
        string admissionid    = hdnCurrentAdmissionid.Value;
        string admissiongrade = hdnCurrentAdmissionGrade.Value;
        string Nationality    = hdnCurrentNationality.Value;
        bool   AllComplate    = true;

        BAL_Admission            oBAL_Admission            = new BAL_Admission();
        AdmissionFeesAndDocument oAdmissionFeesAndDocument = new AdmissionFeesAndDocument();

        oAdmissionFeesAndDocument.AdmissionId = admissionid;

        oAdmissionFeesAndDocument.Fees = chkdocumentlist.Items.FindByText("Fees").Selected;
        if (!oAdmissionFeesAndDocument.Fees)
        {
            AllComplate = false;
        }

        oAdmissionFeesAndDocument.BirthCertificate = chkdocumentlist.Items.FindByText("Birth Certificate").Selected;
        if (!oAdmissionFeesAndDocument.BirthCertificate)
        {
            AllComplate = false;
        }

        oAdmissionFeesAndDocument.AdmissionAcceptanceForm = chkdocumentlist.Items.FindByText("Admission Acceptance Form").Selected;
        if (!oAdmissionFeesAndDocument.AdmissionAcceptanceForm)
        {
            AllComplate = false;
        }

        oAdmissionFeesAndDocument.ParentsTestimonials = chkdocumentlist.Items.FindByText("Parents Testimonials").Selected;
        if (!oAdmissionFeesAndDocument.ParentsTestimonials)
        {
            AllComplate = false;
        }

        switch (admissiongrade)
        {
        case "Nursery":
        case "Jr KG":
        case "Sr KG":
            oAdmissionFeesAndDocument.BonafiedCertificate = chkdocumentlist.Items.FindByText("Bonafide Certificate").Selected;
            if (!oAdmissionFeesAndDocument.BonafiedCertificate)
            {
                AllComplate = false;
            }
            break;

        case "1":
        case "2":
        case "3":
        case "4":
        case "5":
        case "6":
        case "7":
        case "8":
        case "9":
        case "10":
        case "11":
            oAdmissionFeesAndDocument.SchoolLeavingCertificate = chkdocumentlist.Items.FindByText("SchoolLeaving Certificate").Selected;
            if (!oAdmissionFeesAndDocument.SchoolLeavingCertificate)
            {
                AllComplate = false;
            }
            break;

        default:
            break;
        }
        if (Nationality == "Other")
        {
            oAdmissionFeesAndDocument.ReferenceletterTC = chkdocumentlist.Items.FindByText("Reference letter/TC").Selected;
            if (!oAdmissionFeesAndDocument.ReferenceletterTC)
            {
                AllComplate = false;
            }
            oAdmissionFeesAndDocument.CopyofPassport = chkdocumentlist.Items.FindByText("Copy of Passport").Selected;
            if (!oAdmissionFeesAndDocument.CopyofPassport)
            {
                AllComplate = false;
            }
        }

        oAdmissionFeesAndDocument.CreatedBy   = Convert.ToString(AppSessions.EmpolyeeID);
        oAdmissionFeesAndDocument.AllComplate = AllComplate;

        bool IsSuccess = oBAL_Admission.AdmissionFeesAndDocument_Insert(oAdmissionFeesAndDocument);

        BindGrid();
        fdpopup.Attributes["class"]   = "overlay";
        mainpopup.Attributes["class"] = "overlayone";

        if (IsSuccess)
        {
            msg.InnerHtml = "Fees And Document has been submitted successfully.";
        }
        else
        {
            msg.InnerHtml = "Fees And Document has been submitted failed.";
        }
    }
Пример #9
0
    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 Page_Load(object sender, EventArgs e)
    {
        if (!string.IsNullOrEmpty(Request.QueryString["mb"]) && !string.IsNullOrEmpty(Request.QueryString["rn"]))
        {
            BAL_Admission oBAL_Admission = new BAL_Admission();
            DataSet       ods            = new DataSet();
            ods = oBAL_Admission.Admission_getadmissiondetail_byreferenceno(Convert.ToString(Request.QueryString["rn"]), Convert.ToString(Request.QueryString["mb"]));
            if (ods.Tables[0].Rows.Count > 0)
            {
                admissiongrade.Text     = Convert.ToString(ods.Tables[0].Rows[0]["AdmissionGrade"]);
                referencenumber.Text    = Convert.ToString(ods.Tables[0].Rows[0]["ReferenceNumber"]);
                nameoftheapplicant.Text = Convert.ToString(ods.Tables[0].Rows[0]["FirstName"]) + ' ' + Convert.ToString(ods.Tables[0].Rows[0]["LastName"]);

                StringBuilder oAddressBuilder = new StringBuilder();
                oAddressBuilder.Append(Convert.ToString(ods.Tables[0].Rows[0]["Addressline1"]));
                if (!string.IsNullOrEmpty(Convert.ToString(ods.Tables[0].Rows[0]["Addressline2"])))
                {
                    oAddressBuilder.Append(", ");
                    oAddressBuilder.Append(Convert.ToString(ods.Tables[0].Rows[0]["Addressline2"]));
                }
                oAddressBuilder.Append(", ");
                oAddressBuilder.Append(Convert.ToString(ods.Tables[0].Rows[0]["City"]));

                oAddressBuilder.Append(", ");
                oAddressBuilder.Append(Convert.ToString(ods.Tables[0].Rows[0]["State"]));

                oAddressBuilder.Append(", ");
                oAddressBuilder.Append(Convert.ToString(ods.Tables[0].Rows[0]["Country"]));

                address.Text = Convert.ToString(oAddressBuilder);

                telephonenumber.Text       = Convert.ToString(ods.Tables[0].Rows[0]["TelephoneNo"]);
                emergencymobilenumber.Text = Convert.ToString(ods.Tables[0].Rows[0]["EmergencyMobileNo"]);
                gender.Text       = Convert.ToString(ods.Tables[0].Rows[0]["Gender"]);
                dateofbirth.Text  = Convert.ToString(ods.Tables[0].Rows[0]["DateOfBirth"]);
                placeofbirth.Text = Convert.ToString(ods.Tables[0].Rows[0]["PlaceOfBirth"]);

                if (Convert.ToString(ods.Tables[0].Rows[0]["Nationality"]) == "Other")
                {
                    nationality.Text = Convert.ToString(ods.Tables[0].Rows[0]["OtherNationality"]);
                }
                else
                {
                    nationality.Text = Convert.ToString(ods.Tables[0].Rows[0]["Nationality"]);
                }


                passportnumber.Text = Convert.ToString(ods.Tables[0].Rows[0]["PassportNumber"]);
                caste.Text          = Convert.ToString(ods.Tables[0].Rows[0]["Caste"]);

                if (Convert.ToString(ods.Tables[0].Rows[0]["LastSchoolAttended"]) == "Other")
                {
                    lastschoolattended.Text = Convert.ToString(ods.Tables[0].Rows[0]["OtherLastSchoolAttended"]);
                }
                else
                {
                    lastschoolattended.Text = Convert.ToString(ods.Tables[0].Rows[0]["LastSchoolAttended"]);
                }

                fathername.Text                 = Convert.ToString(ods.Tables[0].Rows[0]["FatherName"]);
                fathergraduationdegree.Text     = Convert.ToString(ods.Tables[0].Rows[0]["FatherGraduationdegree"]);
                fatherpostgraduationdegree.Text = Convert.ToString(ods.Tables[0].Rows[0]["FatherPostGraduationDegree"]);
                fatheroccupation.Text           = Convert.ToString(ods.Tables[0].Rows[0]["FatherOccupation"]);
                fatherofficeaddress.Text        = Convert.ToString(ods.Tables[0].Rows[0]["FatherOfficeAddress"]);
                fathermobilenumber.Text         = Convert.ToString(ods.Tables[0].Rows[0]["FatherMobileNumber"]);
                fatheremailid.Text              = Convert.ToString(ods.Tables[0].Rows[0]["FatherEmailId"]);
                fatherschoolattended.Text       = Convert.ToString(ods.Tables[0].Rows[0]["FatherSchoolAttended"]);
                fathercollegeattended.Text      = Convert.ToString(ods.Tables[0].Rows[0]["FatherCollegeAttended"]);

                mothername.Text                 = Convert.ToString(ods.Tables[0].Rows[0]["MotherName"]);
                mothergraduationdegree.Text     = Convert.ToString(ods.Tables[0].Rows[0]["MotherGraduationdegree"]);
                motherpostgraduationdegree.Text = Convert.ToString(ods.Tables[0].Rows[0]["MotherPostGraduationDegree"]);
                motheroccupation.Text           = Convert.ToString(ods.Tables[0].Rows[0]["MotherOccupation"]);
                motherofficeaddress.Text        = Convert.ToString(ods.Tables[0].Rows[0]["MotherOfficeAddress"]);
                mothermobilenumber.Text         = Convert.ToString(ods.Tables[0].Rows[0]["MotherMobileNumber"]);
                residencelandlinenumber.Text    = Convert.ToString(ods.Tables[0].Rows[0]["ResidenceOrLandlineNumber"]);
                motheremailid.Text              = Convert.ToString(ods.Tables[0].Rows[0]["MotherEmailId"]);
                motherschoolattended.Text       = Convert.ToString(ods.Tables[0].Rows[0]["MotherSchoolAttended"]);
                mothercollegeattended.Text      = Convert.ToString(ods.Tables[0].Rows[0]["MotherCollegeAttended"]);

                mobilenumberforcommunication.Text = Convert.ToString(ods.Tables[0].Rows[0]["MobileNumberForCommunication"]);
                emailidforcommunication.Text      = Convert.ToString(ods.Tables[0].Rows[0]["EmailIdForCommunication"]);

                siblingname1.Text        = Convert.ToString(ods.Tables[0].Rows[0]["Siblingname"]);
                siblingdateofbirth1.Text = Convert.ToString(ods.Tables[0].Rows[0]["Siblingage"]);
                siblingschool1.Text      = Convert.ToString(ods.Tables[0].Rows[0]["Siblingschoolcollege"]);
                siblinggrade1.Text       = Convert.ToString(ods.Tables[0].Rows[0]["Siblingschoolcollegegrade"]);
                siblingdivision1.Text    = Convert.ToString(ods.Tables[0].Rows[0]["Siblingschoolcollegedivision"]);

                siblingname2.Text        = Convert.ToString(ods.Tables[0].Rows[0]["Siblingnamesecond"]);
                siblingdateofbirth2.Text = Convert.ToString(ods.Tables[0].Rows[0]["Siblingagesecond"]);
                siblingschool2.Text      = Convert.ToString(ods.Tables[0].Rows[0]["Siblingschoolcollegesecond"]);
                siblinggrade2.Text       = Convert.ToString(ods.Tables[0].Rows[0]["Siblingschoolcollegegradesecond"]);
                siblingdivision2.Text    = Convert.ToString(ods.Tables[0].Rows[0]["Siblingschoolcollegedivisionsecond"]);

                mothertongue.Text = Convert.ToString(ods.Tables[0].Rows[0]["MotherTongue"]);
                otherlanguagespokenathome.Text = Convert.ToString(ods.Tables[0].Rows[0]["OtherLanguagesSpokenAtHome"]);
                familytype.Text            = Convert.ToString(ods.Tables[0].Rows[0]["IsNuclearOrJointFamily"]);
                howdidyouhereaboutais.Text = Convert.ToString(ods.Tables[0].Rows[0]["HowDoYouHearAboutAIS"]);
                optionafterseven.Text      = Convert.ToString(ods.Tables[0].Rows[0]["OptionOfferedByAISafterGradeVII"]);
                optionafterten.Text        = Convert.ToString(ods.Tables[0].Rows[0]["OptionOfferedByAISafterGradeX"]);
            }
        }
    }
    protected void btnapproveadmission_click(object sender, EventArgs e)
    {
        foreach (ListViewDataItem item in lvstudent.Items)
        {
            string    AdmissionID       = string.Empty;
            string    Remarks           = string.Empty;
            string    MailFrom          = string.Empty;
            string    MailTo            = string.Empty;
            string    MailSubject       = string.Empty;
            string    MailBody          = string.Empty;
            string    FailiurReason     = string.Empty;
            ArrayList ArrMailTo         = new ArrayList();
            ArrayList ArrAttachmentList = new ArrayList();

            HtmlInputCheckBox admissionapprovalcheck = (HtmlInputCheckBox)item.FindControl("admissionapprovalcheck");
            if (admissionapprovalcheck.Checked)
            {
                HtmlInputRadioButton radioadmissionyes = (HtmlInputRadioButton)item.FindControl("radioadmissionyes");
                HtmlInputRadioButton radioadmissionno  = (HtmlInputRadioButton)item.FindControl("radioadmissionno");

                if (radioadmissionyes.Checked)
                {
                    HtmlSelect  approvalremarksyes = (HtmlSelect)item.FindControl("approvalremarksyes");
                    Label       communicationemail = (Label)item.FindControl("communicationemail");
                    HiddenField hdnAdmissionID     = (HiddenField)item.FindControl("hdnAdmissionID");
                    HiddenField hdnFirstname       = (HiddenField)item.FindControl("hdnFirstname");
                    HiddenField hdnLastName        = (HiddenField)item.FindControl("hdnLastName");
                    HiddenField hdnAddressline1    = (HiddenField)item.FindControl("hdnAddressline1");
                    HiddenField hdnCity            = (HiddenField)item.FindControl("hdnCity");
                    HiddenField hdnState           = (HiddenField)item.FindControl("hdnState");
                    HiddenField hdnAdmissionGrade  = (HiddenField)item.FindControl("hdnAdmissionGrade");

                    AdmissionID = hdnAdmissionID.Value;
                    Remarks     = approvalremarksyes.Value;
                    MailFrom    = EmailUtility.SMTPEmailAddress;
                    MailTo      = communicationemail.Text;
                    MailSubject = GetMailSubject();
                    MailBody    = GetMailBody(hdnFirstname.Value, hdnLastName.Value, hdnAddressline1.Value, hdnCity.Value, hdnState.Value, hdnAdmissionGrade.Value);

                    ArrMailTo.Add(MailTo);

                    string DocumentPath = Server.MapPath("~/Documents/AISAdmissionDocument");
                    ArrAttachmentList.Add(Path.Combine(DocumentPath, "Grade " + hdnAdmissionGrade.Value + " Fee Schedule 2015-16.pdf"));
                    ArrAttachmentList.Add(Path.Combine(DocumentPath, "Grade " + hdnAdmissionGrade.Value + " Admission Acceptance Form 2015-16.pdf"));

                    bool IsSendSuccess = EmailUtility.SendEmail(ArrMailTo, MailSubject, MailBody, out FailiurReason, ArrAttachmentList);

                    BAL_Admission     oBAL_Admission     = new BAL_Admission();
                    AdmissionApproval oAdmissionApproval = new AdmissionApproval();

                    oAdmissionApproval.AdmissionId     = AdmissionID;
                    oAdmissionApproval.AdmissionStatus = "Approve";
                    oAdmissionApproval.Remarks         = GetValue(Remarks);
                    oAdmissionApproval.MailFrom        = MailFrom;
                    oAdmissionApproval.MailTo          = MailTo;
                    oAdmissionApproval.MailSubject     = MailSubject;
                    oAdmissionApproval.MailBody        = MailBody;
                    oAdmissionApproval.IsSendSuccess   = IsSendSuccess;
                    oAdmissionApproval.FailureReasons  = GetValue(FailiurReason);
                    oAdmissionApproval.CreatedBy       = Convert.ToString(AppSessions.EmpolyeeID);

                    oBAL_Admission.AdmissionApproval_Insert(oAdmissionApproval);
                }
                else if (radioadmissionno.Checked)
                {
                    HiddenField hdnAdmissionID    = (HiddenField)item.FindControl("hdnAdmissionID");
                    HtmlSelect  approvalremarksno = (HtmlSelect)item.FindControl("approvalremarksno");

                    AdmissionID = hdnAdmissionID.Value;
                    Remarks     = approvalremarksno.Value;
                    MailFrom    = null;
                    MailTo      = null;
                    MailSubject = null;
                    MailBody    = null;

                    BAL_Admission     oBAL_Admission     = new BAL_Admission();
                    AdmissionApproval oAdmissionApproval = new AdmissionApproval();

                    oAdmissionApproval.AdmissionId     = AdmissionID;
                    oAdmissionApproval.AdmissionStatus = "NotApprove";
                    oAdmissionApproval.Remarks         = GetValue(Remarks);
                    oAdmissionApproval.MailFrom        = MailFrom;
                    oAdmissionApproval.MailTo          = MailTo;
                    oAdmissionApproval.MailSubject     = MailSubject;
                    oAdmissionApproval.MailBody        = MailBody;
                    oAdmissionApproval.IsSendSuccess   = true;
                    oAdmissionApproval.FailureReasons  = GetValue("Mail Not Send Because Admission NotApprove");
                    oAdmissionApproval.CreatedBy       = Convert.ToString(AppSessions.EmpolyeeID);

                    oBAL_Admission.AdmissionApproval_Insert(oAdmissionApproval);
                }
            }
        }
        BindGrid();

        mainpopup.Attributes["class"] = "overlayone";
        msg.InnerHtml = "Your operation has been successfully completed.";
    }
Пример #12
0
    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.";
        }
    }