public TaskRecord GetTaskRecord(int id)
{
using (var sqlWrapper = new SqlQueryWrapper(_connStr))
{
TaskRecord taskRecord = null;
sqlWrapper.Run((db) =>
{
var options = new DataLoadOptions();
options.LoadWith <TaskRecord>(t => t.User);
options.LoadWith <TaskRecord>(t => t.User1);
options.LoadWith <TaskRecord>(t => t.Client);
options.LoadWith <TaskRecord>(t => t.Analyses_Equipment);
options.LoadWith <Analyses_Equipment>(ae => ae.Equipment);
options.LoadWith <Equipment>(e => e.Building);
options.LoadWith <Equipment>(e => e.EquipmentType);
options.LoadWith <EquipmentType>(et => et.EquipmentClass);
options.LoadWith <Building>(b => b.State);
options.LoadWith <Building>(b => b.Country);
db.LoadOptions = options;
taskRecord = db.TaskRecords.SingleOrDefault(t => t.TaskID == id);
});
return(taskRecord);
}
}
public Equipment GetEquipment(int id)
{
using (var sqlWrapper = new SqlQueryWrapper(_connStr))
{
return(sqlWrapper.Run((db) => db.Equipments.SingleOrDefault(e => e.EID == id)));
}
}
public int InsertTaskRecord(TaskRecord taskRecord)
{
using (var sqlWrapper = new SqlQueryWrapper(_connStr))
{
sqlWrapper.Run((db) =>
{
db.TaskRecords.InsertOnSubmit(taskRecord);
db.SubmitChanges();
});
return(taskRecord.TaskID);
}
}
public void InsertWorkOrder(ModelTaskRecord taskRecord)
{
using (var sqlWrapper = new SqlQueryWrapper(_connStr))
{
sqlWrapper.Run((db) =>
{
var existingTaskRecord = db.TaskRecords.Single(t => t.TaskID == taskRecord.TaskId);
existingTaskRecord.WorkOrderID = taskRecord.WorkOrderId;
db.SubmitChanges();
});
}
}
public void UpdateTaskRecord(ModelTaskRecord modelTaskRecord)
{
using (var sqlWrapper = new SqlQueryWrapper(_connStr))
{
sqlWrapper.Run((db) =>
{
var existingTaskRecord = db.TaskRecords.Single(t => t.TaskID == modelTaskRecord.TaskId);
existingTaskRecord.Summary = modelTaskRecord.Summary;
existingTaskRecord.AssignedUID = modelTaskRecord.AssignedUid;
existingTaskRecord.StatusID = modelTaskRecord.StatusId;
existingTaskRecord.DateCompleted = modelTaskRecord.DateCompleted;
existingTaskRecord.Description = modelTaskRecord.Description;
existingTaskRecord.Recommendations = modelTaskRecord.Recommendations;
existingTaskRecord.Actions = modelTaskRecord.Actions;
existingTaskRecord.AnnualAvoidableCost = modelTaskRecord.AnnualAvoidableCost;
existingTaskRecord.AnnualAvoidableHeatingUse = modelTaskRecord.AnnualAvoidableHeatingUse;
existingTaskRecord.AnnualAvoidableCoolingUse = modelTaskRecord.AnnualAvoidableCoolingUse;
existingTaskRecord.AnnualAvoidableElectricUse = modelTaskRecord.AnnualAvoidableElectricUse;
existingTaskRecord.DateModified = modelTaskRecord.DateModified;
existingTaskRecord.LastModifiedUID = modelTaskRecord.LastModifiedUid;
if (modelTaskRecord.CreateWorkOrder)
{
existingTaskRecord.WorkOrderID = modelTaskRecord.WorkOrderId;
}
db.SubmitChanges();
});
}
}
public void SetNextClientTaskId(ModelTaskRecord taskRecord)
{
var clientTaskId = 1;
using (var sqlWrapper = new SqlQueryWrapper(_connStr))
{
sqlWrapper.Run((db) =>
{
var tr = db.TaskRecords.Where(_ => _.CID == taskRecord.Cid);
if (tr.Any())
{
clientTaskId = tr.Max(_ => _.ClientTaskID) + 1;
}
});
taskRecord.ClientTaskId = clientTaskId;
}
}
