// GET: GrantRequestInfo
public ActionResult Index()
{
var per = from g in db.GrantRequests
from r in db.GrantReviews
select new
{
g.GrantRequestDate,
g.GrantRequestExplanation,
g.GrantRequestAmount,
r.GrantReviewDate,
r.GrantRequestStatus,
r.GrantAllocationAmount
};
List <GrantRequestInfo> gr = new List <GrantRequestInfo>();
foreach (var pers in per)
{
GrantRequestInfo gre = new GrantRequestInfo();
gre.GrantRequestDate = pers.GrantRequestDate.ToString();
gre.GrantRequestAmount = pers.GrantRequestAmount.ToString();
gre.GrantRequestExplanation = pers.GrantRequestExplanation;
gre.GrantRequestStatus = pers.GrantRequestStatus;
gre.GrantReviewDate = pers.GrantReviewDate.ToString();
gre.GrantAllocationAmount = pers.GrantAllocationAmount.ToString();
gr.Add(gre);
}
return(View(gr));
}
public List <GrantRequestInfo> ViewGrants(int userkey)
{
var grantRequests = from rqs in db.GrantRequests
where rqs.PersonKey == userkey
select rqs;
List <GrantRequestInfo> requestsInfo = new List <GrantRequestInfo>();
foreach (var rq in grantRequests)
{
GrantRequestInfo grqst = new GrantRequestInfo();
grqst.GrantRequestAmount = (decimal)rq.GrantRequestAmount;
grqst.GrantRequestDate = rq.GrantRequestDate;
grqst.GrantRequestExplanation = rq.GrantRequestExplanation;
foreach (var review in rq.GrantReviews)
{
grqst.GrantStatus = review.GrantRequestStatus;
grqst.GrantAllocatedAmount = (decimal)review.GrantAllocationAmount;
grqst.GrantReviewDate = review.GrantReviewDate.ToString();
}
if (grqst.GrantStatus == null)
{
grqst.GrantStatus = "Requires Review";
grqst.GrantAllocatedAmount = 0;
grqst.GrantReviewDate = "Pending";
}
requestsInfo.Add(grqst);
}
return(requestsInfo);
}
public List <GrantRequestInfo> GetRequestGrantAmount(int Key)
{
var grant = from g in db.GrantRequests
from r in g.GrantReviews
where g.PersonKey == Key
select new { g.PersonKey, g.GrantRequestDate, g.GrantRequestAmount, g.GrantRequestExplanation, g.GrantTypeKey,
r.GrantRequestStatus };
List <GrantRequestInfo> GRequest = new List <GrantRequestInfo>();
foreach (var gr in grant)
{
GrantRequestInfo gr1 = new GrantRequestInfo();
gr1.GrantRequestDate = gr.GrantRequestDate.ToShortDateString();
gr1.GrantRequestExplanation = gr.GrantRequestExplanation;
gr1.GrantRequestAmount = gr.GrantRequestAmount.ToString();
gr1.GrantTypeKey = (int)gr.GrantTypeKey;
gr1.PersonKey = (int)gr.PersonKey;
gr1.GrantRequestStatus = gr.GrantRequestStatus;
GRequest.Add(gr1);
}
return(GRequest);
}
