public ActionResult Create([Bind(Include = "Request, GrantType, Description, Amount, Notes, EventDate, IsFromOtherBranch")] GrantRequest grantRequest)
{
Db db = new Db(DbServices.ConnectionString);
if (ModelState.IsValid)
{
try
{
GrantRequestServices.Insert(CurrentUser.Id, grantRequest, db);
TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "InsertConfirmed");
return(RedirectToAction("Index"));
}
catch (CfException cfex)
{
TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage;
}
catch (Exception ex)
{
TempData["Failure"] = ex.Message;
}
}
ViewBag.GrantTypeList = new SelectList(GrantTypeServices.List(db), "Id", "Name");
ViewBag.RequestList = new SelectList(RequestServices.List(db), "Product", "Attachment");
return(View(grantRequest));
}
public async Task <ActionResult> GetGrant([FromBody] GrantRequest req)
{
var user = _context.User.Where(u => u.Email == req.Email).FirstOrDefault <User>();
string grant = Guid.NewGuid().ToString();
if (user != null)
{
string code = _service.RandomDigits(6);
await _service.SendEmail(
req.Email,
"Movim Password Recovery Code",
"Your recovery code is: " + code,
"Your recovery code is: <b>" + code + "</b>"
);
var recoveryGrant = new RecoveryGrant();
recoveryGrant.Code = code;
recoveryGrant.Email = req.Email;
recoveryGrant.DateSent = DateTime.Now;
recoveryGrant.Uid = grant;
_context.RecoveryGrant.Add(recoveryGrant);
_context.SaveChanges();
}
return(Ok(new { grant = grant }));
}
public int RequestGrant(int GrantTypeKey, string GrantRequestExplanation, decimal GrantRequestAmount, int PersonKey)
{
GrantRequest grantRequest = new GrantRequest();
grantRequest.GrantRequestDate = DateTime.Now;
grantRequest.GrantRequestAmount = GrantRequestAmount;
grantRequest.GrantTypeKey = GrantTypeKey;
grantRequest.PersonKey = PersonKey;
grantRequest.GrantRequestExplanation = GrantRequestExplanation;
var result = db.GrantRequests.Add(grantRequest);
db.SaveChanges();
GrantReview addentry = new GrantReview();
addentry.GrantReviewDate = DateTime.Now;
addentry.GrantRequestStatus = "Pending";
addentry.GrantAllocationAmount = GrantRequestAmount;
addentry.GrantRequestKey = result.GrantRequestKey;
db.GrantReviews.Add(addentry);
db.SaveChanges();
return(result.GrantRequestKey);
}
public ActionResult Edit(int?id)
{
Db db = new Db(DbServices.ConnectionString);
if (id == null)
{
return(RedirectToAction("Index"));
}
Product product = ProductServices.Get(id.Value, db);
Request request = RequestServices.Get(id.Value, db);
GrantRequest loanRequest = GrantRequestServices.Get(id.Value, db);
if (product == null || request == null || loanRequest == null)
{
return(HttpNotFound());
}
// For Product
ViewBag.EmployeeList = new SelectList(EmployeeServices.List(db), "Id", "Id_Name", product.Employee);
//For Grant
ViewBag.GrantTypeList = new SelectList(GrantTypeServices.List(db), "Id", "Name");
GrantRequestViewModel vm = new GrantRequestViewModel();
vm.RequestProduct = product;
vm.Request = request;
vm.GrantRequest = loanRequest;
return(View(vm));
}
public List <GrantRequest> GetGrant(int key)
{
//select grants using PersonKey
var grq = from g in db.GrantRequests
where g.PersonKey == key
select g;
//new list of grants
List <GrantRequest> grants = new List <GrantRequest>();
//loop through all results
foreach (var gr in grq)
{
//add info to list
GrantRequest g01 = new GrantRequest();
g01.GrantRequestDate = gr.GrantRequestDate;
g01.GrantRequestAmount = gr.GrantRequestAmount;
g01.GrantRequestExplanation = gr.GrantRequestExplanation;
g01.GrantRequestKey = gr.GrantRequestKey;
g01.GrantTypeKey = gr.GrantTypeKey;
grants.Add(g01);
}
//reutrn result
return(grants);
}
protected void Page_Load(object sender, EventArgs e)
{
int personId = ((int)Session["personKey"]);
Community_AssistEntities db = new Community_AssistEntities();
List <GrantRequest> queryResult = (from g in db.GrantRequests
where g.PersonKey == personId
select g).ToList <GrantRequest>();
List <GrantRequest> resultList = new List <GrantRequest>();
foreach (GrantRequest request in queryResult)
{
GrantRequest g = new GrantRequest();
g.GrantRequestAmount = request.GrantRequestAmount;
g.GrantRequestDate = request.GrantRequestDate;
g.GrantRequestExplanation = request.GrantRequestExplanation;
g.GrantRequestKey = request.GrantRequestKey;
g.PersonKey = request.PersonKey;
g.GrantTypeKey = request.GrantTypeKey;
resultList.Add(g);
}
GridView1.DataSource = resultList;
GridView1.DataBind();
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
string date = DateTextBox.Text;
string Amount = AmountTextBox.Text;
string explains = ExplainTextBox.Text;
Community_AssistEntities apply = new Community_AssistEntities();
GrantRequest grant = new GrantRequest();
//CommunityAssistReference.CommunityServiceClient ca = new CommunityAssistReference.CommunityServiceClient();
// CommunityAssistReference.GrantRequest apply = new CommunityAssistReference.GrantRequest();
grant.GrantRequestDate = DateTime.Parse(date);
grant.GrantRequestAmount = decimal.Parse(Amount);
grant.GrantRequestExplanation = explains;
grant.PersonKey = (int)Session["userKey"];
apply.GrantRequests.Add(grant);
apply.SaveChanges();
// if (Session["userkey"] == null)
// Response.Redirect("grantHistory.aspx");
Response.Redirect("grantHistory.aspx");
}
protected void FillGrid()
{
int key = (int)Session["userkey"];
var del = from g in melat.GrantRequests where g.PersonKey == key select g;
List <GrantRequest> ss = new List <GrantRequest>();
foreach (var gr in del)
{
GrantRequest gs = new GrantRequest();
gs.GrantRequestAmount = gr.GrantRequestAmount;
gs.GrantRequestDate = gr.GrantRequestDate;
gs.GrantRequestExplanation = gr.GrantRequestExplanation;
gs.GrantRequestKey = gr.GrantRequestKey;
gs.GrantReviews = gr.GrantReviews;
gs.GrantType = gr.GrantType;
gs.GrantTypeKey = gr.GrantTypeKey;
ss.Add(gs);
}
GridView1.DataSource = ss;
GridView1.DataBind();
}
public ActionResult DeleteConfirmed(int id)
{
GrantRequest grantRequest = db.GrantRequests.Find(id);
db.GrantRequests.Remove(grantRequest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "GrantRequestKey,GrantRequestDate,PersonKey,GrantTypeKey,GrantRequestExplanation,GrantRequestAmount")] GrantRequest grantRequest)
{
if (ModelState.IsValid)
{
db.Entry(grantRequest).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PersonKey = new SelectList(db.People, "PersonKey", "PersonLastName", grantRequest.PersonKey);
return(View(grantRequest));
}
public bool newGrant(GrantRequest r)
{
bool result = true;
try {
db.GrantRequests.Add(r);
db.SaveChanges();
}catch {
result = false;
}
return(result);
}
public ActionResult Create([Bind(Include = "GrantRequestKey,GrantRequestDate,PersonKey,GrantTypeKey,GrantRequestExplanation,GrantRequestAmount")] GrantRequest grantRequest)
{
if (ModelState.IsValid)
{
db.GrantRequests.Add(grantRequest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.GrantTypeKey = new SelectList(db.GrantTypes, "GrantTypeKey", "GrantTypeName", grantRequest.GrantTypeKey);
ViewBag.PersonKey = new SelectList(db.People, "PersonKey", "PersonLastName", grantRequest.PersonKey);
return(View(grantRequest));
}
// GET: GrantRequests/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
GrantRequest grantRequest = db.GrantRequests.Find(id);
if (grantRequest == null)
{
return(HttpNotFound());
}
return(View(grantRequest));
}
// GET: GrantRequests/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
GrantRequest grantRequest = db.GrantRequests.Find(id);
if (grantRequest == null)
{
return(HttpNotFound());
}
ViewBag.PersonKey = new SelectList(db.People, "PersonKey", "PersonLastName", grantRequest.PersonKey);
return(View(grantRequest));
}
// GET: GrantRequest/Delete/5
public ActionResult Delete(Nullable <int> id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Db db = new Db(DbServices.ConnectionString);
GrantRequest grantRequest = GrantRequestServices.Get(id.Value, db);
if (grantRequest == null)
{
return(HttpNotFound());
}
return(View(grantRequest));
}
public bool ApplyForGrant(GrantRequest gr)
{
bool result = true;
try
{
cae.GrantRequests.Add(gr);
cae.SaveChanges();
}
catch (Exception ex)
{
result = false;
Console.WriteLine(ex);
throw;
}
return(result);
}
//to request a grant
public bool RequestGrant(GrantRequest rq)
{
bool result = true;
rq.GrantRequestDate = DateTime.Now;
db.GrantRequests.Add(rq);
GrantReview rev = new GrantReview()
{
GrantRequest = rq,
GrantRequestStatus = "pending"
};
db.SaveChanges();
return(result);
}
public List <GrantRequest> ReviewGrant(int personKey)
{
var rev = from b in db.GrantRequests where b.PersonKey == personKey select b;
List <GrantRequest> grat = new List <GrantRequest>();
foreach (var r in rev)
{
GrantRequest gr = new GrantRequest();
gr.GrantRequestAmount = r.GrantRequestAmount;
gr.GrantRequestDate = r.GrantRequestDate;
gr.GrantRequestExplanation = r.GrantRequestExplanation;
gr.PersonKey = r.PersonKey;
grat.Add(gr);
}
return(grat);
}
public List <GrantRequest> GetGrant()
{
var gs = from b in db.GrantRequests
select b;
List <GrantRequest> grants = new List <GrantRequest>();
foreach (var g in gs)
{
GrantRequest grant1 = new GrantRequest();
grant1.PersonKey = g.PersonKey;
grant1.GrantRequestDate = g.GrantRequestDate;
grant1.GrantRequestExplanation = g.GrantRequestExplanation;
grants.Add(grant1);
}
return(grants);
}
public bool newGrant(GrantRequest gRequest, GrantReview gReview)
{
bool result = true;
try
{
db.GrantRequests.Add(gRequest);
db.GrantReviews.Add(gReview);
db.SaveChanges();
}
catch
{
result = false;
}
return(result);
}
public List <GrantRequest> GetGrantsByPerson(string personName)
{
var gs = from b in db.GrantRequests
where b.Person.PersonLastName == personName
select b;
List <GrantRequest> grants = new List <GrantRequest>();
foreach (var g in gs)
{
GrantRequest grant1 = new GrantRequest();
grant1.PersonKey = g.PersonKey;
grant1.GrantRequestDate = g.GrantRequestDate;
grant1.GrantRequestExplanation = g.GrantRequestExplanation;
grants.Add(grant1);
}
return(grants);
}
public List <GrantRequest> ReviewG(int key)
{
var req = from b in db.GrantRequests where b.PersonKey == key select b;
List <GrantRequest> Gran = new List <GrantRequest>();
foreach (var r in req)
{
GrantRequest gr = new GrantRequest();
gr.GrantRequestAmount = r.GrantRequestAmount;
gr.GrantRequestDate = r.GrantRequestDate;
gr.GrantRequestExplanation = r.GrantRequestExplanation;
gr.PersonKey = r.PersonKey;
Gran.Add(gr);
}
return(Gran);
}
public bool ApplyForGrant(GrantRequest gr)
{
bool result = true;
try
{
GrantReview review = new GrantReview();
review.GrantRequest = gr;
review.GrantRequestStatus = "Pending";
cae.GrantRequests.Add(gr);
//cae.GrantReviews.Add(review);
cae.SaveChanges();
}
catch {
result = false;
}
return(result);
}
public List <GrantRequest> GetGrantsRequest(int PersonKey)
{
var grqs = from gr in db.GrantRequests
select gr;
List <GrantRequest> gRequest = new List <GrantRequest>();
foreach (GrantRequest grq in grqs)
{
GrantRequest gRequest1 = new GrantRequest();
gRequest1.GrantRequestDate = grq.GrantRequestDate;
gRequest1.PersonKey = grq.PersonKey;
gRequest1.GrantTypeKey = grq.GrantTypeKey;
gRequest1.GrantRequestExplanation = grq.GrantRequestExplanation;
gRequest1.GrantRequestAmount = grq.GrantRequestAmount;
}
return(gRequest);
}
public bool RequestGrant(GrantRequest r)
{
bool result01 = true;
//int rev = db.usp_AddRequest(r.GrantTypeKey, r.GrantRequestExplanation,
//r.GrantRequestAmount, r.PersonKey);
try
{
db.GrantRequests.Add(r);
db.SaveChanges();
}
catch
{
result01 = false;
}
return(result01);
}
protected void Button1_Click(object sender, EventArgs e)
{
Community_AssistEntities db = new Community_AssistEntities();
string selectedGrant = DropDownList1.SelectedValue;
int selectedGrantId = 1;
foreach (var gt in grantTypes)
{
if (selectedGrant.Equals(gt.GrantTypeName))
{
selectedGrantId = gt.GrantTypeKey;
break;
}
}
decimal grantAmount = decimal.Parse(GrantAmountTextBox.Text);
string grantExplanation = ExplainationTextBox.Text;
int personId = ((int)Session["personKey"]);
GrantRequest grantRequest = new GrantRequest();
grantRequest.GrantRequestDate = DateTime.Now;
grantRequest.GrantRequestAmount = grantAmount;
grantRequest.GrantTypeKey = selectedGrantId;
grantRequest.PersonKey = personId;
grantRequest.GrantRequestExplanation = grantExplanation;
var result = db.GrantRequests.Add(grantRequest);
db.SaveChanges();
GrantReview addentry = new GrantReview();
addentry.GrantReviewDate = DateTime.Now;
addentry.GrantRequestStatus = "Pending";
addentry.GrantAllocationAmount = grantAmount;
addentry.GrantRequestKey = result.GrantRequestKey;
db.GrantReviews.Add(addentry);
db.SaveChanges();
ResultLabel.Text = "Grant requested succesfully" + personId;
}
// GET: GrantRequest/Edit/5
public ActionResult Edit(Nullable <int> request)
{
Db db = new Db(DbServices.ConnectionString);
if (request == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
GrantRequest grantRequest = GrantRequestServices.Get(request.Value, db);
if (grantRequest == null)
{
return(HttpNotFound());
}
ViewBag.GrantTypeList = new SelectList(GrantTypeServices.List(db), "Id", "Name", grantRequest.GrantType);
ViewBag.RequestList = new SelectList(RequestServices.List(db), "Product", "Attachment", grantRequest.Request);
return(View(grantRequest));
}
public bool ApplyForGrant(GrantRequest gr)
{
bool result = true;
try
{
//GrantReview review = new GrantReview();
//review.GrantRequest = gr;
//review.GrantRequestStatus = "pending";
cae.GrantRequests.Add(gr);
//cae.GrantReviews.Add(review);
cae.SaveChanges();
}
catch (Exception ex)
{
result = false;
throw ex;
}
return(result);
}
public List <GrantRequest> GetGrantReview(int personKey)
{
var grnts = from g in db.GrantRequests
from p in g.GrantReviews
where g.PersonKey == personKey
select g;
List <GrantRequest> grantRequests = new List <GrantRequest>();
foreach (var gt in grnts)
{
GrantRequest gr = new GrantRequest();
gr.GrantRequestDate = gt.GrantRequestDate;
gr.GrantTypeKey = gt.GrantTypeKey;
gr.GrantRequestExplanation = gt.GrantRequestExplanation;
gr.GrantRequestAmount = gt.GrantRequestAmount;
gr.PersonKey = gt.PersonKey;
}
return(grantRequests);
}
public List <GrantRequest> GetGrants()
{
var GrantReq = from g in db.GrantRequests
select g;
List <GrantRequest> grants = new List <GrantRequest>();
foreach (var gr in GrantReq)
// loop through the request to write each field to the grant request
{
GrantRequest grants1 = new GrantRequest();
grants1.GrantRequestDate = gr.GrantRequestDate;
grants1.GrantRequestAmount = gr.GrantRequestAmount;
grants1.PersonKey = gr.PersonKey;
grants1.GrantTypeKey = gr.GrantTypeKey;
grants.Add(grants1);
}
return(grants);
}
