public MaximoWorkOrderService(IWorkOrderRepository repo, WoTask woTask, ModelTaskRecord taskRecord)
        {
            _repo = repo;

            _processor = new WorkOrderSoapProcessorFactory().GetWorkOrderSoapProcessor();

            _woTask = woTask;

            _taskRecord = taskRecord;
        }
        public MCSWorkOrderService(IWorkOrderRepository repo, CMMSConfig settings, WoTask woTask, ModelTaskRecord taskRecord)
        {
            _repo = repo;

            _processor = new WorkOrderSoapProcessorFactory().GetWorkOrderSoapProcessor();

            _settings = settings;

            _woTask = woTask;

            _taskRecord = taskRecord;
        }
        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;
            }
        }
Exemple #6
0
        public IWorkOrderService GetWorkOrderService(WoTask woTask, ModelTaskRecord taskRecord)
        {
            var connStr = ConfigurationManager.ConnectionStrings["CWConnectionString"].ConnectionString;

            var _repo = new WorkOrderRepositoryFactory().GetWorkOrderRepository(connStr);

            var settings = _repo.GetSettings(taskRecord.Bid);

            switch (settings.VendorId)
            {
            case 1:
                return(null);

            case 2:
                return(new MaximoWorkOrderService(_repo, woTask, taskRecord));

            case 3:
                return(new MCSWorkOrderService(_repo, settings, woTask, taskRecord));

            default:
                return(null);
            }
        }