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 Host HostLogin(string email, string password) { HashPass hashedPass = new HashPass(); string pass = HashPass.HashPassword(password); using (EventrixDBDataContext mde = new EventrixDBDataContext()) { try { return(mde.EventHosts.Where(pe => pe.Email == email && pe.Password == pass).Select(pe => new Host { ID = pe.EH_ID, NAME = pe.Name, EMAIL = pe.Email, SURNAME = pe.Surname, PASS = pe.Password, }).First()); } catch { return(null); } }; }