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