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