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