public CouponRepoTest() { user = new ApplicationUser { Id = "aaaaa", Email = "*****@*****.**", UserName = "******" }; cv1 = new CouponValue { Id = 1, Value = 10 }; cv2 = new CouponValue { Id = 2, Value = 20 }; cv3 = new CouponValue { Id = 3, Value = 50 }; list.Add(new Coupon { Id = 1, Active = true, Code = "ASDFG12345", DateCreated = new DateTime(2017, 10, 10, 8, 23, 4), DateExpired = new DateTime(2017, 12, 10, 8, 23, 4), DateExchanged = new DateTime(2017, 11, 11, 8, 23, 4), Value = cv1, User = user }); list.Add(new Coupon { Id = 2, Active = true, Code = "12345ASDFG", DateCreated = new DateTime(2017, 10, 10, 8, 23, 4), DateExpired = new DateTime(2017, 12, 10, 8, 23, 4), DateExchanged = new DateTime(2017, 11, 11, 8, 23, 4), Value = cv1, User = user }); list.Add(new Coupon { Id = 3, Active = true, Code = "A1S2D3F4GU", DateCreated = new DateTime(2017, 10, 10, 8, 23, 4), DateExpired = new DateTime(2017, 12, 10, 8, 23, 4), DateExchanged = new DateTime(2017, 11, 11, 8, 23, 4), Value = cv2, User = user }); list.Add(new Coupon { Id = 4, Active = true, Code = "ASD123DFG3", DateCreated = new DateTime(2017, 10, 10, 8, 23, 4), DateExpired = new DateTime(2017, 12, 10, 8, 23, 4), DateExchanged = new DateTime(2017, 11, 11, 8, 23, 4), Value = cv2, User = user }); list.Add(new Coupon { Id = 5, Active = true, Code = "GFD54RFG67", DateCreated = new DateTime(2017, 10, 10, 8, 23, 4), DateExpired = new DateTime(2017, 12, 10, 8, 23, 4), DateExchanged = new DateTime(2017, 11, 11, 8, 23, 4), Value = cv3, User = user }); }
public void TestCreateCouponValue() { var cv = wheelService.CreateCouponValue(10, user.Id); var tmpcv = new CouponValue { Id = 1, Value = 5 }; Assert.True(cv.Id == tmpcv.Id); Assert.True(cv.Value == tmpcv.Value); }
public CouponValue CreateCouponValue(int value, string userId) { var user = _context.Users.First(x => x.Id == userId); if (user == null) { throw new Exception("User does not exist"); } var cv = new CouponValue { Value = value }; _context.CouponValues.Add(cv); _context.SaveChanges(); return(cv); }
protected override void Seed(WheelOfFortune.Models.ApplicationDbContext context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. E.g. // // context.People.AddOrUpdate( // p => p.FullName, // new Person { FullName = "Andrew Peters" }, // new Person { FullName = "Brice Lambson" }, // new Person { FullName = "Rowan Miller" } // ); // var wheelConfigs = context.WheelConfigurations.Count(); var wheelSlices = context.WheelConfigurationSlices.Count(); var couponValues = context.CouponValues.Count(); var coupons = context.Coupons.Count(); var cv1 = new CouponValue { Id = 1, Value = 5 }; var cv2 = new CouponValue { Id = 2, Value = 10 }; var cv3 = new CouponValue { Id = 3, Value = 20 }; var cv4 = new CouponValue { Id = 4, Value = 50 }; var adminUser = new ApplicationUser { Id = "e31a3b70-3a1b-4276-b1fa-d1f4eccfca47", Active = true, Email = "*****@*****.**", EmailConfirmed = true, PasswordHash = "AKmsfZCVv9M9CeftEEymCHGQy7T8tHTzrIXsH0jVEViPdx2ZQ9DMEA1DeIzC9Oj9/Q==", // 123456 SecurityStamp = "c2e1b386-46fa-4410-a6d1-dff9a720c22e", UserName = "******", UName = "admin", UserPhoto = new byte[10] }; var wheelConfig1 = new WheelConfiguration { Id = 1, User = adminUser, DateCreated = DateTime.Now }; var wheelConfig2 = new WheelConfiguration { Id = 2, DateCreated = DateTime.Now, User = adminUser }; var slice1 = new WheelConfigurationSlice { Id = 1, Propability = 25, Win = true, Type = "string", Value = "Win x2", ResultText = "Yoo-hoo!", Score = 2, User = adminUser, WheelConfiguration = wheelConfig1 }; var slice2 = new WheelConfigurationSlice { Id = 2, Propability = 25, Win = true, Type = "string", Value = "Win x1.5", ResultText = "Yoo-hoo!", Score = 1.5, User = adminUser, WheelConfiguration = wheelConfig1 }; var slice3 = new WheelConfigurationSlice { Id = 3, Propability = 25, Win = false, Type = "string", Value = "Lose x2", ResultText = "Oops!", Score = -2, User = adminUser, WheelConfiguration = wheelConfig1 }; var slice4 = new WheelConfigurationSlice { Id = 4, Propability = 25, Win = false, Type = "string", Value = "Lose x1.5", ResultText = "Oops!", Score = -1.5, User = adminUser, WheelConfiguration = wheelConfig1 }; var slice5 = new WheelConfigurationSlice { Id = 5, Propability = 10, Win = true, Type = "string", Value = "Win x2", ResultText = "Yoo-hoo!", Score = 2, User = adminUser, WheelConfiguration = wheelConfig2 }; var slice6 = new WheelConfigurationSlice { Id = 6, Propability = 10, Win = true, Type = "string", Value = "Win x1.5", ResultText = "Yoo-hoo!", Score = 1.5, User = adminUser, WheelConfiguration = wheelConfig2 }; var slice7 = new WheelConfigurationSlice { Id = 7, Propability = 10, Win = false, Type = "string", Value = "Lose x2", ResultText = "Oops!", Score = -2, User = adminUser, WheelConfiguration = wheelConfig2 }; var slice8 = new WheelConfigurationSlice { Id = 8, Propability = 10, Win = false, Type = "string", Value = "Lose x1.5", ResultText = "Oops!", Score = -1.5, User = adminUser, WheelConfiguration = wheelConfig2 }; var slice9 = new WheelConfigurationSlice { Id = 9, Propability = 10, Win = false, Type = "string", Value = "Lose x0.5", ResultText = "Oops!", Score = -0.5, User = adminUser, WheelConfiguration = wheelConfig2 }; var slice10 = new WheelConfigurationSlice { Id = 10, Propability = 10, Win = false, Type = "string", Value = "Lose xgit2.5", ResultText = "Oops!", Score = -2.5, User = adminUser, WheelConfiguration = wheelConfig2 }; var slice11 = new WheelConfigurationSlice { Id = 11, Propability = 10, Win = true, Type = "string", Value = "Win x2.5", ResultText = "Yoo-hoo!", Score = 2.5, User = adminUser, WheelConfiguration = wheelConfig2 }; var slice12 = new WheelConfigurationSlice { Id = 12, Propability = 10, Win = true, Type = "string", Value = "Win x0.5", ResultText = "Yoo-hoo!", Score = 0.5, User = adminUser, WheelConfiguration = wheelConfig2 }; var slice13 = new WheelConfigurationSlice { Id = 13, Propability = 10, Win = false, Type = "string", Value = "Lose x3", ResultText = "Oops!", Score = -3, User = adminUser, WheelConfiguration = wheelConfig2 }; var slice14 = new WheelConfigurationSlice { Id = 14, Propability = 10, Win = true, Type = "string", Value = "Win x4", ResultText = "Yoo-hoo!", Score = 4, User = adminUser, WheelConfiguration = wheelConfig2 }; var coupon1 = new Coupon { Id = 1, Code = "WUY57QM1N3", Value = cv1, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon2 = new Coupon { Id = 2, Code = "25D9O94QMR", Value = cv1, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon3 = new Coupon { Id = 3, Code = "LIHUU6JKA2", Value = cv1, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon4 = new Coupon { Id = 4, Code = "8TCRCEHHG0", Value = cv1, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon5 = new Coupon { Id = 5, Code = "U3A1OM7610", Value = cv1, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon6 = new Coupon { Id = 6, Code = "KBZ9TSYK1K", Value = cv2, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon7 = new Coupon { Id = 7, Code = "CPWI6JF5GO", Value = cv2, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon8 = new Coupon { Id = 8, Code = "VIKGA3OGPP", Value = cv2, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon9 = new Coupon { Id = 9, Code = "4APAKZUIO9", Value = cv2, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon10 = new Coupon { Id = 10, Code = "1ARMMXQPTR", Value = cv2, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon11 = new Coupon { Id = 11, Code = "RJQU9LDIXT", Value = cv3, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon12 = new Coupon { Id = 12, Code = "RMHFZAVGCM", Value = cv3, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon13 = new Coupon { Id = 13, Code = "Y4F4DKT9JS", Value = cv3, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon14 = new Coupon { Id = 14, Code = "OG7PVPSDNJ", Value = cv3, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon15 = new Coupon { Id = 15, Code = "WYT0HHQ2PE", Value = cv3, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon16 = new Coupon { Id = 16, Code = "UXLCMGB7K9", Value = cv4, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon17 = new Coupon { Id = 17, Code = "LGZ3DTP6MB", Value = cv4, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon18 = new Coupon { Id = 18, Code = "OJN851B8W5", Value = cv4, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon19 = new Coupon { Id = 19, Code = "A4QOWRKQJK", Value = cv4, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; var coupon20 = new Coupon { Id = 20, Code = "MQ4ETIIL6A", Value = cv4, DateCreated = new DateTime(2017, 11, 17, 10, 10, 10), DateExpired = new DateTime(2017, 11, 27, 10, 10, 10), DateExchanged = new DateTime(2017, 11, 17, 10, 10, 10), Active = true, User = adminUser }; if (!context.Users.Select(x => x.Id).Contains(adminUser.Id)) { context.Users.Add(adminUser); context.Balances.Add( new Balance { Id = 1, BalanceValue = 100, User = adminUser }); var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context)); var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context)); if (!roleManager.RoleExists("Admin")) { var role = new Microsoft.AspNet.Identity.EntityFramework.IdentityRole(); role.Name = "Admin"; roleManager.Create(role); UserManager.AddToRole(adminUser.Id, "Admin"); } } if (wheelConfigs == 0) { context.WheelConfigurations.Add(wheelConfig1); context.WheelConfigurations.Add(wheelConfig2); } if (wheelSlices == 0) { context.WheelConfigurationSlices.Add(slice1); context.WheelConfigurationSlices.Add(slice2); context.WheelConfigurationSlices.Add(slice3); context.WheelConfigurationSlices.Add(slice4); context.WheelConfigurationSlices.Add(slice5); context.WheelConfigurationSlices.Add(slice6); context.WheelConfigurationSlices.Add(slice7); context.WheelConfigurationSlices.Add(slice8); context.WheelConfigurationSlices.Add(slice9); context.WheelConfigurationSlices.Add(slice10); context.WheelConfigurationSlices.Add(slice11); context.WheelConfigurationSlices.Add(slice12); context.WheelConfigurationSlices.Add(slice13); context.WheelConfigurationSlices.Add(slice14); } if (couponValues == 0) { context.CouponValues.Add(cv1); context.CouponValues.Add(cv2); context.CouponValues.Add(cv3); context.CouponValues.Add(cv4); } if (coupons == 0) { context.Coupons.Add(coupon1); context.Coupons.Add(coupon2); context.Coupons.Add(coupon3); context.Coupons.Add(coupon4); context.Coupons.Add(coupon5); context.Coupons.Add(coupon6); context.Coupons.Add(coupon7); context.Coupons.Add(coupon8); context.Coupons.Add(coupon9); context.Coupons.Add(coupon10); context.Coupons.Add(coupon11); context.Coupons.Add(coupon12); context.Coupons.Add(coupon13); context.Coupons.Add(coupon14); context.Coupons.Add(coupon15); context.Coupons.Add(coupon16); context.Coupons.Add(coupon17); context.Coupons.Add(coupon18); context.Coupons.Add(coupon19); context.Coupons.Add(coupon20); } }
public IHttpActionResult GetCouponValue(CouponValue coupon) { try { MySqlCommand cmd = new MySqlCommand(); sqlConn.Open(); cmd.Connection = sqlConn; cmd.CommandText = "spo_Get_Coupon_Value"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CouponName", coupon.CouponName); cmd.Parameters["@CouponName"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("@Mobile", coupon.Mobile); cmd.Parameters["@Mobile"].Direction = ParameterDirection.Input; using (var cursor = cmd.ExecuteReader()) { if (cursor.Read()) { var value = cursor[0]; if (decimal.TryParse(value.ToString(), out decimal dval)) { var modules = cursor[1]; sqlConn.Close(); return(Ok(new WebResponse { code = (int)HttpStatusCode.OK, status = "Ok", message = "Success", data = string.Format("{0}:{1}", value, modules), error = false })); } else { sqlConn.Close(); return(Ok(new WebResponse { code = (int)HttpStatusCode.BadRequest, status = "Not_Ok", message = "Error", data = value, error = true })); } } else { sqlConn.Close(); return(Ok(new WebResponse { code = (int)HttpStatusCode.BadRequest, status = "Not_Ok", message = "Error", data = "Coupon is not vaild!", error = true })); } } } catch (Exception ex) { return(Ok(new WebResponse { code = (int)HttpStatusCode.InternalServerError, status = "Not_Ok", message = "Error", data = ex.Message, error = true })); } }