public void Test_Add_QueryById_Update_Delete_RelatedProductProvider() { var product1 = new Product { Name = "Product1", ShortDescription = "this is product1", FullDescription = "full", UtcCreationDate = DateTime.UtcNow, UtcUpdateDate = DateTime.UtcNow }; var product2 = new Product { Name = "Product2", ShortDescription = "this is product2", FullDescription = "full", UtcCreationDate = DateTime.UtcNow, UtcUpdateDate = DateTime.UtcNow }; var relatedProduct = new RelatedProduct { DisplayOrder = 1, Product1 = product1, Product2 = product2 }; //Add brand ProductProvider productProcider = new ProductProvider(new NoDI_NHibernateContextFactory()); productProcider.Add(product1); productProcider.Add(product2); provider.Add(relatedProduct); Console.WriteLine("Add OK!"); //QueryBy var relatedProductQueryBy = provider.QueryById(relatedProduct.Id); Assert.IsNotNull(relatedProductQueryBy); Console.WriteLine("QueryBy OK!"); //update relatedProduct.DisplayOrder = 5; provider.Update(relatedProduct); var brandUpdate = provider.QueryById(relatedProduct.Id); Assert.AreEqual(5, relatedProduct.DisplayOrder); Console.WriteLine("Update OK!"); //Delete provider.Delete(relatedProduct); var relatedProductDelete = provider.QueryById(relatedProduct.Id); Assert.IsNull(relatedProductDelete); Console.WriteLine("Delete OK!"); }
/// <summary> /// 查询单据详细数据分页 /// </summary> /// <param name="entity"></param> /// <param name="pageInfo"></param> /// <returns></returns> public override List <BadReportDetailEntity> GetDetailList(BadReportDetailEntity entity, ref Framework.DataTypes.PageInfo pageInfo) { BadReportDetailEntity detail = new BadReportDetailEntity(); detail.Where(a => a.CompanyID == this.CompanyID); detail.IncludeAll(); detail.OrderBy(a => a.ID, EOrderBy.DESC); if (entity.OrderSnNum.IsNotEmpty()) { detail.And(item => item.OrderSnNum == entity.OrderSnNum); } if (entity.ProductName.IsNotEmpty()) { detail.And("ProductName", ECondition.Like, "%" + entity.ProductName + "%"); } if (entity.BarCode.IsNotEmpty()) { detail.And("BarCode", ECondition.Like, "%" + entity.BarCode + "%"); } if (entity.StorageNum.IsNotEmpty()) { detail.And(item => item.StorageNum == entity.StorageNum); } BadReportEntity badOrder = new BadReportEntity(); badOrder.Include(item => new { Status = item.Status, BadType = item.BadType, AuditeTime = item.AuditeTime }); detail.Left <BadReportEntity>(badOrder, new Params <string, string>() { Item1 = "OrderSnNum", Item2 = "SnNum" }); badOrder.Where(item => item.IsDelete == (int)EIsDelete.NotDelete); if (entity.OrderNum.IsNotEmpty()) { badOrder.And("OrderNum", ECondition.Like, "%" + entity.OrderNum + "%"); } if (entity.Status > 0) { badOrder.And(item => item.Status == entity.Status); } if (entity.BeginTime.IsNotEmpty()) { DateTime begin = ConvertHelper.ToType <DateTime>(entity.BeginTime, DateTime.Now.AddDays(-30)).Date; badOrder.And(item => item.CreateTime >= begin); } if (entity.EndTime.IsNotEmpty()) { DateTime end = ConvertHelper.ToType <DateTime>(entity.EndTime, DateTime.Now).AddDays(1).Date; badOrder.And(item => item.CreateTime < end); } if (entity.BadType > 0) { badOrder.And(item => item.BadType == entity.BadType); } AdminEntity admin = new AdminEntity(); admin.Include(a => new { CreateUserName = a.UserName }); badOrder.Left <AdminEntity>(admin, new Params <string, string>() { Item1 = "CreateUser", Item2 = "UserNum" }); AdminEntity auditeAdmin = new AdminEntity(); auditeAdmin.Include(a => new { AuditUserName = a.UserName }); badOrder.Left <AdminEntity>(auditeAdmin, new Params <string, string>() { Item1 = "AuditUser", Item2 = "UserNum" }); int rowCount = 0; List <BadReportDetailEntity> listResult = this.BadReportDetail.GetList(detail, pageInfo.PageSize, pageInfo.PageIndex, out rowCount); pageInfo.RowCount = rowCount; if (!listResult.IsNullOrEmpty()) { List <LocationEntity> listLocation = new LocationProvider(this.CompanyID).GetList(); listLocation = listLocation == null ? new List <LocationEntity>() : listLocation; ProductProvider productProvider = new ProductProvider(this.CompanyID); foreach (BadReportDetailEntity item in listResult) { LocationEntity location = listLocation.FirstOrDefault(a => a.LocalNum == item.FromLocalNum); item.FromLocalName = location == null ? "" : location.LocalName; location = listLocation.FirstOrDefault(a => a.LocalNum == item.ToLocalNum); item.ToLocalName = location == null ? "" : location.LocalName; item.StorageName = location.StorageName; ProductEntity product = productProvider.GetProduct(item.ProductNum); item.Size = product != null ? product.Size : string.Empty; item.UnitName = product != null ? product.UnitName : string.Empty; } } return(listResult); }
/// <summary> /// 查询单据详细数据分页 /// </summary> /// <param name="entity"></param> /// <param name="pageInfo"></param> /// <returns></returns> public override List <SaleDetailEntity> GetDetailList(SaleDetailEntity entity, ref PageInfo pageInfo) { SaleDetailEntity detail = new SaleDetailEntity(); detail.And(a => a.CompanyID == this.CompanyID) ; if (!entity.BarCode.IsEmpty()) { detail.And("BarCode", ECondition.Like, "%" + entity.BarCode + "%"); } if (!entity.ProductName.IsEmpty()) { detail.And("ProductName", ECondition.Like, "%" + entity.ProductName + "%"); } SaleOrderEntity SaleOrder = new SaleOrderEntity(); detail.Left <SaleOrderEntity>(SaleOrder, new Params <string, string>() { Item1 = "OrderSnNum", Item2 = "SnNum" }); SaleOrder.Include(a => new { CusNum = a.CusNum, CusName = a.CusName, Phone = a.Phone, CusOrderNum = a.CusOrderNum, Address = a.Address, SendDate = a.SendDate, OrderTime = a.OrderTime, AuditeStatus = a.AuditeStatus, OrderStatus = a.Status, OrderAmount = a.Amount, HasReturn = a.HasReturn }); SaleOrder.And(a => a.IsDelete == (int)EIsDelete.NotDelete); if (!entity.CusNum.IsEmpty()) { SaleOrder.AndBegin <SaleOrderEntity>() .And <SaleOrderEntity>("CusNum", ECondition.Like, "%" + entity.CusNum + "%") .Or <SaleOrderEntity>("CusName", ECondition.Like, "%" + entity.CusNum + "%") .End <SaleOrderEntity>() ; } if (!entity.CusName.IsEmpty()) { SaleOrder.AndBegin <SaleOrderEntity>() .And <SaleOrderEntity>("CusNum", ECondition.Like, "%" + entity.CusName + "%") .Or <SaleOrderEntity>("CusName", ECondition.Like, "%" + entity.CusName + "%") .End <SaleOrderEntity>() ; } if (!entity.Phone.IsEmpty()) { SaleOrder.And("Phone", ECondition.Like, "%" + entity.Phone + "%"); } if (!entity.OrderNum.IsEmpty()) { SaleOrder.And("OrderNum", ECondition.Like, "%" + entity.OrderNum + "%"); } if (!entity.OrderSnNum.IsEmpty()) { SaleOrder.And(item => item.SnNum == entity.OrderSnNum); } if (entity.Status > 0) { SaleOrder.And(item => item.Status == entity.Status); } if (entity.AuditeStatus > -1) { SaleOrder.And(item => item.AuditeStatus == entity.AuditeStatus); } if (!entity.ContractOrder.IsEmpty()) { SaleOrder.And(item => item.ContractOrder == entity.ContractOrder); } if (!entity.CusOrderNum.IsEmpty()) { SaleOrder.And(item => item.CusOrderNum == entity.CusOrderNum); } if (!entity.BeginTime.IsEmpty()) { DateTime time = ConvertHelper.ToType <DateTime>(entity.BeginTime, DateTime.Now).Date; SaleOrder.And(a => a.CreateTime >= time); } if (!entity.EndTime.IsEmpty()) { DateTime time = ConvertHelper.ToType <DateTime>(entity.EndTime, DateTime.Now).Date.AddDays(1); SaleOrder.And(a => a.CreateTime < time); } detail.IncludeAll(); detail.OrderBy(a => a.ID, EOrderBy.DESC); int rowCount = 0; List <SaleDetailEntity> listResult = this.SaleDetail.GetList(detail, pageInfo.PageSize, pageInfo.PageIndex, out rowCount); pageInfo.RowCount = rowCount; if (!listResult.IsNullOrEmpty()) { ProductProvider productProvider = new ProductProvider(this.CompanyID); foreach (SaleDetailEntity item in listResult) { ProductEntity product = productProvider.GetProduct(item.ProductNum); item.UnitName = product != null ? product.UnitName : string.Empty; item.Size = product != null ? product.Size : string.Empty; } } return(listResult); }
public CheckoutController(CartProvider cartProvider, ProductProvider productProvider) { CartProvider = cartProvider; ProductProvider = productProvider; }
public CustomClassificationQuery(ProductProvider provider) : base(provider) { }
public object ProductDelete(int productID) { return(JsonConvert.SerializeObject(ProductProvider.productDelete(dbConnection, productID))); }
public static IList <Product> GetProductByCategory(int categoryID) { return(ProductProvider.getProductByCategory(dbConnection, categoryID)); }
public static Product GetProductByID(int productID) { return(ProductProvider.getProductByID(dbConnection, productID)); }
public void GivenIHaveEnteredTwoButterTwoBread() { Basket.Add(new App.BasketItem(ProductProvider.Find("butter").Id, 2)); Basket.Add(new App.BasketItem(ProductProvider.Find("bread").Id, 2)); }
protected void btnAdd_OnClick(object sender, EventArgs e) { this.AlertNone(lblMsg); ProductProvider productProvider = new ProductProvider(); AjaxControlToolkit.ComboBox ddlProductValidation = (AjaxControlToolkit.ComboBox)UC_ProductSearch1.FindControl("ddlProduct"); if (ddlProductValidation.SelectedValue == "") { MessageHelper.ShowAlertMessage("Select Product!"); lblMsg.Focus(); return; } string measurementUnit = productProvider.GetMeasurementUnit(ddlProductValidation.SelectedValue.Toint()); List <ProductionRequisitionDetailProvider> purchaseLedgerDetailsProviderList = new List <ProductionRequisitionDetailProvider>(); foreach (GridViewRow row in gvPurchaseForLSE.Rows) { ProductionRequisitionDetailProvider obj = new ProductionRequisitionDetailProvider(); HiddenField hfRowProductID = (HiddenField)row.FindControl("hfProductID"); Label lblProductName = (Label)row.FindControl("lblProduct"); TextBox txtRequiredQuantity = (TextBox)row.FindControl("txtRequiredQuantity"); TextBox txtUnit = (TextBox)row.FindControl("txtUnit"); TextBox txtSentQuantity = (TextBox)row.FindControl("txtSentQuantity"); TextBox txtPresentStock = (TextBox)row.FindControl("txtPresentStock"); TextBox txtRemarks = (TextBox)row.FindControl("txtRemarks"); Label lblTotalAmount = (Label)row.FindControl("lblTotalAmount"); ImageButton btnAddOrDelete = (ImageButton)row.FindControl("btnDeleteSelectedRowLSE"); if (hfRowProductID.Value == ddlProductValidation.SelectedValue) { MessageHelper.ShowAlertMessage("This product already added!"); return; } if (txtRequiredQuantity.Text.ToDecimal() <= 0) { MessageHelper.ShowAlertMessage("Enter Quantity!"); return; } obj.ProductID = hfRowProductID.Value.Toint(); obj.PresentStock = txtPresentStock.Text.ToDecimal(); obj.RawProductName = lblProductName.Text.ToString(); obj.MeasurementUnitName = txtUnit.Text.ToString(); obj.RequiredQuantity = txtRequiredQuantity.Text.ToDecimal(); obj.SentQuantity = txtSentQuantity.Text.ToDecimal(); obj.Remarks = txtRemarks.Text.ToString(); purchaseLedgerDetailsProviderList.Add(obj); } AjaxControlToolkit.ComboBox ddlProduct = (AjaxControlToolkit.ComboBox)UC_ProductSearch1.FindControl("ddlProduct"); string productName = ddlProduct.SelectedItem.Text; int productID = ddlProduct.SelectedValue.Toint(); ProductionRequisitionDetailProvider obj2 = new ProductionRequisitionDetailProvider(); obj2.ProductID = productID; obj2.RawProductName = productName; obj2.MeasurementUnitName = measurementUnit; obj2.PresentStock = productProvider.GetPresentStock(obj2.ProductID); purchaseLedgerDetailsProviderList.Add(obj2); if (!divGridForLSE.Visible) { divGridForLSE.Visible = true; } gvPurchaseForLSE.DataSource = purchaseLedgerDetailsProviderList; gvPurchaseForLSE.DataBind(); }
public ProductController(ProductProvider productProvider, ProductCategoryProvider productCategoryProvider, IMapper mapper) { this.mapper = mapper; this.productProvider = productProvider; this.productCategoryProvider = productCategoryProvider; }
public TempController(DataContext context, ProductProvider productProvider) { _context = context; _productProvider = productProvider; }
public ProductController() { productProvider = new ProductProvider(); }
protected void btnAdd_OnClick(object sender, EventArgs e) { this.AlertNone(lblMsg); ProductProvider productProvider = new ProductProvider(); string measurementUnit = productProvider.GetMeasurementUnit(ddlFinishedProduct.SelectedValue.Toint()); string packSize = productProvider.GetPackSizeName(ddlFinishedProduct.SelectedValue.Toint()); string code = productProvider.GetFinishedProductCode(ddlFinishedProduct.SelectedValue.Toint()); decimal tradePrice = productProvider.GetTradePrice(ddlFinishedProduct.SelectedValue.Toint()); if (ddlFinishedProduct.SelectedValue == "") { MessageHelper.ShowAlertMessage("Select Product!"); lblMsg.Focus(); return; } List <FinishedProductProvider> purchaseLedgerDetailsProviderList = new List <FinishedProductProvider>(); foreach (GridViewRow row in gvRequisition.Rows) { FinishedProductProvider obj = new FinishedProductProvider(); HiddenField hfRowProductID = (HiddenField)row.FindControl("hfProductID"); Label lblProductName = (Label)row.FindControl("lblProduct"); Label lblPackSize = (Label)row.FindControl("lblPackSize"); Label lblBatchNo = (Label)row.FindControl("lblBatchNo"); Label lblUnit = (Label)row.FindControl("lblUnit"); Label lblTradePrice = (Label)row.FindControl("lblTradePrice"); TextBox txtBatchQuantity = (TextBox)row.FindControl("txtBatchQuantity"); Label lblTotalTradePrice = (Label)row.FindControl("lblTotalTradePrice"); ImageButton btnAddOrDelete = (ImageButton)row.FindControl("btnDeleteSelectedRowLSE"); if (hfRowProductID.Value == ddlFinishedProduct.SelectedValue) { MessageHelper.ShowAlertMessage("This product already exists!"); return; } if (txtBatchQuantity.Text.ToDecimal() <= 0) { MessageHelper.ShowAlertMessage("Enter Quantity!"); return; } obj.ProductID = hfRowProductID.Value.Toint(); obj.ProductName = lblProductName.Text.ToString(); obj.BatchQuantity = txtBatchQuantity.Text.ToDecimal(); obj.PackSize = lblPackSize.Text; obj.BatchNo = lblBatchNo.Text; obj.MeasurementUnitName = lblUnit.Text.ToString(); obj.TradePrice = lblTradePrice.Text.ToDecimal(); obj.TotalTradePrice = lblTotalTradePrice.Text.ToDecimal(); purchaseLedgerDetailsProviderList.Add(obj); } string productName = ddlFinishedProduct.SelectedItem.Text; int productID = ddlFinishedProduct.SelectedValue.Toint(); FinishedProductProvider obj2 = new FinishedProductProvider(); DataTable dt = obj2.GetBatchWiseMFCExpDate(ddlBatchNo.SelectedItem.ToString()); obj2.ProductID = productID; obj2.ProductName = productName; obj2.ProductCode = code; obj2.MeasurementUnitName = measurementUnit; obj2.PackSize = packSize; obj2.TradePrice = tradePrice; obj2.BatchNo = ddlBatchNo.SelectedItem.ToString(); obj2.MfgDate = DateTime.ParseExact(dt.Rows[0]["MfgDate"].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture); obj2.MfgDate = DateTime.ParseExact(dt.Rows[0]["ExpDate"].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture); purchaseLedgerDetailsProviderList.Add(obj2); if (!divGridForLSE.Visible) { divGridForLSE.Visible = true; } gvRequisition.DataSource = purchaseLedgerDetailsProviderList; gvRequisition.DataBind(); ddlDivision.Enabled = false; }
public async Task GetProductsTest() { var products = await ProductProvider.GetProducts(); Assert.IsInstanceOfType(products, typeof(IEnumerable <Product>)); }
public static IList <Product> GetAllProduct() { return(ProductProvider.getProduct(dbConnection)); }
public void GivenIHaveEnteredFourMilk() { Basket.Add(new App.BasketItem(ProductProvider.Find("milk").Id, 4)); }
public static IList <Product> GetProductByName(string productName) { return(ProductProvider.getProduct(dbConnection, productName)); }
public void GivenIHaveEnteredTwoButterOneBreadEightMilk() { Basket.Add(new App.BasketItem(ProductProvider.Find("butter").Id, 2)); Basket.Add(new App.BasketItem(ProductProvider.Find("bread").Id, 1)); Basket.Add(new App.BasketItem(ProductProvider.Find("milk").Id, 8)); }
public static HttpResult ProductMerge(Product product) { return(ProductProvider.productMerge(dbConnection, product)); }
public List <Product> GetProducts() { IProductProvider p = new ProductProvider(); return(p.GetProducts()); }
private bool IsSupported(SoftwareInfo software) { return(ProductProvider.GetProductNames() .Contains(software.Product.Name, StringComparer.InvariantCulture)); }
public ProductService() { productProvider = new ProductProvider(); }
public static void CriarDadosIniciais() { var jsonUser = ApiClient <User> .Request(GetUsersEndpoint(), Method.POST, UsuarioProvider.CriarUsuario()); LastUserId = jsonUser.Id; var jsonLogin = ApiClient <Login> .Request(GetLoginEndpoint(), Method.POST, UsuarioProvider.RealizarLogin()); LastToken = jsonLogin.Authorization; var jsonProduct = ApiClient <Product> .Request(GetProductId(), Method.POST, ProductProvider.CadastrarProduto(), LastToken); LastProductId = jsonProduct.Id; }
private IEnumerable <CategoryInfo> GetCategories() { return(ProductProvider.GetCategoryNames() .Select(CreateCategory)); }