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