public async Task <IActionResult> PutProduct_Price(int id, Product_Price product_Price)
{
if (id != product_Price.price_id)
{
return(BadRequest());
}
_context.Entry(product_Price).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!Product_PriceExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <Product_Price> > PostProduct_Price(Product_Price product_Price)
{
_context.Product_Price.Add(product_Price);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetProduct_Price", new { id = product_Price.price_id }, product_Price));
}
public override int GetHashCode()
{
var hashCode = 155131702;
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Product_ID);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Product_Name);
hashCode = hashCode * -1521134295 + Combination_RequiredQty.GetHashCode();
hashCode = hashCode * -1521134295 + Product_Price.GetHashCode();
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Combination_Product_ID);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Category_Division);
hashCode = hashCode * -1521134295 + Combination_ID.GetHashCode();
hashCode = hashCode * -1521134295 + Combination_DeletedYN.GetHashCode();
return(hashCode);
}
private Product_Price EmptyIfNull(Product_Price p1)
{
p1.ma_san_pham = (p1.ma_san_pham == null) ? "" : p1.ma_san_pham;
p1.gia_mua = string.IsNullOrEmpty(p1.gia_mua.ToString()) ? 0 : p1.gia_mua;
p1.gia_ban_le = string.IsNullOrEmpty(p1.gia_ban_le.ToString()) ? 0 : p1.gia_ban_le;
p1.gia_ban_si = string.IsNullOrEmpty(p1.gia_ban_si.ToString()) ? 0 : p1.gia_ban_si;
p1.gia_khuyen_mai = string.IsNullOrEmpty(p1.gia_khuyen_mai.ToString()) ? 0 : p1.gia_khuyen_mai;
p1.gia_luu_kho = string.IsNullOrEmpty(p1.gia_luu_kho.ToString()) ? 0 : p1.gia_luu_kho;
p1.ngay_bat_dau = string.IsNullOrEmpty(p1.ngay_bat_dau.ToString()) ? DateTime.Parse("1900-01-01") : p1.ngay_bat_dau;
p1.ngay_ket_thuc = string.IsNullOrEmpty(p1.ngay_ket_thuc.ToString()) ? DateTime.Parse("1900-01-01") : p1.ngay_ket_thuc;
p1.nguoi_duyet = (p1.nguoi_duyet == null) ? "" : p1.nguoi_duyet;
p1.ngay_duyet = string.IsNullOrEmpty(p1.ngay_duyet.ToString()) ? DateTime.Parse("1900-01-01") : p1.ngay_duyet;
p1.nguoi_xuat_ban = (p1.nguoi_xuat_ban == null) ? "" : p1.nguoi_xuat_ban;
p1.ngay_xuat_ban = string.IsNullOrEmpty(p1.ngay_xuat_ban.ToString()) ? DateTime.Parse("1900-01-01") : p1.ngay_xuat_ban;
p1.trang_thai_duyet = (p1.trang_thai_duyet == null) ? "" : p1.trang_thai_duyet;
p1.trang_thai_xuat_ban = (p1.trang_thai_xuat_ban == null) ? "" : p1.trang_thai_xuat_ban;
p1.trang_thai = (p1.trang_thai == null) ? "" : p1.trang_thai;
return(p1);
}
public JsonResult UpdateParameters(IEnumerable <_post_Product_Attr> items)
{
ResultBase_form result = new ResultBase_form();
result.status = 1;
result.msg = "操作成功";
try
{
//清除数据
Guid pid = items.First().ProductID;
if (Product_Att_ValService.instance().DeleteByProductID(pid) > 0 && Product_PriceService.instance().DeleteByProductID(pid) > 0)
{
foreach (var item in items)
{
//添加属性值
Product_Att_Val pv = new Product_Att_Val();
pv.ID = Guid.NewGuid();
pv.ProductID = pid;
pv.Value = item.Att_val;
pv.Att_Key_ID = item.Att_key;
pv.Short = item.Short;
if (Product_Att_ValService.instance().Insert(pv) > 0)
{
//添加价格
Product_Price pp = new Product_Price();
pp.ID = Guid.NewGuid();
pp.ProductID = pid;
pp.Price = item.Price;
pp.Stock = item.Stock;
pp.Att_Key = item.Att_key;
pp.Att_Val = pv.ID;
Product_PriceService.instance().Insert(pp);
}
}
}
}
catch
{
result.status = 0;
result.msg = "操作失败";
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public static List <ProductModel> Get_Active_Products()
{
List <ProductModel> Products = new List <ProductModel>();
MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring);
MySqlConnection dbconn1 = new MySqlConnection(CommonClass.connectionstring);
dbconn.Open();
MySqlDataReader reader = CommonClass.FetchRecords("GET_ACIVE_PRODUCTS",
new string[] { "PHOTO_IND" },
new string[] { "0" },
dbconn);
while (reader.Read())
{
ProductModel product = new ProductModel();
product.id = int.Parse(reader["PRODUCT_ID"].ToString());
product.Name = reader["PRODUCT_NAME"].ToString();
product.Picture = "http://www.gilldstore.in/img/" + reader["PHOTO_FILE_NAME"].ToString();
List <Product_Price> ProductPrices = new List <Product_Price>();
dbconn1.Open();
MySqlDataReader reader1 = CommonClass.FetchRecords("GET_PRODUCT_PRICE",
new string[] { "P_PRODUCT_ID", "P_CUSTOMER_ID", "P_EXTERNAL_USER_ID" },
new string[] { reader["PRODUCT_ID"].ToString(), null, null },
dbconn1);
while (reader1.Read())
{
Product_Price productprice = new Product_Price();
productprice.Measurement_Name = reader1["MEASUREMENT_NAME"].ToString();
productprice.Measurement_Unit = double.Parse(reader1["MEASUREMENT_UNIT"].ToString());
productprice.Price = double.Parse(reader1["PRICE"].ToString());
productprice.ShippingCharge = double.Parse(reader1["SHIPPING_CHARGE"].ToString());
productprice.DisplayMeasurement = reader1["MEASUREMENT_UNIT"].ToString() + " " + reader1["MEASUREMENT_NAME"].ToString();
ProductPrices.Add(productprice);
}
reader1.Close();
dbconn1.Close();
product.Productrices = ProductPrices;
Products.Add(product);
}
dbconn.Close();
return(Products);
}
public JsonResult GetParameters(string id)
{
Guid pid;
List <_post_Product_Attr> result = new List <_post_Product_Attr>();
if (Guid.TryParse(id, out pid))
{
IEnumerable <Product_Att_Val> pvs = Product_Att_ValService.instance().GetEnumByProductID(pid).OrderBy(m => m.Short);
foreach (var pv in pvs)
{
_post_Product_Attr att = new _post_Product_Attr();
att.ProductID = pid;
att.Att_val = pv.Value;
att.Att_key = pv.Att_Key_ID;
Product_Price pp = Product_PriceService.instance().GetEnumByKVP(pid, pv.Att_Key_ID, pv.ID);
att.Price = pp.Price;
att.Stock = pp.Stock;
att.Short = pv.Short;
result.Add(att);
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
//chua biet dung lam gi
public ActionResult Upsert(Product_Price item)
{
if (accessDetail != null && (accessDetail.access["all"] || accessDetail.access["create"]) ||
accessDetail != null && (accessDetail.access["all"] || accessDetail.access["update"]))
{
string result = "";
try
{
List <Product_Price> lstProdPrice = new List <Product_Price>();
lstProdPrice.Add(item);
result = new Product_Price_DAO().UpSert(lstProdPrice, currentUser.name, AppConfigs.MCCConnectionString);
if (result == "true")
{
if (item.id == 0)// 0 insert, 1 update
{
return(Json(new { success = true, type = 0 }));
}
else
{
return(Json(new { success = true, type = 1 }));
}
}
else
{
return(Json(new { success = false, message = result }));
}
}
catch (Exception e)
{
return(Json(new { success = false, message = "Có lỗi file upload" + e.Message }));
}
}
else
{
return(Json(new { success = false, message = "Bạn không có quyền." }));
}
}
public ActionResult Upsert(Product_Price item)
{
if (asset.Create || asset.Update)
{
string result = "";
try
{
List <Product_Price> lstProdPrice = new List <Product_Price>();
lstProdPrice.Add(item);
result = new Product_Price_DAO().UpSert(lstProdPrice, currentUser.UserName, "Insert");
if (result == "true")
{
if (item.id == 0)// 0 insert, 1 update
{
return(Json(new { success = true, type = 0 }));
}
else
{
return(Json(new { success = true, type = 1 }));
}
}
else
{
return(Json(new { success = false, message = result }));
}
}
catch (Exception e)
{
return(Json(new { success = false, message = "Có lỗi file upload" + e.Message }));
}
}
else
{
return(Json(new { success = false, message = "Bạn không có quyền." }));
}
}
public bool Update(Product_Price price)
{
_repository.Update(price);
_unitOfWork.CommitChanges();
return(true);
}
public bool Insert(Product_Price price)
{
_repository.Add(price);
_unitOfWork.CommitChanges();
return(true);
}
public void SetMultipler(Product_Price model)
{
_MultiplerRepository.Insert(model);
}
private void SaveButton_Click(object sender, EventArgs e)
{
int IntTest;
Double DoubleTest;
Boolean Fail = true;
while (Fail)
{
_Product.Product_Name = Product_Name.Text;
if (Int32.TryParse(Product_ID.Text, out IntTest))
{
_Product.ProductId = Int32.Parse(Product_ID.Text);
}
else
{
MessageBox.Show("Not an acceptible ID");
Fail = false;
break;
}
if (Int32.TryParse(Product_Stock.Text, out IntTest))
{
_Product.Stock_Level = Int32.Parse(Product_Stock.Text);
}
else
{
MessageBox.Show("Not an acceptible stock level");
Fail = false;
break;
}
if (Double.TryParse(Product_Price.Text, out DoubleTest))
{
_Product.Price = Double.Parse(Product_Price.Text);
}
else
{
MessageBox.Show("Not an acceptible price");
Fail = false;
break;
}
_PHPRepo.EditProductRecord(_Product);
Product_ID.Clear();
Product_Name.Clear();
Product_Stock.Clear();
Product_Price.Clear();
Product_Name.Enabled = false;
Product_Stock.Enabled = false;
Product_Price.Enabled = false;
StockList.Items.Clear();
List <Product> _NewList = _PHPRepo.GetProducts();
foreach (Product p in _NewList)
{
string[] row = { p.ProductId.ToString(), p.Product_Name.ToString(), p.Price.ToString(), p.Stock_Level.ToString() };
var listViewItem = new ListViewItem(row);
StockList.Items.Add(listViewItem);
}
;
Fail = false;
break;
}
}
public DbEntityProfile(IConfiguration configuration)
{
this.CreateMap <ProductImageViewModel, NTImage>().ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <NTImage, ProductImageViewModel>().ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <ProductPriceViewModel, NTPrice>().ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <NTPrice, ProductPriceViewModel>().ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <NTImage, NTImage>().ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <NTPrice, NTPrice>().ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <ProductSearchViewModel, Product>().ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <Product_Image, Product_Image>().ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <Product_Price, Product_Price>().ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <Product, Product>().ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <ProductCreateViewModel, Product>().ForMember(p => p.Product_Image_Lst, opt =>
{
opt.ResolveUsing <List <Product_Image> >((s, d, dm, c) =>
{
List <Product_Image> pro_img_lst = new List <Product_Image>();
if (s.Images?.Count() > 0)
{
foreach (var item in s.Images)
{
var pro_img = dm?.FirstOrDefault(p => $"{p.ProductId}{p.ImageId}".ToCrc32().ToString() == item.MockId) ?? new Product_Image();
var img = pro_img.Image ?? new NTImage();
pro_img.Image = c.Mapper.Map(item, img);
pro_img.Type = item.Type;
pro_img.MockId = item.MockId;
pro_img_lst.Add(pro_img);
}
}
return(pro_img_lst);
});
}).ForMember(p => p.Product_Price, opt =>
{
opt.ResolveUsing <Product_Price>((s, d, dm, c) =>
{
Product_Price pro_price = null;
if (s.Prices != null)
{
pro_price = dm != null ? dm as Product_Price : new Product_Price();
var price = pro_price.Price ?? new NTPrice();
pro_price.Price = c.Mapper.Map(s.Prices, price);
}
return(pro_price);
});
}).ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <Product, ProductCreateViewModel>().ForMember(p => p.Images, opt =>
{
opt.ResolveUsing <List <ProductImageViewModel> >((s, d, dm, c) =>
{
if (s.Product_Image_Lst?.Count() > 0)
{
dm = new List <ProductImageViewModel>();
foreach (var item in s.Product_Image_Lst)
{
var imgModel = c.Mapper.Map <ProductImageViewModel>(item.Image);
imgModel.Type = item.Type;
imgModel.MockId = $"{item.ProductId}{item.ImageId}".ToCrc32().ToString();
dm.Add(imgModel);
}
}
return(dm);
});
}).ForMember(p => p.Prices, opt =>
{
opt.ResolveUsing <ProductPriceViewModel>((s, d, dm, c) =>
{
if (s.Product_Price != null)
{
dm = c.Mapper.Map <ProductPriceViewModel>(s.Product_Price.Price);
dm.MockId = $"{s.Product_Price.ProductId}{s.Product_Price.PriceId}".ToCrc32().ToString();
}
return(dm);
});
}).ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <WeChatInfo, WeChatInfo>().ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <AppUserViewModel, AppUser>().ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <AppUserSearchViewModel, AppUser>().ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
this.CreateMap <AppUser, AppUser>().ForAllMembers(p => p.Condition((s, d, sm, dm) => sm != null));
}
