public InvestmentProduct GetById(int Id) { DynamicParameters spParams = new DynamicParameters(); spParams.Add("Id", Id); return((InvestmentProduct)DapperORM.ReturnSingle <InvestmentProduct>("GetProduct", spParams)); }
public InvestmentCycle GetById(int Id) { DynamicParameters spParams = new DynamicParameters(); spParams.Add("Id", Id); return((InvestmentCycle)DapperORM.ReturnSingle <InvestmentCycle>("GetInvestmentCycle", spParams)); }
public User GetById(int Id) { DynamicParameters spParams = new DynamicParameters(); spParams.Add("Id", Id); return((User)DapperORM.ReturnSingle <User>("GetUser", spParams)); }
public void Delete(int Id, User user) { DynamicParameters spParams = new DynamicParameters(); spParams.Add("Id", Id); spParams.Add("UserId", user.Id); DapperORM.ExecuteWithoutReturn("DeleteProduct", spParams); }
public void AddEdit(InvestmentCategory investmentCategory, User user) { DynamicParameters spParams = new DynamicParameters(); spParams.Add("Id", investmentCategory.Id); spParams.Add("Name", investmentCategory.Name); spParams.Add("Description", investmentCategory.Description); spParams.Add("UserId", user.Id); DapperORM.ExecuteWithoutReturn("AddEditProductCategory", spParams); }
public void AddEdit(User theUser) { DynamicParameters spParams = new DynamicParameters(); spParams.Add("Id", theUser.Id); spParams.Add("UserName", theUser.UserName); spParams.Add("FirstName", theUser.FirstName); spParams.Add("MiddleName", theUser.MiddleName); spParams.Add("Surname", theUser.Surname); DapperORM.ExecuteWithoutReturn("AddEditUser", spParams); }
public void AddEdit(InvestmentCycle investmentCycle, User user) { DynamicParameters spParams = new DynamicParameters(); spParams.Add("Id", investmentCycle.Id); spParams.Add("FromDate", investmentCycle.FromDate); spParams.Add("ProductId", investmentCycle.ProductId); spParams.Add("TargetAmount", investmentCycle.TargetAmount); spParams.Add("MinimumAmount", investmentCycle.MinimumAmount); spParams.Add("MaximumAmount", investmentCycle.MaximumAmount); spParams.Add("UserId", user.Id); DapperORM.ExecuteWithoutReturn("AddEditInvestmentCycle", spParams); }
public List <InvestmentProductManagerViewModel> GetAll() { List <InvestmentProductManagerViewModel> var = (List <InvestmentProductManagerViewModel>)DapperORM.ReturnList <InvestmentProductManagerViewModel>("GetProducts"); foreach (InvestmentProductManagerViewModel prod in var) { prod.InvestmentCategory = new InvestmentCategory { Id = prod.ProductCategoryId, Name = prod.ProductCategoryName, Description = prod.ProductCategoryName }; } return(var); }
public List <User> GetAll() { return((List <User>)DapperORM.ReturnList <User>("GetProducts")); }
public List <InvestmentCategoryManagerViewModel> GetAll() { return((List <InvestmentCategoryManagerViewModel>)DapperORM.ReturnList <InvestmentCategoryManagerViewModel>("GetProductCategories")); }
public List <InvestmentCycleManagerViewModel> GetAll() { return((List <InvestmentCycleManagerViewModel>)DapperORM.ReturnList <InvestmentCycleManagerViewModel>("GetInvestmentCycles")); }