public JsonResult GetDataById(int id) { string msg = ""; string modelDate = ""; DevTest model = new DevTest(); try { using (DevTestContext context = new DevTestContext()) { model = context.DevTests.FirstOrDefault(d => d.ID == id); modelDate = Convert.ToDateTime(model.Date).ToShortDateString(); } } catch (Exception cc) { msg = "Error Occur"; } var jsonresult = new { msg = msg, Result = model, modelDate = modelDate }; return(Json(jsonresult, JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteData(int id) { string msg = ""; try { using (DevTestContext context = new DevTestContext()) { var data = context.DevTests.FirstOrDefault(d => d.ID == id); context.DevTests.Remove(data); context.SaveChanges(); msg = "Data Deleted Successfully.."; } DevTestHub.NotifyCurrentDevInformationToAllClients(); } catch (Exception cc) { msg = "Error Occur"; } var jsonresult = new { msg = msg }; return(Json(jsonresult)); }
public void Get_TestClassObjectPassed_ProperMethodCalled() { var options = new DbContextOptionsBuilder <DevTestContext>().UseInMemoryDatabase(databaseName: "Payments Test") .Options; using (var context = new DevTestContext(options)) { context.Payment.Add(new Payment { ID = 1, Amount = 100, PaymentDate = System.DateTime.Now, AccountID = 2 }); context.SaveChanges(); } using (var context = new DevTestContext(options)) { //Arrange var repo = new Repository <Payment>(context); //method var payment = repo.GetById(x => x.ID == 1); Assert.Equal(1, payment.ID); } }
public void InitDatabase_WithSeed_AsDropCreateDatabaseIfModelChangesWithSeed_Test() { DatabaseInitializer.SeedActions.Add(new TestSeedAction()); DatabaseInitializer.Initialize(new DropCreateDatabaseIfModelChangesWithSeed <DevTestContext>()); using (var context = new DevTestContext()) { Assert.IsTrue(context.Database.Exists()); } }
public void InitDatabase_WithSeed_AsCreateDatabaseIfNotExistsWithSeed_Test() { DatabaseInitializer.SeedActions.Add(new TestSeedAction()); DatabaseInitializer.Initialize(new CreateDatabaseIfNotExistsWithSeed <DevTestContext>()); using (var context = new DevTestContext()) { Assert.IsTrue(context.Database.Exists()); Assert.IsTrue(4 == context.ReadonlyQuery <Order>().Count()); } }
public void InitDatabase_WithSeed_AsMigrateDatabaseToLatestVersion_Test() { using (var context = new DevTestContext()) { context.Database.Delete(); DatabaseInitializer.SeedActions.Add(new TestSeedAction()); DatabaseInitializer.Initialize(new MigrateDatabaseToLatestVersion <DevTestContext, MigrationsConfigurationWithSeed <DevTestContext> >()); Assert.IsTrue(context.Database.Exists()); } }
public void InitDatabaseTest() { var dir = AppDomain.CurrentDomain.GetData("DataDirectory"); var initializer = new DropCreateDatabaseAlwaysWithSeed <DevTestContext>(); DatabaseInitializer.Initialize(initializer); using (var context = new DevTestContext()) { Assert.IsTrue(context.Database.Exists()); } }
public async Task SaveAsyncWithRetryTest() { using (var context = new DevTestContext()) { var order = new Order { OrderNo = SequenceNoUtils.GenerateNo('O'), OrderAmount = 10000, ProductNo = "PN1001", UserNo = "UID1001" }; await context.SaveAsync(order); } }
public void SaveOrUpdateWithRetryTest() { using (var context = new DevTestContext()) { var order = new Order { OrderNo = SequenceNoUtils.GenerateNo('O'), OrderAmount = 10000, ProductNo = "PN1001", UserNo = "UID1001" }; context.Save(order); context.SaveOrUpdate(order, x => x.Id == order.Id); } }
public ActionResult GetAllData() { string msg = ""; List <DevTest> list = new List <DevTest>(); try { using (DevTestContext context = new DevTestContext()) { list = context.DevTests.ToList(); } } catch (Exception cc) { msg = "Error Occur"; } return(PartialView("~/Views/Shared/_PartialAllData.cshtml", list)); }
public ActionResult Create(Character model) { if (ModelState.IsValid) { using (var ctx = new DevTestContext()) { model.CharacterId = Guid.NewGuid(); model.DateAdded = DateTime.Now; ctx.Characters.Add(model); ctx.SaveChanges(); } return(RedirectToAction("Index")); } return(View(model)); }
public ActionResult Index() { var model = new Character(); using (var ctx = new DevTestContext()) { if (ctx.Characters.Any()) { model = ctx.Characters.OrderByDescending(x => x.DateAdded).First(); ViewBag.Title = model.Name; } else { ViewBag.Title = "No Characters"; } } //We could display the data using ViewBag but I prefer using a strongly-typed model. return(View(model)); }
public JsonResult InsertData(DevTest model) { string msg = ""; try { using (DevTestContext context = new DevTestContext()) { if (model.ID > 0) { var data = context.DevTests.FirstOrDefault(d => d.ID == model.ID); data.Clicks = model.Clicks; data.AffiliateName = model.AffiliateName; data.CampaignName = model.CampaignName; data.Conversions = model.Conversions; data.Date = model.Date; data.Impressions = model.Impressions; } else { context.DevTests.Add(model); } context.SaveChanges(); msg = "Data Saved Successfully.."; } DevTestHub.NotifyCurrentDevInformationToAllClients(); } catch (Exception cc) { msg = "Error Occur"; } var jsonresult = new { msg = msg }; return(Json(jsonresult)); }
public AccountRepository(DevTestContext dbContext) : base(dbContext) { _dbContextContext = dbContext; }
public Repository(DevTestContext dbContext) { _dbContext = dbContext; }
public UserDetailsRepository(DevTestContext dbContext) : base(dbContext) { _dbContextContext = dbContext; }
public PaymentRepository(DevTestContext dbContext) : base(dbContext) { _dbContextContext = dbContext; }