public CheckRegistryViewModel GetViewModelForEntriesAfterForJsonResult(DateTime dtLastDataRetrieve)
{
var vm = new CheckRegistryViewModel
{
Accounts = GetAccountSummary().ToList(),
Register = GetRegisterEntriesAfter(dtLastDataRetrieve).ToList(),
Categories = GetCategoriesListCollection()
};
// There are a number of improvements that could be made.. for instance we could just return the accounts
// that changed
vm.LastRetrieve = String.Format("{0:MM/dd/yyyy hh:mm:ss}", DateTime.Now.AddSeconds(-1));
return vm;
}
public ActionResult Create(FormCollection collection)
{
registercategory category = null;
dailyregister reg = null;
try
{
if (collection.AllKeys.Contains("RegisterCategoryId"))
{
var catID = collection.GetValue("RegisterCategoryId").AttemptedValue;
category = Dbcontext.GetCategoryById(Convert.ToInt32(catID));
}
else
if (collection.AllKeys.Contains("RegisterCategoryName"))
{
var categoryName = collection.GetValue("RegisterCategoryName").AttemptedValue;
category = Dbcontext.GetCategoryByName(categoryName) ?? Dbcontext.CreateCategory(categoryName);
}
DateTime EntryDate = DateTime.Now;
if (collection.AllKeys.Contains("EntryDate"))
{
DateTime dt = EntryDate;
if (DateTime.TryParse(collection.GetValue("EntryDate").AttemptedValue, out dt))
{
EntryDate =dt;
}
}
// The entry will return, but we don't need it.. model context prepares to add it on submitchanges
reg = Dbcontext.CreateRegisterEntry(
Dbcontext.GetAccountById(Convert.ToInt32(collection.GetValue("AccountID").AttemptedValue)),
category,
Convert.ToDouble(collection.GetValue("Amount").AttemptedValue),
EntryDate,
collection.GetValue("Who").AttemptedValue);
Dbcontext.SubmitChanges();
if (!Request.IsAjaxRequest())
{
var vm = Dbcontext.GetViewModel();
vm.Message = "Created item";
return View("Main", vm);
}
else
{
var dreg = new DailyRegistry
{
AccountId = reg.account.account_id,
AccountName = reg.account.account_name,
CategoryId = reg.register_category_id,
CategoryName = reg.registercategory.register_category_name,
EntryDate = reg.registry_date,
RegistryAmount = reg.registry_amount,
RegistryDesc = reg.registry_enteredby,
RegistryId = reg.registry_id
};
// Need to slightly alter our resultset
DateTime dtLastDataRetrieve = DateTime.Parse(collection.GetValue("LastRetrieveDate").AttemptedValue);
var newResult = Dbcontext.GetViewModelForEntriesAfterForJsonResult(dtLastDataRetrieve);
if (!newResult.Register.Contains(dreg))
newResult.Register.Add(dreg);
return Json(newResult);
}
}
catch (Exception ex)
{
var vmex = Dbcontext.GetViewModel();
vmex.Message = String.Format("Error while creating item ({0})", ex.Message);
if (!Request.IsAjaxRequest())
{
return View("Main", vmex);
}
var newResult = new CheckRegistryViewModel() { Message = vmex.Message };
return Json(newResult);
}
}
