public static bool AddMensa(Mensa m)
{
try
{
if (Mensa.Mensas.Exists(x => x.Name == m.Name))
{
MUtility.ShowError("Menza sa tim nazivom vec postoji");
return(false);
}
MenzaFullDto mdto = new MenzaFullDto();
mdto.Naziv = m.Name;
mdto.Lokacija = m.Location;
mdto.GpsLat = m.GPSLat;
mdto.GpsLong = m.GPSLong;
mdto.RadnoVreme = m.WorkTime;
mdto.VanrednoNeRadi = m.CurrentlyClosed;
Api.AddNewMensa(mdto);
Mensa.UpdateMensaList();
return(true);
}
catch (Exception ex)
{
MUtility.ShowException(ex);
return(false);
}
}
public static void PostLoginInit()
{
Faculty.UpdateFacultyList();
Mensa.UpdateMensaList();
Mensa.LoadPrices();
MSettings.LoadSettings();
}
public void Setup()
{
_deserializer = new XmlSerializer(typeof(Mensa));
Assembly.GetExecutingAssembly().GetManifestResourceNames().ToList().ForEach(l => Console.WriteLine(l));
using (var stream = Assembly.GetExecutingAssembly().GetManifestResourceStream("Mensa_KL.Sync.Tests.Resources.meals.xml"))
{
_mensa = _deserializer.Deserialize(stream) as Mensa;
}
}
private void RefreshList()
{
if (Mensa.Mensas == null)
{
return;
}
dgvMensaList.DataSource = Mensa.Mensas;
newMensa = null;
}
public static bool ChangeCurrentMensa(Mensa m)
{
if (m == null)
{
return(false);
}
MSettings.CurrentMensa = m;
return(true);
}
public ActionResult Detail(string id)
{
try
{
ViewBag.message = TempData["message"].ToString();
ViewBag.error = TempData["error"].ToString();
}
catch { }
var p = new Produkte();
double price = 0.0;
int vorrat = 1;
uint xid = Convert.ToUInt32(id);
using (var MensaContext = new Mensa())
{
var query = from be in MensaContext.Mahlzeiten
where be.ID == Convert.ToUInt32(id)
select be.Vorrat;
try
{
vorrat = query.Sum();
}
catch (Exception e)
{
var x = e.Message;
}
}
try {
uint t = Convert.ToUInt32(id);
p = Produkte.GetByID(t);
if (Session["role"] == null)
{
price = Produkte.GetPrice("Gast", p);
}
else
{
Models.Benutzer b = new Models.Benutzer();
b = Models.Benutzer.GetByNutzername(Session["name"].ToString());
price = Produkte.GetPrice(Models.Benutzer.Rolle(b), p);
}
ViewData["p"] = p;
ViewData["price"] = price;
return(View());
}catch (Exception ex)
{
ViewData["price"] = price;
ViewData["p"] = p;
return(View());
}
}
public static bool DeleteMensa(Mensa m)
{
try
{
Api.DeleteMensa(m.MensaID);
Mensa.UpdateMensaList();
return(true);
}
catch (Exception e)
{
MUtility.ShowException(e);
return(false);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
selectedMensa = null;
txtMenzaID.Text = "<NovaMenza>";
txtName.Text = "Unesi podatak";
txtGPS_Lat.Text = "Unesi podatak";
txtGPS_Lon.Text = "Unesi podatak";
txtLocation.Text = "Unesi podatak";
txtWorkTime.Text = "Unesi podatak";
cbxNotWorking.Checked = false;
txtName.Focus();
txtName.SelectAll();
newMensa = new Mensa();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (newMensa != null)
{
if (!ValidateInput())
{
MUtility.ShowInformation("Nevalidni podaci. Proverite sva polja!");
return;
}
newMensa.Name = txtName.Text;
newMensa.Location = txtLocation.Text;
newMensa.WorkTime = txtWorkTime.Text;
newMensa.CurrentlyClosed = cbxNotWorking.Checked;
newMensa.GPSLat = double.Parse(txtGPS_Lat.Text);
newMensa.GPSLong = double.Parse(txtGPS_Lon.Text);
MainController.AddMensa(newMensa);
RefreshList();
RefreshData();
newMensa = null;
return;
}
if (selectedMensa == null)
{
MUtility.ShowInformation("Odaberi menzu za izmenu");
return;
}
if (!ValidateInput())
{
MUtility.ShowInformation("Nevalidni podaci. Proverite sva polja!");
return;
}
selectedMensa.Name = txtName.Text;
selectedMensa.CurrentlyClosed = cbxNotWorking.Checked;
selectedMensa.Location = txtLocation.Text;
selectedMensa.GPSLong = double.Parse(txtGPS_Lon.Text);
selectedMensa.GPSLat = double.Parse(txtGPS_Lat.Text);
selectedMensa.WorkTime = txtWorkTime.Text;
MainController.UpdateMensa(selectedMensa);
RefreshList();
RefreshData();
}
public static bool UpdateMensa(Mensa m)
{
try
{
MenzaFullDto mdto = new MenzaFullDto();
mdto.IdMenze = m.MensaID;
mdto.GpsLat = m.GPSLat;
mdto.GpsLong = m.GPSLong;
mdto.Lokacija = m.Location;
mdto.RadnoVreme = m.WorkTime;
mdto.VanrednoNeRadi = m.CurrentlyClosed;
mdto.Naziv = m.Name;
Api.UpdateMenza(mdto);
Mensa.UpdateMensaList();
return(true);
}
catch (Exception e)
{
MUtility.ShowException(e);
return(false);
}
}
private void RefreshData()
{
if (dgvMensaList.SelectedRows.Count == 0)
{
txtMenzaID.Text = "";
txtName.Text = "";
txtLocation.Text = "";
txtWorkTime.Text = "";
cbxNotWorking.Checked = false;
txtGPS_Lat.Text = "";
txtGPS_Lon.Text = "";
return;
}
selectedMensa = (Mensa)dgvMensaList.SelectedRows[0].DataBoundItem;
txtMenzaID.Text = selectedMensa.MensaID.ToString();
txtName.Text = selectedMensa.Name;
txtLocation.Text = selectedMensa.Location;
txtWorkTime.Text = selectedMensa.WorkTime;
cbxNotWorking.Checked = selectedMensa.CurrentlyClosed;
txtGPS_Lat.Text = selectedMensa.GPSLat.ToString();
txtGPS_Lon.Text = selectedMensa.GPSLong.ToString();
newMensa = null;
}
public ActionResult Bestellen()
{
//
if (HttpContext.Request.Cookies.Get("dbwt") != null)
{
HttpCookie exists = HttpContext.Request.Cookies.Get("dbwt");
try
{
if (exists.Value != null)
{
Dictionary <string, Dictionary <int, int> > fromCookie = JsonConvert.DeserializeObject <Dictionary <string, Dictionary <int, int> > >(exists.Value);
// cookie-Wert in ein Objekt umwandeln (geben Sie in < > an, in welchen Typ)
foreach (var cookie in fromCookie)
{
using (var MensaContext = new Mensa())
{
try {
// Attribute für das Model p setzen
// Model für den nächsten Submit mit aufnehmen
// Submit löst SQL Operationen auf der DB aus
//Bestellung einfügen
MensaContext.BeginTransaction();
Models.Benutzer User = Models.Benutzer.GetByNutzername(cookie.Key);
var query = from bestmax in MensaContext.Bestellungen
//where be.Nutzername.Contains("db")
//select new {Vorname = be.Vorname, Nachname = be.Nachname};
select bestmax.Nummer;
Bestellungen best = new Bestellungen();
best.Benutzer = (uint)User.Nummer;
best.Bestellzeitpunkt = DateTime.Now;
best.Abholzeitpunkt = DateTime.Parse(Request["Abholdate"].ToString());
best.Endpreis = Convert.ToDouble(Request["Endpreis"].ToString());
best.Nummer = query.Max() + 1;
MensaContext.Insert <Bestellungen>(best);
//ID bekommen und einfügen
foreach (var mahl in cookie.Value)
{
Mahlzeitenxbestellungen mxb = new Mahlzeitenxbestellungen();
mxb.Anzahl = Convert.ToUInt32(mahl.Value);
mxb.Mahlzeiten = (uint?)mahl.Key;
mxb.Bestellungen = best.Nummer;
MensaContext.Insert <Mahlzeitenxbestellungen>(mxb);
//mxb einfügen
}
MensaContext.CommitTransaction();
}
catch
{
MensaContext.RollbackTransaction();
}
}
}
//Warenkorb leeren
Dictionary <string, Dictionary <int, int> > ret = new Dictionary <string, Dictionary <int, int> >();
ret.Add(Session["name"].ToString(), new Dictionary <int, int>());
exists.Value = JsonConvert.SerializeObject(ret);
HttpContext.Response.Cookies.Set(exists);
// zurück mit Meldung.
TempData["message"] = "Bestellung abgeschickt.";
return(RedirectToAction("index"));
}
else
{
TempData["message"] = "Bestellungen leer.";
return(RedirectToAction("index"));
}
}
catch (Exception e)
{
TempData["error"] = "Fehler Meldung: " + e.Message;
return(RedirectToAction("index"));
}
}
TempData["message"] = "Bestellung abgeschickt.";
return(RedirectToAction("index"));
}
public ActionResult AddToList()
{
int anz = 0;
var id = Convert.ToInt32(Request["id"].ToString());
var name = Session["name"].ToString();
using (var MensaContext = new Mensa())
{
var query = from ma in MensaContext.Mahlzeiten
where ma.ID == id
select ma.Vorrat;
try
{
anz = query.ToArray()[0];
}
catch (Exception e)
{
var x = e.Message;
return(Json(x, JsonRequestBehavior.AllowGet));
}
}
Dictionary <int, int> prod = new Dictionary <int, int>()
{
{ Convert.ToInt32(Request["id"].ToString()), 1 },
};
HttpCookie c = new HttpCookie("dbwt");
Dictionary <string, Dictionary <int, int> > fromCookie = new Dictionary <string, Dictionary <int, int> >();
fromCookie.Add(name, prod);
if (anz < 1)
{
ViewBag.message = "Ausverkauft.";
return(Redirect(Request.Headers["Referer"].ToString()));
}
if (HttpContext.Request.Cookies.Get("dbwt") != null)
{
// cookie auslesen
HttpCookie exists = HttpContext.Request.Cookies.Get("dbwt");
try
{
fromCookie = JsonConvert.DeserializeObject <Dictionary <string, Dictionary <int, int> > >(exists.Value);
if (fromCookie != null && fromCookie.ContainsKey(name))
{
//+1
if (fromCookie[name].ContainsKey(id))
{
if (anz - fromCookie[name][id] < 1)
{
TempData["message"] = "ALLE Verfügbare Mahlzeit(en) bereits in Bestellung.";
return(Redirect(Request.Headers["Referer"].ToString()));
}
else
{
fromCookie[name][id]++;
TempData["message"] = "Mahlzeit erneut zur bestellung hinzugefügt.";
}
}
else
{
//neu eingabe.
fromCookie[name].Add(Convert.ToInt32(Request["id"].ToString()), 1);
TempData["message"] = "Mahlzeit hinzugefügt.";
}
}
else
{
//Cookie von Wem anden
}
}
catch (Exception e)
{
TempData["error"] = e.Message;
}
// cookie neu setzten.
}
c.Value = JsonConvert.SerializeObject(fromCookie);
c.Expires = DateTime.Now.AddHours(2);
HttpContext.Response.Cookies.Set(c);
return(Redirect(Request.Headers["Referer"].ToString()));
}
// GET: Dispatch
public JsonResult Bestellungen()
{
var headers = Request.Headers;
/*
* try {
* if (headers["X-Authorize"] != "o2e1s1dpt4nwhwe")
* {
* // hier error code return.
*
* return Json( System.Net.HttpStatusCode.Unauthorized, JsonRequestBehavior.AllowGet);
* }
* }
* catch(Exception e)
* {
* return Json(e.Message, JsonRequestBehavior.AllowGet);
* }
*/
List <jsonreturn> jret = new List <jsonreturn>();
using (var MensaContext = new Mensa())
{
var query = from best in MensaContext.Bestellungen
join be in MensaContext.Benutzer on best.Benutzer equals be.Nummer
where best.Abholzeitpunkt <= DateTime.Now.AddHours(1) && best.Abholzeitpunkt >= DateTime.Now
//where be.Nutzername.Contains("db")
//select new {Vorname = be.Vorname, Nachname = be.Nachname};
select best;
var query2 = from bi in MensaContext.Bilder
select bi;
try
{
var list = query.ToList();
foreach (var item in list)
{
jsonreturn tmp = new jsonreturn();
tmp.Abholung = item.Abholzeitpunkt;
tmp.Bestellnummer = item.Nummer;
var queryNutzer = from be in MensaContext.Benutzer
where be.Nummer == item.Benutzer
select be;
tmp.Benutzer.EMail = queryNutzer.ToArray()[0].EMail;
tmp.Benutzer.Nachname = queryNutzer.ToArray()[0].Nachname;
tmp.Benutzer.Vorname = queryNutzer.ToArray()[0].Vorname;
tmp.Benutzer.Nutzername = queryNutzer.ToArray()[0].Nutzername;
var queryBXM = from bxm in MensaContext.Mahlzeitenxbestellungen
join ma in MensaContext.Mahlzeiten on bxm.Mahlzeiten equals ma.ID
join kat in MensaContext.Kategorien on ma.Kategorie equals kat.ID
where bxm.Bestellungen == item.Nummer
select new { bxm.Anzahl, ma.Vorrat, ma.Name, kat.Bezeichnung };
List <MahlListe> mahllist = new List <MahlListe>();
foreach (var bxm in queryBXM.ToList())
{
MahlListe tmpmahllist = new MahlListe();
tmpmahllist.Mahlzeit.Anzahl = bxm.Anzahl;
tmpmahllist.Mahlzeit.Vorrat = (uint)bxm.Vorrat;
tmpmahllist.Mahlzeit.Name = bxm.Name;
tmpmahllist.Mahlzeit.Kategorie = bxm.Bezeichnung;
mahllist.Add(tmpmahllist);
}
tmp.Mahlzeiten = mahllist;
jret.Add(tmp);
}
return(Json(jret, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
var x = e.Message;
return(Json(x, JsonRequestBehavior.AllowGet));
}
}
}
