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