public Owner updateOwner(string id, Owner owner)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
var query = (from acc in db.HOTEL_OWNERs where acc.OWNER_ID.Equals(Convert.ToInt32(id)) select acc);
if (query.Count() == 1)
{
HOTEL_OWNER acc = query.Single();
owner = new Owner()
{
ServiceProviderNumber = acc.SERVICE_PROVIDER_NUM,
ContactNumber = acc.CONTACT_NUM,
Email = acc.EMAIL,
Gender = acc.GENDER,
Name = acc.FULL_NAMES,
Surname = acc.SURNAME,
Title = acc.TITLE,
};
db.SubmitChanges();
return(owner);
}
else
{
return(null);
}
}
}
catch (Exception)
{
return(null);
}
}
public void deleteOwner(string ownerId)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
HOTEL_OWNER ToDelete = (from s in db.HOTEL_OWNERs where s.OWNER_ID.Equals(Convert.ToInt32(ownerId)) select s).Single();
db.HOTEL_OWNERs.DeleteOnSubmit(ToDelete);
db.SubmitChanges();
}
}
catch (Exception e)
{
e.GetBaseException();
}
}
public string RegisterOwner(Owner owner)
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
HOTEL_OWNER ownerLinq = null;
try
{
int ownerLinqTest = (from uOwner in db.HOTEL_OWNERs where uOwner.EMAIL.Equals(owner.Email) select uOwner).Count();
if (ownerLinqTest == 0)
{
ownerLinq.OWNER_ID = Convert.ToInt32(owner.ID);
ownerLinq.SERVICE_PROVIDER_NUM = Convert.ToInt32(owner.ServiceProviderNumber);
ownerLinq.FULL_NAMES = owner.Name;
ownerLinq.SURNAME = owner.Surname;
ownerLinq.GENDER = owner.Gender;
ownerLinq.EMAIL = owner.Email;
ownerLinq.CONTACT_NUM = owner.ContactNumber;
ownerLinq.PASSWORD = owner.Password;
ownerLinq.AUTHENTICATION_LEVEL = Convert.ToString(owner.AuthenticationLevel);
ownerLinq.TITLE = Convert.ToString(owner.Title);
db.HOTEL_OWNERs.InsertOnSubmit(ownerLinq);
db.SubmitChanges();
return("Success Regristration Successful" + " Your Service Provider Number:" + owner.ServiceProviderNumber);
}
else if (ownerLinqTest != 0)
{
return("Failed Username already exists");
}
}
catch (Exception)
{
return("Failed Registration failed, contact admin");
}
}
return("Failed Registration failed, contact admin");
}
public string changePassword(string id, string oldPassword, string newPassword)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
var query = (from acc in db.HOTEL_OWNERs where acc.OWNER_ID.Equals(Convert.ToInt32(id)) select acc);
if (query.Count() == 1)
{
HOTEL_OWNER student = query.Single();
string oldHashed = Secrecy.HashPassword(oldPassword);
string passwordInDB = student.PASSWORD;
if (oldHashed == passwordInDB)
{
student.PASSWORD = Secrecy.HashPassword(newPassword);
db.SubmitChanges();
return("Password Changed");
}
else
{
return("Incorrect old password");
}
}
else
{
return("Failed to change password");
}
}
}
catch (Exception)
{
return("Failed to change password");
}
}
public BaseUser Login(string email, string password)
{
CLIENT linqClient = null;
HOTEL_MANAGER linqManager = null;
HOTEL_OWNER linqOwner = null;
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
try
{
//Search queries
var query = (from uClient in db.CLIENTs where uClient.EMAIL.Equals(email) && uClient.PASSWORD.Equals(Secrecy.HashPassword(password)) select uClient);
int linqClientCount = query.Count();
if (linqClientCount == 1)
{
linqClient = query.Single();
BaseUser client = new BaseUser();
client.ID = linqClient.CLIENT_ID;
client.Title = linqClient.TITLE;
client.Surname = linqClient.SURNAME;
client.Name = linqClient.FULL_NAMES;
client.Gender = linqClient.GENDER;
client.Email = linqClient.EMAIL;
client.ContactNumber = linqClient.CONTACT_NUM;
client.AuthenticationLevel = linqClient.AUTHENTICATION_LEVEL;
return(client);
}
else if (linqClientCount == 0)
{
var query2 = (from uOff in db.HOTEL_MANAGERs where uOff.EMAIL.Equals(email) && uOff.PASSWORD.Equals(Secrecy.HashPassword(password)) select uOff);
int linqOfficerCount = query2.Count();
if (linqOfficerCount == 1)
{
linqManager = query2.Single();
if (linqManager.AUTHENTICATION_LEVEL == "M")
{
BaseUser manager = new BaseUser();
manager.Title = linqManager.TITLE;
manager.Surname = linqManager.SURNAME;
manager.Name = linqManager.FULL_NAMES;
manager.Gender = linqManager.GENDER;
manager.Email = linqManager.EMAIL;
manager.ContactNumber = linqManager.CONTACT_NUM;
manager.AuthenticationLevel = linqManager.AUTHENTICATION_LEVEL;
manager.ID = linqManager.MANAGER_ID;
return(manager);
}
else
{
return(null);
}
}
else
{
var query3 = (from uOwn in db.HOTEL_OWNERs where uOwn.EMAIL.Equals(email) && uOwn.PASSWORD.Equals(Secrecy.HashPassword(password)) select uOwn);
int linqOwnerCount = query3.Count();
if (linqOwnerCount == 1)
{
linqOwner = query3.Single();
BaseUser owner = new BaseUser();
owner.Title = linqOwner.TITLE;
owner.Surname = linqOwner.SURNAME;
owner.Name = linqOwner.FULL_NAMES;
owner.Gender = linqOwner.GENDER;
owner.Email = linqOwner.EMAIL;
owner.ContactNumber = linqOwner.CONTACT_NUM;
owner.AuthenticationLevel = linqOwner.AUTHENTICATION_LEVEL;
owner.ID = linqOwner.OWNER_ID;
return(owner);
}
else if (linqOwnerCount == 0)
{
return(null);
}
}
}
}
catch (Exception)
{
return(null); //Find another way
}
return(null); //Find another way
}
}
