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