public int RegisterGuest(EventGuest guest) { string reg = ""; HashPass hashedPass = new HashPass(); string pass = HashPass.HashPassword(guest.PASS); using (EventrixDBDataContext dbd = new EventrixDBDataContext()) { try { int MailChecker = (from gst in dbd.Guests where gst.Email.Equals(guest.EMAIL) select gst).Count(); if (MailChecker == 0) { Guest _guest = new Guest(); _guest.Name = guest.NAME; _guest.Email = guest.EMAIL; _guest.Surname = guest.SURNAME; _guest.Type = guest.TYPE; _guest.Password = pass; dbd.Guests.InsertOnSubmit(_guest); dbd.SubmitChanges(); reg = "success"; } else { reg = "fail"; } } catch (Exception e) { return(-1); } }; if (reg.Equals("success")) { using (EventrixDBDataContext db = new EventrixDBDataContext()) { try { var query = (from res in db.Guests select res).ToList(); Guest lastEntry = query.Last(); int ID = lastEntry.G_ID; return(ID); } catch (Exception) { return(-1); } }; } else { return(-1); } }
public bool deleteGuest(EventGuest _guest) { using (EventrixDBDataContext mde = new EventrixDBDataContext()) { try { int _id = Convert.ToInt32(_guest.ID); Guest gst = mde.Guests.Single(p => p.G_ID == _id); mde.Guests.DeleteOnSubmit(gst); //mde.Guests.Remove(gst); //mde.SaveChanges(); mde.SubmitChanges(); return(true); } catch { return(false); } }; }
public string InsertOTP(EventGuest guest, string ID) { HashPass hashedPass = new HashPass(); string pass = HashPass.HashPassword(guest.PASS); using (EventrixDBDataContext db = new EventrixDBDataContext()) { try { int _id = Convert.ToInt32(ID); var query = (from gst in db.Guests where gst.G_ID.Equals(_id) select gst).First(); Guest toUpdate = query; toUpdate.Password = pass; db.SubmitChanges(); return("success"); }catch (Exception) { return("fail"); } }; }
public bool editGuest(EventGuest _guest) { using (EventrixDBDataContext mde = new EventrixDBDataContext()) { try { int _id = Convert.ToInt32(_guest.ID); Guest gst = mde.Guests.Single(p => p.G_ID == _id); gst.Name = _guest.NAME; gst.Surname = _guest.SURNAME; gst.Password = _guest.PASS; gst.Email = _guest.EMAIL; mde.Guests.InsertOnSubmit(gst); //mde.SaveChanges(); return(true); } catch { return(false); } }; }
public bool createGuest(EventGuest _guest) { using (EventrixDBDataContext mde = new EventrixDBDataContext()) { try { Guest gst = new Guest(); gst.Name = _guest.NAME; gst.Surname = _guest.SURNAME; gst.Email = _guest.EMAIL; gst.Password = _guest.PASS; gst.Type = "Public"; mde.Guests.InsertOnSubmit(gst); //mde.Guests.Add(gst); //mde.SaveChanges(); mde.SubmitChanges(); return(true); } catch { return(false); } } }