/// <summary> /// Metodo encargado de eliminar un error de cargar de orden de trabajo /// </summary> /// <param name="idWorkOrder"></param> /// <returns></returns> public Boolean DeleteWorkOrderError(String idWorkOrderErp, String iddealerShopErp) { if (!String.IsNullOrEmpty(idWorkOrderErp) && !String.IsNullOrEmpty(iddealerShopErp)) { using (SystimedbEntities Systimedb = new SystimedbEntities(ConectionString)) { WorkOrderLoadErrorLog currentEntity = Systimedb.WorkOrderLoadErrorLog.FirstOrDefault(w => w.IdWorkOrderNumberErp == idWorkOrderErp && w.idDealerShopOtErp == iddealerShopErp); if (currentEntity != null) { Systimedb.WorkOrderLoadErrorLog.Remove(currentEntity); if (Systimedb.SaveChanges() > 0) { return(true); } } } } return(false); }
/// <summary> /// Metoto encargado de guardar o actualizar un error de carga de ordenes de trabajo /// </summary> /// <param name="workOrderErrorEntity"></param> /// <param name="userModify"></param> /// <returns></returns> public Boolean SaveWorkOrderError(WorkOrderLoadErrorLog workOrderErrorEntity, String userModify) { if (workOrderErrorEntity != null) { Boolean isUpdate = false; using (SystimedbEntities Systimedb = new SystimedbEntities(ConectionString)) { WorkOrderLoadErrorLog currentEntity = Systimedb.WorkOrderLoadErrorLog.FirstOrDefault(w => w.IdWorkOrderNumberErp == workOrderErrorEntity.IdWorkOrderNumberErp && w.idDealerShopOtErp == workOrderErrorEntity.idDealerShopOtErp); if (currentEntity != null) { //Update currentEntity.idCustomerOT = UtilsDataAcces.ValidateDiferentString(currentEntity.idCustomerOT, workOrderErrorEntity.idCustomerOT, true, isUpdate, out isUpdate); currentEntity.idVehicle = UtilsDataAcces.ValidateDiferentString(currentEntity.idVehicle, workOrderErrorEntity.idVehicle, false, isUpdate, out isUpdate); currentEntity.idWorkerOT = UtilsDataAcces.ValidateDiferentString(currentEntity.idWorkerOT, workOrderErrorEntity.idWorkerOT, true, isUpdate, out isUpdate); currentEntity.idWorkerOT = UtilsDataAcces.ValidateDiferentString(currentEntity.idWorkerOT, workOrderErrorEntity.idWorkerOT, true, isUpdate, out isUpdate); currentEntity.CloudUpdateError = UtilsDataAcces.ValidateDiferentString(currentEntity.CloudUpdateError, workOrderErrorEntity.CloudUpdateError, true, isUpdate, out isUpdate); if (isUpdate) { currentEntity.UpdatedAt = DateTime.Now; currentEntity.UpdatedById = userModify; Systimedb.SaveChanges(); } return(true); } else { //Insert workOrderErrorEntity.CreatedAt = DateTime.Now; workOrderErrorEntity.CreatedById = userModify; Systimedb.WorkOrderLoadErrorLog.Add(workOrderErrorEntity); if (Systimedb.SaveChanges() > 0) { return(true); } } } } return(false); }