//delete wait time record
public bool deleteWaitTime(Guid id)
{
EmergencyDataContext objRecord = new EmergencyDataContext();
using (objRecord)
{
var objDelRecord = objRecord.brdhc_Emergencies.Single(x => x.EmergencyID == id);
objRecord.brdhc_Emergencies.DeleteOnSubmit(objDelRecord);
objRecord.SubmitChanges();
return true;
}
}
// update wait time
public bool updateWaitTime(Guid id, TimeSpan time, string updateBy)
{
EmergencyDataContext objRecord = new EmergencyDataContext();
using(objRecord)
{
var objUpRecord = objRecord.brdhc_Emergencies.Single(x=>x.EmergencyID == id);
objUpRecord.WaitTime = time;
objUpRecord.UpdatedBy = updateBy;
objRecord.SubmitChanges();
return true;
}
}
// insert new wait time
public bool insertWaitTime(Guid id, TimeSpan _time, DateTime _addedOn, string _updateBy)
{
EmergencyDataContext objRecord = new EmergencyDataContext();
using (objRecord){
brdhc_Emergency objNewRecord = new brdhc_Emergency();
objNewRecord.EmergencyID = id;
objNewRecord.WaitTime = _time;
objNewRecord.AddedOn = _addedOn;
objNewRecord.UpdatedBy = _updateBy;
objRecord.brdhc_Emergencies.InsertOnSubmit(objNewRecord);
objRecord.SubmitChanges();
return true;
}
}
public IQueryable<brdhc_Emergency> getCurrentWaitTime()
{
EmergencyDataContext obj = new EmergencyDataContext();
var objCurrent = obj.brdhc_Emergencies.OrderByDescending(x => x.AddedOn).Take(1);
return objCurrent;
}
//get Record by ID
public IQueryable<brdhc_Emergency> getRecordByID(Guid id)
{
EmergencyDataContext objRecord = new EmergencyDataContext();
var singleRecord = objRecord.brdhc_Emergencies.Where(x => x.EmergencyID == id).Select(x => x);
return singleRecord;
}
// get all Records
public IQueryable<brdhc_Emergency> getEmergencyRecords() {
EmergencyDataContext objRecord = new EmergencyDataContext();
var allRecords = objRecord.brdhc_Emergencies.Select(x => x).OrderByDescending(x => x.AddedOn);
return allRecords;
}
