public void UpdateProductByProductId(Productinfo prinfo)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
var pr = (from pro in db.products where pro.ProductID == prinfo.ProductID select pro).First();
pr.ProductID = prinfo.ProductID;
pr.ProductName = prinfo.ProductName;
pr.Product_description = prinfo.Product_description;
pr.Product_Expired_date = prinfo.Product_Expired_date;
pr.BrandID = prinfo.BrandID;
pr.CategoryID = prinfo.CategoryID;
pr.Color = prinfo.Color;
pr.Inserted_date = prinfo.Inserted_date;
pr.Manufacture_date = prinfo.Manufacture_date;
//pr.Product_image = prinfo.Product_image;
//pr.Product_imageID = prinfo.Product_imageID;
pr.UnitPrice = prinfo.UnitPrice;
pr.Size = prinfo.Size;
db.SubmitChanges();
}
}
catch (Exception ex)
{
Productinfo p = new Productinfo();
}
}
// The id parameter should match the DataKeyNames value set on the control
// or be decorated with a value provider attribute, e.g. [QueryString]int id
public ygMerceInfo.Productinfo ProductDetail_GetItem([QueryString("ProductID")] string id)
{
ProductController pCon = new ProductController();
Productinfo query = pCon.SelectByID(id);
return(query);
}
public void ServiceLayer_Prod_INF_Test()
{
var options = new DbContextOptionsBuilder <EfstoreContext>()
.UseInMemoryDatabase(databaseName: "WebstoreDB").Options;
using (var op = new EfstoreContext(options))
{
Productinfo PI = new Productinfo();
// PI.productinfoID = 1;
PI.Brand = "Adiddas";
PI.Color = "Black";
PI.size = "L";
var PS = new ProductInfoService(op);
PS.Add(PI);
// Use a separate instance of the context to verify correct data was saved to database
using (var context = new EfstoreContext(options))
{
Assert.AreEqual(1, context.Prodinfo.Count());
Assert.AreEqual(1, context.Prodinfo.Single().productinfoID);
Assert.AreEqual("Black", context.Prodinfo.Single().Color);
}
{
}
}
}
public string InsertProduct(Productinfo pinfo)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
product tbl = new product();
Guid pid = Guid.NewGuid();
tbl.ProductID = pid.ToString();
tbl.ProductName = pinfo.ProductName;
tbl.Product_description = pinfo.Product_description;
tbl.Product_Expired_date = pinfo.Product_Expired_date;
tbl.Expired_date = pinfo.Expired_date;
tbl.BrandID = pinfo.BrandID;
tbl.CategoryID = pinfo.CategoryID;
tbl.Color = pinfo.Color;
tbl.Inserted_date = DateTime.Now;
tbl.Manufacture_Country = pinfo.Manufacture_Country;
tbl.Manufacture_date = pinfo.Manufacture_date;
tbl.SupplierID = pinfo.SupplierID;
tbl.UMID = pinfo.UMID;
tbl.UnitPrice = pinfo.UnitPrice;
tbl.Size = pinfo.Size;
db.products.InsertOnSubmit(tbl);
db.SubmitChanges();
return(pid.ToString());
}
}
catch (Exception ex)
{
return("");
}
}
public Productinfo SelectByID(string productID)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
Productinfo pinfo = new Productinfo();
var obj = (from dt in db.products where dt.ProductID == productID select dt).First();
pinfo.ProductID = obj.ProductID;
pinfo.ProductName = obj.ProductName;
pinfo.Product_description = obj.Product_description;
pinfo.CategoryID = obj.CategoryID;
pinfo.SupplierID = obj.SupplierID;
pinfo.BrandID = obj.BrandID;
pinfo.UMID = obj.UMID;
pinfo.Color = obj.Color;
pinfo.Size = obj.Size;
pinfo.UnitPrice = obj.UnitPrice;
pinfo.Manufacture_date = obj.Manufacture_date;
pinfo.Product_Expired_date = obj.Product_Expired_date;
pinfo.Manufacture_Country = obj.Manufacture_Country.ToString();
pinfo.Inserted_date = obj.Inserted_date;
pinfo.Expired_date = obj.Expired_date;
return(pinfo);
}
}
catch (Exception ex)
{
return(new Productinfo());
}
}
public ActionResult DeleteConfirmed(int id)
{
Productinfo productinfo = db.Productinfoes.Find(id);
db.Productinfoes.Remove(productinfo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public Productinfo SelectByID(string productID)
{
Productinfo pinfo = new Productinfo();
productdao pDao = new productdao();
pinfo = pDao.SelectByID(productID);
return(pinfo);
}
//
// GET: /Productinfo/Details/5
public ActionResult Details(int id = 0)
{
Productinfo productinfo = db.Productinfoes.Find(id);
if (productinfo == null)
{
return(HttpNotFound());
}
return(View(productinfo));
}
public override void Updata(object data)
{
if (data == null)
{
return;
}
base.Updata(data);
this.data = (Productinfo)data;
this.title.text = this.data.name;
this.rechargeBtnTxt.text = string.Format("充值{0}元", this.data.rmb);
}
public ActionResult Edit(Productinfo productinfo)
{
if (ModelState.IsValid)
{
db.Entry(productinfo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductBrandId = new SelectList(db.productBrand, "Id", "Brand", productinfo.ProductBrandId);
ViewBag.ProductCategoryId = new SelectList(db.productCatagory, "Id", "Category", productinfo.ProductCategoryId);
ViewBag.OccasionId = new SelectList(db.occasion, "Id", "ProductOccasion", productinfo.OccasionId);
return(View(productinfo));
}
//
// GET: /Productinfo/Edit/5
public ActionResult Edit(int id = 0)
{
Productinfo productinfo = db.Productinfoes.Find(id);
if (productinfo == null)
{
return(HttpNotFound());
}
ViewBag.ProductBrandId = new SelectList(db.productBrand, "Id", "Brand", productinfo.ProductBrandId);
ViewBag.ProductCategoryId = new SelectList(db.productCatagory, "Id", "Category", productinfo.ProductCategoryId);
ViewBag.OccasionId = new SelectList(db.occasion, "Id", "ProductOccasion", productinfo.OccasionId);
return(View(productinfo));
}
public async Task <IActionResult> Create([Bind("Id,Idproductmenuinfo,Idproduct,Description,Datecreate")] Productinfo productinfo)
{
if (ModelState.IsValid)
{
productinfo.Datecreate = DateTime.Now;
_context.Add(productinfo);
await _context.SaveChangesAsync();
return(Redirect("~/Admin/Productinfoes/Index/" + productinfo.Idproduct));
}
ViewData["idproduct"] = new SelectList(_context.Products, "Id", "Title", productinfo.Idproduct);
ViewData["idproductmenuinfo"] = new SelectList(_context.Productmenuinfos.Where(a => a.Idsubmenu == productinfo.Idproductmenuinfo), "Id", "Title", productinfo.Idproductmenuinfo);
return(View(productinfo));
}
public void DelectProductByProductId(Productinfo prinfo)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
var pr = (from pro in db.products where pro.ProductID == prinfo.ProductID select pro).First();
db.products.DeleteOnSubmit(pr);
db.SubmitChanges();
}
}
catch (Exception ex)
{
Productinfo p = new Productinfo();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string productId = Request.QueryString["ProductID"];
productInfo = productCtlr.SelectByID(productId);
if (!Page.IsPostBack)
{
ltProductName.Text = productInfo.ProductName.ToString();
ltAboutProduct.Text = productInfo.Product_description.ToString();
rptMainList.DataSource = SelectProductImagebyProductId(productId);
rptMainList.DataBind();
shopItemsLst = new List <Productinfo>();
}
}
public ActionResult Create(Productinfo productinfo)
{
if (ModelState.IsValid)
{
ViewBag.Name = productinfo.Name;
db.Productinfoes.Add(productinfo);
//Session["productinfo_Name_ID"] = productinfo.Name + productinfo.ID;
db.SaveChanges();
Session["productinfo_Name_ID"] = productinfo.Name + db.Productinfoes.Max(x => x.ID);
return(RedirectToAction("PhotoUpload"));
}
ViewBag.ProductBrandId = new SelectList(db.productBrand, "Id", "Brand", productinfo.ProductBrandId);
ViewBag.ProductCategoryId = new SelectList(db.productCatagory, "Id", "Category", productinfo.ProductCategoryId);
ViewBag.OccasionId = new SelectList(db.occasion, "Id", "ProductOccasion", productinfo.OccasionId);
return(View(productinfo));
}
public void Test1()
{
Productinfo objProductInfo6 = new Productinfo()
{
GroupID = Searchgroupid.Searchid("Dairy"),
ID = 6,
Name = "Kokarakko-Cheese",
Description = "Kokkarakko-Cheese-180g",
Rate = 300
};
ProductDetailsFill objProdDetailsFill = new ProductDetailsFill();
List <Productinfo> ProductInfo = objProdDetailsFill.Productfill();
List <Productinfo> Productaddedlist = objProdDetailsFill.AddProduct(ProductInfo, objProductInfo6);
int x = Productaddedlist.Count();
Assert.Equal(6, x);
}
public async Task <IActionResult> Edit(long Id, [Bind("Id,Idproductmenuinfo,Idproduct,Description,Datecreate")] Productinfo productinfo)
{
if (Id != productinfo.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
productinfo.Datecreate = DateTime.Now;
_context.Update(productinfo);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductinfoExists(productinfo.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(Redirect("~/Admin/Productinfoes/Index/" + productinfo.Idproduct));
}
var pto = _context.Products.
Include(p => p.IdmenuNavigation)
.Where(p => p.Id == Id).FirstOrDefault();
ViewData["Product"] = pto;
ViewData["idproduct"] = new SelectList(_context.Products.Where(a => a.Id == Id), "Id", "Title");
var bb = new SelectList(_context.Productmenuinfos.Where(a => a.Idsubmenu == pto.Idmenu), "Id", "Title");
ViewData["idproductmenuinfo"] = bb;
return(View(productinfo));
}
public List <Productinfo> SelectProductsByCategoryId(string categoryId)
{
try
{
List <Productinfo> lstpinfo = new List <Productinfo>();
using (RMSDataContext db = new RMSDataContext())
{
Productinfo pinfo;
var b = (from c in db.products where c.CategoryID == categoryId select c).ToList();
foreach (var obj in b)
{
pinfo = new Productinfo();
pinfo.ProductID = obj.ProductID;
pinfo.ProductName = obj.ProductName;
pinfo.Product_description = obj.Product_description;
pinfo.CategoryID = obj.CategoryID;
pinfo.SupplierID = obj.SupplierID;
pinfo.BrandID = obj.BrandID;
pinfo.UMID = obj.UMID;
pinfo.Color = obj.Color;
pinfo.Size = obj.Size;
pinfo.UnitPrice = obj.UnitPrice;
pinfo.Manufacture_date = obj.Manufacture_date;
pinfo.Product_Expired_date = obj.Product_Expired_date;
pinfo.Manufacture_Country = obj.Manufacture_Country.ToString();
pinfo.Inserted_date = obj.Inserted_date;
pinfo.Expired_date = obj.Expired_date;
lstpinfo.Add(pinfo);
}
return(lstpinfo);
}
}
catch (Exception ex)
{
return(new List <Productinfo>());
}
}
public void DelectProduct(Productinfo prinfo)
{
pDao = new productdao();
pDao.DelectProductByProductId(prinfo);
}
public void UpdateProduct(Productinfo prinfo)
{
pDao = new productdao();
pDao.UpdateProductByProductId(prinfo);
}
protected void btnSave_Click(object sender, EventArgs e)
{
Productinfo prinfo = new Productinfo();
ProductController pcon = new ProductController();
prinfo.ProductName = txtProductName.Text.Trim();
prinfo.Product_description = txtDesc.Text.Trim();
prinfo.Color = txtColor.Text.Trim();
prinfo.Size = txtSize.Text.Trim();
prinfo.Manufacture_Country = txtMade.Text.Trim();
prinfo.UnitPrice = Convert.ToDecimal(txtSellPrice.Text.Trim());
prinfo.Manufacture_date = Convert.ToDateTime(txtManuDate.Text.Trim());
prinfo.Expired_date = Convert.ToDateTime(txtExpDate.Text.Trim());
prinfo.Product_Expired_date = Convert.ToDateTime(txtExpDate.Text.Trim());
prinfo.BrandID = ddlBrand.SelectedItem.Value;
prinfo.CategoryID = ddlCateogry.SelectedItem.Value;
prinfo.SupplierID = ddlSupplier.SelectedItem.Value;
prinfo.UMID = ddlUM.SelectedItem.Value;
//pcon.InsertProduct(prinfo);
string productID = pcon.InsertProduct(prinfo);
Inventoryinfo invinfo = new Inventoryinfo();
Invertorycontroller invCon = new Invertorycontroller();
invinfo.ProductID = productID;
invinfo.UnitInStock = Convert.ToInt32(txtUnitStock.Text.Trim());
string invId = invCon.InsertInventory(invinfo);
ReorderInfo rinfo = new ReorderInfo();
ReorderController rcon = new ReorderController();
rinfo.ProductID = productID;
rinfo.InventoryID = invId;
rinfo.ReorderUnit = txtReorder.Text.Trim();
rcon.InsertReorder(rinfo);
Cell_Priceinfoinfo cinfo = new Cell_Priceinfoinfo();
Cell_PriceController ccon = new Cell_PriceController();
cinfo.Cell_Price1 = Convert.ToDecimal(txtBuyPrice.Text.Trim());
cinfo.Cell_Price2 = Convert.ToDecimal(txtSellPrice.Text.Trim());
cinfo.Product_id = productID;
cinfo.UMID = ddlUM.SelectedItem.Value;
ccon.InsertCell_Price(cinfo);
if (fuMain.HasFile)
{
product_imageinfo piminfo = new product_imageinfo();
ProductImageController pimcon = new ProductImageController();
piminfo.ProductID = productID;
piminfo.Images = fuMain.FileBytes;
piminfo.MainPic = true;
pimcon.InsertProductImage(piminfo);
}
if (fuLeft.HasFile)
{
product_imageinfo piminfo = new product_imageinfo();
ProductImageController pimcon = new ProductImageController();
piminfo.ProductID = productID;
piminfo.Images = fuLeft.FileBytes;
pimcon.InsertProductImage(piminfo);
}
if (FuBehind.HasFile)
{
product_imageinfo piminfo = new product_imageinfo();
ProductImageController pimcon = new ProductImageController();
piminfo.ProductID = productID;
piminfo.Images = FuBehind.FileBytes;
piminfo.MainPic = false;
pimcon.InsertProductImage(piminfo);
}
if (fuRight.HasFile)
{
product_imageinfo piminfo = new product_imageinfo();
ProductImageController pimcon = new ProductImageController();
piminfo.ProductID = productID;
piminfo.Images = fuRight.FileBytes;
piminfo.MainPic = false;
pimcon.InsertProductImage(piminfo);
}
if (fuFront.HasFile)
{
product_imageinfo piminfo = new product_imageinfo();
ProductImageController pimcon = new ProductImageController();
piminfo.ProductID = productID;
piminfo.Images = fuFront.FileBytes;
piminfo.MainPic = false;
pimcon.InsertProductImage(piminfo);
}
if (fuBottom.HasFile)
{
product_imageinfo piminfo = new product_imageinfo();
ProductImageController pimcon = new ProductImageController();
piminfo.ProductID = productID;
piminfo.Images = fuBottom.FileBytes;
piminfo.MainPic = false;
pimcon.InsertProductImage(piminfo);
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('New Product Inserted Successfully!')", true);
}
public Productinfo Add(Productinfo P)
{
_ctx.Prodinfo.Add(P);
Commit();
return(P);
}
public Productinfo Update(Productinfo updateProducts)
{
throw new NotImplementedException();
}
protected string listingImage(Productinfo info)
{
return("<img class='postedimage' src='" + "Controller/productImgHandler.ashx?ProIMID=" + info.ProductID + "' />");
}
public string InsertProduct(Productinfo prinfo)
{
pDao = new productdao();
return(pDao.InsertProduct(prinfo));
}
