public static void Order(NameValueCollection form, string userName, out string msg) { msg = ""; try { using (DbwtDB db = new DbwtDB()) { var result = db.Benutzer.Where(b => b.Nutzername.Equals(userName)).FirstOrDefault() ?.Nummer; int userId = result != null?Convert.ToInt32(result) : 0; //TODO: we shouldn't let any faulty user order int key = db.InsertWithInt32Identity(new DbModels.Bestellungen { Bestellzeitpunkt = DateTime.Now, Abholzeitpunkt = DateTime.Parse(form["time"]), Endpreis = Double.Parse(form["totalCost"]), GetätigtVon = userId }); List <Bestellungenenthältmahlzeiten> list = form.AllKeys .Where(k => Int32.TryParse(k, out int n)).Select(k => new Bestellungenenthältmahlzeiten { Bestellung = key, Mahlzeit = Int32.Parse(k), Anzahl = Int32.Parse(form[k]) }).ToList(); db.BulkCopy(list); } } catch (Exception e) { msg = e.Message; } }
} // int(11) public static List <Bestellungen> GetDispatch(int hours, out string msg) { List <Bestellungen> list = null; try { using (DbwtDB db = new DbwtDB()) { list = db.Bestellungen.Where(b => DateTime.Now <b.Abholzeitpunkt && //after now DateTime.Now.AddHours(1)> b.Abholzeitpunkt) //in max 1h .ToList(); } } catch (Exception e) { msg = e.Message; return(list); } msg = ""; return(list); }