private static ProductGetOut _getProduct(int warehouse, tbl_Product product)
{
var quantity = PJUtils.TotalProductQuantityInstock(1, product.ProductSKU);
var quantity2 = StockManagerController.getQuantityStock2BySKU(product.ProductSKU);
if (warehouse == 1 && quantity == 0)
{
return(null);
}
if (warehouse == 2 && (!quantity2.HasValue && quantity2.Value == 0))
{
return(null);
}
var result = new ProductGetOut()
{
ID = product.ID,
ProductName = product.ProductTitle,
ProductVariable = String.Empty,
ProductVariableName = String.Empty,
ProductVariableValue = String.Empty,
ProductStyle = 1,
ProductImage = Thumbnail.getURL(product.ProductImage, Thumbnail.Size.Normal),
ProductImageOrigin = Thumbnail.getURL(product.ProductImage, Thumbnail.Size.Source),
SKU = product.ProductSKU.Trim().ToUpper(),
WarehouseQuantity = String.Format("{0:N0}", quantity),
WarehouseQuantity2 = String.Format("{0:N0}", quantity2),
ParentID = product.ID,
ParentSKU = product.ProductSKU
};
return(result);
}
//Khoi tao gio hàng theo Masp duoc truyen vao voi Soluong mac dinh la 1
public ShoppingCart(int Masp)
{
iMasp = Masp;
tbl_Product sp = db.tbl_Products.Single(n => n.ID == iMasp);
var _Checksp = db.tbl_promotion_details.FirstOrDefault(n => n.Idsp == iMasp);
if (_Checksp != null)
{
tbl_promotion_detail spkm = db.tbl_promotion_details.Single(n => n.Idsp == iMasp);
khuyemai = spkm.KhuyenMai.Value;
sTensp = sp.TenSP;
sAnhbia = sp.UrlHinh;
if (khuyemai > 0)
{
dDongia = double.Parse(spkm.Giakhuyenmai.ToString());
}
else
{
dDongia = double.Parse(sp.GiaHienTai.ToString());
}
gift = spkm.Gift;
iSoluong = 1;
salias = sp.alias;
}
else
{
sTensp = sp.TenSP;
sAnhbia = sp.UrlHinh;
dDongia = double.Parse(sp.GiaHienTai.ToString());
iSoluong = 1;
salias = sp.alias;
}
}
public int UpdateProductDetails(IDictionary <string, object> data)
{
//dynamic updateData = JObject.Parse(data);
string Id = data["Id"].ToString();
int searchId = Convert.ToInt32(Id);
if (searchId != 0)
{
var result = db.tbl_Product.Where(p => p.Id == searchId).SingleOrDefault();
result.ProductName = data["productName"].ToString();
result.CategoryId = Convert.ToInt32(data["categoryName"].ToString());
result.UnitId = Convert.ToInt32(data["unitName"].ToString());
result.CurrencyId = Convert.ToInt32(data["currencyName"].ToString());
result.Price = Convert.ToDecimal(data["price"].ToString());
result.UpdatedDate = DateTime.Now;
db.SaveChanges();
}
else
{
tbl_Product tbl_Product = new tbl_Product();
tbl_Product.ProductName = data["productName"].ToString();
tbl_Product.CategoryId = Convert.ToInt32(data["categoryName"].ToString());
tbl_Product.UnitId = Convert.ToInt32(data["unitName"].ToString());
tbl_Product.CurrencyId = Convert.ToInt32(data["currencyName"].ToString());
tbl_Product.Price = Convert.ToDecimal(data["price"].ToString());
tbl_Product.UpdatedDate = DateTime.Now;
tbl_Product.AddedDate = DateTime.Now;
db.tbl_Product.Add(tbl_Product);
db.SaveChanges();
}
return(1);
}
public HttpResponseMessage put(int id, [FromBody] tbl_Product tbl_Product)
{
try
{
using (OrderDBEntities entities = new OrderDBEntities())
{
var entity = entities.tbl_Product.FirstOrDefault(e => e.OrderitemID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product with id = " + id.ToString() + "Not found to update"));
}
else
{
entity.Productname = tbl_Product.Productname;
entity.Productdetails = tbl_Product.Productdetails;
entity.height = tbl_Product.height;
entity.Image = tbl_Product.Image;
entity.Weight = tbl_Product.Weight;
entity.SKU = tbl_Product.SKU;
entity.Barcode = tbl_Product.Barcode;
entity.AvailableQuantity = tbl_Product.AvailableQuantity;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
protected void lbUpdateFile_OnClick(object sender, EventArgs e)
{
productData = _dataManager.Product.SelectById(CurrentUser.Instance.SiteID, ProductId);
productData = _dataManager.Product.Save(
CurrentUser.Instance.SiteID,
productData == null ? Guid.Empty : productData.ID,
txtTitle.Text,
txtSKU.Text,
null,
null,
txtPrice.Text == "" ? null : (decimal?)(decimal.Parse(txtPrice.Text)),
null,
null,
null,
null,
null,
null,
null,
txtDescription.Text,
CurrentUser.Instance.ID,
null
);
((Labitec.UI.BaseWorkspace.Grid)FindControl("gridProducts", Page.Controls)).Rebind();
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
using (WebDBEntities db = new WebDBEntities())
{
ViewBag.Categories = db.tbl_Category.ToList();
return(View(new ProductViewModel()));
}
}
else
{
using (WebDBEntities db = new WebDBEntities())
{
ViewBag.Categories = db.tbl_Category.ToList();
tbl_Product item = db.tbl_Product.Where(i => i.productID == id).FirstOrDefault();
ProductViewModel itemvm = new ProductViewModel();
itemvm.productID = item.productID;
itemvm.categoryID = Convert.ToInt32(item.categoryID);
itemvm.title = item.title;
itemvm.unitPrice = item.unitPrice;
itemvm.sellingPrice = item.sellingPrice;
itemvm.description = item.description;
itemvm.photo = item.photo;
return(View(itemvm));
}
}
}
public void CreateRedirectOnSuccess()
{
ProductController controller = GetProductController(new InMemoryProductRepository());
tbl_Product model = GetProductID();
var result = (RedirectToRouteResult)controller.CreateProduct(model);
Assert.AreEqual("ProductList", result.RouteValues["action"]);
}
public ActionResult DeleteConfirmed(short id)
{
tbl_Product tbl_Product = db.tbl_Product.Find(id);
db.tbl_Product.Remove(tbl_Product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ItemSetCaTuoiMoiNgayEnable(int id)
{
tbl_Product tic = getOneItem(id);
tic.SachMoiMoiNgay = !tic.SachMoiMoiNgay;
UpdateModel(tic);
data.SubmitChanges();
return(RedirectToAction("itemView"));
}
/// <summary>
/// Binds the data.
/// </summary>
private void BindData()
{
dcbManufacturer.SiteID = SiteId;
//dcbManufacturer.EditLink = UrlsData.AP_Company(Guid.Empty);
dcbSupplier.SiteID = SiteId;
//dcbSupplier.EditLink = UrlsData.AP_Company(Guid.Empty);
sccCategory.ValidationGroup = ValidationSummary.ValidationGroup;
sccCategory.SiteID = SiteId;
dcbCountry.Order = new List <DictionaryComboBox.DictionaryOrderColumn>();
dcbCountry.Order.Add(new DictionaryComboBox.DictionaryOrderColumn()
{
Name = "it.[Name]", Direction = "ASC"
});
ProductComplectation.SiteID = SiteId;
ProductPrice.SiteID = SiteId;
BindProductType();
BindProductStatus();
BindBrand();
BindUnit();
productData = DataManager.Product.SelectById(SiteId, _productID);
ProductComplectation.ProductID = Guid.Empty;
ProductPrice.ProductID = Guid.Empty;
if (productData != null)
{
BindImageGallery(productData.ID);
ProductComplectation.ProductID = productData.ID;
ProductPrice.ProductID = productData.ID;
txtSKU.Text = productData.SKU;
txtTitle.Text = productData.Title;
ddlProductType.SelectedIndex = ddlProductType.Items.IndexOf(ddlProductType.Items.FindByValue(productData.ProductTypeID.ToString()));
txtPrice.Text = productData.Price == null ? "0,00" : ((decimal)productData.Price).ToString("F");
ddlProductStatus.SelectedIndex = ddlProductStatus.Items.IndexOf(ddlProductStatus.Items.FindByValue(productData.ProductStatusID.ToString()));
ddlBrand.SelectedIndex = ddlBrand.Items.IndexOf(ddlBrand.Items.FindByValue(productData.BrandID.ToString()));
ddlUnit.SelectedIndex = ddlUnit.Items.IndexOf(ddlUnit.Items.FindByValue(productData.UnitID.ToString()));
txtWholesalePrice.Text = productData.WholesalePrice == null ? "0,00" : ((decimal)productData.WholesalePrice).ToString("F");
ucHtmlEditor.Content = productData.Description;
sccCategory.SelectedCategoryId = productData.ProductCategoryID == null ? Guid.Empty:(Guid)productData.ProductCategoryID;
dcbCountry.SelectedId = productData.CountryID == null ? Guid.Empty:(Guid)productData.CountryID;
dcbManufacturer.SelectedId = productData.ManufacturerID == null ? Guid.Empty : (Guid)productData.ManufacturerID;
dcbSupplier.SelectedId = productData.SupplierID == null ? Guid.Empty : (Guid)productData.SupplierID;
txtSupplierSKU.Text = productData.SupplierSKU;
}
sccCategory.BindData();
}
public void ViewIsNotValid()
{
ProductController productController = GetProductController(new InMemoryProductRepository());
productController.ModelState.AddModelError("", "mock error message");
tbl_Product model = GetProductName(52, "");
var result = (ViewResult)productController.CreateProduct(model);
Assert.AreEqual("CreateProduct", result.ViewName);
}
public ActionResult Delete(int id)
{
using (WebDBEntities db = new WebDBEntities())
{
tbl_Product sm = db.tbl_Product.Where(x => x.productID == id).FirstOrDefault();
db.tbl_Product.Remove(sm);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(ProductViewModel ivm)
{
using (WebDBEntities db = new WebDBEntities())
{
if (ivm.productID == 0)
{
tbl_Product itm = new tbl_Product();
itm.categoryID = Convert.ToInt32(ivm.categoryID);
itm.title = ivm.title;
itm.unitPrice = ivm.unitPrice;
itm.sellingPrice = ivm.sellingPrice;
itm.description = ivm.description;
HttpPostedFileBase fup = Request.Files["photo"];
if (fup != null)
{
if (fup.FileName != "")
{
fup.SaveAs(Server.MapPath("~/ProductImages/" + fup.FileName));
itm.photo = fup.FileName;
}
}
itm.isSpecial = ivm.isSpecial;
db.tbl_Product.Add(itm);
db.SaveChanges();
ViewBag.Message = "Created Successfully";
}
else
{
tbl_Product itm = db.tbl_Product.Where(i => i.productID == ivm.productID).FirstOrDefault();
itm.categoryID = Convert.ToInt32(ivm.categoryID);
itm.title = ivm.title;
itm.unitPrice = ivm.unitPrice;
itm.sellingPrice = ivm.sellingPrice;
itm.description = ivm.description;
HttpPostedFileBase fup = Request.Files["Photo"];
if (fup != null)
{
if (fup.FileName != "")
{
fup.SaveAs(Server.MapPath("~/ProductImages/" + fup.FileName));
itm.photo = fup.FileName;
}
}
db.SaveChanges();
ViewBag.Message = "Updated Successfully";
}
ViewBag.Categories = db.tbl_Category.ToList();
return(View(new ProductViewModel()));
}
}
public void CreateProductInRepository()
{
InMemoryProductRepository productRepository = new InMemoryProductRepository();
ProductController productController = GetProductController(productRepository);
tbl_Product product = GetProductID();
productController.CreateProduct(product);
IEnumerable <tbl_Product> products = productRepository.ProductList();
Assert.IsTrue(products.Contains(product));
}
