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 } }