public void ProcessProduct_NoRelations_Archive()
{
var productId = SetupNoRelation();
Assert.AreEqual(1, Articles.Count());
Assert.IsTrue(Articles.All(a => a.Id == productId && a.Archived));
}
public MySqlContext(DbContextOptions options) : base(options)
{
//Database.EnsureDeleted();
Database.EnsureCreated();
if (Articles.Count() == 0)
{
PutData data = new PutData();
Articles.AddRange(data.articles);
Comments.AddRange(data.comments);
SuperUsers.Add(data.super);
TeacherUsers.AddRange(data.teacher);
StudentUsers.AddRange(data.studentUser);
TestStudents.AddRange(data.testStudents);
QuestionAnswers.AddRange(data.questionAnswers);
Tests.AddRange(data.tests);
Themes.AddRange(data.themes);
TestThemes.AddRange(data.TestThemas);
Questions.AddRange(data.questions1);
Questions.AddRange(data.questions2);
Questions.AddRange(data.questions3);
Marks.AddRange(data.Marks1);
Marks.AddRange(data.Marks2);
EventProfileUsers.AddRange(data.EventProfileUsers);
Meetups.AddRange(data.Meetups);
Speakers.AddRange(data.Speakers);
SaveChanges();
}
}
public void ProcessProduct_M2ORelation_DefaultReference()
{
var productId = SetupM2ORelation(null, null);
Assert.AreEqual(2, Articles.Count());
Assert.AreEqual(1, Articles.Count(a => a.Id == productId));
}
public void ProcessProduct_M2ORelation_IgnoreReference()
{
var productId = SetupM2ORelation(null, DeletingMode.Keep);
Assert.AreEqual(2, Articles.Count());
Assert.AreEqual(1, Articles.Count(a => a.Id == productId));
}
public int GetPublishedArticleCount(String categoryId, DateTime currentDate)
{
var articleFilter = Builders <Article> .Filter.Eq(c => c.CategoryId, categoryId);
var filter = this.GetPublishedArticleFilter <Article>(currentDate) & articleFilter;
return((int)Articles.Count(filter));
}
public void ProcessProduct_M2ORelation_ArchiveReference()
{
var productId = SetupM2ORelation(null, DeletingMode.Delete);
Assert.AreEqual(1, Articles.Count(a => a.Id == productId));
Assert.AreEqual(1, Articles.Count(a => a.Id != productId));
Assert.IsTrue(Articles.All(a => a.Archived));
}
private async Task LoadFeed(HttpClient client, int expectedCount)
{
var response = await client.GetAsync("/api/articles/feed");
var feed = await response.Content.ReadFromJsonAsync <FeedEnvelope>();
Assert.Equal(expectedCount, feed !.Articles.Count());
}
public void AddArticle(DateTimeOffset publishDateTime)
{
var month = publishDateTime.Month;
var year = publishDateTime.Year;
var article = Articles.FirstOrDefault(a => a.Month == month && a.Year == year);
if (article == null)
{
article = DataSourceArticle.Create(month, year);
Articles.Add(article);
}
article.Increment();
NbStoriesPerMonth = Articles.Sum(a => a.NbArticles) / Articles.Count();
}
private async Task HandleLoadArticlesFromIndexedDb()
{
BusyOverlayService.SetBusyState(BusyEnum.Busy);
var stopwatch = new Stopwatch();
stopwatch.Start();
var result = await PersistenceService.GetAllAsync <Article>();
Articles = result.ToList();
ItemCount = Articles.Count();
stopwatch.Stop();
ProcessingTimeMs = stopwatch.ElapsedMilliseconds;
BusyOverlayService.SetBusyState(BusyEnum.NotBusy);
}
/// <summary>
/// 设置内容
/// </summary>
/// <param name="elements"></param>
protected override void SetBody(List <System.Xml.XmlElement> elements)
{
elements.Add(Document.CreateElement("ArticleCount", Articles.Count()));
var items = Document.CreateElement("Articles");
foreach (var article in Articles)
{
var item = Document.CreateElement("item");
foreach (var property in article.GetType().GetProperties())
{
var value = property.GetValue(article);
if (value == null)
{
continue;
}
var element = Document.CreateElement(property.Name, value);
item.AppendChild(element);
}
items.AppendChild(item);
}
elements.Add(items);
}
public int GetArticleCount()
{
return((int)Articles.Count(new BsonDocument()));
}
static void CreateCompleteOrder()
{
// conteggio i numeri di articoli del file csv valorizzando la lista articles
Console.WriteLine("il numero di articoli è :" + Articles.Count());
//Milestone 1
Customer myCustomer1 = new Customer("Francesco", "Rossi", "*****@*****.**");
Customer myCustomer2 = new Customer("Alberto", "Bianchi", "*****@*****.**");
Admin myAdmin = new Admin();
myAdmin.SetAdministrator(true);
myAdmin.AggiungiUser("lore", "ctt", "lore@aaa");
//Milestone 2
Articles.List();
Article myArticle1 = new Article("Videocassetta", (decimal)12.4);
Articles.Add(myArticle1);
Article myArticle2 = new Article("martello", (decimal)90.0);
Articles.Add(myArticle2);
Article myArticle3 = new Article("pinza", (decimal)10.5);
Articles.Add(myArticle3);
Articles.List();
Console.WriteLine($"stampo in console il prezzo del martello: {Articles.SearchArticle("martello").Price}");
Console.WriteLine("adesso il numero di articoli è :" + Articles.Count());
//-----------
//Milestone 3
Basket Basket1 = new Basket(myArticle1, 20, myCustomer1); //aggiungo un articolo nel carrello
// Basket1.Add(myArticle1, 20, myCustomer1);
Baskets.AddtoList(Basket1);
/// -------------------------------
Article myart = new Article();
myart = Articles.SearchArticle("martello"); // ricerco una descrizione e ritorno un articolo Milestone 2
Basket Basket2 = new Basket(myart, 20, myCustomer1); //Creo e valorizzo il basket
Baskets.AddtoList(Basket2); // aggiungo il basket alla lista
//-------------
Baskets.ElencaTutti(); // elenca gli articoli inseriti del basket
// -----
Console.WriteLine($"----- prezzo totale del cliente myCustomer1 è = {Baskets.TotalPrice(myCustomer1)}");
//-----------------------
// esercizio 10
// Articles.WriteToFileCSV(); // SALVA LA LISTA ARTICOLI dalla classe
// Baskets.WriteToFileCSV(); // SALVA LA LISTA DEL CARRELLO
//-------------------
}
static void TestaArticoliBis()
{
Console.WriteLine(Articles.Count());
}
static void TestaArticoli()
{
// avvio il costruttore
Article myArticle1 = new Article("Face mask", (decimal)12.44);
Console.WriteLine(myArticle1.List());
Console.WriteLine(myArticle1.List());
myArticle1.Update((decimal)12.5, "Face mask", 15, 22);
Console.WriteLine(myArticle1.List());
Console.WriteLine("Avvio distruzione oggetto");
myArticle1.Destroy(1);
Console.WriteLine(myArticle1.List());
myArticle1.Stock = 200;
Console.WriteLine(myArticle1.List());
//{ // utilizzo di una lista di articoli esterna
// List<Article> myArticlelist = new List<Article>()
// {
// new Article(1, "Face mask", (decimal)44.5 ),
// new Article( 2,"trapano", (decimal)57.5 )
// };
// foreach (Article c in myArticlelist)
// System.Console.WriteLine(c.List());//scorro e stampo a video il contenuto della lista
//}
//Articles myArticles = new Articles();
//myArticles.Add(myArticle1);
//Console.WriteLine(myArticles.Count());
////----
//Article myArticle2 = new Article(2, "cacciavite", (decimal)12.44);
//myArticles.Add(myArticle2);
////----
//Article myArticle3 = new Article(3, "quaderno", (decimal)12.44);
//myArticles.Add(myArticle3);
////----
//Article myArticle4 = new Article(4, "penna", (decimal)12.44);
//myArticles.Add(myArticle4);
////----
///
//-------------------------------------------
Articles.Add(myArticle1);
Console.WriteLine(Articles.Count());
//----
Article myArticle2 = new Article("cacciavite", (decimal)12.44);
Articles.Add(myArticle2);
//----
Article myArticle3 = new Article("quaderno", (decimal)12.44);
Articles.Add(myArticle3);
//----
Article myArticle4 = new Article("penna", (decimal)12.44);
Articles.Add(myArticle4);
//----
//--------------------------------------
Articles.Delete(myArticle2);
Console.WriteLine(Articles.Count());
Articles.Delete(myArticle3);
Articles.List();
//--
Article myArticleSearched = Articles.SearchArticle("penna"); //Finishing the ecommerce structure (#6)
Console.WriteLine("l'id ricercato è " + myArticleSearched.Id_article);
if (Articles.Delete(myArticleSearched.Id_article))
{ // CANCELLO PER ID
Console.WriteLine("Articolo cancellato");
}
else
{
Console.WriteLine("Articolo non trovato");
}
}
public int GetPublishedArticleCount(DateTime currentDate)
{
var filter = this.GetPublishedArticleFilter <Article>(currentDate);
return((int)Articles.Count(filter));
}
/// <summary>
/// Return an int which contain the number of bill's article
/// </summary>
/// <returns></returns>
public int NbArticles()
{
return(Articles.Count());
}
public async Task <JsonResult> Get(int pageIndex,
int pageSize,
string pageOrder,
int group,
string userName,
string title,
string fromDate,
string toDate,
sbyte articleStatus
)
{
DateTime?sDate = null,
eDate = null;
ArticleStatus?status = null;
if (!String.IsNullOrWhiteSpace(fromDate))
{
sDate = Utilities.ToEnglishDate(fromDate).Date;
}
if (!String.IsNullOrWhiteSpace(toDate))
{
eDate = Utilities.ToEnglishDate(toDate).Date;
}
if (articleStatus != -1)
{
status = (ArticleStatus)articleStatus;
}
if (pageOrder.Trim() == "ID")
{
pageOrder = "LastUpdate desc";
}
var list = Articles.Get(pageIndex,
pageSize,
pageOrder,
_articleType,
group,
userName,
title,
sDate,
eDate,
status
);
foreach (var item in list)
{
try
{
item.UserTitle = (await UserManager.FindByIdAsync(item.UserID)).UserName;
}
catch (Exception)
{
item.UserTitle = StaticValues.HomeTitle;
}
}
int total = Articles.Count(_articleType, group, userName, title, sDate, eDate, status);
int totalPage = (int)Math.Ceiling((decimal)total / pageSize);
if (pageSize > total)
{
pageSize = total;
}
if (list.Count < pageSize)
{
pageSize = list.Count;
}
JsonResult result = new JsonResult()
{
Data = new
{
TotalPages = totalPage,
PageIndex = pageIndex,
PageSize = pageSize,
Rows = list
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
return(result);
}
