public void ReadExcelIntoObjects(string fileName, string productNum)
{
AllProducts.Clear();
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (var package = new ExcelPackage(new FileInfo(fileName)))
{
var firstSheet = package.Workbook.Worksheets["Configured Options"];
int row = 1, j = 1;
for (row = 2; row < firstSheet.Dimension.Rows; row++)
{
ExcelProduct ep = new ExcelProduct();
ep.ProductName = firstSheet.Cells[row, 1].Text;
ep.ProductNumber = firstSheet.Cells[row, 2].Text;
ep.FeatureName = firstSheet.Cells[row, 3].Text;
ep.FeatureRequired = firstSheet.Cells[row, 4].Text;
ep.FeatureCSROnly = firstSheet.Cells[row, 5].Text;
ep.OptionGroupName = firstSheet.Cells[row, 6].Text;
ep.OptionGroupRequired = firstSheet.Cells[row, 7].Text;
ep.OptionGroupCSRonly = firstSheet.Cells[row, 8].Text;
ep.SubOptionGroupName = firstSheet.Cells[row, 9].Text;
ep.SubOptionGroupRequired = firstSheet.Cells[row, 10].Text;
ep.OptionName = firstSheet.Cells[row, 11].Text;
ep.OptionCode = firstSheet.Cells[row, 12].Text;
ep.HCPCS = firstSheet.Cells[row, 13].Text;
ep.OptionRequired = firstSheet.Cells[row, 14].Text;
ep.OptionCSROnly = firstSheet.Cells[row, 15].Text;
ep.WorkTicketInput = firstSheet.Cells[row, 16].Text;
AllProducts.Add(ep);
}
}
}
// GET: Widgets
public ActionResult products()
{
AllProducts model = new AllProducts();
using (ApplicationDbContext _context = new ApplicationDbContext())
{
model.pro = _context.Products.Include(x => x.Category).Include(x => x.Companies)
.Include(x => x.ProductImages).Where(x => x.isDeleted == false && x.Companies.isDeleted == false)
.Select(s => new showAllProducts
{
ID = s.ID,
ProductName = s.ProductName,
ProductDescription = s.ProductDescription,
CategoryName = s.Category.Name,
CompanyName = s.Companies.CompanyName,
IsFeatured = s.IsFeatured,
// Quantity = s.Quantity,
salePrice = s.salePrice,
ProductImages = s.ProductImages.Select(x => x.ImagePath).ToList()
}).OrderByDescending(x => x.ID).Take(8).ToList();
return(PartialView("_products", model));
}
}
public virtual void SearchProducts()
{
if (AllProducts == null)
{
if (Repository == null)
{
throw new ApplicationException("Must set the Repository property.");
}
else
{
// Get data from Repository
AllProducts = Repository.Search(SearchEntity).OrderBy(p => p.Name).ToList();
}
}
// Get data for the Products collection
if (SearchEntity == null)
{
Products = AllProducts.ToList();
}
else
{
Products = AllProducts.Where(p => (SearchEntity.Name == null || p.Name.StartsWith(SearchEntity.Name)) && p.ListPrice >= SearchEntity.ListPrice).ToList();
}
}
public static AllProducts GotoHomePage(AvtorizateData avtorize, IWebDriver driver)
{
Login log = new Login(driver);
AllProducts products = log.SetLogin(avtorize);
return(log.SetPassword(avtorize));
}
public List <AllProducts> AllProducs()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM BrandCategoryProduct";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <AllProducts> allProductses = new List <AllProducts>();
while (reader.Read())
{
AllProducts product = new AllProducts();
product.SerialNo = int.Parse(reader["Id"].ToString());
// product.Purchase_No = reader["Purchase_No"].ToString();
// product.DateTime = int.Parse(reader["DateTime"].ToString());
product.ProductCategory = reader["Category_Name"].ToString();
product.ProductBrand = reader["Brand_Name"].ToString();
product.TotalNumberOfUnit = int.Parse(reader["Unit"].ToString());
// student.DepartmentId = reader["DepartmentId"].ToString() == "" ? (int?)null : int.Parse(reader["DepartmentId"].ToString());
// products.Add(product);
allProductses.Add(product);
}
reader.Close();
connection.Close();
return(allProductses);
}
public IActionResult Products()
{
AllProducts allProducts = new AllProducts();
allProducts.Products = dbContext.Products.ToList();
return(View(allProducts));
}
public ActionResult GetById(long?productId)
{
var inventorylist = new AllProducts();
if (productId != null)
{
var groupName = (GroupName)productId;
var query = new InventoryQuery().GetInventories(groupName.ToString());
if (query != null)
{
foreach (var inventory in query)
{
var inverntoryModel = new InventoriesModel()
{
Id = inventory.Id,
GroupName = groupName.ToString(),
ItemsCount = inventory.ItemsCount,
ProductName = inventory.ProductName
};
inventorylist.InventoriesModels.Add(inverntoryModel);
}
}
}
return(PartialView("ProductsGrid", inventorylist));
}
override public bool Add_product(int SKU, int count)
{
check = ExceptionType.Check_type;
if (check(SKU))
{
throw new ProductException("попытка добавить товар сыпучего типа на склад " + this.name + $" (SKU={SKU})");
//return false;
}
foreach (KeyValuePair <int, int> P in products)
{
if (SKU == P.Key)
{
products[P.Key] += count;
logger.Info("{0}: пополнение товара {1}({2})", this.name, P.Key, P.Value);
return(true);
}
}
Product foundProd = AllProducts.Where(p => p.SKU == SKU).First();
foundProd.storages.Add(this);
logger.Info("{0}: поступил новый товар {1}({2})", this.name, foundProd.name, count);
products.Add(SKU, count);
return(true);
}
public void AddProduct(int ID)
{
Products p = AllProducts.Where(x => x.ID == ID).First();
TotalCost += p.Price;
CheckBalance();
SelectedProducts.Add(p);
}
private void MakeAllProducts()
{
AllProducts.Clear();
foreach (string product in product.ReturnAllProducts())
{
AllProducts.Text += product;
}
}
public void ReloadGrid()
{
CurrentIndex = PageSize;
if (AllProducts.Count > PageSize)
{
CurrentProducts = AllProducts.Take((int)PageSize).ToList();
}
}
public static GotoMyProduct GotoAllProducts(AvtorizateData avtorize, Headers headers, IWebDriver driver)
{
Login log = new Login(driver);
AllProducts products = log.SetLogin(avtorize);
AllProducts products2 = log.SetPassword(avtorize);
return(products.ClickOnNorthWind(headers));
}
public static void RemoveFromCart(int productCode)
{
Product product = AllProducts.Find(i => i.ProductCode == productCode);
if (product != null)
{
product.ItemsCount--;
}
}
public static void AddToCart(int productCode)
{
Product product = AllProducts.Find(i => i.ProductCode == productCode);
if (product != null)
{
product.ItemsCount++;
}
}
public MainPage Delete()
{
AllProducts.Click();
RemoveProduct.Click();
IAlert alert = driver.SwitchTo().Alert();
alert.Accept();
return(new MainPage(driver));
}
public void AddBlankProduct(string name)
{
Products product = new Products()
{
ProductName = name
};
AllProducts.Add(product);
}
public void NewProduct()
{
Products p = new Products();
p.ProductName = "Nieuw Product";
p.Price = 0;
p.Edit = Visibility.Visible;
AllProducts.Add(p);
}
public OrderFormViewModel()
{
Order = StateService.CurrentOrder;
AllCustomers = ComboBoxService.GetOptions(ComboBoxTargets.Customers);
CurrentCustomer = AllCustomers.FirstOrDefault(x => x.ID == Order.CustomerID);
AllEmployees = ComboBoxService.GetOptions(ComboBoxTargets.Employees);
CurrentEmployee = AllEmployees.FirstOrDefault(x => x.ID == Order.EmployeeID);
AllProducts = ComboBoxService.GetOptions(ComboBoxTargets.Products);
CurrentProduct = AllProducts.FirstOrDefault(x => x.ID == Order.ProductID);
}
public List <Product> GetAllProducts(bool slow)
{
//fake a long running query
if (slow)
{
Task.Delay(2000).Wait();
}
return(AllProducts.ToList());
}
private void Request_Progress(AllProducts products)
{
listBox1.Items.Clear();
var myProducts = products;
foreach (var item in myProducts.products)
{
listBox1.Items.Add(item.name);
}
}
#pragma warning disable CS1998 // El método asincrónico carece de operadores "await" y se ejecutará de forma sincrónica
private async Task SeachText()
{
#pragma warning restore CS1998 // El método asincrónico carece de operadores "await" y se ejecutará de forma sincrónica
try
{
if (txtSearch.Length > 2)
{
IsBusy = true;
isSearch = true;
var productsSeach = from x in AllProducts
.Where(x => x.products_name.ToUpper().Contains(txtSearch.ToUpper()))
select x;
dataProducts = new ObservableCollection <Product>();
foreach (var item in productsSeach)
{
dataProducts.Add(item);
}
IsBusy = false;
}
else
{
if (isSearch)
{
dataProducts = new ObservableCollection <Product>();
foreach (var item in AllProducts)
{
dataProducts.Add(item);
}
isSearch = false;
}
}
}
finally
{
if (dataProducts.Count > 0)
{
isBackVisible = false;
}
else
{
isBackVisible = true;
}
IsBusy = false;
}
}
public void FillInventoryProductList()
{
var products = AllProducts.Where(x => x.InventoryId == SelectedInventory.Id);
InventoryProductViewModels.Clear();
foreach (var product in products)
{
InventoryProductViewModels.Add(new InventoryProductViewModel
{
Id = product.Id,
ScannedDate = product.ScannedDate,
ScannedZone = AvailableZones.First(x => x.Id == product.ZoneId).Description
});
}
}
public MainPage Add(string Product, string Price, string Quantity, string Stock, string Order, string Level)
{
AllProducts.Click();
CreateNew.Click();
ProductName.SendKeys(Product);
CategoryID.FindElement(By.XPath("//option[. = 'Seafood']")).Click();
SupplierID.FindElement(By.XPath("//option[. = 'Leka Trading']")).Click();
UnitPrice.SendKeys(Price);
QuantityPerUnit.SendKeys(Quantity);
UnitsInStock.SendKeys(Stock);
UnitsOnOrder.SendKeys(Order);
ReorderLevel.SendKeys(Level);
Confirm.Click();
return(new MainPage(driver));
}
public IActionResult AddProductProcess(AllProducts modelData)
{
if (ModelState.IsValid)
{
Product NewProduct = modelData.Product;
dbContext.Add(NewProduct);
dbContext.SaveChanges();
return(RedirectToAction("Products"));
}
else
{
AllProducts allProducts = new AllProducts();
allProducts.Products = dbContext.Products.ToList();
return(View("Products", allProducts));
}
}
public MainPage Exist()
{
AllProducts.Click();
TestProduct.Click();
Assert.AreEqual(ProductName.GetAttribute("value"), "Test Product");
Assert.AreEqual(CategoryID.FindElement(By.XPath("//option[. = 'Seafood']")).GetAttribute("text"), "Seafood");
Assert.AreEqual(SupplierID.FindElement(By.XPath("//option[. = 'Leka Trading']")).GetAttribute("text"), "Leka Trading");
Assert.AreEqual(UnitPrice.GetAttribute("value"), "111,0000");
Assert.AreEqual(QuantityPerUnit.GetAttribute("value"), "222");
Assert.AreEqual(UnitsInStock.GetAttribute("value"), "333");
Assert.AreEqual(UnitsOnOrder.GetAttribute("value"), "444");
Assert.AreEqual(ReorderLevel.GetAttribute("value"), "555");
Home.Click();
logoutField.Click();
return(new MainPage(driver));
}
private async Task ValidateCategory(string value)
{
if (SetProperty(ref selectedItem, value))
{
Products = AllProducts.Where(item => item.Category.ToLower() == selectedItem.ToLower()).ToList();
if (Products.Count == 0)
{
await dialogService.Show("Nothing to show", "In this demo, only watch products are loaded.", "Close");
navigationService.NavigateBack();
return;
}
var items = await GetCartList();
CartItemCount = items.Count.ToString();
}
}
public void GetNextPage()
{
if (CurrentIndex >= AllProducts.Count)
{
return;
}
var diff = AllProducts.Count - CurrentIndex;
if (diff > PageSize)
{
diff = PageSize;
}
CurrentProducts.Clear();
CurrentProducts = AllProducts.GetRange((int)CurrentIndex, (int)diff);
CurrentIndex += diff;
}
override public bool Add_product(int SKU, int count)
{
foreach (KeyValuePair <int, int> P in products)
{
if (SKU == P.Key)
{
logger.Debug("{0}: пополнение товара {1}({2})", this.name, P.Key, P.Value);
products[P.Key] += count;
return(true);
}
}
Product foundProd = AllProducts.Where(p => p.SKU == SKU).First();
foundProd.storages.Add(this);
logger.Debug("{0}: поступил новый товар {1}({2})", this.name, foundProd.name, count);
products.Add(SKU, count);
return(true);
}
private List <ExcelProduct> BeginsSearch(SearchParam param, string value)
{
switch (param)
{
case SearchParam.FeatureName:
return(AllProducts.Where(p => p.FeatureName.StartsWith(value)).ToList());
case SearchParam.OptionCode:
return(AllProducts.Where(p => p.OptionCode.StartsWith(value)).ToList());
case SearchParam.OptionGroup:
return(AllProducts.Where(p => p.OptionGroupName.StartsWith(value)).ToList());
case SearchParam.OptionName:
return(AllProducts.Where(p => p.OptionName.StartsWith(value)).ToList());
default: return(AllProducts.Where(p => p.OptionCode.StartsWith(value)).ToList());
}
}
private List <ExcelProduct> NotEqualsSearch(SearchParam param, string value)
{
switch (param)
{
case SearchParam.FeatureName:
return(AllProducts.Where(p => p.FeatureName != value).ToList());
case SearchParam.OptionCode:
return(AllProducts.Where(p => p.OptionCode != value).ToList());
case SearchParam.OptionGroup:
return(AllProducts.Where(p => p.OptionGroupName != value).ToList());
case SearchParam.OptionName:
return(AllProducts.Where(p => p.OptionName != value).ToList());
default: return(AllProducts.Where(p => p.OptionCode != value).ToList());
}
}
public virtual int Update(AllProducts dataSet) {
return this.Adapter.Update(dataSet, "Products");
}
public virtual int Update(AllProducts.ProductsDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
public virtual int Fill(AllProducts.ProductsDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
