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