public static bool updatePersonalInfo(int a1, string a3, string a4, string a5) { try { var oldinfo = (from x in cnDB.enFelhasznaloSet where x.felhasznaloID == a1 select x).FirstOrDefault(); if (oldinfo == null) { return(false); } // userid pass, fullname, address string[] tmp = a4.Split(' '); string vnev = tmp[0], knev = ""; for (int i = 1; i < tmp.Length; i++) { knev += tmp[i] + " "; } knev = knev.TrimEnd(); tmp = a5.Split(' '); string irsz = tmp[0], vros = tmp[1], _cim = ""; for (int i = 2; i < tmp.Length; i++) { _cim += tmp[i] + " "; } _cim = _cim.TrimEnd(); /*var record = new enFelhasznalo() * { * felhasznalonev = oldinfo.felhasznalonev, * jelszo = a3, * email = oldinfo.email, * vezeteknev = vnev, * keresztnev = knev, * iranyitoszam = int.Parse(irsz), * varos = vros, * cim = _cim, * };*/ enFelhasznalo user = cnDB.enFelhasznaloSet.Single(x => x.felhasznaloID == a1); user.jelszo = a3; user.vezeteknev = vnev; user.keresztnev = knev; user.iranyitoszam = int.Parse(irsz); user.varos = vros; user.cim = _cim; cnDB.SaveChanges(); return(true); } catch (Exception) { } return(false); }
public static List <enKosar> getMyOrders(int a1) { List <enKosar> results = new List <enKosar>(); try { enFelhasznalo felhasz = (from x in cnDB.enFelhasznaloSet where x.felhasznaloID == a1 select x).FirstOrDefault(); if (felhasz == null) { return(null); } results = felhasz.enRendeles.ToList(); } catch (Exception) { } return(results); }
public static bool tryRegister(string a1, string a2, string a3, string a4, string a5) { try { // email, user, pass, fullname, address string[] tmp = a4.Split(' '); string vnev = tmp[0], knev = ""; for (int i = 1; i < tmp.Length; i++) { knev += tmp[i] + " "; } knev = knev.TrimEnd(); tmp = a5.Split(' '); string irsz = tmp[0], vros = tmp[1], _cim = ""; for (int i = 2; i < tmp.Length; i++) { _cim += tmp[i] + " "; } _cim = _cim.TrimEnd(); var record = new enFelhasznalo() { felhasznalonev = a2, jelszo = a3, email = a1, vezeteknev = vnev, keresztnev = knev, iranyitoszam = int.Parse(irsz), varos = vros, cim = _cim, }; cnDB.enFelhasznaloSet.Add(record); cnDB.SaveChanges(); return(true); } catch (Exception) { } return(false); }
public static int uploadOrder(int a1, DateTime a2, int a3) { try { var tmp = from x in cnDB.enFelhasznaloSet where x.felhasznaloID == a3 select x; enFelhasznalo felhasz = tmp.FirstOrDefault(); enKosar kosar = new enKosar() { szamla = a1, rendelesido = a2, enFelhasznalo = felhasz }; cnDB.enKosarSet.Add(kosar); cnDB.SaveChanges(); int id = (from x in cnDB.enKosarSet select x).OrderByDescending(a => a.rendelesID).FirstOrDefault().rendelesID; return(id); } catch (Exception) { } return(-1); }