public string insertQuestions(List <InpecQuestions> inspecQ)
{
INSPECTION_QUESTION questionLinq = null;
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
foreach (InpecQuestions question in inspecQ)
{
questionLinq = new INSPECTION_QUESTION()
{
CATEGORY_ID = question.CategoryId,
QUESTION = question.Question,
REQUIRES_PIC = question.RequiresPicture
};
db.INSPECTION_QUESTIONs.InsertOnSubmit(questionLinq);
}
db.SubmitChanges();
return("Success Insertion Successful");
}
}
catch (Exception)
{
return("Failed Insertion Failed");
}
}
public string insertEvaluationComMembers(List <EvaluationCommitte> evalCommitte)
{
EVALUATION_COMM comm = null;
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
foreach (EvaluationCommitte person in evalCommitte)
{
comm = new EVALUATION_COMM()
{
INSPEC_ID = person.InspecId,
IDENTIFICATION = person.Identification,
NAME = person.Name,
SURNAME = person.Surname,
OCCUPATION = person.Occupation,
COMPANY = person.Oraganisation
};
db.EVALUATION_COMMs.InsertOnSubmit(comm);
}
db.SubmitChanges();
return("Success Insertion Successful");
}
}
catch (Exception)
{
return("Failed Insertion Failed");
}
}
public string updateAccredApplication(CycleApplications application)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
var query = from accredApp in db.CYCLE_APPLICATIONs
where accredApp.HOTEL_ID.Equals(Convert.ToInt32(application.HotelId)) &&
accredApp.APPLICATION_ID.Equals(Convert.ToInt32(application.ApplicationId))
select accredApp;
CYCLE_APPLICATION updatedApp = new CYCLE_APPLICATION();
updatedApp = query.Single();
updatedApp.APP_STATUS = application.ApplicationStatus;
updatedApp.REASON = application.Reason;
db.SubmitChanges();
return("Success Update Successful");
}
}
catch (Exception)
{
return("Failed Update Failed");
}
}
public string changeInspecResultJason(string inspecId, string result)
{
HOTEL_INSPECTION inspec = null;
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
var query = from accInspec in db.HOTEL_INSPECTIONs
where accInspec.INSPEC_ID.Equals(Convert.ToInt32(inspecId))
select accInspec;
inspec = query.Single();
inspec.INSPEC_RESULT = result;
db.SubmitChanges();
return("Success Update Successful");
}
}
catch (Exception)
{
return("Failed Update Failed");
}
}
public string insertCategories(List <Category> cat)
{
CATEGORY catLinq = null;
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
foreach (Category category in cat)
{
catLinq = new CATEGORY()
{
CATEGORY_NAME = category.CategoryName,
};
db.CATEGORies.InsertOnSubmit(catLinq);
}
db.SubmitChanges();
return("Success Insertion Successful");
}
}
catch (Exception)
{
return("Failed Insertion Failed");
}
}
public string RegisterManager(Manager manager)
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
HOTEL_MANAGER officerLinq = null;
try
{
int officerLinqTest = (from uOfficer in db.HOTEL_MANAGERs where uOfficer.EMAIL.Equals(manager.Email) select uOfficer).Count();
if (officerLinqTest == 0)
{
officerLinq = ConvertToLinq.ConvertOfficerToLinqObject(manager);
db.HOTEL_MANAGERs.InsertOnSubmit(officerLinq);
db.SubmitChanges();
return("Success Regristration Successful");
}
else if (officerLinqTest != 0)
{
return("Failed Username already exists");
}
}
catch (Exception)
{
return("Failed Registration failed, contact admin");
}
}
return("Failed Registration failed, contact admin");
}
public string removeAdmin(string id)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
var query = (from acc in db.HOTEL_MANAGERs where acc.MANAGER_ID.Equals(Convert.ToInt32(id)) select acc);
if (query.Count() == 1)
{
HOTEL_MANAGER student = query.Single();
if (student.AUTHENTICATION_LEVEL == "A")
{
student.AUTHENTICATION_LEVEL = "S";
db.SubmitChanges();
return("Success Update Successful");
}
else
{
return("Failed");
}
}
else
{
return("Failed Error User Not Found");
}
}
}
catch (Exception)
{
return("Failed Update Failed");
}
}
public Manager updateOfficer(string id, Manager off)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
var query = (from acc in db.HOTEL_MANAGERs where acc.MANAGER_ID.Equals(Convert.ToInt32(id)) select acc);
if (query.Count() == 1)
{
HOTEL_MANAGER acc = query.Single();
off = new Manager()
{
EmployeeNumber = acc.EMPLOYEE_NUM,
CityID = acc.CITY_ID,
ContactNumber = acc.CONTACT_NUM,
Email = acc.EMAIL,
Gender = acc.GENDER,
Name = acc.FULL_NAMES,
Surname = acc.SURNAME,
Title = acc.TITLE,
};
db.SubmitChanges();
return(off);
}
else
{
return(null);
}
}
}
catch (Exception)
{
return(null);
}
}
public string RegisterClient(Client client)
{
//Using the using keyword ensures that the connection is closed automatically
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
CLIENT clientLinq = null;
try
{
int clientLinqTest = (from uStud in db.CLIENTs where uStud.EMAIL.Equals(client.Email) select uStud).Count();
if (clientLinqTest == 0)
{
clientLinq = ConvertToLinq.ConvertStudentToLinqObject(client);
db.CLIENTs.InsertOnSubmit(clientLinq);
db.SubmitChanges();
return("Success Regristration Successful");
}
else if (clientLinqTest != 0)
{
return("Failed Username already exists");
}
}
catch (Exception e)
{
return(e.GetBaseException().ToString());//"Registration failed, contact admin";
}
}
return("Why does this keeps happening???");
}
public OwnersCompany updateCompany(string id, OwnersCompany comp)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
var query = (from acc in db.OWNERS_COMPANies where acc.COMP_ID.Equals(Convert.ToInt32(id)) select acc);
if (query.Count() == 1)
{
OWNERS_COMPANY acc = query.Single();
comp = new OwnersCompany()
{
ContactNum = acc.CONTACT_NUM,
Email = acc.EMAIL,
CompanyName = acc.NAME,
RegNum = acc.REG_NUM
};
db.SubmitChanges();
return(comp);
}
else
{
return(null);
}
}
}
catch (Exception)
{
return(null);
}
}
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);
}
}
//**************************************************INSPECTION PROCESS**********************************************************************
public string performInspection(InspectionAdditionalDetails details)
{
INSPEC_ADD_DETAIL inspectionLinq = null;
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
//foreach (InspectionAdditionalDetails details in inspectionAddDet)
//{
inspectionLinq = new INSPEC_ADD_DETAIL()
{
INSPEC_ID = details.InspecId,
QUESTION = details.Question,
CORRECTIVE_ACTION = details.CorrectiveAction,
ANSWER = details.Answer,
};
db.INSPEC_ADD_DETAILs.InsertOnSubmit(inspectionLinq);
db.SubmitChanges();
if (details.InspecImages != null)
{
foreach (ImageFile image in details.InspecImages)
{
saveImage(image);
}
db.SubmitChanges();
}
}
return("Insertion Successfullllllllllllll");
}
//}
catch (Exception e)
{
return(e.Message + "hello");
}
}
public void deleteOfficer(string offId)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
HOTEL_MANAGER ToDelete = (from s in db.HOTEL_MANAGERs where s.MANAGER_ID.Equals(Convert.ToInt32(offId)) select s).Single();
db.HOTEL_MANAGERs.DeleteOnSubmit(ToDelete);
db.SubmitChanges();
}
}
catch (Exception e)
{
e.GetBaseException();
}
}
public void deleteCompany(string compId)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
OWNERS_COMPANY ToDelete = (from s in db.OWNERS_COMPANies where s.COMP_ID.Equals(Convert.ToInt32(compId)) select s).Single();
db.OWNERS_COMPANies.DeleteOnSubmit(ToDelete);
db.SubmitChanges();
}
}
catch (Exception e)
{
e.GetBaseException();
}
}
public string saveImage(ImageFile image)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
INSPEC_IMAGE fileToSave = ConvertToLinq.ConvertInspecImageToLinq(image);
db.INSPEC_IMAGEs.InsertOnSubmit(fileToSave);
db.SubmitChanges();
}
return("Success File Uploaded");
}
catch (Exception)
{
return("Failed Upload Failed");
}
}
public int applyForAccred(CycleApplications application)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
CYCLE_APPLICATION applicationToInsert = ConvertToLinq.ConvertAccredApplyToLinq(application);
db.CYCLE_APPLICATIONs.InsertOnSubmit(applicationToInsert);
db.SubmitChanges();
return(applicationToInsert.APPLICATION_ID);
}
}
catch (Exception)
{
return(-1);
}
}
public string insertCompany(OwnersCompany comp)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
OWNERS_COMPANY companyLinq = ConvertToLinq.ConvertCompanyToLinq(comp);
db.OWNERS_COMPANies.InsertOnSubmit(companyLinq);
db.SubmitChanges();
return("Success Adding company was successful");
}
}
catch (Exception)
{
return("Failed Adding company failed, contact admin");
}
}
public string deleteImage(string id)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
INSPEC_IMAGE fileToDelete = (from file in db.INSPEC_IMAGEs where file.IMAGE_ID.Equals(Convert.ToInt32(id)) select file).Single();
db.INSPEC_IMAGEs.DeleteOnSubmit(fileToDelete);
db.SubmitChanges();
return("Success Deletion successful");
}
}
catch (Exception)
{
return("Failed Unable to perform deletion");
}
}
public string cancelAccredit(string accommoId)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
HOTEL updateAccred = new HOTEL();
updateAccred = (from accommo in db.HOTELs
where accommo.HOTEL_ID.Equals(Convert.ToInt32(accommoId))
select accommo).Single();
updateAccred.ACCRED_STATUS = "CANCELLED";
db.SubmitChanges();
return("Success Cancellation made");
}
}
catch (Exception)
{
return("Failed to perform cancellation");
}
}
public string changePassword(string id, string oldPassword, string newPassword)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
var query = (from acc in db.HOTEL_MANAGERs where acc.MANAGER_ID.Equals(Convert.ToInt32(id)) select acc);
if (query.Count() == 1)
{
HOTEL_MANAGER 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 string updateAllCoordinatesInDb()
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
List <string> result = new List <string>();
List <ADDRESS> listAddr = new List <ADDRESS>();
var query = from a in db.ADDRESSes select a;
listAddr = query.ToList();
foreach (ADDRESS add in listAddr)
{
if (add.LATITUDE == null || add.LONGTUDE == null)
{
result = getLatLong(add.STREET, add.TOWN, add.CITY);
//Equate the ff to the result of the above
string lng = "";
string lat = "";
if (result.Count() == 2)
{
lat = result[0];
lng = result[1];
}
add.LONGTUDE = lng;
add.LATITUDE = lat;
}
}
db.SubmitChanges();
}
return("Success All coordinates updated");
}
catch (Exception)
{
return("Failed");
}
}
public string createInspection(HotelInspection inspection)
{
HOTEL_INSPECTION inspec = null;
//ACCRED_APPLICATION appl = null;
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
/*var query = from application in db.ACCRED_APPLICATIONs
* where application.ACCOMMO_ID.Equals(inspection.AccommoId) &&
* application.APPLICATION_ID.Equals(inspection.ApplicationId)
* select application;
*
* appl = new ACCRED_APPLICATION();
* appl = query.Single();
*
* appl.APP_STATUS = "APPROVED";
* appl.REASON = "CRITERIA MET";
* db.SubmitChanges();*/
inspec = new HOTEL_INSPECTION()
{
MANAGER_ID = inspection.OfficerId,
APPLICATION_ID = inspection.ApplicationId,
INSPEC_DATE = DateTime.Now,
INSPEC_RESULT = "PENDING"
};
db.HOTEL_INSPECTIONs.InsertOnSubmit(inspec);
db.SubmitChanges();
return("Success Insertion Successful");
}
}
catch (Exception)
{
return("Failed Insertion Failed");
}
}
public string accreditAccommo(string accommoId)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
HOTEL updateAccred = (from accommo in db.HOTELs
where accommo.HOTEL_ID.Equals(Convert.ToInt32(accommoId))
select accommo).Single();
updateAccred.ACCRED_STATUS = "ACCREDITED";
updateAccred.ACCRED_START_DATE = Convert.ToDateTime(DateTime.Now.AddYears(1).Year.ToString() + "-01-01");
updateAccred.ACCRED_EXPIRY_DATE = Convert.ToDateTime(AccreditationDuration.computeDuration());
db.SubmitChanges();
return("Success Accreditation made");
}
}
catch (Exception)
{
return("Failed to perform accreditation");
}
}
public int insertAddress(Address addr)
{
try
{
ADDRESS addrLnq = null;
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
addrLnq = new ADDRESS();
addrLnq = ConvertToLinq.ConvertAddressToLinq(addr);
db.ADDRESSes.InsertOnSubmit(addrLnq);
db.SubmitChanges();
int addrssID = addrLnq.ADDRESS_ID;
return(addrssID);// "Adding Address was successful";
}
}
catch (Exception)
{
return(-1);
}
}
public void makeRating(ClientHotelRatings ratingMade)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
var query = (from rating in db.CLIENT_HOTEL_RATINGs
where rating.CLIENT_ID.Equals(Convert.ToInt32(ratingMade.ClientID)) && rating.HOTEL_ID.Equals(Convert.ToInt32(ratingMade.HotelID))
select rating);
int count = query.Count();
if (count == 0)
{
CLIENT_HOTEL_RATING AccommoRating = new CLIENT_HOTEL_RATING()
{
HOTEL_ID = ratingMade.HotelID,
CLIENT_ID = ratingMade.ClientID,
RATING_VALUE = ratingMade.RatingValue
};
db.CLIENT_HOTEL_RATINGs.InsertOnSubmit(AccommoRating);
db.SubmitChanges();
}
if (count == 1)
{
CLIENT_HOTEL_RATING update = new CLIENT_HOTEL_RATING();
update = query.Single();
update.RATING_VALUE = ratingMade.RatingValue;
}
}
}
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 assignAccommodations(OfficerHandlesAccommo assignment)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
MANAGER_HANDLES_HOTEL insert = new MANAGER_HANDLES_HOTEL()
{
HOTEL_ID = assignment.AccommoID,
MANAGER_ID = assignment.OfficerID,
DATE_ASSIGNED = Convert.ToDateTime(assignment.AssignDate)
};
db.MANAGER_HANDLES_HOTELs.InsertOnSubmit(insert);
db.SubmitChanges();
return("Success");
}
}
catch (Exception e)
{
return("Failed " + e.Message);
}
}