public ActionResult Create([Bind(Include = "GrantRequest, AverageIncome, GrantPercentage, ServiceInMonthes")] ServiceEndGrantRequest serviceEndGrantRequest)
{
Db db = new Db(DbServices.ConnectionString);
if (ModelState.IsValid)
{
try
{
ServiceEndGrantRequestServices.Insert(CurrentUser.Id, serviceEndGrantRequest, 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.GrantRequestList = new SelectList(GrantRequestServices.List(db), "Request", "Description");
return(View(serviceEndGrantRequest));
}
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.GrantRequestList = new SelectList(GrantRequestServices.List(db), "Request", "Description");
return(View());
}
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 Edit(GrantRequestViewModel model)
{
int productId = model.RequestProduct.Id;
try
{
Db db = new Db(DbServices.ConnectionString);
if (!(db.Connection.State == ConnectionState.Open))
{
db.Connection.Open();
}
db.Transaction = db.Connection.BeginTransaction();
if (ModelState.IsValid)
{
try
{
// 1- Update Prouct
ProductServices.Update(CurrentUser.Id, model.RequestProduct, db);
//2- Update Request
RequestServices.Update(CurrentUser.Id, model.Request, db);
//3- Update GrantRequest
GrantRequestServices.Update(CurrentUser.Id, model.GrantRequest, db);
TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "UpdateConfirmed");
}
catch (CfException cfex)
{
TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage;
}
catch (Exception ex)
{
TempData["Failure"] = ex.Message;
}
}
if (db.Transaction != null)
{
db.Transaction.Commit();
}
if (productId == 0)
{
return(RedirectToAction("Index"));
}
return(RedirectToAction("Details", new { id = productId }));
}
catch
{
return(View());
}
}
// 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));
}
// GET: ServiceEndGrantRequest/Edit/5
public ActionResult Edit(Nullable <int> grantRequest)
{
Db db = new Db(DbServices.ConnectionString);
if (grantRequest == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ServiceEndGrantRequest serviceEndGrantRequest = ServiceEndGrantRequestServices.Get(grantRequest.Value, db);
if (serviceEndGrantRequest == null)
{
return(HttpNotFound());
}
ViewBag.GrantRequestList = new SelectList(GrantRequestServices.List(db), "Request", "Description", serviceEndGrantRequest.GrantRequest);
return(View(serviceEndGrantRequest));
}
// 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 ActionResult DeleteConfirmed(int request)
{
try
{
Db db = new Db(DbServices.ConnectionString);
GrantRequestServices.Delete(CurrentUser.Id, request, 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(grantRequest);
return(RedirectToAction("Index"));
}
public ActionResult Create(GrantRequestViewModel model)
{
int productId = 0;
try
{
Db db = new Db(DbServices.ConnectionString);
if (!(db.Connection.State == ConnectionState.Open))
{
db.Connection.Open();
}
db.Transaction = db.Connection.BeginTransaction();
if (ModelState.IsValid)
{
try
{
// 1- Add Prouct
// set the Amount of the Produt the same as Request
model.RequestProduct.Amount = model.Request.Amount;
model.RequestProduct.ProductType = 0;
Product p = ProductServices.Insert(CurrentUser.Id, model.RequestProduct, db);
productId = p.Id;
//2-Add Request
model.Request.Product = p.Id;
model.Request.RequestStatus = (int)RequestStatusEnum.New;
model.Request.Cost = 5;
Request r = RequestServices.Insert(CurrentUser.Id, model.Request, db);
//3-Add GrantRequest
model.GrantRequest.Request = p.Id;
model.GrantRequest.Amount = model.Request.Amount;
GrantRequestServices.Insert(CurrentUser.Id, model.GrantRequest, db);
TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "InsertConfirmed");
}
catch (CfException cfex)
{
TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage;
}
catch (Exception ex)
{
TempData["Failure"] = ex.Message;
}
}
if (db.Transaction != null)
{
db.Transaction.Commit();
}
if (productId == 0)
{
return(RedirectToAction("Index"));
}
return(RedirectToAction("Details", new { id = productId }));
}
catch
{
return(View());
}
}
