public PartialViewResult Count(FormCollection form) { string MemberSubscriptionTypeid = form["MemberSubscriptionType"].ToString().Trim(); string AgeGroups = form["AgeGroup"].ToString(); string Countryid = form["Country"].ToString().Trim(); string Stateid = string.IsNullOrEmpty(form["State"])? string.Empty : form["State"].ToString().Trim(); string Ethnicity = form["Ethnicity"].ToString(); string Gender = form["Gender"].ToString(); var Predicates = ""; if (!string.IsNullOrEmpty(MemberSubscriptionTypeid)) { Predicates += " AND MemberSubscriptionTypeid >= " + MemberSubscriptionTypeid + ""; } if (!string.IsNullOrEmpty(AgeGroups)) { string[] Ages = AgeGroups.Split('-'); int Left = Convert.ToInt32(Ages[0]); int Right = Convert.ToInt32(Ages[1]); var leftLimit = (DateTime.Now.AddYears(-Right)).Date; var RightLimit = (DateTime.Now.AddYears(-Left)).Date; Predicates += " AND DateOfBirth Between '" + leftLimit.ToString("yyyy-MM-dd") + "' AND '" + RightLimit.ToString("yyyy-MM-dd") + "'"; } if (!Countryid.Equals("0")) { Predicates += " AND Countryid = " + Convert.ToInt32(Countryid); } if (!string.IsNullOrEmpty(Stateid) && !Stateid.Equals("0")) { Predicates += " AND StateID in ( " + (Stateid) + ")"; } if (!string.IsNullOrEmpty(Ethnicity)) { Predicates += " AND Ethnicity = '" + Ethnicity + "'"; } if (!string.IsNullOrEmpty(Gender)) { Predicates += " AND Gender = '" + Gender + "'"; } //TODO select count var SQL = "SELECT * FROM MEMBER WHERE 1=1 " + Predicates.ToString(); using (var context = new VaultLifeApplicationEntities()) { var MembersCount = context.Members.SqlQuery(SQL).ToList(); ViewBag.number = MembersCount.Count(); } return(PartialView("_MemberCount")); }
public GameEntity(VaultLifeApplicationEntities db, IScheduler scheduler, Game game) { this.scheduler = scheduler; this.db = db; this.rules = new List <IRule>(); this.game = game; // ProductInGame prod = game.ProductInGames.First(); this.numWinnersLeft = game.NumberOfWinners; //prod.Quantity; switch (game.GameState) { case "ACTIVE": this.state = GameState.ACTIVE; break; case "READY": this.state = GameState.READY; break; case "CREATED": this.state = GameState.CREATED; break; case "COMPLETED": this.state = GameState.COMPLETED; break; case "RELEASED": this.state = GameState.RELEASED; break; case "PREPARE": this.state = GameState.PREPARE_ACTIVE; break; } }
public FCFGame(VaultLifeApplicationEntities db, IScheduler scheduler, Game game) : base(db, scheduler, game) { if (!game.GameType.GameTypeName.Equals("FCF")) { throw new InvalidOperationException(); } }
//TODO what does applicationUserManager do ? public AccountService(VaultLifeApplicationEntities db, ApplicationUserManager userManager) { this.db = db; this.memberDao = new MemberDao(db); this.memberSubTypeDao = new MembershipSubscriptionTypeDao(db); this.userManager = userManager; }
public GameEntity(VaultLifeApplicationEntities db, IScheduler scheduler, int numWinners) { state = GameState.CREATED; this.db = db; this.scheduler = scheduler; // StdSchedulerFactory.GetDefaultScheduler(); this.rules = new List <IRule>(); this.numWinnersLeft = numWinners; this.game = new Game(); switch (game.GameState) { case "ACTIVE": this.state = GameState.ACTIVE; break; case "READY": this.state = GameState.READY; break; case "CREATED": this.state = GameState.CREATED; break; case "COMPLETED": this.state = GameState.COMPLETED; break; case "RELEASED": this.state = GameState.RELEASED; break; case "PREPARE": this.state = GameState.PREPARE_ACTIVE; break; } }
public FFFGame(VaultLifeApplicationEntities db, IScheduler scheduler, Game game) : base(db, scheduler, game) { // if (!game.GameType.GameTypeName.Equals("FastestFinger")) // { // throw new InvalidOperationException(); // } }
public static Member GetLoggedInMember(string UserName, VaultLifeApplicationEntities db) { var members = db.Members.Include(x => x.MemberSubscriptionType).Where(s => s.EmailAddress == UserName); if (members != null && members.Count() > 0) { return(members.First()); } return(null); }
public static GameEntity toGameEntity(VaultLifeApplicationEntities db, IScheduler scheduler, Game game) { switch (game.GameType.GameTypeName) { case "FastestFinger": return(new FFFGame(db, scheduler, game)); case "FCF": return(new FCFGame(db, scheduler, game)); } throw new NotImplementedException(); }
public ActionResult Pay([Bind(Include = "type")] int?type) { int ty = type == null ? 1 : (int)type; UpgradePaymentViewModel model = new UpgradePaymentViewModel(); VaultLifeApplicationEntities db = new VaultLifeApplicationEntities(); MembershipSubscriptionTypeDao dao = new MembershipSubscriptionTypeDao(db); MemberSubscriptionType mst = dao.findAll().Where(t => t.MemberSubscriptionTypeID == ty).First(); model.MembershipSubscriptionType = ty; model.amount = mst.amount.ToString("#######");; model.MembershipSubscriptionCode = mst.MemberSubscriptionTypeCode; return(View("Pay", model)); }
public ActionResult Index(int imageId) { VaultLifeApplicationEntities db = new VaultLifeApplicationEntities(); //This is my method for getting the image information // including the image byte array from the image column in // a database. Imagedetail image = db.Imagedetails.Where(x => x.ImageID == imageId).First(); //As you can see the use is stupid simple. Just get the image bytes and the // saved content type. See this is where the contentType comes in real handy. ImageResult result = new ImageResult(image.ImageContent, image.ContentType); return(result); }
private bool UniqueName(Product product, string name) { VaultLifeApplicationEntities _db = new VaultLifeApplicationEntities(); var dbProduct = _db.Products .Where(x => x.ProductSKUCode.ToLower() == name.ToLower()) .FirstOrDefault(); if (dbProduct == null) { return(true); } return(dbProduct.ProductID == product.ProductID); }
private bool AvailableSOHCheck(ProductInGame productInGame, int newQuantity) { VaultLifeApplicationEntities _db = new VaultLifeApplicationEntities(); var dbProduct = _db.Products .Where(x => x.ProductID == productInGame.ProductID) .SingleOrDefault(); if (dbProduct == null) { return(false); } return((dbProduct.AvailableSOH - newQuantity) >= 0); }
private bool Unique(Voucher v, string vnum) { VaultLifeApplicationEntities _db = new VaultLifeApplicationEntities(); var dbVoucher = _db.Vouchers .Where(x => x.VoucherNumber.ToLower() == vnum.ToLower()) .SingleOrDefault(); if (dbVoucher == null) { return(true); } return(dbVoucher.VoucherID == v.VoucherID); }
private bool UniqueName(Member member, string name) { VaultLifeApplicationEntities _db = new VaultLifeApplicationEntities(); var dbMember = _db.Members .Where(x => x.EmailAddress.ToLower() == name.ToLower()) .SingleOrDefault(); if (dbMember == null) { return(true); } return(dbMember.MemberID == member.MemberID); }
private bool Unique(SerialNumber sn, string snum) { VaultLifeApplicationEntities _db = new VaultLifeApplicationEntities(); var dbSerial = _db.SerialNumbers .Where(x => x.Serial.ToLower() == snum.ToLower()) .SingleOrDefault(); if (dbSerial == null) { return(true); } return(dbSerial.SerialNumberID == sn.SerialNumberID); }
public IJob NewJob(TriggerFiredBundle bundle, IScheduler scheduler) { if (bundle.JobDetail.JobType == typeof(EmailSendingJob)) { return(new EmailSendingJob()); } VaultLifeApplicationEntities db = new VaultLifeApplicationEntities(); JobDataMap map = bundle.JobDetail.JobDataMap; Game game = db.Games.Find(Convert.ToInt32(map["gameId"])); DateTimeOffset executeTime = DateTimeOffset.Parse((String)map["executeTime"]); GameRule gameRule; switch (map.GetString("ruleType")) { case "NOTIFY_PARTICIPANTS": gameRule = game.GameRules.First(g => g.GameRuleCode.Equals("NotifiyGameParticipants")); return(new NotifyGameParticipantsRule(gameRule, GameEntity.toGameEntity(db, scheduler, game))); case "START_GAME": gameRule = game.GameRules.First(g => g.GameRuleCode.Equals("StartGame")); return(new StartGameRule(gameRule, GameEntity.toGameEntity(db, scheduler, game))); case "PREPARE_GAME": gameRule = game.GameRules.First(g => g.GameRuleCode.Equals("PrepareGameRule")); return(new PrepareGameRule(gameRule, GameEntity.toGameEntity(db, scheduler, game))); case "RESOLVE_WINNERS": gameRule = game.GameRules.First(g => g.GameRuleCode.Equals("ResolvePotentialWinners")); return(new ResolvePotentialWinners(gameRule, GameEntity.toGameEntity(db, scheduler, game))); case "RESOLVE_ACTUAL_WINNERS": gameRule = game.GameRules.First(g => g.GameRuleCode.Equals("ResolveActualWinners")); return(new ResolveActualWinners(gameRule, GameEntity.toGameEntity(db, scheduler, game))); case "START_NEW_GAME": gameRule = game.GameRules.First(g => g.GameRuleCode.Equals("StartNewGame")); return(new StartNewGameRule(gameRule, GameEntity.toGameEntity(db, scheduler, game), GameEntity.toGameEntity(db, scheduler, db.Games.Find(map["newGameId"])))); } throw new NotImplementedException(); }
private bool HaveOneLocation(ProductInGame product, int ProductInGameID) { VaultLifeApplicationEntities _db = new VaultLifeApplicationEntities(); var dbProductInGame = _db.ProductInGames.Include(a => a.ProductLocations).Where(x => x.ProductInGameID == ProductInGameID).SingleOrDefault(); if (dbProductInGame == null) { return(false); } if (dbProductInGame.ProductLocations == null) { return(false); } if (dbProductInGame.ProductLocations.Count <= 0) { return(false); } return(true); }
public ActionResult Pay([Bind(Include = "MembershipSubscriptionType,PaymentsModel")] UpgradePaymentViewModel paymentViewModel) { Vaultlife.Service.PaymentService paymentService = new Vaultlife.Service.PaymentService(new VaultLifeApplicationEntities()); string custIp = Request.ServerVariables["REMOTE_ADDR"]; bool success = paymentService.pay(paymentViewModel.PaymentsModel, paymentViewModel.MembershipSubscriptionType, User.Identity.Name, this.GetIPAddress(), custIp); if (success) { return(Redirect("/?l=" + paymentViewModel.MembershipSubscriptionType)); } else { ModelState.AddModelError("ErrorMessage", "There was an error processing your payment"); // MemberSubscriptionTypeCode and Amount not included in POST, use MembershipSubscriptionType to do lookup and populate paymentViewModel VaultLifeApplicationEntities db = new VaultLifeApplicationEntities(); MembershipSubscriptionTypeDao dao = new MembershipSubscriptionTypeDao(db); MemberSubscriptionType mst = dao.findAll().Where(t => t.MemberSubscriptionTypeID == paymentViewModel.MembershipSubscriptionType).First(); paymentViewModel.amount = mst.amount.ToString("#######");; paymentViewModel.MembershipSubscriptionCode = mst.MemberSubscriptionTypeCode; return(View("Pay", paymentViewModel)); } }
//TODO what does applicationUserManager do ? public AccountService(VaultLifeApplicationEntities db) { this.db = db; this.memberDao = new MemberDao(db); this.memberSubTypeDao = new MembershipSubscriptionTypeDao(db); }
public RestartGameRule(Game game, VaultLifeApplicationEntities db) { this.game = game; this.db = db; }
public UserService(VaultLifeApplicationEntities db, ApplicationUserManager userManager) { this.userManager = userManager; this.db = db; }
public GameDao(VaultLifeApplicationEntities db) { this.db = db; }
public TransactionDao(VaultLifeApplicationEntities db) { this.db = db; }
public AddressService(VaultLifeApplicationEntities db) { this.db = db; }
public GameService(VaultLifeApplicationEntities db) { this.db = db; }
public MemberDao(VaultLifeApplicationEntities dbEntities) { this.db = dbEntities; }
public MembershipSubscriptionTypeDao(VaultLifeApplicationEntities dbEntities) { this.db = dbEntities; }
public PartialViewResult Insert(FormCollection form) { string Gameid = form["Game"].ToString(); string MemberSubscriptionTypeid = form["MemberSubscriptionType"].ToString().Trim(); string AgeGroups = form["AgeGroup"].ToString(); string Countryid = form["Country"].ToString().Trim(); string Stateid = string.IsNullOrEmpty(form["State"]) ? string.Empty : form["State"].ToString().Trim(); string Ethnicity = form["Ethnicity"].ToString(); string Gender = form["Gender"].ToString(); var Predicates = ""; if (!string.IsNullOrEmpty(MemberSubscriptionTypeid)) { Predicates += "AND MemberSubscriptionTypeid >= " + MemberSubscriptionTypeid + ""; ///TODO hmmm wrong.... } if (!string.IsNullOrEmpty(AgeGroups)) { string[] Ages = AgeGroups.Split('-'); int Left = Convert.ToInt32(Ages[0]); int Right = Convert.ToInt32(Ages[1]); var leftLimit = (DateTime.Now.AddYears(-Right)).Date; var RightLimit = (DateTime.Now.AddYears(-Left)).Date; Predicates += " AND DateOfBirth Between '" + leftLimit.ToString("yyyy-MM-dd") + "' AND '" + RightLimit.ToString("yyyy-MM-dd") + "'"; } if (!Countryid.Equals("0")) { Predicates += " AND Countryid = " + Convert.ToInt32(Countryid); } if (!string.IsNullOrEmpty(Stateid) && !Stateid.Equals("0")) { Predicates += " AND StateID in ( " + (Stateid) + ")"; } if (!string.IsNullOrEmpty(Ethnicity)) { Predicates += " AND Ethnicity = '" + Ethnicity + "'"; } if (!string.IsNullOrEmpty(Gender)) { Predicates += " AND Gender = '" + Gender + "'"; } var SQL = " DELETE FROM MEMBERINGAME WHERE GAMEID = " + Gameid + "; INSERT INTO MEMBERINGAME (GameId,MemberID,CountryID,StateID,CityID,MemberSubscriptionTypeID,DateInserted,DateUpdated,USR,Winindicator,PaymentIndicator) SELECT " + Gameid + ", MemberId , Countryid,Stateid,0, MemberSubscriptionTypeid,'" + DateTime.Now + "','" + DateTime.Now + "','USR' ,0,0 FROM MEMBER WHERE 1=1" + Predicates.ToString(); using (var context = new VaultLifeApplicationEntities()) { var noOfRowInserted = context.Database.ExecuteSqlCommand(SQL); ViewBag.number = noOfRowInserted; } if (Countryid.Equals("0")) { int id = Convert.ToInt32(Gameid); Game game = db.Games.Where(g => g.GameID == id).First(); game.Global = true; db.SaveChanges(); } return(PartialView("_MemberInGameSuccess")); }
public PaymentService(VaultLifeApplicationEntities dbEntities) { this.db = dbEntities; this.memberDao = new MemberDao(db); this.subscriptionTypeDao = new MembershipSubscriptionTypeDao(db); }