public static OperationResult Insert(DataFieldCollection pValues, ConnectionInfo pInfo) { Transaction lTransaction; lTransaction = new Transaction(Instance.CreateDatabase(pInfo)); bool lLocalTransaction = (lTransaction != null); InsertCommand lInsert; OperationResult lReturn = new OperationResult(PORT_BANNERQD.TableName, PORT_BANNERQD.TableName); if (!lReturn.HasError){ try{ if (lLocalTransaction){ lReturn.Trace("Transação local, instanciando banco..."); } lInsert = new InsertCommand(PORT_BANNERQD.TableName); lReturn.Trace("Adicionando campos ao objeto de insert"); foreach (DataField lField in pValues.Keys){ lInsert.Fields.Add(lField.Name, pValues[lField], (ItemType)lField.DBType); } decimal lSequence; lSequence = DataBaseSequenceControl.GetNext(pInfo, "BAN_ID"); lInsert.Fields.Add(PORT_BANNERQD._BAN_ID.Name, lSequence, (ItemType)PORT_BANNERQD._BAN_ID.DBType); lReturn.Trace("Executando o Insert"); lInsert.Execute(lTransaction, false); if (!lReturn.HasError){ if (lLocalTransaction){ if (!lReturn.HasError){ lReturn.Trace("Insert finalizado, executando commit"); lTransaction.Commit(); } else{ lTransaction.Rollback(); } } } else{ if (lLocalTransaction) lTransaction.Rollback(); } } catch (Exception ex){ lReturn.OperationException = new SerializableException(ex); if (lLocalTransaction) lTransaction.Rollback(); } } return lReturn; }
public static OperationResult Update( DataFieldCollection pValues, ConnectionInfo pInfo ) { Transaction pTransaction; pTransaction = new Transaction(Instance.CreateDatabase(pInfo)); bool lLocalTransaction = (pTransaction != null); UpdateCommand lUpdate; OperationResult lReturn = new OperationResult(PLANOINTERNOQD.TableName, PLANOINTERNOQD.TableName); ValidateUpdate(pValues, lReturn); if (lReturn.IsValid) { try { if (lLocalTransaction) { lReturn.Trace("Transação local, instanciando banco..."); } lUpdate = new UpdateCommand(PLANOINTERNOQD.TableName); lReturn.Trace("Adicionando campos ao objeto de update"); foreach (DataField lField in pValues.Keys) { if ((lField.Name != PLANOINTERNOQD._PLANI_ID.Name)) lUpdate.Fields.Add(lField.Name, pValues[lField], (ItemType)lField.DBType); } string lSql = ""; lSql = String.Format("WHERE {0} = <<{0}", PLANOINTERNOQD._PLANI_ID.Name); lUpdate.Condition = lSql; lUpdate.Conditions.Add(PLANOINTERNOQD._PLANI_ID.Name, pValues[PLANOINTERNOQD._PLANI_ID].DBToDecimal()); lReturn.Trace("Executando o Update"); lUpdate.Execute(pTransaction); if (!lReturn.HasError) { if (lLocalTransaction) { if (!lReturn.HasError) { lReturn.Trace("Update finalizado, executando commit"); pTransaction.Commit(); } else { pTransaction.Rollback(); } } } else { if (lLocalTransaction) pTransaction.Rollback(); } } catch (Exception ex) { lReturn.OperationException = new SerializableException(ex); if (lLocalTransaction) pTransaction.Rollback(); } } return lReturn; }
public static OperationResult Update( DataFieldCollection pValues, ConnectionInfo pInfo ) { Transaction pTransaction; pTransaction = new Transaction(Instance.CreateDatabase(pInfo)); bool lLocalTransaction = (pTransaction != null); UpdateCommand lUpdate; OperationResult lReturn = new OperationResult(NucleoQD.TableName, NucleoQD.TableName); ValidateUpdate(pValues, lReturn); if (lReturn.IsValid) { try { if (lLocalTransaction) { lReturn.Trace("Transação local, instanciando banco..."); } //16/10/2012 Ricardo Almeida - retirada da função, pois registro não pode ser excluido se estiver usuário cadastrado //lReturn = NucleoxAreaAtuacaoDo.Exluir_ByNUC_ID(pValues[NucleoQD._NUC_ID].DBToDecimal(), pInfo); //if (lReturn.HasError) //{ // if (lLocalTransaction) // pTransaction.Rollback(); // return lReturn; //} lReturn = NucleoxSecretariaDo.Exluir_ByNUC_ID(pValues[NucleoQD._NUC_ID].DBToDecimal(), pInfo); if (!lReturn.HasError) { lUpdate = new UpdateCommand(NucleoQD.TableName); lReturn.Trace("Adicionando campos ao objeto de update"); foreach (DataField lField in pValues.Keys) { if ((lField.Name != NucleoQD._NUC_ID.Name)) lUpdate.Fields.Add(lField.Name, pValues[lField], (ItemType)lField.DBType); } string lSql = ""; lSql = String.Format("WHERE {0} = <<{0}", NucleoQD._NUC_ID.Name); lUpdate.Condition = lSql; lUpdate.Conditions.Add(NucleoQD._NUC_ID.Name, pValues[NucleoQD._NUC_ID].DBToDecimal()); lReturn.Trace("Executando o Update"); lUpdate.Execute(pTransaction); } if (!lReturn.HasError) { if (lLocalTransaction) { if (!lReturn.HasError) { lReturn.Trace("Update finalizado, executando commit"); pTransaction.Commit(); } else { pTransaction.Rollback(); } } } else { if (lLocalTransaction) pTransaction.Rollback(); } } catch (Exception ex) { lReturn.OperationException = new SerializableException(ex); if (lLocalTransaction) pTransaction.Rollback(); } } return lReturn; }
public static OperationResult Insert( DataFieldCollection pValues, Transaction pTransaction, ConnectionInfo pInfo ) { Transaction lTransaction; bool lLocalTransaction = (pTransaction == null); if (lLocalTransaction) lTransaction = new Transaction(Instance.CreateDatabase(pInfo)); else lTransaction = pTransaction; InsertCommand lInsert; OperationResult lReturn = new OperationResult(AtuacaoQD.TableName, AtuacaoQD.TableName); if (!lReturn.HasError) { try { if (lLocalTransaction) { lReturn.Trace("Transação local, instanciando banco..."); } //lReturn.Trace("Excluído Atuações..."); //lReturn = UpdateInativo(pValues[AtuacaoQD._PESF_ID].DBToDecimal(), pValues[AtuacaoQD._ATUA_STATUS].ToString(), pInfo); //if (lReturn.HasError) //{ // return lReturn; //} lInsert = new InsertCommand(AtuacaoQD.TableName); lReturn.Trace("Adicionando campos ao objeto de insert"); foreach (DataField lField in pValues.Keys) { lInsert.Fields.Add(lField.Name, pValues[lField], (ItemType)lField.DBType); } decimal lSequence; lSequence = DataBaseSequenceControl.GetNext(pInfo, "ATUA_ID"); lInsert.Fields.Add(AtuacaoQD._ATUA_ID.Name, lSequence, (ItemType)AtuacaoQD._ATUA_ID.DBType); lReturn.SequenceControl = lSequence; lReturn.Trace("Executando o Insert"); lInsert.Execute(lTransaction); if (!lReturn.HasError) { if (lLocalTransaction) { if (!lReturn.HasError) { lReturn.Trace("Insert finalizado, executando commit"); lTransaction.Commit(); } else { lTransaction.Rollback(); } } } else { if (lLocalTransaction) lTransaction.Rollback(); } } catch (Exception ex) { lReturn.OperationException = new SerializableException(ex); if (lLocalTransaction) lTransaction.Rollback(); } } return lReturn; }
public static OperationResult Exluir_ByNUC_ID( decimal pNUC_ID, ConnectionInfo pInfo ) { Transaction pTransaction; pTransaction = new Transaction(Instance.CreateDatabase(pInfo)); bool lLocalTransaction = (pTransaction != null); UpdateCommand lUpdate; OperationResult lReturn = new OperationResult(NucleoxAreaAtuacaoQD.TableName, NucleoxAreaAtuacaoQD.TableName); if (lReturn.IsValid) { try { if (lLocalTransaction) { lReturn.Trace("Transação local, instanciando banco..."); } lUpdate = new UpdateCommand(NucleoxAreaAtuacaoQD.TableName); lReturn.Trace("Adicionando campos ao objeto de update"); lUpdate.Fields.Add(NucleoxAreaAtuacaoQD._NUCARATUA_STATUS.Name, "I", (ItemType)NucleoxAreaAtuacaoQD._NUCARATUA_STATUS.DBType); string lSql = ""; lSql = String.Format("WHERE {0} = <<{0}", NucleoxAreaAtuacaoQD._NUC_ID.Name); lUpdate.Condition = lSql; lUpdate.Conditions.Add(NucleoxAreaAtuacaoQD._NUC_ID.Name, pNUC_ID); lReturn.Trace("Executando o Update"); lUpdate.Execute(pTransaction); if (!lReturn.HasError) { if (lLocalTransaction) { if (!lReturn.HasError) { lReturn.Trace("Update finalizado, executando commit"); pTransaction.Commit(); } else { pTransaction.Rollback(); } } } else { if (lLocalTransaction) pTransaction.Rollback(); } } catch (Exception ex) { lReturn.OperationException = new SerializableException(ex); if (lLocalTransaction) pTransaction.Rollback(); } } return lReturn; }
public static string ChangePassword(decimal pSusr_Id, string pSusr_Login, string pSusr_Password_old, string pSusr_Password_new, ConnectionInfo pConnectionInfo) { bool lPasswordOK; string lPassword; string lResult = ""; OperationResult lReturn; Transaction pTransaction; pTransaction = new Transaction(Instance.CreateDatabase(pConnectionInfo)); // Validando a Senha Digitada. lPassword = GetPassword(pSusr_Login, pConnectionInfo); lPasswordOK = (lPassword == pSusr_Password_old) ? true : false; if (!lPasswordOK) lResult = "Senha Atual Incorreta"; // Verificando Transação bool lLocalTransaction = (pTransaction != null); UpdateCommand lUpdate; lReturn = new OperationResult(SystemUserQD.TableName, SystemUserQD.TableName); if (lPasswordOK) { // Iniciando processo de update... if (lReturn.IsValid) { try { if (lLocalTransaction) { lReturn.Trace("ExternalUser: Transação local, instanciando banco..."); } lUpdate = new UpdateCommand(SystemUserQD.TableName); lReturn.Trace("ExternalUser: Adicionando campos ao objeto de update"); lUpdate.Fields.Add(SystemUserQD._SUSR_PASSWORD.Name, APB.Framework.Encryption.Crypto.Encode(pSusr_Password_new), (ItemType)SystemUserQD._SUSR_PASSWORD.DBType); string lSql = ""; //TODO: Condição where customizada lSql = String.Format("WHERE {0} = >>{0}", SystemUserQD._SUSR_ID.Name); lUpdate.Condition = lSql; lUpdate.Conditions.Add(SystemUserQD._SUSR_ID.Name, pSusr_Id); lReturn.Trace("ExternalUser: Executando o Update"); lUpdate.Execute(pTransaction); if (!lReturn.HasError) { if (lLocalTransaction) { if (!lReturn.HasError) { lReturn.Trace("ExternalUser: Update finalizado, executando commit"); pTransaction.Commit(); } else { pTransaction.Rollback(); } } } else { if (lLocalTransaction) pTransaction.Rollback(); } } catch (Exception ex) { lReturn.OperationException = new SerializableException(ex); if (lLocalTransaction) pTransaction.Rollback(); } } } else { return "Senha atual incorreta"; } if (lReturn.IsValid) lResult = ""; else lResult = lReturn.ToString(); return lResult; }