Beispiel #1
0
        public void Update(ProductModel productmodel)
        {
            using (WinHeEntities db = new WinHeEntities())
            {
                tbl_products tbl = (from recode in db.tbl_products where (recode.product_id == productmodel.product_id) select recode).FirstOrDefault();
                //tbl_products tbl = db.tbl_products.Where(x => x.product_id == productmodel.product_id).FirstOrDefault();

                tbl.product_description = productmodel.product_description;
                tbl.product_name        = productmodel.product_name;
                tbl.purchase_price      = productmodel.purchase_price;
                tbl.selling_price       = productmodel.selling_price;
                tbl.quantity            = productmodel.quantity;

                db.Entry(tbl).State = System.Data.Entity.EntityState.Modified;
                db.SaveChanges();
            }
        }
Beispiel #2
0
        public void Insert(ProductModel productmodel)
        {
            using (WinHeEntities db = new WinHeEntities())
            {
                tbl_products tbl = new tbl_products();

                try
                {
                    tbl.product_description = productmodel.product_description;
                    tbl.product_id          = productmodel.product_id;
                    tbl.product_name        = productmodel.product_name;
                    tbl.purchase_price      = productmodel.purchase_price;
                    tbl.selling_price       = productmodel.selling_price;
                    tbl.quantity            = productmodel.quantity;
                    db.tbl_products.Add(tbl);
                    db.SaveChanges();
                }
                catch (Exception)
                {
                    throw;
                }
            }
        }