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"));
}
