public List<DBModel.Product> visProdukter(int katnr) { var prodliste = new List<DBModel.Product>(); if (katnr == 0) { var produ = new DBModel.Product() { Productcategorynumber = 0 }; prodliste.Add(produ); prodliste.Add(produ); prodliste.Add(produ); return prodliste; } var produkt = new DBModel.Product() { Productid = 1, antall = 10, Title = "ProduktTest", antallBestilt = 5, Price = 100, Productcategorynumber = 1, Ordrelines = null, Productcategory = null, Productdescription = "Veldig bra Test", Picture = null }; prodliste.Add(produkt); prodliste.Add(produkt); prodliste.Add(produkt); return prodliste; }
public List<DBModel.Product> finnProduktvedId(int sok) { var list = new List<DBModel.Product>(); if (sok == 0) { var prod = new DBModel.Product() { Productid = 0 }; list.Add(prod); list.Add(prod); list.Add(prod); return list; } var produkt = new DBModel.Product() { Productid = 1, antall = 10, Title = "TestTittel", antallBestilt = 5, Price = 100, Productcategorynumber = 1, Ordrelines = null, Productcategory = null, Productdescription = "Test beskrivelse", Picture = null }; list.Add(produkt); list.Add(produkt); list.Add(produkt); return list; }
public List<DBModel.Product> finnProdukt(string sok) { var list = new List<DBModel.Product>(); if(sok == null) { var prod = new DBModel.Product() { Title = "" }; list.Add(prod); list.Add(prod); list.Add(prod); return list; } var produkt = new DBModel.Product() { Productid = 1, antall = 10, Title = sok, antallBestilt = 5, Price = 100, Productcategorynumber = 1, Ordrelines = null, Productcategory = null, Productdescription = sok, Picture = null }; list.Add(produkt); list.Add(produkt); list.Add(produkt); return list; }
public List<DBModel.Product> visProdukter(int katnr) { try { if (katnr == 0) return null; var prodliste = new List<DBModel.Product>(); var k = db.Productcategories.FirstOrDefault(u => u.Productcategorynumber == katnr); var produkter = (from produkt in db.Products where produkt.Productcategorynumber == katnr select produkt); if (produkter == null) return null; foreach (var item in produkter) { var prod = new DBModel.Product(); prod.Productid = item.Productid; prod.antall = item.antall; prod.Picture = item.Picture; prod.Price = item.Price; prod.Title = item.Title; prod.Productdescription = item.Productdescription; prod.Productcategory.Productcategory = k.Productcategory; prodliste.Add(prod); } return prodliste; } catch (System.Data.SqlClient.SqlException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (InvalidOperationException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (ArgumentException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (NullReferenceException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (SystemException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (Exception ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } return null; }
public List<DBModel.Product> finnProduktvedId(int sok) { try { if (sok == 0) return null; var list = new List<DBModel.Product>(); var item = db.Products.Where(u => u.Productid == sok).FirstOrDefault(); if (item != null) { var prod = new DBModel.Product(); prod.antall = item.antall; prod.Picture = item.Picture; prod.Price = item.Price; prod.Title = item.Title; prod.Productdescription = item.Productdescription; prod.Productcategorynumber = item.Productcategorynumber; prod.Productid = item.Productid; list.Add(prod); return list; } return null; } catch (System.Data.SqlClient.SqlException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (InvalidOperationException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (ArgumentException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (NullReferenceException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (SystemException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (Exception ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } return null; }
public List<DBModel.Product> finnProdukt(string sok) { try { if (sok == "" || sok == null) return null; var list = new List<DBModel.Product>(); var produkt = db.Products.Where(u => u.Title.Contains(sok) || u.Productdescription.Contains(sok)); if (produkt.Count() > 0) { foreach (var item in produkt) { var prod = new DBModel.Product(); prod.antall = item.antall; prod.Picture = item.Picture; prod.Price = item.Price; prod.Title = item.Title; prod.Productdescription = item.Productdescription; prod.Productcategorynumber = item.Productcategorynumber; prod.Productid = item.Productid; list.Add(prod); } return list; } return null; } catch (System.Data.SqlClient.SqlException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (InvalidOperationException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (ArgumentException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (NullReferenceException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (SystemException ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (Exception ex) { SWKP.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKP.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } return null; }