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"));
}
}
// GET: InstitutionScholorship/Edit/5
public ActionResult Edit(int id)
{
using (db = new InstituteRegistrationAndScholarship())
{
return View(db.SchlorshipCriterias.Where(x => x.id == id).FirstOrDefault());
}
}
public ActionResult PasswordReset(InstitutePasswordReset passwordReset)
{
using (db = new InstituteRegistrationAndScholarship())
{
string id = Session["InstitutionID"].ToString();
if (id != null)
{
if (passwordReset.NewPassword != null && passwordReset.ConfirmPassword != null)
{
int InstituteID = int.Parse(Session["InstitutionID"].ToString());
var InstituteIdCheck = db.institutes.Where(d => d.InstitutionID == InstituteID).FirstOrDefault();
InstituteIdCheck.Ins_Password = passwordReset.NewPassword;
db.SaveChanges();
ViewBag.SuccessMessage = "Password Updated successful";
}
else
{
ViewBag.Message = "Please enter Details";
}
}
else
{
return(RedirectToAction("Login"));
}
return(View());
}
}
// GET: InstitutionScholorship
public ActionResult DisplayScholorship()
{
using (db = new InstituteRegistrationAndScholarship())
{
int id = int.Parse(Session["InstitutionID"].ToString());
return View(db.SchlorshipCriterias.Where(x=>x.InstituteId==id).ToList());
}
}
// GET: InstitutionScholorship/Create
public ActionResult Create(int sid , int insID, string ScholarName)
{
InstituteRegistrationAndScholarship dbins = new InstituteRegistrationAndScholarship();
SchlorshipCriteria SC = new SchlorshipCriteria();
SC.ScholarshipID = sid;
SC.InstituteId = insID;
SC.ScholarshipName = ScholarName;
return View(SC);
}
public ActionResult ForgotPassword(InstituteForgetPassword forgotPassword)
{
using (db = new InstituteRegistrationAndScholarship())
{
var InstituteIdCheck = db.institutes.Where(d => d.InstitutionID == forgotPassword.InstitutionID && d.FavoritePet == forgotPassword.FavouritePet && d.FavoriteMovie == forgotPassword.FavouriteMovie && d.Luckynumber == forgotPassword.LuckyNumber).FirstOrDefault();
if (InstituteIdCheck != null)
{
Session["InstitutionID"] = InstituteIdCheck.InstitutionID.ToString();
return(RedirectToAction("PasswordReset", "institutes"));
}
}
return(View("ForgotPassword", "institutes"));
}
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));
}
public ActionResult AddScholarshipDetails(Institute_details scholarshipmodel)
{
using (db = new InstituteRegistrationAndScholarship())
{
if (ModelState.IsValid)
{
db.Institute_details.Add(scholarshipmodel);
db.SaveChanges();
TempData["ScholarshipAdded"] = "New Scholarship Details Added";
TempData.Keep();
return(RedirectToAction("InstituteDashboard", "institutes"));
}
else
{
TempData["ScholarshipAdded"] = "Please Fill the details";
return(View());
}
}
}
public ActionResult Edit(int id, SchlorshipCriteria criteria)
{
try
{
// TODO: Add update logic here
using (db = new InstituteRegistrationAndScholarship())
{
db.Entry(criteria).State = EntityState.Modified;
db.SaveChanges();
}
return RedirectToAction("DisplayScholorship");
}
catch
{
return View();
}
}
public ActionResult Create(SchlorshipCriteria model)
{
try
{// TODO: Add insert logic here
using (db = new InstituteRegistrationAndScholarship())
{
db.SchlorshipCriterias.Add(model);
db.SaveChanges();
TempData["AddCriteria"] = "Criteria Added Successfully";
TempData.Keep();
return RedirectToAction("DisplayScholorship", "AddScholarshipCriteria");
}
}
catch
{
ViewBag.Added = "Criteria Already Added Proceed with Update / Check criteria";
return View();
}
}
public ActionResult Login(InstituteLogin insloginModel)
{
using (db = new InstituteRegistrationAndScholarship())
{
var checkInstitution = db.institutes.Where(d => d.InstitutionID == insloginModel.InstitutionID && d.Ins_Password == insloginModel.Password).FirstOrDefault();
var Institutionid = db.institutes.Where(d => d.InstitutionID == insloginModel.InstitutionID).FirstOrDefault();
var password = db.institutes.Where(d => d.InstitutionID == insloginModel.InstitutionID && d.Ins_Password == insloginModel.Password).FirstOrDefault();
if (checkInstitution != null)
{
ID = insloginModel.InstitutionID;
Session["InstitutionName"] = checkInstitution.InstitutionName;
Session["InstitutionID"] = checkInstitution.InstitutionID.ToString();
Session["IDpass"] = checkInstitution.InstitutionID;
TempData["InstitutionID"] = checkInstitution.InstitutionID;
TempData.Keep();
Session["InstitutionIDTOPASS"] = (int)checkInstitution.InstitutionID;
return(RedirectToAction("InstituteDashboard", "institutes"));
}
else
{
if (Institutionid == null)
{
ViewBag.username = "******";
}
if (password == null)
{
ViewBag.password = "******";
}
//ModelState.Clear();
ViewBag.RejectMessage = "Invalid user Id or Password";
return(View("Login"));
}
}
}
public ActionResult ApplyForInstituionScholarship()
{
try
{
StateScholarshipEntities3 dbscholarshipproviderdb = new StateScholarshipEntities3();
int studentID = int.Parse(Session["ID"].ToString());
if (studentID != 0)
{
InstituteRegistrationAndScholarship dbscholarprovider;
dbscholarprovider = new InstituteRegistrationAndScholarship();
return(View(dbscholarprovider.Institute_details.ToList()));
}
else
{
return(View("Error"));
}
}
catch (Exception)
{
return(View("Error"));
}
}
public ActionResult ForgotID(ForgotInstituteID userID)
{
using (db = new InstituteRegistrationAndScholarship())
{
var EmailCheck = db.institutes.Where(d => d.Email == userID.Email && d.FavoritePet == userID.FavouritePet && d.FavoriteMovie == userID.FavouriteMovie && d.Luckynumber == userID.LuckyNumber).FirstOrDefault();
if (EmailCheck != null)
{
var id = (from institute in db.institutes
where institute.Email.Equals(userID.Email)
select institute.InstitutionID).SingleOrDefault();
ViewBag.SuccessMessage = "Institute Id :" + id;
}
else
{
ModelState.Clear();
ViewBag.RejectMessage = "Invalid Information given";
}
return(View());
}
}
public ActionResult ScholarshipDetails(int sid)
{
InstituteRegistrationAndScholarship dbscholarprovider = new InstituteRegistrationAndScholarship();
return(View(dbscholarprovider.SchlorshipCriterias.Where(x => x.ScholarshipID == sid).FirstOrDefault()));
}
