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