public string getGuestId() { ThreeHotelEntities2 ct = new ThreeHotelEntities2(); Guest guest = new Guest(); guest = (from x in ct.Guests where x.GuestId.Contains("G") orderby x.GuestId descending select x).First(); string a = guest.GuestId; string b = a.Substring(4, 1); int d = Convert.ToInt32(b); string e = Convert.ToString(d + 1); string c = ""; if (d + 1 > 999) c = "G" + e; else if (d + 1 > 99) c = "G0" + e; else if (d + 1 > 9) c = "G00" + e; else c = "G000" + e; return c; }
public Boolean checkMember(string username, string pwd) { Boolean status = false; try { ThreeHotelEntities2 ct = new ThreeHotelEntities2(); User guest = new User(); string ppwd = Encrypt(pwd); var q = from x in ct.Users where x.MembershipId == username && x.Password == ppwd select x; User u = q.First(); if (u == null) status = false; else status = true; return status; } catch { return status; } }
public Guest getByMemberId(string id) { ThreeHotelEntities2 ct = new ThreeHotelEntities2(); Guest guest = new Guest(); guest = (from x in ct.Guests where x.GuestId == id select x).First(); return guest; }
public void MemberUpdate(string id, string salut, string familyName, string fName, string email, string address, string ph, string country) { ThreeHotelEntities2 ct = new ThreeHotelEntities2(); Guest g = new Guest(); g = (from x in ct.Guests where x.GuestId == id select x).First(); g.Salutation = salut; g.FamilyName = familyName; g.FirstName = fName; g.Email = email; g.Address = address; g.PhoneNo = ph; g.Country = country; ct.SaveChanges(); }
public string MemberSave(string salut, string familyName, string fName, string pwd, string email, string address, string ph, string country) { string id; ThreeHotelEntities2 ct = new ThreeHotelEntities2(); Guest g = new Guest(); User user = new User(); id = getMemberId(); g.GuestId = id; g.Salutation = salut; g.FamilyName = familyName; g.FirstName = fName; user.MembershipId = id; user.Password = Encrypt(pwd); g.Email = email; g.Address = address; g.PhoneNo = ph; g.Country = country; ct.Guests.Add(g); ct.Users.Add(user); ct.SaveChanges(); SendMail(fName,familyName,email,id); return id; }
public void MemberChangePwd(string id, string newpwd) { ThreeHotelEntities2 ct = new ThreeHotelEntities2(); User g = new User(); g = (from x in ct.Users where x.MembershipId == id select x).First(); g.Password = Encrypt(newpwd); ct.SaveChanges(); }