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