public ActionResult Edit(Rp3.Test.Mvc.Models.CategoryEditModel editModel) { if (!ModelState.IsValid) { return(View(editModel)); } Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); Rp3.Test.Common.Models.Category commonModel = new Common.Models.Category(); commonModel.Active = editModel.Active; commonModel.CategoryId = editModel.CategoryId; commonModel.Name = editModel.Name; bool respondeOk = proxy.UpdateCategory(commonModel); if (respondeOk) { return(RedirectToAction("Index")); } else { return(View(editModel)); } }
public ActionResult GetByUserId() { Proxies.Proxy proxy = new Proxies.Proxy(); var userId = int.Parse(Session["UserId"].ToString()); var data = proxy.GetTransactionsByUser(userId); List <Rp3.Test.Mvc.Models.TransactionViewModel> model = new List <Models.TransactionViewModel>(); foreach (var item in data) { model.Add(new Models.TransactionViewModel() { Amount = item.Amount, CategoryId = item.CategoryId, CategoryName = item.CategoryName, Notes = item.Notes, RegisterDate = item.RegisterDate, ShortDescription = item.ShortDescription, TransactionId = item.TransactionId, TransactionType = item.TransactionType, TransactionTypeId = item.TransactionTypeId }); } return(Json(model, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Devuelve el listado de transacciones de la persona seleccionada ordenados de manera descendente según la fecha /// </summary> /// <returns></returns> public ActionResult Index() { Proxies.Proxy proxy = new Proxies.Proxy(); List <Rp3.Test.Mvc.Models.TransactionViewModel> model = new List <Models.TransactionViewModel>(); if (PersonController.PersonId != null) { var data = proxy.GetTransactions((int)PersonController.PersonId); foreach (var item in data) { model.Add(new Models.TransactionViewModel() { Amount = item.Amount, CategoryId = item.CategoryId, CategoryName = item.CategoryName, Notes = item.Notes, RegisterDate = item.RegisterDate, ShortDescription = item.ShortDescription, TransactionId = item.TransactionId, TransactionType = item.TransactionType, TransactionTypeId = item.TransactionTypeId }); } } ViewBag.Categories = CategoryController.GetCategories(); ViewBag.TransactionTypes = GetTransactionTypes(); ViewBag.Transactions = model.OrderByDescending(X => X.RegisterDate).ToList(); return(View()); }
public ActionResult Create(Rp3.Test.Mvc.Models.CategoryCreateModel createModel) { if (!ModelState.IsValid) { return(View(createModel)); } Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); Rp3.Test.Common.Models.Category commonModel = new Common.Models.Category(); commonModel.Active = true; commonModel.Name = createModel.Name; bool respondeOk = proxy.InsertCategory(commonModel); if (respondeOk) { return(RedirectToAction("Index")); } else { return(View(createModel)); } }
public ActionResult Edit(int transactionId) { Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); Rp3.Test.Mvc.Models.TransactionEditModel editModel = new Models.TransactionEditModel(); List <TransactionType> transactionTypeList = proxy.GetTransactionTypes(); List <SelectListItem> transactionTypeItems = transactionTypeList.Select(x => GetTransactionTypeItem(x)).ToList(); editModel.TransactionTypeSelectList = new SelectList(transactionTypeItems, "Value", "Text", 1); List <Category> categoryList = proxy.GetCategories(); List <SelectListItem> categoryItems = categoryList.Select(x => GetCategoryItem(x)).ToList(); editModel.CategorySelectList = new SelectList(categoryItems, "Value", "Text", 1); var commonModel = proxy.GetTransaction(transactionId); editModel.TransactionId = commonModel.TransactionId; editModel.TransactionTypeId = commonModel.TransactionTypeId; editModel.CategoryId = commonModel.CategoryId; editModel.Amount = commonModel.Amount; editModel.ShortDescription = commonModel.ShortDescription; editModel.Notes = commonModel.Notes; return(View(editModel)); }
public ActionResult Index() { Proxies.Proxy proxy = new Proxies.Proxy(); int accountId = Convert.ToInt32(System.Web.HttpContext.Current.Session["AccountId"]); var data = proxy.GetTransactions(accountId); List <Rp3.Test.Mvc.Models.TransactionViewModel> model = new List <Models.TransactionViewModel>(); foreach (var item in data) { model.Add(new Models.TransactionViewModel() { Amount = item.Amount, CategoryId = item.CategoryId, CategoryName = item.CategoryName, Notes = item.Notes, RegisterDate = item.RegisterDate, ShortDescription = item.ShortDescription, TransactionId = item.TransactionId, TransactionType = item.TransactionType, TransactionTypeId = item.TransactionTypeId }); } return(View(model)); }
public ActionResult Balance() { Proxies.Proxy proxy = new Proxies.Proxy(); List <Common.Models.BalanceView> model = new List <Common.Models.BalanceView>(); if (PersonController.PersonId != null) { var data = proxy.GetBalance((int)PersonController.PersonId); foreach (var item in data) { model.Add(new Common.Models.BalanceView { Category = item.Category, Amount = item.Amount }); } decimal total = model.Sum(X => X.Amount); if (total > 0) { model = model.OrderByDescending(X => X.Amount).ToList(); } else { model = model.OrderBy(X => X.Amount).ToList(); } ViewBag.Total = total; } return(View(model)); }
public ActionResult Index() { Proxies.Proxy proxy = new Proxies.Proxy(); var data = proxy.GetTransactions(); List <Rp3.Test.Mvc.Models.TransactionViewModel> model = new List <Models.TransactionViewModel>(); foreach (var item in data) { model.Add(new Models.TransactionViewModel() { Amount = item.Amount, CategoryId = item.CategoryId, CategoryName = item.CategoryName, Notes = item.Notes, RegisterDate = item.RegisterDate, ShortDescription = item.ShortDescription, TransactionId = item.TransactionId, TransactionType = item.TransactionType, TransactionTypeId = item.TransactionTypeId }); } return(View(model)); }
public ActionResult GetById(int id) { Proxies.Proxy proxy = new Proxies.Proxy(); var data = proxy.GetTransactionById(id); return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult GetBalance() { var userId = int.Parse(Session["UserId"].ToString()); Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); var balance = proxy.GetBalance(userId); return(Json(balance, JsonRequestBehavior.AllowGet)); }
public ActionResult Get() { Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); var categories = proxy.GetCategories(); var transactionsTypes = proxy.GetTransactionTypes(); return(Json(new { categories, transactionsTypes }, JsonRequestBehavior.AllowGet)); }
void ObjListEZProxy_SelectionChanged(object sender, SelectionChangedEventArgs e) { Proxies.Proxy proxy = ObjListEZProxy.SelectedItem as Proxies.Proxy; if (null != proxy && !String.IsNullOrEmpty(proxy.url)) { ConfigurationManager.Instance.ConfigurationRecord.Proxy_EZProxy = proxy.url; ConfigurationManager.Instance.ConfigurationRecord_Bindable.NotifyPropertyChanged(() => ConfigurationManager.Instance.ConfigurationRecord.Proxy_EZProxy); } e.Handled = true; }
public ActionResult EditTran() { var _t = Request.Params["transaction"]; var editModel = JsonConvert.DeserializeObject <Rp3.Test.Mvc.Models.TransactionEditModel>(_t); Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); Rp3.Test.Common.Models.Transaction commonModel = new Common.Models.Transaction(); commonModel.RegisterDate = editModel.RegisterDate; commonModel.Amount = editModel.Amount; commonModel.Notes = editModel.Notes; commonModel.TransactionTypeId = editModel.TransactionTypeId; commonModel.CategoryId = editModel.CategoryId; commonModel.TransactionId = editModel.TransactionId; commonModel.ShortDescription = editModel.ShortDescription; commonModel.UserId = editModel.UserId; commonModel.DateUpdate = DateTime.Now; bool respondeOk = proxy.UpdateTransaction(commonModel); if (respondeOk) { var userId = int.Parse(Session["UserId"].ToString()); var data = proxy.GetTransactionsByUser(userId); List <Rp3.Test.Mvc.Models.TransactionViewModel> model = new List <Models.TransactionViewModel>(); foreach (var item in data) { model.Add(new Models.TransactionViewModel() { Amount = item.Amount, CategoryId = item.CategoryId, CategoryName = item.CategoryName, Notes = item.Notes, RegisterDate = item.RegisterDate, ShortDescription = item.ShortDescription, TransactionId = item.TransactionId, TransactionType = item.TransactionType, TransactionTypeId = item.TransactionTypeId }); } return(Json(model, JsonRequestBehavior.AllowGet)); } else { Response.StatusCode = 500; return(Json("ERROR", JsonRequestBehavior.AllowGet)); } }
public ActionResult Index() { string accountId = ConfigurationManager.AppSettings["AccountId"]; System.Web.HttpContext.Current.Session["AccountId"] = accountId; Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); var commonModel = proxy.GetAccount(Convert.ToInt32(accountId)); System.Web.HttpContext.Current.Session["AccountName"] = commonModel.FullName; return(View()); }
public static List <Rp3.Test.Mvc.Models.CategoryViewModel> GetCategories() { Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); List <Rp3.Test.Mvc.Models.CategoryViewModel> categories = proxy.GetCategories(). Select(p => new Models.CategoryViewModel() { Active = p.Active, CategoryId = p.CategoryId, Name = p.Name }).ToList(); return(categories); }
/// <summary> /// Obtenemos la lista de personas ordenadas por orden alfabético /// </summary> /// <returns>Listado de personas</returns> private List <Models.PersonViewModel> GetAllPersons() { Proxies.Proxy proxy = new Proxies.Proxy(); List <Models.PersonViewModel> persons = proxy.GetPersons(). Select(p => new Models.PersonViewModel() { Active = p.Active, PersonId = p.PersonId, Name = p.Name }).ToList(); return(persons.OrderBy(X => X.Name).ToList()); }
public ActionResult Edit(int categoryId) { Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); Rp3.Test.Mvc.Models.CategoryEditModel editModel = new Models.CategoryEditModel(); var commonModel = proxy.GetCategory(categoryId); editModel.Active = commonModel.Active; editModel.CategoryId = commonModel.CategoryId; editModel.Name = commonModel.Name; return(View(editModel)); }
public ActionResult Edit(int?id) { Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); Rp3.Test.Mvc.Models.UserEditModel editModel = new Models.UserEditModel(); var commonModel = proxy.GetUserById(id); editModel.PersonName = commonModel.PersonName; editModel.AccountNumber = commonModel.AccountNumber; editModel.UserId = commonModel.UserId; editModel.RegisterDate = commonModel.RegisterDate; return(View(editModel)); }
private List <Models.PersonViewModel> GetAllPersons() { Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); List <Rp3.Test.Mvc.Models.PersonViewModel> persons = proxy.GetPersons(). Select(p => new Models.PersonViewModel() { Active = p.Active, PersonId = p.PersonId, Identification = p.Identification, Name = p.Name }).ToList(); return(persons.OrderBy(P => P.Name).ToList()); }
public ActionResult Edit(Rp3.Test.Mvc.Models.TransactionEditModel editModel) { Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); int accountId = Convert.ToInt32(System.Web.HttpContext.Current.Session["AccountId"]); List <TransactionType> transactionTypeList = proxy.GetTransactionTypes(); List <SelectListItem> transactionTypeItems = transactionTypeList.Select(x => GetTransactionTypeItem(x)).ToList(); editModel.TransactionTypeSelectList = new SelectList(transactionTypeItems, "Value", "Text", 1); List <Category> categoryList = proxy.GetCategories(); List <SelectListItem> categoryItems = categoryList.Select(x => GetCategoryItem(x)).ToList(); editModel.CategorySelectList = new SelectList(categoryItems, "Value", "Text", 1); if (editModel.Amount <= 0) { ModelState.AddModelError("Amount", "El monto debe ser mayor a cero"); } if (!ModelState.IsValid) { return(View(editModel)); } Rp3.Test.Common.Models.Transaction commonModel = new Common.Models.Transaction(); commonModel.TransactionId = editModel.TransactionId; commonModel.TransactionTypeId = editModel.TransactionTypeId; commonModel.CategoryId = editModel.CategoryId; commonModel.AccountId = accountId; commonModel.Amount = editModel.Amount; commonModel.ShortDescription = editModel.ShortDescription; commonModel.Notes = editModel.Notes; bool respondeOk = proxy.UpdateTransaction(commonModel); if (respondeOk) { return(RedirectToAction("Index")); } else { return(View(editModel)); } }
public static List <Common.Models.TransactionType> GetTransactionTypes() { Proxies.Proxy proxy = new Proxies.Proxy(); List <Common.Models.TransactionType> model = new List <Common.Models.TransactionType>(); if (PersonController.PersonId != null) { var data = proxy.GetTransactionTypes(); foreach (var item in data) { model.Add(new Common.Models.TransactionType() { Name = item.Name, TransactionTypeId = item.TransactionTypeId }); } } return(model.OrderBy(X => X.Name).ToList()); }
public ActionResult Balance() { Proxies.Proxy proxy = new Proxies.Proxy(); int accountId = Convert.ToInt32(System.Web.HttpContext.Current.Session["AccountId"]); var data = proxy.GetTransactionsBalance(accountId, DateTime.Now.AddDays(-30).ToString(), DateTime.Now.ToString()); List <Rp3.Test.Mvc.Models.TransactionViewModel> model = new List <Models.TransactionViewModel>(); foreach (var item in data) { model.Add(new Models.TransactionViewModel() { Amount = item.Amount, CategoryName = item.CategoryName, TransactionTypeId = item.TransactionTypeId }); } return(View(model)); }
public ActionResult Create() { Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); Rp3.Test.Mvc.Models.TransactionCreateModel createModel = new Models.TransactionCreateModel(); List <TransactionType> transactionTypeList = proxy.GetTransactionTypes(); List <SelectListItem> transactionTypeItems = transactionTypeList.Select(x => GetTransactionTypeItem(x)).ToList(); createModel.TransactionTypeSelectList = new SelectList(transactionTypeItems, "Value", "Text", 1); List <Category> categoryList = proxy.GetCategories(); List <SelectListItem> categoryItems = categoryList.Select(x => GetCategoryItem(x)).ToList(); createModel.CategorySelectList = new SelectList(categoryItems, "Value", "Text", 1); createModel.Amount = 0; createModel.ShortDescription = ""; createModel.Notes = ""; return(View(createModel)); }
public ActionResult Index(Rp3.Test.Mvc.Models.TransactionEditModel model) { if (model != null) { Proxies.Proxy proxy = new Proxies.Proxy(); //Validamos si es para crear o actualizar if (model.TransactionId > 0) { //Actualizar proxy.UpdateTransaction(new Common.Models.Transaction() { TransactionId = model.TransactionId, TransactionTypeId = model.TransactionTypeId, Amount = model.Amount, CategoryId = model.CategoryId, Notes = model.Notes, RegisterDate = model.RegisterDate, ShortDescription = model.ShortDescription, PersonId = PersonController.PersonId.Value }); } else { //Crear proxy.InsertTransaction(new Common.Models.Transaction() { TransactionTypeId = model.TransactionTypeId, Amount = model.Amount, CategoryId = model.CategoryId, Notes = model.Notes, RegisterDate = model.RegisterDate, ShortDescription = model.ShortDescription, PersonId = PersonController.PersonId.Value }); } } return(Index()); }
public ActionResult Create(Rp3.Test.Mvc.Models.UserViewModel editModel) { Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); Rp3.Test.Common.Models.User commonModel = new Common.Models.User(); commonModel.PersonName = editModel.PersonName; commonModel.AccountNumber = editModel.AccountNumber; commonModel.RegisterDate = DateTime.Now; bool respondeOk = proxy.InsertUser(commonModel); if (respondeOk) { return(RedirectToAction("Index")); } else { return(View(editModel)); } }
public ActionResult Index() { Proxies.Proxy proxy = new Proxies.Proxy(); var data = proxy.GetUsers(); List <Rp3.Test.Mvc.Models.UserViewModel> model = new List <Models.UserViewModel>(); foreach (var item in data) { model.Add(new Models.UserViewModel() { PersonName = item.PersonName, AccountNumber = item.AccountNumber, RegisterDate = item.RegisterDate, UserId = item.UserId, DateUpdate = item.DateUpdate }); } return(View(model)); }
public ActionResult Login(Rp3.Test.Mvc.Models.UserViewModel user) { string message = string.Empty; if (user.UserName != null && user.Password != null) { Rp3.Test.Proxies.Proxy proxy = new Proxies.Proxy(); Rp3.Test.Common.Models.User commonModel = new Common.Models.User(); commonModel.UserName = user.UserName; commonModel.Password = user.Password; commonModel = proxy.LoginUser(commonModel); if (commonModel != null) { Session["UserId"] = commonModel.UserId.ToString(); Session["UserName"] = commonModel.UserName.ToString(); FormsAuthentication.SetAuthCookie(commonModel.UserName, true); if (!string.IsNullOrEmpty(Request.Form["ReturnUrl"])) { return(RedirectToAction(Request.Form["ReturnUrl"].Split('/')[2])); } else { return(RedirectToAction("Index", "Home")); } } else { message = "Username and/or password is incorrect."; } } else { message = "Username and/or password is incorrect."; } ViewBag.Message = message; return(View(user)); }
/// <summary> /// Permite eliminar un registro de transacción según su Id /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Delete(int id) { Proxies.Proxy proxy = new Proxies.Proxy(); proxy.DeleteTransaction(id); return(RedirectToAction("Index")); }