private Supplier1 ReadToSupplier(IDataReader aReaderr)
{
Supplier1 aSupplier1 = new Supplier1();
try
{
aSupplier1.SupplierId = Convert.ToInt32(aReaderr["supplierId"]);
}
catch (Exception)
{
}
try
{
aSupplier1.SupplierName = (aReaderr["supplier_name"]).ToString();
}
catch (Exception)
{
}
try
{
aSupplier1.SupplierInformation = (aReaderr["supplier_information"]).ToString();
}
catch (Exception)
{
}
return aSupplier1;
}
public void AddInitialData()
{
Supplier supplier1 = new Supplier1("Supplier 1");
var article1 = new Article(458);
supplier1.AddArticle(article1);
_context.Suppliers.Add(supplier1);
Supplier supplier2 = new Supplier2("Supplier 2");
var article2 = new Article(459);
supplier2.AddArticle(article2);
_context.Suppliers.Add(supplier2);
var article3 = new Article(460);
Supplier supplier3 = new Supplier3("Supplier 3");
supplier3.AddArticle(article3);
SupplierOrganisation organisation = new SupplierOrganisation()
{
ID = 1
};
organisation.AddSupplier(supplier1);
organisation.AddSupplier(supplier2);
organisation.AddSupplier(supplier3);
_context.Organisations.Add(organisation);
}
private Supplier1 ReadToSupplier(IDataReader aReaderr)
{
Supplier1 aSupplier1 = new Supplier1();
try
{
aSupplier1.SupplierId = Convert.ToInt32(aReaderr["supplierId"]);
}
catch (Exception)
{
}
try
{
aSupplier1.SupplierName = (aReaderr["supplier_name"]).ToString();
}
catch (Exception)
{
}
try
{
aSupplier1.SupplierInformation = (aReaderr["supplier_information"]).ToString();
}
catch (Exception)
{
}
return(aSupplier1);
}
public void AddNullArticleTest()
{
var supplier = new Supplier1();
Action testCode = () => { supplier.AddArticle(null); };
Assert.NotNull(Record.Exception(testCode));
}
public void HasViableleArticleWithNoArticle()
{
int price = 10;
int idArticle = 2;
var supplier = new Supplier1("Supplier 1");
Assert.False(supplier.HasViableleArticle(idArticle, price + 1));
}
public void GetArticalFromEmptyInventoryTest()
{
var supplier = new Supplier1();
var articleFromInventory = supplier.GetArticle(23);
Assert.Null(articleFromInventory);
}
public void SetSuppliersAddArticleTest()
{
Article article = new Article(200);
Supplier supplier = new Supplier1("Sup 1");
article.SetSuplier(supplier);
Assert.True(article.Supplier.Articles.Exists(a => a == article));
}
public void SetSupplierTest()
{
Article article = new Article(200);
Supplier supplier = new Supplier1("Sup 1");
article.SetSuplier(supplier);
Assert.Equal(article.Supplier, supplier);
}
public void SuccessfulAddSupplierTest()
{
var supplier = new Supplier1("Supplier 1");
var organisation = new SupplierOrganisation();
organisation.AddSupplier(supplier);
Assert.NotNull(organisation.Suppliers.Find(s => s == supplier));
}
public void SuccessfulAddSupplierSetOrganisationTest()
{
var supplier = new Supplier1("Supplier 1");
var organisation = new SupplierOrganisation();
organisation.AddSupplier(supplier);
Assert.Equal(organisation, supplier.Organisation);
}
public SupplierService()
{
supp1 = new Supplier1();
supp2 = new Supplier2();
supp3 = new Supplier3();
suppliers = new List <BaseSupplierModel>();
suppliers.Add(supp1);
suppliers.Add(supp2);
suppliers.Add(supp3);
}
public void SuccessfulAddArticleTest()
{
var article = new Article
{
ID = 2
};
var supplier = new Supplier1();
supplier.AddArticle(article);
Assert.NotNull(supplier.Articles.Find(a => a == article));
}
public void ArticleInInventoryTest()
{
var article = new Article
{
ID = 2
};
var supplier = new Supplier1();
supplier.AddArticle(article);
Assert.True(supplier.ArticleInInventory(article.ID));
}
public void SuccessfulAddArticleSupplierSetTest()
{
var article = new Article
{
ID = 2
};
var supplier = new Supplier1();
supplier.AddArticle(article);
Assert.Equal(supplier.Articles.Find(a => a == article).Supplier, supplier);
}
public void NoArticleInInventoryTest()
{
var article = new Article
{
ID = 2
};
var supplier = new Supplier1();
supplier.AddArticle(article);
Assert.False(supplier.ArticleInInventory(23));
}
public void GetArticleWithNoExestingIdTest()
{
var article = new Article
{
ID = 2
};
var supplier = new Supplier1();
supplier.AddArticle(article);
var articleFromInventory = supplier.GetArticle(23);
Assert.Null(articleFromInventory);
}
public void GetArticleTest()
{
var article = new Article
{
ID = 2
};
var supplier = new Supplier1();
supplier.AddArticle(article);
var articleFromInventory = supplier.GetArticle(article.ID);
Assert.Equal(articleFromInventory, article);
}
public void SuccessfulHasViableleArticle()
{
int price = 10;
int idArticle = 2;
var validArticle = new Article(price)
{
ID = idArticle
};
var supplier = new Supplier1("Supplier 1");
supplier.AddArticle(validArticle);
Assert.True(supplier.HasViableleArticle(idArticle, price + 1));
}
public void SoldArticleInInventoryTest()
{
var article = new Article
{
ID = 2
};
article.Sell(12);
var supplier = new Supplier1();
supplier.AddArticle(article);
Assert.False(supplier.ArticleInInventory(article.ID));
}
public void HasViableleArticleWithIncorrectArticleId()
{
int price = 10;
int idArticle = 2;
var validArticle = new Article(price)
{
ID = idArticle
};
var supplier = new Supplier1("Supplier 1");
supplier.AddArticle(validArticle);
Assert.False(supplier.HasViableleArticle(idArticle + 1, price + 1));
}
public string InsertSupplier(Supplier1 aSuppllier)
{
try
{
this.OpenConnection();
string sqlComm = String.Format(SqlQueries.GetQuery(Query.InsertSupplier1), aSuppllier.SupplierName,
aSuppllier.SupplierInformation);
this.ExecuteNonQuery(sqlComm);
return "Supplier1 Insert Successfully";
}
catch (Exception)
{
return "Please Try Again";
}
}
public string InsertSupplier(Supplier1 aSuppllier)
{
try
{
this.OpenConnection();
string sqlComm = String.Format(SqlQueries.GetQuery(Query.InsertSupplier1), aSuppllier.SupplierName,
aSuppllier.SupplierInformation);
this.ExecuteNonQuery(sqlComm);
return("Supplier1 Insert Successfully");
}
catch (Exception)
{
return("Please Try Again");
}
}
private void supplierAddbutton_Click(object sender, EventArgs e)
{
Supplier1 aSuppllier =new Supplier1();
aSuppllier.SupplierName = NametextBox.Text.Replace("'", "''");
aSuppllier.SupplierInformation = informationtextBox.Text.Replace("'", "''");
Supplier1DAO aDao=new Supplier1DAO();
string sr = aDao.InsertSupplier(aSuppllier);
if (sr == "Supplier1 Insert Successfully")
{
NametextBox.Clear();
informationtextBox.Clear();
}
MessageBox.Show(sr);
}
private void supplierAddbutton_Click(object sender, EventArgs e)
{
Supplier1 aSuppllier = new Supplier1();
aSuppllier.SupplierName = NametextBox.Text.Replace("'", "''");
aSuppllier.SupplierInformation = informationtextBox.Text.Replace("'", "''");
Supplier1DAO aDao = new Supplier1DAO();
string sr = aDao.InsertSupplier(aSuppllier);
if (sr == "Supplier1 Insert Successfully")
{
NametextBox.Clear();
informationtextBox.Clear();
}
MessageBox.Show(sr);
}
public void SuccessfulOrderArticle()
{
int price = 10;
int idArticle = 2;
var validArticle = new Article(price)
{
ID = idArticle
};
var supplier = new Supplier1("Supplier 1");
supplier.AddArticle(validArticle);
var organisation = new SupplierOrganisation();
organisation.AddSupplier(supplier);
var orderedArticle = organisation.OrderArticle(idArticle, price + 1);
Assert.Equal(orderedArticle, validArticle);
}
public List <Supplier1> GetAllSupplier()
{
List <Supplier1> aSuppliers = new List <Supplier1>();
try
{
this.OpenConnection();
string sqlComm = string.Format(SqlQueries.GetQuery(Query.GetAllSupplier1));
IDataReader aReader = this.ExecuteReader(sqlComm);
if (aReader != null)
{
while (aReader.Read())
{
Supplier1 aSupplier1 = new Supplier1();
aSupplier1 = ReadToSupplier(aReader);
aSuppliers.Add(aSupplier1);
}
}
}
catch (Exception)
{
}
return(aSuppliers);
}
public List<Supplier1> GetAllSupplier()
{
List<Supplier1> aSuppliers=new List<Supplier1>();
try
{
this.OpenConnection();
string sqlComm = string.Format(SqlQueries.GetQuery(Query.GetAllSupplier1));
IDataReader aReader=this.ExecuteReader(sqlComm);
if(aReader!=null)
{
while(aReader.Read())
{
Supplier1 aSupplier1=new Supplier1();
aSupplier1 = ReadToSupplier(aReader);
aSuppliers.Add(aSupplier1);
}
}
}
catch (Exception)
{
}
return aSuppliers;
}
public void NoArticleInEmptyInventoryTest()
{
var supplier = new Supplier1();
Assert.False(supplier.ArticleInInventory(23));
}
