public ActionResult Create([Bind(Include = "Id, Name, Amount, GrantTypeGroup")] GrantType grantType)
{
Db db = new Db(DbServices.ConnectionString);
if (ModelState.IsValid)
{
try
{
GrantTypeServices.Insert(CurrentUser.Id, grantType, 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.GrantTypeGroupList = new SelectList(GrantTypeGroupServices.List(db), "Id", "Name");
return(View(grantType));
}
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 ActionResult Create([Bind(Include = "Id, Employee, RequestDate, GrantType, Description, Amount, CersNumber, CersDate, PaymentNumber, PaymentDate, Notes")] ExternalGrant externalGrant)
{
Db db = new Db(DbServices.ConnectionString);
if (ModelState.IsValid)
{
try
{
ExternalGrantServices.Insert(CurrentUser.Id, externalGrant, 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.EmployeeList = new SelectList(EmployeeServices.List(db), "Id", "FirstName");
ViewBag.GrantTypeList = new SelectList(GrantTypeServices.List(db), "Id", "Name");
return(View(externalGrant));
}
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 ActionResult Create()
{
Db db = new Db(DbServices.ConnectionString);
ViewBag.GrantTypeList = new SelectList(GrantTypeServices.List(db), "Id", "Name");
ViewBag.RequestList = new SelectList(RequestServices.List(db), "Product", "Attachment");
return(View());
}
public ActionResult Create()
{
Db db = new Db(DbServices.ConnectionString);
ViewBag.EmployeeList = new SelectList(EmployeeServices.List(db), "Id", "FirstName");
ViewBag.GrantTypeList = new SelectList(GrantTypeServices.List(db), "Id", "Name");
return(View());
}
/// <summary>
/// Returns a list of GrantRequestVw objects
/// </summary>
/// <returns></returns>
public ActionResult Index(GrantRequestVwViewModel Model)
{
Db db = new Db(DbServices.ConnectionString);
ViewBag.GrantType = new SelectList(GrantTypeServices.List(db), "Id", "Name");
if (Model.Filter.HasCriteria)
{
Model.List = GrantRequestVwServices.Get(Model.Filter, db);
}
else
{
Model.List = new List <GrantRequestVw>();
}
return(View(Model));
}
// GET: GrantType/Delete/5
public ActionResult Delete(Nullable <byte> id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Db db = new Db(DbServices.ConnectionString);
GrantType grantType = GrantTypeServices.Get(id.Value, db);
if (grantType == null)
{
return(HttpNotFound());
}
return(View(grantType));
}
// GET: GrantType/Edit/5
public ActionResult Edit(Nullable <byte> id)
{
Db db = new Db(DbServices.ConnectionString);
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
GrantType grantType = GrantTypeServices.Get(id.Value, db);
if (grantType == null)
{
return(HttpNotFound());
}
ViewBag.GrantTypeGroupList = new SelectList(GrantTypeGroupServices.List(db), "Id", "Name", grantType.GrantTypeGroup);
return(View(grantType));
}
// 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));
}
// GET: ExternalGrant/Edit/5
public ActionResult Edit(Nullable <int> id)
{
Db db = new Db(DbServices.ConnectionString);
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ExternalGrant externalGrant = ExternalGrantServices.Get(id.Value, db);
if (externalGrant == null)
{
return(HttpNotFound());
}
ViewBag.EmployeeList = new SelectList(EmployeeServices.List(db), "Id", "FirstName", externalGrant.Employee);
ViewBag.GrantTypeList = new SelectList(GrantTypeServices.List(db), "Id", "Name", externalGrant.GrantType);
return(View(externalGrant));
}
public ActionResult DeleteConfirmed(byte id)
{
try
{
Db db = new Db(DbServices.ConnectionString);
GrantTypeServices.Delete(CurrentUser.Id, id, db);
TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "DeleteConfirmed");
// return RedirectToAction("Index");
}
catch (CfException cfex)
{
TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage;
}
catch (Exception ex)
{
TempData["Failure"] = ex.Message;
}
// return View(grantType);
return(RedirectToAction("Index"));
}
public JsonResult getGrantTypeAmount(int id)
{
GrantType type = GrantTypeServices.Get((byte)id);
if (type != null)
{
if (type.Amount == null)
{
return(Json(new { amount = 0 }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { amount = type.Amount }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { amount = 0 }, JsonRequestBehavior.AllowGet));
}
}
