public void Dispose()
{
using (var ctx = new JournalDbContext(DbOptions))
{
ctx.Database.EnsureDeleted();
}
}
public EditUser(JournalDbContext db, MainWindow mw)
{
InitializeComponent();
this.db = db;
this.mw = mw;
this.loginComboBox.ItemsSource = getUsernames();
}
public void GetByIssueId()
{
using (var ctx = new JournalDbContext(DbOptions))
{
//Arrange
var issueController = new IssueController(new IssueService(ctx), MapperConfig.Configure());
var controller = new ArticleController(new ArticleService(ctx), MapperConfig.Configure());
//Act
var issueResult = issueController.Get();
var issueOkObjectResult = issueResult as OkObjectResult;
var issueModel = issueOkObjectResult.Value as IEnumerable <IssueModel>;
var result = controller.GetByIssue(issueModel.Single().AllTime);
//Assert
var okObjectResult = result as OkObjectResult;
Assert.NotNull(okObjectResult);
var model = okObjectResult.Value as IEnumerable <ArticleModel>;
Assert.NotNull(model);
Assert.Equal(2, model.Count());
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, JournalDbContext dbContext)
{
// 查資料表是否已經存在，若不存在自動建立；若資料表存在但版本太舊符則自動更新。
// 在正式環境自動更新Schema有點可怕，我加了限定LocalDB執行的安全鎖
if (dbContext.Database.GetDbConnection().ConnectionString.Contains("MSSQLLocalDB"))
{
dbContext.Database.Migrate();
}
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Error");
}
app.UseStaticFiles();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapRazorPages();
});
}
public void Put()
{
int Id = 0;
//Arrange
using (var ctx = new JournalDbContext(DbOptions))
{
var controller = new ArticleController(new ArticleService(ctx), MapperConfig.Configure());
//Act
var result = controller.Get();
var okObjectResult = result as OkObjectResult;
var model = okObjectResult.Value as IEnumerable <ArticleModel>;
Id = model.First().Id;
controller.Put(model.First().Id, new ArticleModel
{
Id = model.First().Id,
Title = "Sudoku"
});
}
//Assert
using (var ctx = new JournalDbContext(DbOptions))
{
Assert.Equal(2, ctx.Articles.Count());
Assert.Equal("Sudoku", ctx.Articles.Where(a => a.Id == Id).Single().Title);
}
}
public ArticleApiTest()
{
DbOptions = new DbContextOptionsBuilder <JournalDbContext>()
.UseInMemoryDatabase(databaseName: "Article_Test_Db")
.Options;
using (var ctx = new JournalDbContext(DbOptions))
{
ctx.Issues.Add(new Issue
{
Id = 6,
AllTime = 474,
IssueDetails = new IssueDetails
{
Volume = 45,
Number = 6,
Name = "Nyári szám",
CopyNumber = 800,
ExpectedPageCount = 36
},
Articles = new List <Article> ()
{
new Article()
{
Title = "Az 1%"
},
new Article()
{
Title = "Utazd be Európát!"
}
}
});
ctx.SaveChanges();
}
}
public void Add()
{
//Arrange
using (var ctx = new JournalDbContext(DbOptions))
{
//Arrange
var issueController = new IssueController(new IssueService(ctx), MapperConfig.Configure());
var controller = new ArticleController(new ArticleService(ctx), MapperConfig.Configure());
//Act
var issueResult = issueController.Get();
var issueOkObjectResult = issueResult as OkObjectResult;
var issueModel = issueOkObjectResult.Value as IEnumerable <IssueModel>;
//Act
controller.Post(new ArticleModel()
{
IssueId = issueModel.Single().Id,
Title = "Receptek"
});
}
//Assert
using (var ctx = new JournalDbContext(DbOptions))
{
var iss = ctx.Articles.ToList();
Assert.Equal(3, ctx.Articles.Count());
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, JournalDbContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseBrowserLink();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseStaticFiles();
app.UseAuthentication();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Login}/{action=Index}/{id?}");
});
DbInitializer.Initialize(context);
}
public void Put()
{
//Arrange
using (var ctx = new JournalDbContext(DbOptions))
{
var controller = new IssueController(new IssueService(ctx), MapperConfig.Configure());
//Act
var result = controller.Get();
var okObjectResult = result as OkObjectResult;
var model = okObjectResult.Value as IEnumerable <IssueModel>;
controller.Put(model.Single().Id, new IssueModel
{
Id = 6,
AllTime = 474,
Volume = 45,
Number = 3,
Name = "Téli szám",
CopyNumber = 800,
ExpectedPageCount = 36
});
}
//Assert
using (var ctx = new JournalDbContext(DbOptions))
{
Assert.Equal(1, ctx.Issues.Count());
Assert.Equal("Téli szám", ctx.Issues.Include(i => i.IssueDetails).Single().IssueDetails.Name);
}
}
public EditEntry(JournalDbContext db, MainWindow mw, Entry entry, string journal)
{
InitializeComponent();
this.db = db;
this.mw = mw;
this.entry = entry;
this.journal = journal;
this.entryTextBox.Text = entry.Text;
}
public AddEntry(JournalDbContext db, List <string> journals, string user, MainWindow mw)
{
InitializeComponent();
this.db = db;
this.journals = journals;
this.JournalsComboBox.ItemsSource = this.journals;
this.currrentUser = user;
this.mw = mw;
}
public OpenArticleModel(JournalDbContext db)
{
_db = db;
List <string> articles = _db.Journals
.AsNoTracking()
.Where(x => x.Event == "Aangebroken")
.Select(x => x.Message)
.Distinct()
.OrderBy(x => x)
.ToList();
Articles = new SelectList(articles);
}
public void DeadlineReminder()
{
Mock <EmailSender> sender = new Mock <EmailSender>();
sender.Setup(x => x.SendEmailAsync(It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>())).Returns(Task.CompletedTask);
using (var ctx = new JournalDbContext(DbOptions))
{
var controller = new EmailController(sender.Object, new IssueService(ctx), MapperConfig.Configure());
controller.SendDeadlineReminder(ctx.Issues.SingleAsync().Id);
}
sender.Verify(mock => mock.SendEmailAsync(It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>()), Times.Once);
}
public void Initialize()
{
using (var ctx = new JournalDbContext(DbOptions))
{
ctx.Issues.Add(new DAL.Entities.Issue
{
AllTime = 474,
IssueDetails = new DAL.Entities.IssueDetails
{
Volume = 45,
Number = 6,
Name = "Nyári szám",
CopyNumber = 800,
ExpectedPageCount = 36
}
});
ctx.SaveChanges();
}
}
public void AddWithoutDetails()
{
//Arrange
using (var ctx = new JournalDbContext(DbOptions))
{
var controller = new IssueController(new IssueService(ctx), MapperConfig.Configure());
//Act
controller.Post(new IssueModel()
{
AllTime = 500
});
}
//Assert
using (var ctx = new JournalDbContext(DbOptions))
{
var iss = ctx.Issues.ToList();
Assert.Equal(2, ctx.Issues.Count());
}
}
public void Delete()
{
//Arrange
using (var ctx = new JournalDbContext(DbOptions))
{
var controller = new IssueController(new IssueService(ctx), MapperConfig.Configure());
//Act
var result = controller.Get();
var okObjectResult = result as OkObjectResult;
var model = okObjectResult.Value as IEnumerable <IssueModel>;
controller.Delete(model.Single().Id);
}
//Assert
using (var ctx = new JournalDbContext(DbOptions))
{
Assert.Equal(0, ctx.Issues.Count());
}
}
public void Get()
{
using (var ctx = new JournalDbContext(DbOptions))
{
//Arrange
var controller = new IssueController(new IssueService(ctx), MapperConfig.Configure());
//Act
var result = controller.Get();
//Assert
var okObjectResult = result as OkObjectResult;
Assert.NotNull(okObjectResult);
var model = okObjectResult.Value as IEnumerable <IssueModel>;
Assert.NotNull(model);
Assert.Single(model);
Assert.Equal("Nyári szám", model.Single().Name);
}
}
public void AddWithDetails()
{
//Arrange
using (var ctx = new JournalDbContext(DbOptions))
{
var controller = new IssueController(new IssueService(ctx), MapperConfig.Configure());
//Act
controller.Post(new IssueModel()
{
Volume = 46,
Number = 0,
Name = "Gólyaszám"
});
}
//Assert
using (var ctx = new JournalDbContext(DbOptions))
{
Assert.Equal(2, ctx.Issues.Count());
Assert.Equal(2, ctx.IssueDetails.Count());
Assert.Equal("Gólyaszám", ctx.IssueDetails.Where(i => i.Volume == 46).Single().Name);
}
}
public IssueApiTest()
{
DbOptions = new DbContextOptionsBuilder <JournalDbContext>()
.UseInMemoryDatabase(databaseName: "Issue_Test_Db")
.Options;
using (var ctx = new JournalDbContext(DbOptions))
{
ctx.Issues.Add(new Issue
{
Id = 6,
AllTime = 474,
IssueDetails = new IssueDetails
{
Volume = 45,
Number = 6,
Name = "Nyári szám",
CopyNumber = 800,
ExpectedPageCount = 36
}
});
ctx.SaveChanges();
}
}
public DetailsModel(JournalDbContext context)
{
_context = context;
}
public IndexModel(JournalDbContext context)
{
_context = context;
}
public static void Initialize(JournalDbContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Students.Any() && context.Teachers.Any())
{
return; // DB has been seeded
}
var teachers = new Teacher[]
{
new Teacher {
Login = "******", Password = "******"
},
new Teacher {
Login = "******", Password = "******"
}
};
context.Teachers.AddRange(teachers);
context.SaveChanges();
var students = new Student[]
{
new Student {
FirstName = "Carson", LastName = "Alexander"
},
new Student {
FirstName = "Meredith", LastName = "Alonso"
},
new Student {
FirstName = "Arturo", LastName = "Anand"
},
new Student {
FirstName = "Gytis", LastName = "Barzdukas"
},
new Student {
FirstName = "Yan", LastName = "Li"
},
new Student {
FirstName = "Peggy", LastName = "Justice"
},
new Student {
FirstName = "Laura", LastName = "Norman"
},
new Student {
FirstName = "Nino", LastName = "Olivetto"
}
};
context.Students.AddRange(students);
context.SaveChanges();
var subjects = new Subject[]
{
new Subject {
ID = 1050, Name = "Chemistry"
},
new Subject {
ID = 4022, Name = "Microeconomics"
},
new Subject {
ID = 4041, Name = "Macroeconomics"
},
new Subject {
ID = 1045, Name = "Calculus"
},
new Subject {
ID = 3141, Name = "Trigonometry"
},
new Subject {
ID = 2021, Name = "Composition"
},
new Subject {
ID = 2042, Name = "Literature"
}
};
context.Subjects.AddRange(subjects);
context.SaveChanges();
var marks = new Mark[]
{
new Mark {
ID = 1, SubjectID = 1050, Grade = 3
},
new Mark {
ID = 1, SubjectID = 4022, Grade = 4
},
new Mark {
ID = 1, SubjectID = 4041, Grade = 3
},
new Mark {
ID = 2, SubjectID = 1045, Grade = 4
},
new Mark {
ID = 2, SubjectID = 3141, Grade = 4
},
new Mark {
ID = 2, SubjectID = 2021, Grade = 3
},
new Mark {
ID = 3, SubjectID = 1050, Grade = 2
},
new Mark {
ID = 4, SubjectID = 1050, Grade = 5
},
new Mark {
ID = 4, SubjectID = 4022, Grade = 5
},
new Mark {
ID = 5, SubjectID = 4041, Grade = 5
},
new Mark {
ID = 6, SubjectID = 1045, Grade = 6
},
new Mark {
ID = 7, SubjectID = 3141, Grade = 4
},
};
context.Marks.AddRange(marks);
context.SaveChanges();
}
public AddUser(JournalDbContext db, MainWindow mw)
{
InitializeComponent();
this.db = db;
this.mw = mw;
}
public EditModel(JournalDbContext context)
{
_context = context;
}
public ArticleService(JournalDbContext dbContext)
{
DbContext = dbContext;
}
public MainWindow()
{
InitializeComponent();
db = new JournalDbContext();
}
public DeleteModel(JournalDbContext context)
{
_context = context;
}
public RemoveUser(JournalDbContext db)
{
InitializeComponent();
this.db = db;
}
public IssueService(JournalDbContext dbContext)
{
DbContext = dbContext;
}
public BooksController(JournalDbContext context, UserManager <IdentityUser> userManager)
{
_context = context;
_userManager = userManager;
}
