public void Insert(Productline productline) { using (var entities = new toysforboysEntities()) { entities.productlines.Add(productline); entities.SaveChanges(); } }
public ActionResult DeleteConfirmed(string id) { Productline productline = db.Productlines.Find(id); db.Productlines.Remove(productline); db.SaveChanges(); return(RedirectToAction("Index")); }
public void Delete(Productline productline) { using (var entities = new toysforboysEntities()) { entities.productlines.Attach(productline); entities.productlines.Remove(productline); entities.SaveChanges(); } }
public ActionResult Edit([Bind(Include = "ProductLineID,ProductLineName")] Productline productline) { if (ModelState.IsValid) { db.Entry(productline).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(productline)); }
public ActionResult Create([Bind(Include = "ProductLineID,ProductLineName")] Productline productline) { if (ModelState.IsValid) { db.Productlines.Add(productline); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(productline)); }
// GET: Productlines/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Productline productline = db.Productlines.Find(id); if (productline == null) { return(HttpNotFound()); } return(View(productline)); }
public static bool IdCheck(List <Productline> l, Productline p) { bool b = false; foreach (Productline productline in l) { if (p.id == productline.id) { b = true; if (p.description == productline.description && p.name == productline.name) { throw new ArgumentException(); } break; } } return(b); }
public void Edit(Productline productline) { using (var entities = new toysforboysEntities()) { var originalProductline = entities.productlines.Find(productline.id); if (productline.name != string.Empty) { originalProductline.name = productline.name; } if (productline.description != string.Empty) { originalProductline.description = productline.description; } entities.SaveChanges(); } }
public bool ProductFilter(object prod) { bool result = true; Product p = prod as Product; Productline selectedProductLine = (Productline)comboBoxProductLine.SelectedValue; if (comboBoxProductLine.SelectedIndex > 0) { result = (p.ProductlineId == Convert.ToInt16(selectedProductLine.Id)); } if (result) { if (Discontinued_checkbox.IsChecked == true) { result = (p.BuyPrice == 0); if (!result && Apply_MQC_checkBox.IsChecked == true) { result = (p.QuantityInStock < Convert.ToInt32(Min_Quantity_textBox.Text) && p.BuyPrice != 0); } } else { if (result && Apply_MQC_checkBox.IsChecked == true) { result = (p.QuantityInStock < Convert.ToInt32(Min_Quantity_textBox.Text) && p.BuyPrice != 0); } } } return(result); }
public List <Product> GetProductsById(int ID) { List <Product> products = new List <Product>(); connection(); //sqlCommand.CommandText = "select * from Product where ProductlineId = @id"; string sample = "ProductsByID"; sqlCommand.CommandText = sample; sqlCommand.CommandType = System.Data.CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@ID", ID); sqlConnection.Open(); SqlDataReader dataReader = sqlCommand.ExecuteReader(); while (dataReader.Read()) { Product product = new Product(); Productline productline = new Productline(); product.Code = Convert.ToInt32(dataReader["Code"]); product.ProductlineID = Convert.ToInt32(dataReader["ProductlineID"]); product.Name = Convert.ToString(dataReader["Name"]); product.Scale = Convert.ToInt32(dataReader["Scale"]); product.Vendor = Convert.ToString(dataReader["Vendor"]); product.PdtDescription = Convert.ToString(dataReader["PdtDescription"]); product.QtyInStock = Convert.ToInt32(dataReader["QtyInStock"]); product.BuyPrice = Convert.ToInt32(dataReader["BuyPrice"]); product.MSRP = Convert.ToString(dataReader["MSRP"]); productline.ID = Convert.ToInt32(dataReader["ID"]); // productline.DesclnHTML = Convert.ToString(dataReader["DesclnHTML"]); productline.DesclnText = Convert.ToString(dataReader["DesclnText"]); productline.Image = Convert.ToString(dataReader["Image"]); product.productline = productline; products.Add(product); } sqlConnection.Close(); return(products); }