public override int deleteUser(BaseUserModel baseUser) { PromoUserModel user = (PromoUserModel)baseUser; int affectedRows = factory.Query(ASSOCIATED_TABLE_NAME).Where("id", "=", user.id).Delete(); return(affectedRows); }
public PromoUserModel getUserByPhoneNumber(string phoneNumber) { PromoUserModel userByPhoneNumber = factory. Query("PromoUsers"). Select("*"). Where("cellPhoneNumber", "=", phoneNumber). FirstOrDefault <PromoUserModel>(); return(userByPhoneNumber); }
public PromoUserModel findUserById(int userId) { PromoUserModel userById = factory. Query(ASSOCIATED_TABLE_NAME). Select("*"). Where("id", "=", userId). FirstOrDefault <PromoUserModel>(); return(userById); }
public PromoUserModel getUsersBetweenDates(DateTime minDate, DateTime maxDate) { PromoUserModel usersBetweenDates = factory. Query("PromoUsers"). Select("*"). Where("entryDate", ">=", minDate). Where("entryDate", "<=", maxDate). OrderBy("entryDate"). FirstOrDefault <PromoUserModel>(); return(usersBetweenDates); }
public override int updateUser(BaseUserModel baseUser) { PromoUserModel user = (PromoUserModel)baseUser; int affectedRows = factory.Query(ASSOCIATED_TABLE_NAME).Where("id", "=", user.id).Update(new { firstName = user.firstName, lastName = user.lastName, cellPhoneNumber = user.cellPhoneNumber, typeOfPromo = user.typeOfPromo, entryDate = user.entryDate }); return(affectedRows); }
public override int insertUser(BaseUserModel baseUser) { PromoUserModel user = (PromoUserModel)baseUser; int affectedRows = factory.Query(ASSOCIATED_TABLE_NAME).Insert(new { user.firstName, user.lastName, user.cellPhoneNumber, user.typeOfPromo, user.entryDate }); return(affectedRows); }
public ActionResult EditUser(int userId) { ActionResult resultView; PromoUserModel userToEdit = promoManager.findUserById(userId); if (userToEdit != null) { resultView = View(userToEdit); } else { resultView = RedirectToAction("ShowOptions"); } return(resultView); }
public ActionResult EditUser(PromoUserModel user) { promoManager.doDataBaseOperation(promoManager.updateUser, user); return(RedirectToAction("ShowOptions")); }