public async Task <ActionResult <ProductsEntity> > Put(int id, [FromBody] ProductsEntity product, [FromServices] DataContext context)
{
if (id != product.Id)
{
return(NotFound(new { message = "Produto não foi encontrado" }));
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
context.Entry(product).State = EntityState.Modified;
await context.SaveChangesAsync();
return(Ok(new { message = "O produto foi atualizado" }));
}
catch (Exception)
{
return(BadRequest(new { message = "Não foi possivel atualizar o produto" }));
}
}
public void Insert(LoadProductRequest request)
{
try
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
ProductsEntity productEntity = new ProductsEntity()
{
Description = request.Description,
Name = request.Name,
IdMarca = request.idMarca,
Stock = request.Stock,
Price = request.Price,
IdCategory = request.IdCategory,
IdSubCategory = request.IdSubCategory,
Recipe = request.Recipe,
IdResoruce = request.IdResoruce
};
context.ProductsEntity.Add(productEntity);
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("ProductDataAccess.Insert : ERROR : " + ex.Message);
throw;
}
}
/// <summary>
/// 得到 products 数据实体
/// </summary>
/// <param name="dr">dr</param>
/// <returns>products 数据实体</returns>
public ProductsEntity Populate_ProductsEntity_FromDr(IDataReader dr)
{
ProductsEntity Obj = new ProductsEntity();
Obj.ProductId = ((dr["ProductId"]) == DBNull.Value)?0:Convert.ToInt32(dr["ProductId"]);
Obj.ShopId = ((dr["ShopId"]) == DBNull.Value)?0:Convert.ToInt32(dr["ShopId"]);
Obj.CategoryId = ((dr["CategoryId"]) == DBNull.Value)?0:Convert.ToInt32(dr["CategoryId"]);
Obj.Name = dr["Name"].ToString();
Obj.Intro = dr["Intro"].ToString();
Obj.Description = dr["Description"].ToString();
Obj.Image1 = dr["Image1"].ToString();
Obj.Image2 = dr["Image2"].ToString();
Obj.Image3 = dr["Image3"].ToString();
Obj.Image4 = dr["Image4"].ToString();
Obj.Image5 = dr["Image5"].ToString();
Obj.OriginPrice = ((dr["OriginPrice"]) == DBNull.Value) ? 0 : Convert.ToDecimal(dr["OriginPrice"]);
Obj.CostPrice = ((dr["CostPrice"]) == DBNull.Value)?0:Convert.ToDecimal(dr["CostPrice"]);
Obj.SalePrice = ((dr["SalePrice"]) == DBNull.Value)?0:Convert.ToDecimal(dr["SalePrice"]);
Obj.Commission = ((dr["Commission"]) == DBNull.Value)?0:Convert.ToDecimal(dr["Commission"]);
Obj.Status = ((dr["Status"]) == DBNull.Value)?0:Convert.ToInt32(dr["Status"]);
Obj.AddTime = ((dr["AddTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["AddTime"]);
Obj.UpdateTime = ((dr["UpdateTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["UpdateTime"]);
Obj.OrderBy = ((dr["OrderBy"]) == DBNull.Value)?0:Convert.ToInt32(dr["OrderBy"]);
Obj.IsCommission = ((dr["IsCommission"]) == DBNull.Value)?0:Convert.ToInt32(dr["IsCommission"]);
Obj.ProductCode = dr["ProductCode"].ToString();
Obj.Stock = ((dr["Stock"]) == DBNull.Value)?0:Convert.ToInt32(dr["Stock"]);
Obj.IsNew = ((dr["IsNew"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["IsNew"]);
Obj.IsHot = ((dr["IsHot"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["IsHot"]);
Obj.CategoryId2 = ((dr["CategoryId2"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["CategoryId2"]);
return(Obj);
}
public async Task <bool> AddProductToStoreAsync(string storeName, string productName)
{
StoresEntity stores = await context.Stores.FirstOrDefaultAsync(s => s.Name == storeName);
if (stores == null)
{
throw new NoExistInDbException(ExceptionMessages.CannotAddProductToStoreSTORE());
}
ProductsEntity products = await context.Products.FirstOrDefaultAsync(p => p.Name == productName);
if (products == null)
{
throw new NoExistInDbException(ExceptionMessages.CannotAddProductToStorePRODUCT());
}
stores.StoreProduct = new List <ProductsAndStoresEntity>();
stores.StoreProduct.Add(new ProductsAndStoresEntity {
ProductId = products.Id
});
try
{
return((await context.SaveChangesAsync()) > 0);
}
catch (DbUpdateException dbe)
{
throw new ExistsInDBException(ExceptionMessages.CannotAddProductToStore(), dbe);
}
}
public List <ProductsEntity> ObtenerProductos()
{
var capaData = new Data.CapaData();
List <ProductsEntity> ListaProductos = new List <ProductsEntity>();
foreach (var item in capaData.GetProducts())
{
ProductsEntity Producto = new ProductsEntity()
{
Id = item.Id,
IdBrand = item.IdBrand,
IdCatalog = item.IdCatalog,
IdColor = item.IdColor,
IdProvider = item.IdProvider,
IdType = item.IdType,
Tittle = item.Title,
Nombre = item.Nombre,
Description = item.Description,
Observations = item.Observations,
PriceDistributor = item.PriceDistributor,
PriceClient = item.PriceClient,
PriceMember = item.PriceMember,
IsEnabled = item.IsEnabled,
Keywords = item.Keywords,
DateUpdate = item.DateUpdate,
Image = item.ImagesProduct.Select(x => x.Image).ToList(),
};
ListaProductos.Add(Producto);
}
return(ListaProductos);
}
public ProductsEntity ShowProduct(int id)
{
var data = new Data.CapaData();
var product = data.ShowProduct(id);
ProductsEntity producto = new ProductsEntity();
producto.Id = id;
producto.IdBrand = product.IdBrand;
producto.IdCatalog = product.IdCatalog;
producto.IdColor = product.IdColor;
producto.IdProvider = product.IdProvider;
producto.IdType = product.IdType;
producto.Nombre = product.Nombre;
producto.Tittle = product.Title;
producto.Description = product.Description;
producto.Observations = producto.Observations;
producto.PriceClient = product.PriceClient;
producto.PriceDistributor = product.PriceDistributor;
producto.PriceMember = product.PriceMember;
producto.Image = product.ImagesProduct.Select(x => x.Image).ToList();
producto.IsEnabled = product.IsEnabled;
producto.ImageP = product.ImagesProduct.Select(x => x.IdImage).ToList();
producto.DateUpdate = producto.DateUpdate;
return(producto);
}
/// <summary>
/// 向数据库中插入一条新记录。
/// </summary>
/// <param name="_ProductsModel">Products实体</param>
/// <returns>新插入记录的编号</returns>
public int Insert(ProductsEntity _ProductsModel)
{
string sqlStr = "insert into Products([ShopId],[CategoryId],[Name],[Intro],[Description],[Image1],[Image2],[Image3],[Image4],[Image5],[CostPrice],[SalePrice],[Commission],[Status],[AddTime],[UpdateTime],[OrderBy],[IsCommission],[ProductCode],[Stock],[OriginPrice],[IsNew],[IsHot],[CategoryId2]) values(@ShopId,@CategoryId,@Name,@Intro,@Description,@Image1,@Image2,@Image3,@Image4,@Image5,@CostPrice,@SalePrice,@Commission,@Status,@AddTime,@UpdateTime,@OrderBy,@IsCommission,@ProductCode,@Stock,@OriginPrice,@IsNew,@IsHot,@CategoryId2) select @@identity";
int res;
SqlParameter[] _param =
{
new SqlParameter("@ShopId", SqlDbType.Int),
new SqlParameter("@CategoryId", SqlDbType.Int),
new SqlParameter("@Name", SqlDbType.VarChar),
new SqlParameter("@Intro", SqlDbType.VarChar),
new SqlParameter("@Description", SqlDbType.VarChar),
new SqlParameter("@Image1", SqlDbType.VarChar),
new SqlParameter("@Image2", SqlDbType.VarChar),
new SqlParameter("@Image3", SqlDbType.VarChar),
new SqlParameter("@Image4", SqlDbType.VarChar),
new SqlParameter("@Image5", SqlDbType.VarChar),
new SqlParameter("@CostPrice", SqlDbType.Decimal),
new SqlParameter("@SalePrice", SqlDbType.Decimal),
new SqlParameter("@Commission", SqlDbType.Decimal),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@OrderBy", SqlDbType.Int),
new SqlParameter("@IsCommission", SqlDbType.Int),
new SqlParameter("@ProductCode", SqlDbType.VarChar),
new SqlParameter("@Stock", SqlDbType.Int),
new SqlParameter("@OriginPrice", SqlDbType.Decimal),
new SqlParameter("@IsNew", SqlDbType.Int),
new SqlParameter("@IsHot", SqlDbType.Int),
new SqlParameter("@CategoryId2", SqlDbType.Int)
};
_param[0].Value = _ProductsModel.ShopId;
_param[1].Value = _ProductsModel.CategoryId;
_param[2].Value = _ProductsModel.Name;
_param[3].Value = _ProductsModel.Intro;
_param[4].Value = _ProductsModel.Description;
_param[5].Value = _ProductsModel.Image1;
_param[6].Value = _ProductsModel.Image2;
_param[7].Value = _ProductsModel.Image3;
_param[8].Value = _ProductsModel.Image4;
_param[9].Value = _ProductsModel.Image5;
_param[10].Value = _ProductsModel.CostPrice;
_param[11].Value = _ProductsModel.SalePrice;
_param[12].Value = _ProductsModel.Commission;
_param[13].Value = _ProductsModel.Status;
_param[14].Value = _ProductsModel.AddTime;
_param[15].Value = _ProductsModel.UpdateTime;
_param[16].Value = _ProductsModel.OrderBy;
_param[17].Value = _ProductsModel.IsCommission;
_param[18].Value = _ProductsModel.ProductCode;
_param[19].Value = _ProductsModel.Stock;
_param[20].Value = _ProductsModel.OriginPrice;
_param[21].Value = _ProductsModel.IsNew;
_param[22].Value = _ProductsModel.IsHot;
_param[23].Value = _ProductsModel.CategoryId2;
res = Convert.ToInt32(SqlHelper.ExecuteScalar(WebConfig.WfxRW, CommandType.Text, sqlStr, _param));
return(res);
}
/// <summary>
/// 向数据表Products更新一条记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="_ProductsModel">_ProductsModel</param>
/// <returns>影响的行数</returns>
public int Update(SqlTransaction sp, ProductsEntity _ProductsModel)
{
string sqlStr = "update Products set [ShopId]=@ShopId,[CategoryId]=@CategoryId,[Name]=@Name,[Intro]=@Intro,[Description]=@Description,[Image1]=@Image1,[Image2]=@Image2,[Image3]=@Image3,[Image4]=@Image4,[Image5]=@Image5,[CostPrice]=@CostPrice,[SalePrice]=@SalePrice,[Commission]=@Commission,[Status]=@Status,[AddTime]=@AddTime,[UpdateTime]=@UpdateTime,[OrderBy]=@OrderBy,[IsCommission]=@IsCommission,[ProductCode]=@ProductCode,[Stock]=@Stock,[OriginPrice]=@OriginPrice,[IsNew]=@IsNew,[IsHot]=@IsHot,[CategoryId2]=@CategoryId2 where ProductId=@ProductId";
SqlParameter[] _param =
{
new SqlParameter("@ProductId", SqlDbType.Int),
new SqlParameter("@ShopId", SqlDbType.Int),
new SqlParameter("@CategoryId", SqlDbType.Int),
new SqlParameter("@Name", SqlDbType.VarChar),
new SqlParameter("@Intro", SqlDbType.VarChar),
new SqlParameter("@Description", SqlDbType.VarChar),
new SqlParameter("@Image1", SqlDbType.VarChar),
new SqlParameter("@Image2", SqlDbType.VarChar),
new SqlParameter("@Image3", SqlDbType.VarChar),
new SqlParameter("@Image4", SqlDbType.VarChar),
new SqlParameter("@Image5", SqlDbType.VarChar),
new SqlParameter("@CostPrice", SqlDbType.Decimal),
new SqlParameter("@SalePrice", SqlDbType.Decimal),
new SqlParameter("@Commission", SqlDbType.Decimal),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@OrderBy", SqlDbType.Int),
new SqlParameter("@IsCommission", SqlDbType.Int),
new SqlParameter("@ProductCode", SqlDbType.VarChar),
new SqlParameter("@Stock", SqlDbType.Int),
new SqlParameter("@OriginPrice", SqlDbType.Decimal),
new SqlParameter("@IsNew", SqlDbType.Int),
new SqlParameter("@IsHot", SqlDbType.Int),
new SqlParameter("@CategoryId2", SqlDbType.Int)
};
_param[0].Value = _ProductsModel.ProductId;
_param[1].Value = _ProductsModel.ShopId;
_param[2].Value = _ProductsModel.CategoryId;
_param[3].Value = _ProductsModel.Name;
_param[4].Value = _ProductsModel.Intro;
_param[5].Value = _ProductsModel.Description;
_param[6].Value = _ProductsModel.Image1;
_param[7].Value = _ProductsModel.Image2;
_param[8].Value = _ProductsModel.Image3;
_param[9].Value = _ProductsModel.Image4;
_param[10].Value = _ProductsModel.Image5;
_param[11].Value = _ProductsModel.CostPrice;
_param[12].Value = _ProductsModel.SalePrice;
_param[13].Value = _ProductsModel.Commission;
_param[14].Value = _ProductsModel.Status;
_param[15].Value = _ProductsModel.AddTime;
_param[16].Value = _ProductsModel.UpdateTime;
_param[17].Value = _ProductsModel.OrderBy;
_param[18].Value = _ProductsModel.IsCommission;
_param[19].Value = _ProductsModel.ProductCode;
_param[20].Value = _ProductsModel.Stock;
_param[21].Value = _ProductsModel.OriginPrice;
_param[22].Value = _ProductsModel.IsNew;
_param[23].Value = _ProductsModel.IsHot;
_param[24].Value = _ProductsModel.CategoryId2;
return(SqlHelper.ExecuteNonQuery(sp, CommandType.Text, sqlStr, _param));
}
public ActionResult Edit(int id, ProductsEntity model)
{
if (model.Description == null || model.Description == "" || model.Observations == null || model.Observations == "" || model.Keywords == null || model.Keywords == "")
{
model.Description = "";
model.Observations = "";
model.Keywords = "";
}
bussines.Edit(id, model);
return(View("Index", bussines.ObtenerProductos()));
}
public bool Delete(Guid Id)
{
bool toReturn = false;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
ProductsEntity _ProductsEntity = new ProductsEntity(Id);
if (adapter.FetchEntity(_ProductsEntity))
{
adapter.DeleteEntity(_ProductsEntity);
toReturn = true;
}
}
return toReturn;
}
public async Task <ProductStruct> GetOneAsync(string name)
{
ProductsEntity productEntity = await context.Products.Include(c => c.ProductStore).SingleOrDefaultAsync(s => s.Name == name);
if (productEntity == null)
{
throw new NoExistInDbException(ExceptionMessages.CannotFindStore());
}
return(new ProductStruct
{
Name = productEntity.Name,
Description = productEntity.Description,
Id = productEntity.Id
});
}
public ActionResult FileUpload(ProductsEntity pro, HttpPostedFileBase file, int id)
{
string pic = System.IO.Path.GetFileName(file.FileName);
if (file != null)
{
using (MemoryStream ms = new MemoryStream())
{
file.InputStream.CopyTo(ms);
byte[] array = ms.GetBuffer();
bussines.AddImage(array, id); //id
}
}
return(RedirectToAction("Index"));
}
public async Task UpdateProduct(Products products)
{
CloudTableClient tableClient = _storageAccount.CreateCloudTableClient();
CloudTable table = tableClient.GetTableReference("Products");
var productsEntity = new ProductsEntity
{
RowKey = products.Name,
PartitionKey = "Ingredient",
Description = products.Description,
Quantity = products.Quantity
};
var operation = TableOperation.InsertOrReplace(productsEntity);
await table.ExecuteAsync(operation);
}
private void productSelectComboBox_SelectedIndexChanged(object sender, System.EventArgs e)
{
// get the selected product
if (productSelectComboBox.SelectedItem == null)
{
return;
}
ProductsEntity selectedProduct = (ProductsEntity)productSelectComboBox.SelectedItem;
EntityCollection customers = (EntityCollection)MainForm.DalService.GetAllCustomersFilteredOnProduct(selectedProduct.ProductId);
customers.AllowNew = false;
// bind them
customersDataGrid.DataSource = customers;
_amountUnitsSoldTextBox.Text = MainForm.DalService.GetNumerOfTimesProductWasSold(selectedProduct.ProductId).ToString();
}
public async Task <IActionResult> Update([FromBody] ProductsEntity productsEntity)
{
try
{
var product = db.Products.Find(productsEntity.productId);
product.ProductId = productsEntity.productId;
product.ProductName = productsEntity.productName;
product.BrandId = productsEntity.brandId;
product.CategoryId = productsEntity.categoryId;
product.ModelYear = productsEntity.modelYear;
product.ListPrice = productsEntity.listPrice;
db.SaveChanges();
return(Ok(product));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
/// <summary>
/// Gets a collection of Products sorted by the passed in filed name, and direction of sort.
/// </summary>
/// <param name="sortOnField">field name to sort upon</param>
/// <param name="direction">direction of sort</param>
/// <returns>a sorted products collection</returns>
/// <remarks>Shows how to use message parameters to specify sorting.
/// </remarks>
public IEntityCollection2 GetProductsSortedBy(string sortOnField, SortOperator direction)
{
EntityCollection toReturn = new EntityCollection(new ProductsEntityFactory());
ProductsEntity product = new ProductsEntity();
SortExpression sorter = null;
IEntityField2 sortField = product.Fields[sortOnField];
if (sortField != null)
{
sorter = new SortExpression(new SortClause(sortField, null, direction));
}
using (DataAccessAdapter adapter = new DataAccessAdapter())
{
// fetch all products, sorted on the sort expression passed in
adapter.FetchEntityCollection(toReturn, null, 0, sorter);
}
return(toReturn);
}
public async Task <bool> RemoveProductFromStoreAsync(string storeName, string productName)
{
StoresEntity stores = await context.Stores.Include(c => c.StoreProduct).FirstOrDefaultAsync(s => s.Name == storeName);
if (stores == null)
{
throw new NoExistInDbException(ExceptionMessages.CannotRemoveProductFromStoreSTORE());
}
ProductsEntity products = await context.Products.Include(c => c.ProductStore).FirstOrDefaultAsync(p => p.Name == productName);
if (products == null)
{
throw new NoExistInDbException(ExceptionMessages.CannotRemoveProductFromStoreSTORE());
}
ProductsAndStoresEntity ps = stores.StoreProduct.Single(s => s.ProductId == products.Id && s.StoreId == stores.Id);
stores.StoreProduct.Remove(ps);
context.Stores.Update(stores);
return((await context.SaveChangesAsync()) > 0);
}
/// <summary>
/// 根据ID,返回一个Products对象
/// </summary>
/// <param name="productId">productId</param>
/// <returns>Products对象</returns>
public ProductsEntity Get_ProductsEntity(int productId)
{
ProductsEntity _obj = null;
SqlParameter[] _param =
{
new SqlParameter("@ProductId", SqlDbType.Int)
};
_param[0].Value = productId;
string sqlStr = "select * from Products with(nolock) where ProductId=@ProductId";
using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.WfxRW, CommandType.Text, sqlStr, _param))
{
while (dr.Read())
{
_obj = Populate_ProductsEntity_FromDr(dr);
}
}
return(_obj);
}
public async Task <IActionResult> Add([FromBody] ProductsEntity productsEntity)
{
try
{
var product = new Products()
{
ProductId = productsEntity.productId,
ProductName = productsEntity.productName,
BrandId = productsEntity.brandId,
CategoryId = productsEntity.categoryId,
ModelYear = productsEntity.modelYear,
ListPrice = productsEntity.listPrice
};
db.Products.Add(product);
db.SaveChanges();
return(Ok(product));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public void GuardarProducto(ProductsEntity model)
{
Products Producto = new Products();
Producto.IdBrand = model.IdBrand;
Producto.IdCatalog = model.IdCatalog;
Producto.IdColor = model.IdColor;
Producto.IdProvider = model.IdProvider;
Producto.IdType = model.IdType;
Producto.Title = model.Tittle;
Producto.Nombre = model.Nombre;
Producto.Description = model.Description;
Producto.Observations = model.Observations;
Producto.PriceClient = model.PriceClient;
Producto.PriceDistributor = model.PriceDistributor;
Producto.PriceMember = model.PriceMember;
Producto.IsEnabled = model.IsEnabled;
Producto.Keywords = model.Keywords;
Producto.DateUpdate = DateTime.Now;
var data = new Data.CapaData();
data.SaveProduct(Producto);
}
public ProductsEntity SelectOne(Guid Id)
{
ProductsEntity toReturn = null;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
ProductsEntity _ProductsEntity = new ProductsEntity(Id);
if (adapter.FetchEntity(_ProductsEntity))
{
toReturn = _ProductsEntity;
}
}
return toReturn;
}
public static void Main(string[] args)
{
var context = new ProductsEntity();
var serializer = new JavaScriptSerializer();
// Products In Range
var productsInRange = context.Products
.Where(p => p.Buyer == null)
.OrderByDescending(p => p.Price)
.Select(p => new
{
p.Name,
p.Price,
Seller = p.Seller.FirstName + " " + p.Seller.LastName
})
.ToList();
var serializedProductsInRange = serializer.Serialize(productsInRange);
// Uncomment for the result, it might look nasty since it is formatted
// without any spaces.
//Console.WriteLine(serializedProductsInRange);
// Successfully Sold Products
var soldProduct = context.Users
.Where(u => u.ProductsSold.Count > 1 &&
u.ProductsSold.Where(p => p.Buyer != null).Count() > 0)
.OrderBy(u => u.FirstName)
.ThenBy(u => u.LastName)
.Select(u => new
{
firstName = u.FirstName,
lastname = u.LastName,
soldProducts = u.ProductsSold.Select(p => new
{
name = p.Name,
pice = p.Price,
buyerFirstName = p.Buyer.FirstName,
buyerLastName = p.Buyer.LastName
})
})
.ToList();
var serializedSoldProduct = serializer.Serialize(soldProduct);
//Console.WriteLine(serializedSoldProduct);
// Categories By Products Count
var productsByCategory = context.Categories
.OrderByDescending(c => c.Products.Count)
.Select(c => new
{
category = c.Name,
productsCount = c.Products.Count,
averagePrice = c.Products.Average(p => p.Price),
totalRavenue = c.Products.Sum(p => p.Price)
})
.ToList();
var serializedProductsByCategory = serializer.Serialize(productsByCategory);
//Console.WriteLine(serializedProductsByCategory);
// Users and Products
var xmlUsers = context.Users
.Where(u => u.ProductsSold.Count > 1 &&
u.ProductsSold.Where(p => p.Buyer != null).Count() > 0)
.OrderByDescending(u => u.ProductsSold.Count)
.ThenBy(u => u.LastName)
.Select(u => new
{
u.FirstName,
u.LastName,
u.Age,
Products = u.ProductsSold.Select(p => new
{
p.Name,
p.Price
})
})
.ToList();
var xml = new XDocument();
var root = new XElement("users");
root.SetAttributeValue("count", xmlUsers.Count);
xml.Add(root);
foreach (var user in xmlUsers)
{
var userNode = new XElement("user");
if (user.FirstName != null)
{
userNode.SetAttributeValue("first-name", user.FirstName);
}
if (user.LastName != null)
{
userNode.SetAttributeValue("last-name", user.LastName);
}
if (user.Age != 0)
{
userNode.SetAttributeValue("age", user.Age);
}
var productsNode = new XElement("sold-products");
productsNode.SetAttributeValue("count", user.Products.Count());
foreach (var product in user.Products)
{
var productNode = new XElement("product");
productNode.SetAttributeValue("name", product.Name);
productNode.SetAttributeValue("price", product.Price);
productsNode.Add(productNode);
}
userNode.Add(productsNode);
root.Add(userNode);
}
//Console.WriteLine(xml);
}
public bool Update(ProductsEntity _ProductsEntity, RelationPredicateBucket filter)
{
bool toReturn = false;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
adapter.UpdateEntitiesDirectly(_ProductsEntity, filter);
toReturn = true;
}
return toReturn;
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
try
{
Weifenxiao.Entity.ProductsEntity model = new ProductsEntity();
if (productId != 0)
{
model = Weifenxiao.BLL.ProductsBLL.GetInstance().GetAdminSingle(productId);
model.ProductId = productId;
model.UpdateTime = DateTime.Now;
}
else
{
model.AddTime = DateTime.Now;
}
UserIdentity identity = User.Identity as UserIdentity;
model.ShopId = identity.ShopID;
model.Name = txtName.Value;
model.CostPrice = Convert.ToDecimal(txtCostPrize.Value);
model.SalePrice = Convert.ToDecimal(txtPrize.Value);
model.OriginPrice = Convert.ToDecimal(txtOriginPrice.Value);
model.IsCommission = Convert.ToInt32(hidden_isCommission.Value.ToString());
model.Commission = Convert.ToDecimal(txtCommission.Value);
model.OrderBy = Convert.ToInt32(txtOrderby.Value);
model.CategoryId = Convert.ToInt32(ddl_Category.SelectedValue);
model.CategoryId2 = Convert.ToInt32(selecteurozone.Text.Trim());
model.Intro = txtIntro.Text.ToString();
model.Status = Convert.ToInt32(RadioButtonList1.SelectedValue);
model.Description = html_ue.Value;
model.Stock = Convert.ToInt32(txtStock.Value);
//-----------------------------------------------------
model.IsNew = Convert.ToInt32(RadioButtonList2.SelectedValue);
model.IsHot = Convert.ToInt32(RadioButtonList3.SelectedValue);
//-----------------------------------------------------
model.UpdateTime = DateTime.Now;
string[] imgs = (txt_img.Value.ToString()).Split(',');
if (imgs.Length > 0)
{
model.Image1 = imgs[0];
}
else
{
model.Image1 = null;
}
if (imgs.Length > 1)
{
model.Image2 = imgs[1];
}
else
{
model.Image2 = null;
}
if (imgs.Length > 2)
{
model.Image3 = imgs[2];
}
else
{
model.Image3 = null;
}
if (imgs.Length > 3)
{
model.Image4 = imgs[3];
}
else
{
model.Image4 = null;
} if (imgs.Length > 4)
{
model.Image5 = imgs[4];
}
else
{
model.Image5 = null;
}
Weifenxiao.BLL.ProductsBLL bll = new ProductsBLL();
if (productId != 0)
{
bll.Update(model);
}
else
{
bll.Insert(model);
}
Jnwf.Utils.Helper.HttpHelper.LoadPageContent("http://m.disneybg.com/clear.aspx?type=product&shopid=" + identity.ShopID);
}
catch (Exception ex)
{
Jnwf.Utils.Log.Logger.Log4Net.Error("proedit.aspx,ex:" + ex.Message + "|" + ex.StackTrace);
}
finally
{
Response.Redirect("/product/proList.aspx");
}
}
ProductsEntity getProduct()
{
ProductsEntity product = new ProductsEntity();
product.Id = Guid.NewGuid();
product.ProductName = Filter.GetMaxString(txtProductName.Text.Trim(), ProductsFields.ProductName.MaxLength);
product.TextId = ProductsManager.CreateInstant().GetUniqueTextIdFromUnicodeText(product.ProductName);
product.CatalogId = ucCatalogs.getCatId();
product.SupplierId = new Guid(ddlSuppliers.SelectedValue);
product.Price = decimal.Parse(txtPrice.Text.Trim(), new CultureInfo("en-US"));
product.Abstract = Filter.GetMaxString(txtAbstract.Text.Trim(), ProductsFields.Abstract.MaxLength);
product.Warranty = Filter.GetMaxString(txtWarranty.Text.Trim(), ProductsFields.Warranty.MaxLength);
product.Detail = Filter.GetMaxString(txtDetail.Value.Trim(), ProductsFields.Detail.MaxLength);
product.Thumbnail = "";
if (fileThumbnail.HasFile)
{
product.Thumbnail = FileUploadControl.FullPath(fileThumbnail, EnumsFile.Thumbnails, product.TextId, ProductsFields.Thumbnail.MaxLength);
}
else
{
ProductRegisterEntity register = ProductRegisterManager.CreateInstant().SelectOne(RegisterId);
if (register != null && !string.IsNullOrEmpty(register.Thumbnail))
{
product.Thumbnail = register.Thumbnail;
}
}
product.CreatedDate = DateTime.Now;
product.CreatedBy = Util.CurrentUserName;
product.UpdatedDate = DateTime.Now;
product.UpdatedBy = Util.CurrentUserName;
return product;
}
public ProductsEntity Insert(string ProductName, string ProductCode, string TextId, string Abstract, decimal Price, string UnitCode, string Thumbnail, string Warranty, string Detail, int Amount, int Locked, int Views, Guid SupplierId, bool IsVisible, int SortOrder, string PositionId, int CatalogId, bool IsPromotion, bool IsDiscount, string CreatedBy, DateTime CreatedDate, string UpdatedBy, DateTime UpdatedDate, bool IsDelete)
{
ProductsEntity _ProductsEntity = new ProductsEntity();
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
_ProductsEntity.ProductName = ProductName;
_ProductsEntity.ProductCode = ProductCode;
_ProductsEntity.TextId = TextId;
_ProductsEntity.Abstract = Abstract;
_ProductsEntity.Price = Price;
_ProductsEntity.UnitCode = UnitCode;
_ProductsEntity.Thumbnail = Thumbnail;
_ProductsEntity.Warranty = Warranty;
_ProductsEntity.Detail = Detail;
_ProductsEntity.Amount = Amount;
_ProductsEntity.Locked = Locked;
_ProductsEntity.Views = Views;
_ProductsEntity.SupplierId = SupplierId;
_ProductsEntity.IsVisible = IsVisible;
_ProductsEntity.SortOrder = SortOrder;
_ProductsEntity.PositionId = PositionId;
_ProductsEntity.CatalogId = CatalogId;
_ProductsEntity.IsPromotion = IsPromotion;
_ProductsEntity.IsDiscount = IsDiscount;
_ProductsEntity.CreatedBy = CreatedBy;
_ProductsEntity.CreatedDate = CreatedDate;
_ProductsEntity.UpdatedBy = UpdatedBy;
_ProductsEntity.UpdatedDate = UpdatedDate;
_ProductsEntity.IsDelete = IsDelete;
adapter.SaveEntity(_ProductsEntity, true);
}
return _ProductsEntity;
}
DealsEntity getDeal(ProductsEntity product)
{
DealsEntity deal = new DealsEntity();
deal.ProductId = product.Id;
deal.Price = product.Price;
deal.PoPrice = FNumber.ConvertDecimal(txtPricePo.Text.Trim());
deal.CreatedBy = Util.CurrentUserName;
deal.CreatedDate = DateTime.Now;
return deal;
}
ProductsEntity getProduct(ProductsEntity _product)
{
ProductsEntity product = new ProductsEntity();
product.Id = _product.Id;
product.ProductName = Filter.GetMaxString(txtProductName.Text.Trim(), ProductsFields.ProductName.MaxLength);
if (_product.ProductName != txtProductName.Text.Trim())
product.TextId = ProductsManager.CreateInstant().GetUniqueTextIdFromUnicodeText(product.ProductName);
else
product.TextId = _product.TextId;
product.CatalogId = ucCatalogs.getCatId();
product.SupplierId = new Guid(ddlSuppliers.SelectedValue);
product.Abstract = Filter.GetMaxString(txtAbstract.Text.Trim(), ProductsFields.Abstract.MaxLength);
product.Warranty = Filter.GetMaxString(txtWarranty.Text.Trim(), ProductsFields.Warranty.MaxLength);
product.Detail = Filter.GetMaxString(txtDetail.Value.Trim(), ProductsFields.Detail.MaxLength);
if (!fileThumbnail.HasFile)
product.Thumbnail = _product.Thumbnail;
else
product.Thumbnail = FileUploadControl.FullPath(fileThumbnail, EnumsFile.Thumbnails, product.TextId, ProductsFields.Thumbnail.MaxLength);
product.CreatedDate = _product.CreatedDate;
product.CreatedBy = _product.CreatedBy;
product.UpdatedDate = DateTime.Now;
product.UpdatedBy = Util.CurrentUserName;
return product;
}
public void Update(ProductsEntity productsEntity)
{
productsdal.Update(productsEntity);
}
public bool Update(ProductsEntity _ProductsEntity)
{
bool toReturn = false;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(ProductsFields.Id == _ProductsEntity.Id);
filter.PredicateExpression.Add(_PredicateExpression);
adapter.UpdateEntitiesDirectly(_ProductsEntity, filter);
toReturn = true;
}
return toReturn;
}
StorageEntity getStore(ProductsEntity product)
{
StorageEntity store = new StorageEntity();
store.ProductId = product.Id;
store.Import = 0;
store.Export = 0;
store.Price = product.Price;
store.PoPrice = FNumber.ConvertDecimal(txtPricePo.Text.Trim());
store.CreatedBy = Util.CurrentUserName;
return store;
}
EntityCollection<ProductInCatalogEntity> getGetListCat(ProductsEntity product)
{
EntityCollection<ProductInCatalogEntity> items = new EntityCollection<ProductInCatalogEntity>();
int[] cats = ucCatalogs.getListCatId();
for (int i = 0; i < cats.Length; i++)
{
ProductInCatalogEntity item = new ProductInCatalogEntity();
item.ProductId = product.Id;
item.CatId = cats[i];
item.OrderIndex = i;
items.Add(item);
}
return items;
}
public Task <JResponseEntity <ProductsEntity> > UpdateAsync(ProductsEntity Product)
{
throw new NotImplementedException();
}
ProductInfoEntity getProductInfo(ProductsEntity product)
{
ProductInfoEntity info = new ProductInfoEntity();
info.Id = product.Id;
info.PriceSell = product.Price;
info.PriceBuy = FNumber.ConvertDecimal(txtPricePo.Text.Trim());
info.Currency = "VND";
return info;
}
public ProductsEntity Insert(ProductsEntity _ProductsEntity)
{
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
adapter.SaveEntity(_ProductsEntity, true);
}
return _ProductsEntity;
}
public async Task <ActionResult <ProductsEntity> > Post([FromServices] DataContext context, [FromBody] ProductsEntity product)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
context.Products.Add(product);
await context.SaveChangesAsync();
return(Ok(new { message = "Produto cadastrado com sucesso" }));
}
catch (Exception)
{
return(BadRequest(new { message = "Não foi possivel cadastrar o Produto" }));
}
}
public ActionResult Agregar(ProductsEntity model)
{
bussines.GuardarProducto(model);
return(View("Index", bussines.ObtenerProductos()));
}
public static void Main(string[] args)
{
var context = new ProductsEntity();
var serializer = new JavaScriptSerializer();
// Products In Range
var productsInRange = context.Products
.Where(p => p.Buyer == null)
.OrderByDescending(p => p.Price)
.Select(p => new
{
p.Name,
p.Price,
Seller = p.Seller.FirstName + " " + p.Seller.LastName
})
.ToList();
var serializedProductsInRange = serializer.Serialize(productsInRange);
// Uncomment for the result, it might look nasty since it is formatted
// without any spaces.
//Console.WriteLine(serializedProductsInRange);
// Successfully Sold Products
var soldProduct = context.Users
.Where(u => u.ProductsSold.Count > 1 &&
u.ProductsSold.Where(p => p.Buyer != null).Count() > 0)
.OrderBy(u => u.FirstName)
.ThenBy(u => u.LastName)
.Select(u => new
{
firstName = u.FirstName,
lastname = u.LastName,
soldProducts = u.ProductsSold.Select(p => new
{
name = p.Name,
pice = p.Price,
buyerFirstName = p.Buyer.FirstName,
buyerLastName = p.Buyer.LastName
})
})
.ToList();
var serializedSoldProduct = serializer.Serialize(soldProduct);
//Console.WriteLine(serializedSoldProduct);
// Categories By Products Count
var productsByCategory = context.Categories
.OrderByDescending(c => c.Products.Count)
.Select(c => new
{
category = c.Name,
productsCount = c.Products.Count,
averagePrice = c.Products.Average(p => p.Price),
totalRavenue = c.Products.Sum(p => p.Price)
})
.ToList();
var serializedProductsByCategory = serializer.Serialize(productsByCategory);
//Console.WriteLine(serializedProductsByCategory);
// Users and Products
var xmlUsers = context.Users
.Where(u => u.ProductsSold.Count > 1 &&
u.ProductsSold.Where(p => p.Buyer != null).Count() > 0)
.OrderByDescending(u => u.ProductsSold.Count)
.ThenBy(u => u.LastName)
.Select(u => new
{
u.FirstName,
u.LastName,
u.Age,
Products = u.ProductsSold.Select(p => new
{
p.Name,
p.Price
})
})
.ToList();
var xml = new XDocument();
var root = new XElement("users");
root.SetAttributeValue("count", xmlUsers.Count);
xml.Add(root);
foreach (var user in xmlUsers)
{
var userNode = new XElement("user");
if (user.FirstName != null)
{
userNode.SetAttributeValue("first-name", user.FirstName);
}
if (user.LastName != null)
{
userNode.SetAttributeValue("last-name", user.LastName);
}
if (user.Age != 0)
{
userNode.SetAttributeValue("age", user.Age);
}
var productsNode = new XElement("sold-products");
productsNode.SetAttributeValue("count", user.Products.Count());
foreach (var product in user.Products)
{
var productNode = new XElement("product");
productNode.SetAttributeValue("name", product.Name);
productNode.SetAttributeValue("price", product.Price);
productsNode.Add(productNode);
}
userNode.Add(productsNode);
root.Add(userNode);
}
//Console.WriteLine(xml);
}
public int Insert(ProductsEntity productsEntity)
{
return(productsdal.Insert(productsEntity));
}
