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));
}
