public List <GrantInfo> GetGrantsByPerson(int personId)
{
var grants = from g in cae.GrantRequests
from r in g.GrantReviews
where g.PersonKey == personId
select new
{
g.GrantRequestDate,
g.GrantRequestExplanation,
g.GrantType.GrantTypeName,
g.GrantRequestAmount,
r.GrantRequestStatus
};
List <GrantInfo> info = new List <GrantInfo>();
foreach (var gr in grants)
{
GrantInfo gi = new GrantInfo();
gi.GrantTypeName = gr.GrantTypeName;
gi.Explanation = gr.GrantRequestExplanation;
gi.Amount = (decimal)gr.GrantRequestAmount;
gi.Status = gr.GrantRequestStatus;
info.Add(gi);
}
return(info);
}
//to create and show the grant list
public List <GrantInfo> GetGrants(int PersonKey)
{
List <GrantInfo> grants = new List <GrantInfo>();
var ggs = (from grt in db.GrantRequests
from gvt in grt.GrantReviews
/*where gvt.GrantRequestKey == grt.GrantRequestKey*/
where grt.PersonKey == PersonKey
select new
{
grt.Person.PersonFirstName,
grt.Person.PersonLastName,
grt.GrantRequestDate,
grt.GrantRequestAmount,
gvt.GrantReviewDate,
gvt.GrantRequestStatus,
gvt.GrantAllocationAmount
});
foreach (var g in ggs)
{
GrantInfo gtgr = new GrantInfo();
gtgr.FirstName = g.PersonFirstName;
gtgr.LastName = g.PersonLastName;
gtgr.RequestDate = g.GrantRequestDate.ToString();;
gtgr.RequestAmount = g.GrantRequestAmount.GetValueOrDefault();
gtgr.ReviewDate = g.GrantReviewDate.ToString();
gtgr.ReviewStatus = g.GrantRequestStatus;
gtgr.AllocationAmount = g.GrantAllocationAmount.GetValueOrDefault();
grants.Add(gtgr);
}
return(grants);
}
List <GrantInfo> GetGrantType()
{
var grants = from b in db.GrantType
select b;
List <GrantInfo> grants = new List <GrantInfo>();
foreach (GrantInfo gr in grants)
{
GrantInfo grant1 = new GrantInfo();
grant1.GrantTypeDescription = gr.GrantTypeDescription;
grant1.GrantTypeName = gr.GrantTypeName;
grant1.GrantPerson = new List <Person>();
foreach (Person a in bk.Persons)
{
Person au = new Person();
au.PersonFirstName = a.PersonFirstName;
au.PersonLastName = a.PersonLastName;
au.PersonEmail = a.PersonEmail;
}
}
return(grants);
}
public IActionResult Login([FromForm] GrantInfo authInfo)
{
try
{
_logger.LogInformation(Newtonsoft.Json.JsonConvert.SerializeObject(authInfo));
return(Ok(_movieService.Login(authInfo)));
}
catch (System.Exception ex)
{
_logger.LogError(ex, ex.Message);
return(StatusCode(500));
}
}
public LoginResponse Login(GrantInfo authInfo)
{
try
{
IRestClient client = new RestClient(_appConfiguration.AuthInfo.token_url);
RestRequest request = new RestRequest(Method.POST);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Newtonsoft.Json.JsonConvert.SerializeObject(authInfo), ParameterType.RequestBody);
var response = client.Post <LoginResponse>(request);
return(response.Data);
}
catch (Exception)
{
throw;
}
}
public GrantInfo GetGrantInfo(string code, string key)
{
var ch = new CashbagHelper(_webUrl + "QueryGrantApply", "GET");
var dictionary = new Dictionary <string, string>
{
{ "code", code },
{ "key", key },
{ "currentTime", DateTime.Now.ToString("yyyyMMddHHmmss") }
};
var data = ch.ParamsURLEncode(dictionary);
var result = ch.GetBackJsonData(data);
if (result.status == false)
{
throw new CashBagException(result.message.ToString());
}
var grant = new GrantInfo();
if (result.result != null)
{
grant.GrantArray = new List <GrantArray>();
var rows = JArray.FromObject(result.result);
foreach (var item in rows)
{
if (item.Key.ToString() == "")
{
continue;
}
var grantarray = new GrantArray
{
Key = item.Key,
ImageUrl = item.ImageUrl
};
grant.GrantArray.Add(grantarray);
}
}
grant.Applystatus = result.code;
grant.message = result.message;
return(grant);
}
public void Init()
{
instance = new GrantInfo();
}
