public ActionResult Index([Bind(Include = "UserName, Password")] LogInClass lc) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int loginResult = db.usp_Login(lc.UserName, lc.Password); if (loginResult != -1) { var uid = (from r in db.People where r.PersonFirstName.Equals(lc.UserName) select r.PersonKey).FirstOrDefault(); int rKey = (int)uid; Session ["ReviewerKey"] = rKey; Class1Messages msg = new Class1Messages(); msg.MessageText = "Thank You, " + lc.UserName + " for login you can donate"; return(RedirectToAction("Result", msg)); } Class1Messages message = new Class1Messages(); message.MessageText = "invalid Login"; return(View("Result", message)); }
public ActionResult Index([Bind(Include = "Email, Password")] Login lc) { //make connection with database CommunityAssist2017Entities db = new CommunityAssist2017Entities(); //use stored procedure in database int result = db.usp_Login(lc.Email, lc.Password); if (result != -1) { var uID = (from p in db.People where p.PersonEmail.Equals(lc.Email) select p.PersonKey).FirstOrDefault(); //cast ID into a int int key = (int)uID; //store it in a session key Session["PersonKey"] = key; var pName = (from p in db.People where p.PersonEmail.Equals(lc.Email) select p.PersonFirstName).FirstOrDefault(); //create a message class and pass the string to the result view Message msg = new Message("Welcome, " + pName + ". You can now make donation or request for grant."); return(RedirectToAction("Result", msg)); } //if it fails pass this message to the result view Message message = new Message("Invalid Login"); return(View("Result", message)); }
public ActionResult Index() { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); // pass grant type as a list return(View(db.GrantTypes.ToList())); }
public ActionResult Index([Bind(Include = "Email, Password")] LoginClass lgc) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); lgc.PersonKey = 0; int result = db.usp_Login(lgc.Email, lgc.Password); if (result != -1) { var ukey = (from p in db.People where p.PersonEmail.Equals(lgc.Email) select p.PersonKey).FirstOrDefault(); lgc.PersonKey = ukey; System.Web.HttpContext.Current.Session["ukey"] = ukey; } var resultMessage = new Message(); if (result != -1) { resultMessage.MessageText = "Thank you for loggin in. You may now Donate or apply for assistance."; } else { resultMessage.MessageText = "Login failed. Please check your credentials, or Register if you have not yet done so."; } return(View("Result", resultMessage)); }
public ActionResult Index([Bind(Include = "Username, Password")] LoginClass lc) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int loginresult = db.usp_Login(lc.Username, lc.Password); if (loginresult != -1) { var uid = (from p in db.People where p.PersonEmail.Equals(lc.Username) select p.PersonKey).FirstOrDefault(); int pKey = (int)uid; Session["personKey"] = pKey; //create message Message m = new Message(); m.MessageTitle = "Login Results"; m.MessageText = "Thank You, " + lc.Username + " for logging in. You can now donate or apply for grants"; return(RedirectToAction("Result", m)); } Message bad = new Message(); bad.MessageTitle = "Login Results"; bad.MessageText = "Invalid Login"; return(View("Result", bad)); }
public ActionResult Index() { ////initalize entities classes CommunityAssist2017Entities db = new CommunityAssist2017Entities(); //pass the collection catergories to the index as a list return(View(db.GrantTypes.ToList())); }
public ActionResult Index([Bind(Include = "UserName, " + "Password, " + "PersonKey" )] Login li) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); li.PersonKey = 0; int result = db.usp_Login(li.UserName, li.Password); Message msg = new Message(); msg.Succeeded = result != -1; if (msg.Succeeded) { Session["PersonKey"] = (int)(from p in db.People where p.PersonEmail.Equals(li.UserName) select p.PersonKey).FirstOrDefault(); msg.UserName = (string)(from p in db.People where p.PersonEmail.Equals(li.UserName) select p.PersonFirstName).FirstOrDefault(); return(RedirectToAction("Result", msg)); } else { return(View("Result", msg)); } }
public ActionResult Index([Bind(Include = "GrantType, GrantApplicationReason, GrantApplicationRequestAmount")] GrantApplication app) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); if (Session["PersonKey"] != null) { GrantApplication g = new GrantApplication(); g.PersonKey = (int)Session["PersonKey"]; g.GrantAppicationDate = DateTime.Now; g.GrantApplicationRequestAmount = app.GrantApplicationRequestAmount; g.GrantApplicationReason = app.GrantApplicationReason; g.GrantApplicationStatusKey = 1; g.GrantType = app.GrantType; db.GrantApplications.Add(g); db.SaveChanges(); Message m = new Message(); m.MessageText = "Your application has been submitted"; return(RedirectToAction("Result", m)); } return(View("Result")); }
public ActionResult Index() { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); return(View(db.GrantTypes.ToList())); //return View(); }
public ActionResult Index([Bind(Include = "PersonKey," + "GrantApplicationDate, " + "GrantTypeKey," + "GrantApplicationRequestAmount," + "GrantApplicationReason," + "GrantApplicationStatusKey," + "GrantApplicationAllocationAmount")] GrantApplication ga) { try { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); ga.PersonKey = (int)Session["PersonKey"]; ga.GrantAppicationDate = DateTime.Now; ga.GrantApplicationStatusKey = (int)1; //ga.GrantTypeKey = // CommunityAssist2017Entities db = new CommunityAssist2017Entities(); db.GrantApplications.Add(ga); db.SaveChanges(); Message m = new Message(); m.MessageText = "Your application is being reviewed"; return(RedirectToAction("Result", m)); } catch (Exception e) { Message m = new Message(); m.MessageText = e.Message; return(RedirectToAction("Result", m)); } }
public ActionResult Index([Bind(Include = "DonationKey, DonationDate, DonationAmount, DontionConfirmationCode")] NewDonation nd) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int loginResult = db.Donations(nd.DonationAmount, nd.DonationDate, nd.DontionConfirmationCode); if (loginResult != -1) { var uid = (from np in db.Donations where np.DonationConfirmationCode.Equals(nd.DonationKey) select np.DonationKey).FirstOrDefault(); int npKey = (int)uid; Session["personkey"] = npKey; Donation donation = new Donation(); donation.DonationConfirmationCode = Guid.NewGuid(); db.Donations.Add(donation); db.SaveChanges(); Message msg = new Message(); msg.MessageText = "Thank you," + nd.DonationKey + "for logging in. You can now" + "donate"; return(View("Message", msg)); } Message m = new Message(); m.MessageText = "Thank you, the donation has been added"; return(View("Result", m)); }
public ActionResult Index([Bind(Include = "PersonKey,GrantApplicationDate," + "GrantTypeKey,GrantApplicationRequestAmount,GrantApplicationReason,GrantApplicationStatusKey," + "GrantApplicationAllocationAmount")] GrantApplication g) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int key = (int)Session["userKey"]; //GrantApplication grantApplication = new GrantApplication(); //grantApplication.GrantTypeKey = g.GrantTypeKey; g.GrantApplicationStatusKey = 1; //pending g.PersonKey = key; g.GrantAppicationDate = DateTime.Now; Console.WriteLine("g = ", g.ToString()); db.GrantApplications.Add(g); db.SaveChanges(); Message m = new Message("Thank you for your contribution to the community."); return(RedirectToAction("Result", m)); }
public ActionResult Index([Bind(Include = "UserName, Password, PersonKey")] LoginClass loginClass) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); loginClass.PersonKey = 0; int result = db.usp_Login(loginClass.UserName, loginClass.Password); Message msg = new Message(); if (result != -1) { var ukey = (from r in db.People where r.PersonEmail.Equals(loginClass.UserName) select r.PersonKey).FirstOrDefault(); loginClass.PersonKey = (int)ukey; Session["NewPersonKey"] = loginClass.PersonKey; msg.MessageText = "Welcome " + loginClass.UserName; } else { msg.MessageText = "Invalid Login"; } //return the class to the Result view return(View("Result", loginClass)); }
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass lc) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int loginResult = db.usp_Login(lc.UserName, lc.Password); if (loginResult != -1) { var uid = (from np in db.People where np.PersonEmail.Equals(lc.UserName) select np.PersonKey).FirstOrDefault(); int npKey = (int)uid; Session["personkey"] = npKey; Message msg = new Message(); msg.MessageText = "Thank you," + lc.UserName + "for logging in. You can now" + "donate or apply for assistance"; return(RedirectToAction("Result", msg)); } Message message = new Message(); message.MessageText = "Validation failed, please try again or register if you have not done so yet"; return(View("Result", message)); }
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass lc) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int loginResult = db.usp_Login(lc.UserName, lc.Password); if (loginResult != -1) { var uid = (from r in db.People where r.PersonEmail.Equals(lc.UserName) select r.PersonKey).FirstOrDefault(); int rKey = (int)uid; Session["reviewKey"] = rKey; Message msg = new Message(); msg.MessageText = "Thank you, " + lc.UserName + " for logging in. You can now donate or apply for assistance."; return(RedirectToAction("Result", msg)); } Message message = new Message(); message.MessageText = "Invalid Login"; return(View("Result", message)); }
public ActionResult Index() { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); //var gt = (from g in db.GrantTypes //select g).ToList(); return(View(db.GrantTypes.ToList())); }
public ActionResult Index() { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); //Grant types 3 * Modify the index method to create a list of objects //Grant types 4 * Have that list returned to the view return(View(db.GrantTypes.ToList())); }
public ActionResult Index() { //initialized entities - making communityassist2017 database to a class to allow tables to be pass through CommunityAssist2017Entities db = new CommunityAssist2017Entities(); //pass the collection GrantType to the index as a list return(View(db.GrantTypes.ToList())); }
public ActionResult Index([Bind(Include = "DonateDate", "DonationAmount", "DonationConfirmation")] Donation d) { d.PersonKey = (int)Session["PersonKey"]; CommunityAssist2017Entities db = new CommunityAssist2017Entities(); db.Donations.Add(d); db.SaveChanges(); Message m = new Message("Donation has been added"); return(View("Result", m)); }
// GET: GrantApplication public ActionResult Index() { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); if (Session["userKey"] == null) { Message m = new Message("You must be logged in order to apply for assitance."); return(RedirectToAction("Result", m)); } ViewBag.GrantTypeKeys = new SelectList(db.GrantTypes, "GrantTypeKey", "GrantTypeName"); return(View()); }
// GET: GrantApplications public ActionResult Index() { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); if (Session["PersonKey"] == null) { //Message m = new Message("You must be logged in to donate!"); return(RedirectToAction("Index", "Login")); //return RedirectToAction("Result", m); } ViewBag.GrantList = new SelectList(db.GrantTypes, "GrantTypeKey", "GrantTypeName"); return(View()); }
public ActionResult Index([Bind(Include = "PersonKey, DonationDate, DonationAmount, DoantionConfirmationCode")] Donation d) { d.DonationConfirmationCode = Guid.NewGuid(); d.DonationDate = DateTime.Now; d.PersonKey = (int)Session["PersonKey"]; CommunityAssist2017Entities db = new CommunityAssist2017Entities(); db.Donations.Add(d); db.SaveChanges(); Message M = new Message("Donation has been entered"); return(View("Result", M)); }
public ActionResult Index([Bind(Include = "NewPersonLastName,NewPersonFirstName,NewPersonEmail,NewPersonPlainPassword,NewPersonApartment,NewPersonStreet,NewPersonCity,NewPersonState,NewPersonZipcode,NewPersonPhone")] NewPerson r) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int result = db.usp_Register(r.NewPersonLastName, r.NewPersonFirstName, r.NewPersonEmail, r.NewPersonPlainPassword, r.NewPersonApartment, r.NewPersonStreet, r.NewPersonCity, r.NewPersonState, r.NewPersonZipcode, r.NewPersonPhone); if (result != -1) { return(RedirectToAction("Result")); } return(View("Index")); }
// GET: NewGrant public ActionResult Index() { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); if (Session["ReviewerKey"] == null) { Message m = new Message(); m.MessageText = "You must be logged in to request a grant."; return(RedirectToAction("Result", m)); } ViewBag.GrantTypeKey = new SelectList(db.GrantTypes, "GrantTypeKey", "GrantTypeName"); return(View()); }
public ActionResult Index([Bind(Include = "PersonKey, DonationDate,DonationAmount,DonationConfirmationCode")] Donation b) { b.DonationDate = DateTime.Now; b.PersonKey = (int)Session["NewPersonKey"]; b.DonationConfirmationCode = new Guid(); CommunityAssist2017Entities db = new CommunityAssist2017Entities(); db.Donations.Add(b); db.SaveChanges(); Message m = new Message(); m.MessageText = "Thank you for your donation"; return(View("Result", m)); }
public ActionResult Index([Bind(Include = "Personkey, DonationDate, DonationAmount, DonationConfirmationCode")] Donation d) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); d.DonationConfirmationCode = Guid.NewGuid(); d.PersonKey = (int)Session["PersonKey"]; d.DonationDate = DateTime.Now; db.Donations.Add(d); db.SaveChanges(); Message m = new Message("Thank you for your donations!"); return(View("Result", m)); }
public ActionResult Index([Bind(Include = "GrantTypeKey, PersonKey, GrantAppicationDate, GrantApplicationStatusKey, GrantApplicationRequestAmount, GrantApplicationReason")] GrantApplication g) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); g.PersonKey = (int)Session["ReviewerKey"]; g.GrantApplicationStatusKey = 1; g.GrantAppicationDate = DateTime.Now; db.GrantApplications.Add(g); db.SaveChanges(); Message m = new Message(); m.MessageText = "Your application has been successfully submitted."; return(View("Result", m)); }
public ActionResult Index([Bind(Include = "Donation")] DonationClass donate) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); if (Session["PersonKey"] != null) { Donation d = new Donation(); d.PersonKey = (int)Session["PersonKey"]; d.DonationDate = DateTime.Now; d.DonationAmount = donate.Donation; d.DonationConfirmationCode = Guid.NewGuid(); db.Donations.Add(d); db.SaveChanges(); } return(View("Result")); }
public ActionResult Index([Bind(Include = " GrantApplicationKey, PersonKey, GrantApplicationDate, GrantTypeKey, " + "GrantAplicationRequestAmount, GrantApplicationReason, GrantApplicationStutesKey,GrantApplicationAllocationAmount ")] GrantApplication g) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); g.GrantAppicationDate = DateTime.Now; g.PersonKey = (int)Session["personkey"]; g.GrantApplicationStatusKey = 1; db.GrantApplications.Add(g); db.SaveChanges(); Message m = new Message(); m.MessageText = "Thank you for applying for grant"; return(View("Result", m)); }
public ActionResult Index([Bind(Include = "PersonKey, DonationAmount, DonationDate")] Donate d) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); Donation dt = new Donation(); dt.PersonKey = d.PersonKey; dt.DonationAmount = d.DonationAmount; dt.DonationDate = d.DonationDate; dt.DonationConfirmationCode = Guid.NewGuid(); db.Donations.Add(dt); db.SaveChanges(); Message msg = new Message(); msg.MessageText = "Thank you for your donation."; return(View("Result", msg)); }