/*
This will manually create a job to add to the job service
* Used when the user creates a billpay job using the web site
* */
public void manualCreateBPayJob(int accountNumber, int payeeID, decimal amount, string period, DateTime schedDate)
{
//create a database record for the newly created job then retrive the database geneted billpay id and pass
//it to the createScheduledJobService so it can add the job to the job service
Debug.WriteLine("Creating and Adding a Bew Bill Pay Record to the Billpay table");
using (NWBAEntities db = new NWBAEntities())
{
BillPay newBillPayRecord = new BillPay();
newBillPayRecord.AccountNumber = accountNumber;
newBillPayRecord.PayeeID = payeeID;
newBillPayRecord.Amount = amount;
newBillPayRecord.Period = period;
newBillPayRecord.ScheduleDate = schedDate;
newBillPayRecord.ModifyDate = DateTime.Now;
db.BillPays.Add(newBillPayRecord);
db.SaveChanges();
int billPayID = newBillPayRecord.BillPayID; //EF will update the entity object with the database generated identity
//Now we can create a job and add it to the schduler since we have a BillpayID to identify the job
createScheduledJobService(billPayID, accountNumber, payeeID, amount, period[0], schedDate);
}
}
public ActionResult GridUpdate(int Customerid)
{
//Above, id passed in represents the unique primary key for each row, more properties can be passed in if
// needed eg (int id,string CustomerName)
//Creating another viewmodel so it can be used to data validation
//need to assign it the customer id passed from the view so the object can be passed to the repositry method to add to db
//TO BE IMPLEMENTED LATER, AT the moment, doing nothing major
var customerObject = new EditProfile_ViewModel
{
CustomerID = Convert.ToInt32(Customerid)
};
//Perform model binding from the view to the newly created viewmodel then validate if passes data annotations
//Reference: http://msdn.microsoft.com/en-us/library/system.web.mvc.controller.tryupdatemodel%28v=vs.108%29.aspx
if (TryUpdateModel(customerObject))
{
NWBAEntities db = new NWBAEntities();
Debug.WriteLine("Update Validation Passed");
Customer customerRecord = (from x in db.Customers
where x.CustomerID.Equals(Customerid)
select x).SingleOrDefault();
customerRecord.CustomerName = customerObject.CustomerName;
customerRecord.TFN = customerObject.TFN;
customerRecord.Address = customerObject.Address;
customerRecord.City = customerObject.City;
customerRecord.State = customerObject.State;
customerRecord.PostCode = customerObject.PostCode;
customerRecord.Phone = customerObject.Phone;
db.SaveChanges();
Debug.WriteLine("Updated Record in DB");
return RedirectToAction("ChangeUserDetails", this.GridRouteValues());
}
Debug.WriteLine("Update Validation Failed");
return RedirectToAction("ChangeUserDetails", this.GridRouteValues());
}