public ActionResult visOrdre()
{
if (Request.IsAuthenticated)
{
if (_adminBLL.erAnsatt(User.Identity.Name))
{
var list = _produktBLL.hentOrdre("Ubehandlet");
var item = new List<SelectListItem>();
item.Add(new SelectListItem { Text = "Ubehandlet", Value = "Ubehandlet" });
item.Add(new SelectListItem { Text = "Sendt til Plukk", Value = "Plukkes" });
item.Add(new SelectListItem { Text = "Ferdig Plukket", Value = "Plukket" });
item.Add(new SelectListItem { Text = "Sendt", Value = "Sendt" });
item.Add(new SelectListItem { Text = "Motatt", Value = "Motatt" });
ViewBag.status = item;
if (list != null)
return View(list);
else
{
var tomliste = new List<DBModel.Order>();
var tomordre = new DBModel.Order();
tomordre.status = "";
tomliste.Add(tomordre);
return View(tomliste);
}
}
return RedirectToAction("logginn", "Admin");
}
return RedirectToAction("logginn", "Admin");
}
public List<DBModel.Order> hentOrdre(string status)
{
var liste = new List<DBModel.Order>();
if(status== null)
{
var ordre = new DBModel.Order()
{
status = ""
};
liste.Add(ordre);
liste.Add(ordre);
liste.Add(ordre);
return liste;
}
var o = new DBModel.Order()
{
dato = DateTime.Today,
Confirmed = true,
Email = "*****@*****.**",
Ordernumber = 1,
status = status,
statusDato = DateTime.Today
};
liste.Add(o);
liste.Add(o);
liste.Add(o);
return liste;
}
public List<DBModel.Order> VisOrdreListe(string email)
{
var ordreliste = new List<DBModel.Order>();
if (email == null)
{
var orderfail = new DBModel.Order()
{
Ordernumber = 0
};
ordreliste.Add(orderfail);
ordreliste.Add(orderfail);
ordreliste.Add(orderfail);
return ordreliste;
}
var order = new DBModel.Order()
{
Confirmed = true,
Email = "*****@*****.**",
Ordernumber = 1,
dato = DateTime.Today
};
ordreliste.Add(order);
ordreliste.Add(order);
ordreliste.Add(order);
return ordreliste;
}
public List<DBModel.User> KundeListeSøk(string searchby, string search)
{
try
{
if (search == null || search == "")
{
return null;
}
if (searchby == "Epost")
{
var kundeepost = (db.Users.Where(x => x.Email.Contains(search)).ToList());
var sendkunde = new List<DBModel.User>();
var ordreliste = new List<DBModel.Order>();
foreach (var item in kundeepost)
{
var kunde = new DBModel.User();
kunde.Email = item.Email;
kunde.Firstname = item.Firstname;
kunde.Lastname = item.Lastname;
kunde.Orders = null;
foreach (var order in item.Orders)
{
var orderkunde = new DBModel.Order();
orderkunde.Confirmed = orderkunde.Confirmed;
orderkunde.dato = orderkunde.dato;
orderkunde.Email = orderkunde.Email;
orderkunde.Ordernumber = orderkunde.Ordernumber;
orderkunde.status = orderkunde.status;
orderkunde.statusDato = orderkunde.statusDato;
ordreliste.Add(orderkunde);
}
kunde.Orders = ordreliste;
sendkunde.Add(kunde);
}
return sendkunde.ToList();
}
else
{
var kundeepost = (db.Users.Where(x => x.Lastname.Contains(search)).ToList());
var sendkunde = new List<DBModel.User>();
var ordreliste = new List<DBModel.Order>();
foreach (var item in kundeepost)
{
var kunde = new DBModel.User();
kunde.Email = item.Email;
kunde.Firstname = item.Firstname;
kunde.Lastname = item.Lastname;
kunde.Orders = null;
foreach (var order in item.Orders)
{
var orderkunde = new DBModel.Order();
orderkunde.Confirmed = orderkunde.Confirmed;
orderkunde.dato = orderkunde.dato;
orderkunde.Email = orderkunde.Email;
orderkunde.Ordernumber = orderkunde.Ordernumber;
orderkunde.status = orderkunde.status;
orderkunde.statusDato = orderkunde.statusDato;
ordreliste.Add(orderkunde);
}
kunde.Orders = ordreliste;
sendkunde.Add(kunde);
}
return sendkunde.ToList();
}
}
catch (System.Data.SqlClient.SqlException ex)
{
SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
catch (InvalidOperationException ex)
{
SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
catch (ArgumentException ex)
{
SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
catch (NullReferenceException ex)
{
SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
catch (SystemException ex)
{
SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
catch (Exception ex)
{
SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
return null;
}
public List<DBModel.Order> hentOrdre(string status)
{
try
{
if (status == null || status == "")
{ return null; }
var liste = new List<DBModel.Order>();
var ordre = db.Orders.Where(u => u.status == status);
if (ordre != null)
{
foreach (var item in ordre)
{
var o = new DBModel.Order();
o.dato = item.dato;
o.Confirmed = item.Confirmed;
o.Email = item.Email;
o.Ordernumber = item.Ordernumber;
o.status = item.status;
o.statusDato = item.statusDato;
o.Orderlines = new List<DBModel.OrderLine>();
liste.Add(o);
}
}
var prodliste = new List<DBModel.OrderLine>();
foreach (var item in liste)
{
var orderline = db.Orderlines.Where(u => u.Ordernumber == item.Ordernumber);
foreach (var prod in orderline)
{
var ol = new DBModel.OrderLine();
ol.Ordernumber = prod.Ordernumber;
ol.Priceperunit = prod.Priceperunit;
ol.Productid = prod.Productid;
ol.Quantity = prod.Quantity;
ol.Order = new DBModel.Order()
{
statusDato = prod.Order.statusDato,
status = prod.Order.status,
};
prodliste.Add(ol);
}
item.Orderlines = prodliste;
}
return liste;
}
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.Order> VisOrdreListe(string email)
{
try
{
if (email == null || email == "")
return null;
var ordreliste = new List<DBModel.Order>();
var user = db.Users.FirstOrDefault(u => u.Email == email);
if (user == null)
return null;
var bekreftedeOrdre = from ordre in db.Orders
where ordre.Confirmed == true && ordre.Email == user.Email
select ordre;
if (bekreftedeOrdre == null)
return null;
foreach (var item in bekreftedeOrdre)
{
var order = new DBModel.Order();
order.Confirmed = item.Confirmed;
order.Email = item.Email;
order.Ordernumber = item.Ordernumber;
order.dato = item.dato;
order.status = item.status;
order.statusDato = item.statusDato;
ordreliste.Add(order);
}
return ordreliste;
}
catch (System.Data.SqlClient.SqlException ex)
{
SWKR.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
SWKR.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
catch (InvalidOperationException ex)
{
SWKR.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
SWKR.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
catch (ArgumentException ex)
{
SWKR.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
SWKR.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
catch (NullReferenceException ex)
{
SWKR.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
SWKR.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
catch (SystemException ex)
{
SWKR.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
SWKR.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
catch (Exception ex)
{
SWKR.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
SWKR.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
return null;
}
