public void AddOrder(String ccode, String cname, String pname, String qty) { //Select Customer SearchCustomer.Click(); Thread.Sleep(3000); SearchCode.SendKeys(ccode); SearchName.SendKeys(cname); RunSearch.Click(); Thread.Sleep(3000); SelectCustomer.Click(); Thread.Sleep(5000); //Select Product SearchProduct.Click(); Thread.Sleep(3000); SearchPName.SendKeys(pname); RunPSearch.Click(); Thread.Sleep(3000); SelectProduct.Click(); Thread.Sleep(3000); //Finish the follow flow AddQty.SendKeys(qty); AddBtn.Click(); Thread.Sleep(3000); CompleteBtn.Click(); }
public void Delete(Guid id) { using (var connection = context.CreateConnection()) { connection.Execute(SelectProduct.Delete(id)); } }
public Product GetById(Guid id) { using (var connection = context.CreateConnection()) { return(connection.Query <Product>(SelectProduct.ById(id)).SingleOrDefault()); } }
public IEnumerable <Product> Get() { using (var connection = context.CreateConnection()) { return(connection.Query <Product>(SelectProduct.All())); } }
public void SelectAllProductsDto() { using (IDbConnection dbConnection = new SqliteConnectionFactory().Create()) { var product1 = new ProductDto { Name = "Product #1" }; dbConnection.Execute(new InsertProduct().Query(product1)); var product2 = new ProductDto { Name = "Product #2" }; dbConnection.Execute(new InsertProduct().Query(product2)); var product3 = new ProductDto { Name = "Product #3" }; dbConnection.Execute(new InsertProduct().Query(product3)); QueryObject all = new SelectProduct().All(); IEnumerable <ProductDto> productDtos = dbConnection.Query <ProductDto>(all); Assert.AreEqual(3, productDtos.Count()); } }
public Product GetByKey(string key) { using (var connection = context.CreateConnection()) { return(connection.Query <Product>(SelectProduct.ByKey(key)).SingleOrDefault()); } }
public void ShouldHaveErrorWhenProductNameIsNotCorrect() { var model = new SelectProduct("IncorrectProductName"); var result = _validator.TestValidate(model); Assert.True(result.ShouldHaveValidationErrorFor(product => product.ProductName).Any()); }
public void ShouldHaveErrorWhenProductNameIsNull() { var model = new SelectProduct(null); var result = _validator.TestValidate(model); result.ShouldHaveValidationErrorFor(product => product.ProductName); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ProductSet = new DataSet(); #region Populating Product List try { connection.Open(); SqlCommand command = new SqlCommand("Select DISTINCT tbl_ProductMaster.* From tbl_ProductMaster INNER JOIN tblStock_Detail ON tbl_ProductMaster.ProductID = tblStock_Detail.ProductID Where tbl_ProductMaster.Status = 1", connection); DataSet ds = new DataSet(); SqlDataAdapter sA = new SqlDataAdapter(command); sA.Fill(ds); ProductSet = ds; ds.Tables[0].Columns.Add("ProductInfo", typeof(string), "Product_Name+ ' '+itemStrength+' '+itemPackSize+' '+itemForm"); SelectProduct.DataSource = ds.Tables[0]; SelectProduct.DataTextField = "ProductInfo"; SelectProduct.DataValueField = "ProductID"; SelectProduct.DataBind(); if (SelectProduct != null) { SelectProduct.Items.Insert(0, "Select Product"); SelectProduct.SelectedIndex = 0; } } catch (Exception ex) { } finally { connection.Close(); } #endregion } }
public Product Update(Product product) { using (var connection = context.CreateConnection()) { connection.Execute(SelectProduct.Update(product)); return(product); } }
public void ShouldNotHaveErrorWhenProductNameIsCorrect() { var model = new SelectProduct(nameof(Product.ChickenSoup)); var result = _validator.TestValidate(model); result.ShouldNotHaveValidationErrorFor(product => product.ProductName); Assert.False(result.Errors.Any()); }
public void MakeSelectionTest2() { VendingMachine machine = new VendingMachine(); SelectProduct test = new SelectProduct(); test.MakeSelection("B3", 10.00, machine.VendingDictionary["B3"], 0.00); Assert.AreEqual(1.50, test.TotalSale); }
public void VendingMachineTestQuantity() { VendingMachine dictionary = new VendingMachine(); Assert.AreEqual(5, dictionary.VendingDictionary["A1"].Quantity); SelectProduct test = new SelectProduct(); test.MakeSelection("B3", 10.00, dictionary.VendingDictionary["B3"], 0.00); Assert.AreEqual(4, dictionary.VendingDictionary["B3"].Quantity); }
public Product Create(Product product) { if (product.Id == Guid.Empty) { product.Id = Guid.NewGuid(); } using (var connection = context.CreateConnection()) { connection.Execute(SelectProduct.Insert(product)); return(product); } }
public void FindProduct() { IJavaScriptExecutor js = Properties.driver as IJavaScriptExecutor; // Javascript'e etki edecek referans. js.ExecuteScript("window.scrollBy(0,500)"); // Kaydırma çubuğu Y ekseninde 1300 birim aşağı hareket eder. SelectProduct.Click(); // İlgili ürüne tıklanır. System.Threading.Thread.Sleep(4000); // İçerik aktif olana kadar bekler. js.ExecuteScript("window.scrollBy(0,200)"); // Kaydırma çubuğu Y ekseninde 1300 birim aşağı hareket eder. Ask.Click(); // Mağazaya soru sor butonuna tıklanır ve otomatik olarak kaydırma çubuğu aşağı iner. System.Threading.Thread.Sleep(2000); // İçerik aktif olana kadar bekler. AskSeller.Click(); // Tekrardan mağazaya soru sor butonuna tıklanır. System.Threading.Thread.Sleep(2000); // İçerik aktif olana kadar bekler. }
public void SelectProductDtoById() { using (IDbConnection dbConnection = new SqliteConnectionFactory().Create()) { var product1 = new ProductDto {Name = "Product #1"}; dbConnection.Execute(new InsertProduct().Query(product1)); QueryObject byId = new SelectProduct().ById(1); ProductDto productDto = dbConnection.Query<ProductDto>(byId).SingleOrDefault(); Assert.AreEqual(1, productDto.Id); Assert.AreEqual("Product #1", productDto.Name); } }
public void SelectProductDtoById() { using (IDbConnection dbConnection = new SqliteConnectionFactory().Create()) { var product1 = new ProductDto { Name = "Product #1" }; dbConnection.Execute(new InsertProduct().Query(product1)); QueryObject byId = new SelectProduct().ById(1); ProductDto productDto = dbConnection.Query <ProductDto>(byId).SingleOrDefault(); Assert.AreEqual(1, productDto.Id); Assert.AreEqual("Product #1", productDto.Name); } }
public void UpdateProductName() { using (IDbConnection dbConnection = new SqliteConnectionFactory().Create()) { var insertProduct = new InsertProduct(); var product = new ProductDto {Name = "Product Name"}; product.Id = (int) dbConnection.Query<Int64>(insertProduct.Query(product)).Single(); var updateProduct = new UpdateProduct(); dbConnection.Execute(updateProduct.NameForAllProducts("new name")); var selectProduct = new SelectProduct(); ProductDto result = dbConnection.Query<ProductDto>(selectProduct.ById(product.Id)).Single(); StringAssert.AreEqualIgnoringCase("new name", result.Name); } }
//Sp_FillPO_Details public void PopulateDropDown(String Text) { #region Populating Product Name Dropdown try { connection.Open(); Text = Text + "%"; SqlCommand command = new SqlCommand("SELECT Distinct * From tbl_ProductMaster INNER JOIN tblStock_Detail ON tbl_ProductMaster.ProductID = tblStock_Detail.ProductID Where tbl_ProductMaster.Product_Name LIKE '" + Text + "' AND tbl_ProductMaster.Status = 1", connection); DataSet ds = new DataSet(); SqlDataAdapter sA = new SqlDataAdapter(command); sA.Fill(ds); if (ds.Tables[0].Rows.Count.Equals(0)) { WebMessageBoxUtil.Show("There is no stock for the selected product"); } if (SelectProduct.DataSource != null) { SelectProduct.DataSource = null; } ProductSet = null; ProductSet = ds; //ds.Tables[0].Columns.Add("ProductInfo", typeof(string), "Product_Name+ ' '+itemStrength+' '+itemPackSize+' '+itemForm"); SelectProduct.DataSource = ds.Tables[0]; SelectProduct.DataTextField = "Description"; SelectProduct.DataValueField = "ProductID"; SelectProduct.DataBind(); if (SelectProduct != null) { SelectProduct.Items.Insert(0, "Select Product"); SelectProduct.SelectedIndex = 0; } } catch (Exception ex) { } finally { connection.Close(); } #endregion }
public void UpdateProductName() { using (IDbConnection dbConnection = new SqliteConnectionFactory().Create()) { var insertProduct = new InsertProduct(); var product = new ProductDto { Name = "Product Name" }; product.Id = (int)dbConnection.Query <Int64>(insertProduct.Query(product)).Single(); var updateProduct = new UpdateProduct(); dbConnection.Execute(updateProduct.NameForAllProducts("new name")); var selectProduct = new SelectProduct(); ProductDto result = dbConnection.Query <ProductDto>(selectProduct.ById(product.Id)).Single(); StringAssert.AreEqualIgnoringCase("new name", result.Name); } }
public void PopulateDropDown(String Text) { #region Populating Product Name Dropdown try { connection.Open(); Text = Text + "%"; SqlCommand command = new SqlCommand("SELECT * From tbl_ProductMaster Where tbl_ProductMaster.Product_Name LIKE '" + Text + "' AND Status = 1", connection); DataSet ds = new DataSet(); SqlDataAdapter sA = new SqlDataAdapter(command); sA.Fill(ds); if (SelectProduct.DataSource != null) { SelectProduct.DataSource = null; } ProductSet = null; ProductSet = ds; StockDisplayGrid.DataSource = ds; StockDisplayGrid.DataBind(); SelectProduct.DataSource = ds.Tables[0]; SelectProduct.DataTextField = "Product_Name"; SelectProduct.DataValueField = "ProductID"; SelectProduct.DataBind(); if (SelectProduct != null) { SelectProduct.Items.Insert(0, "Select Product"); SelectProduct.SelectedIndex = 0; } } catch (Exception ex) { } finally { connection.Close(); } #endregion }
public void SelectAllProductsDto() { using (IDbConnection dbConnection = new SqliteConnectionFactory().Create()) { var product1 = new ProductDto {Name = "Product #1"}; dbConnection.Execute(new InsertProduct().Query(product1)); var product2 = new ProductDto {Name = "Product #2"}; dbConnection.Execute(new InsertProduct().Query(product2)); var product3 = new ProductDto {Name = "Product #3"}; dbConnection.Execute(new InsertProduct().Query(product3)); QueryObject all = new SelectProduct().All(); IEnumerable<ProductDto> productDtos = dbConnection.Query<ProductDto>(all); Assert.AreEqual(3, productDtos.Count()); } }
//Sp_FillPO_Details public void PopulateDropDown(String Text) { #region Populating Product Name Dropdown try { connection.Open(); Text = Text + "%"; SqlCommand command = new SqlCommand("SELECT * From tbl_ProductMaster Where tbl_ProductMaster.Product_Name LIKE '" + Text + "' AND Status = 1", connection); DataSet ds = new DataSet(); SqlDataAdapter sA = new SqlDataAdapter(command); sA.Fill(ds); if (SelectProduct.DataSource != null) { SelectProduct.DataSource = null; } ProductSet = null; ProductSet = ds; // ds.Tables[0].Columns.Add("ProductInfo", typeof(string), "Product_Name+ ' '+itemStrength+' '+itemPackSize+' '+itemForm"); SelectProduct.DataSource = ds.Tables[0]; SelectProduct.DataTextField = "Description"; SelectProduct.DataValueField = "ProductID"; SelectProduct.DataBind(); if (SelectProduct != null) { SelectProduct.Items.Insert(0, "Select Product"); SelectProduct.SelectedIndex = 0; } } catch (Exception ex) { } finally { connection.Close(); } #endregion }
internal void SearchingProduct() { EnterProductName.SendKeys("Villa Maria"); Thread.Sleep(2000); SelectProduct.Click(); Thread.Sleep(5000); if (Product.Displayed) { Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Pass, "Test PASS, User can search the wine successfullyusing the search bar"); } else { Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Fail, "Test FAIL,User can't serarch the wine using search bar"); } TastingNotes.Click(); Thread.Sleep(2000); if (CriticReviews.Displayed) { Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Pass, "Test Pass,Critic Reviews Visible"); } else { Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Fail, "Test Fail,Critic Revies Not Visible"); } if (UserReviews.Displayed) { Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Pass, "Test Pass,User Reviews Visible"); } else { Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Fail, "Test Fail,User Reviews Not Visible"); } }
private void BuildProductList() { var productList = new List <SelectProduct>(); if (_vm.SelectGroupPropertyValue.Count == 1) { _vm.SelectGroupPropertyValue[0].SelectedPropertyValueList .Where(p => p.IsChecked).ToList().ForEach(p => { var selectProduct = new SelectProduct { PropertyValueList = new List <PropertyValueVM> { new PropertyValueVM { PropertySysNo = _vm.SelectGroupPropertyValue[0].Property.SysNo, SysNo = p.PropertyValue.SysNo, ValueDescription = p.PropertyValue.ValueDescription } }, ProductTitle = _vm.MainPageVM.BasicInfoVM.ProductGroupName + " " + p.PropertyValue.ValueDescription, ProductModel = _vm.MainPageVM.BasicInfoVM.ProductGroupModel + " " + p.PropertyValue.ValueDescription, }; selectProduct.CountryList = this.CountryList; productList.Add(selectProduct); }); } if (_vm.SelectGroupPropertyValue.Count == 2) { _vm.SelectGroupPropertyValue[0].SelectedPropertyValueList .Where(p => p.IsChecked).ToList() .SelectMany(p1 => _vm.SelectGroupPropertyValue[1].SelectedPropertyValueList .Where(p => p.IsChecked).ToList(), (p1, p2) => new { p1, p2 }).ToList().ForEach(p => { var selectProduct = new SelectProduct { PropertyValueList = new List <PropertyValueVM> { new PropertyValueVM { PropertySysNo = _vm.SelectGroupPropertyValue[0].Property.SysNo, SysNo = p.p1.PropertyValue.SysNo, ValueDescription = p.p1.PropertyValue.ValueDescription }, new PropertyValueVM { PropertySysNo = _vm.SelectGroupPropertyValue[1].Property.SysNo, SysNo = p.p2.PropertyValue.SysNo, ValueDescription = p.p2.PropertyValue.ValueDescription } }, ProductTitle = _vm.MainPageVM.BasicInfoVM.ProductGroupName + " " + p.p1.PropertyValue.ValueDescription + " " + p.p2.PropertyValue.ValueDescription, ProductModel = _vm.MainPageVM.BasicInfoVM.ProductGroupModel + " " + p.p1.PropertyValue.ValueDescription + " " + p.p2.PropertyValue.ValueDescription, }; selectProduct.CountryList = this.CountryList; productList.Add(selectProduct); }); } var existProductList = new List <SelectProduct>(); _vm.GroupProductList.ForEach(p => { var product = new SelectProduct { ProductTitle = p.ProductBasicInfo.ProductTitle.Content, ProductModel = p.ProductBasicInfo.ProductModel.Content }; product.CountryList = this.CountryList; p.ProductBasicInfo.ProductProperties.ToList().ForEach(property => { if (_vm.MainPageVM.PropertyVM.ProductGroupSettings .Any(setting => setting.ProductGroupProperty.SysNo == property.Property.PropertyInfo.SysNo)) { if (property.Property.SysNo.HasValue && property.Property.PropertyInfo.SysNo.HasValue) { product.PropertyValueList.Add(new PropertyValueVM { PropertySysNo = property.Property.PropertyInfo.SysNo.Value, PropertyName = property.Property.PropertyInfo.PropertyName.Content, SysNo = property.Property.SysNo.Value, ValueDescription = property.Property.ValueDescription.Content }); } } }); existProductList.Add(product); }); var result = new List <SelectProduct>(); productList.ForEach(p => { if (!existProductList.Contains(p)) { result.Add(p); } }); _vm.SelectedProduct = result; }
public void AddProductInCart() { SelectProduct.Click(); SeeDetails.Click(); AddToCart.Click(); }