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