public ActionResult ApplyScholarship(ScholarshipRequest scholarshiprequest)
        {
            InstituteRegistrationAndScholarship dbscholarprovider = new InstituteRegistrationAndScholarship();

            scholarshiprequest.ApprovedByInstitution = "Waiting For Approval";
            var isEligible = dbscholarprovider.SchlorshipCriterias.Where(x => x.ScholarshipID == scholarshiprequest.ScholarshipID).FirstOrDefault();

            if (scholarshiprequest.Score >= isEligible.PercentageMerit && scholarshiprequest.AnnualIncome <= isEligible.AnnualIncome)
            {
                var courseCheck = dbscholarprovider.ScholarshipRequests.Where(x => x.StudentId == scholarshiprequest.StudentId && x.ScholarshipName == scholarshiprequest.ScholarshipName).FirstOrDefault();
                if (courseCheck == null)
                {
                    dbscholarprovider.ScholarshipRequests.Add(scholarshiprequest);
                    dbscholarprovider.SaveChanges();
                    TempData["Eligible"] = "Congartulations You are eligible and Your request is Submited Successfully" +
                                           " Please wait for the Approval";
                    return(RedirectToAction("Student", "ScholarshipRegistration"));
                }
                else
                {
                    ViewBag.message = "You have Already Applied for this Scholarship";
                    return(View());
                }
            }
            else
            {
                TempData["Eligible"] = "Sorry Your Criteria Does not meet the Requirements";
                return(RedirectToAction("Student", "ScholarshipRegistration"));
            }
        }
        public ActionResult EditRequest(ScholarshipRequest scholarship)
        {
            scholarship.DateofApproval  = DateTime.Now;
            db.Entry(scholarship).State = EntityState.Modified;
            db.SaveChanges();

            return(RedirectToAction("Approvescholarship", "institutes"));
        }
        public ActionResult RequestDetials(int id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ScholarshipRequest Scholarship_request = db.ScholarshipRequests.Find(id);

            if (Scholarship_request == null)
            {
                return(HttpNotFound());
            }
            return(View(Scholarship_request));
        }
        public ActionResult ApplyScholarship(int ScholarshipID, int InstituteID, string ScholarshipName, int ScholarshipAmount, string Course)
        {
            InstituteRegistrationAndScholarship dbscholarprovider = new InstituteRegistrationAndScholarship();
            ScholarshipRequest sr = new ScholarshipRequest();

            sr.ScholarshipID = ScholarshipID;
            sr.institutionId = InstituteID;
            var institutionDetails = dbscholarprovider.institutes.Where(x => x.InstitutionID == InstituteID).FirstOrDefault();

            sr.institutionName   = institutionDetails.InstitutionName;
            sr.ScholarshipName   = ScholarshipName;
            sr.ScholarshipAmount = ScholarshipAmount;
            sr.Course            = Course;
            sr.DateofApproval    = DateTime.Now;
            sr.StudentId         = int.Parse(Session["userid"].ToString());
            sr.StudentName       = Session["Name"].ToString();

            return(View(sr));
        }