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