private void button2_Click(object sender, EventArgs e)
{
if (Validacoes())
{
_IDFORMAPAGAMENTO = FORMAPAGAMENTOP.Save(Entity);
int Dias = 30;
decimal TotalPorc = Convert.ToDecimal("100,00");
for (int i = 0; i < Convert.ToInt32(txtXPrazos.Text); i++)
{
TxtDias.Text = Convert.ToString(Dias);
decimal Porpagto = 100 / Convert.ToDecimal(txtXPrazos.Text);
txtPorPagto.Text = Porpagto.ToString("n2");
TotalPorc -= Convert.ToDecimal(txtPorPagto.Text);
//Calcula a diferença em Porcentagem de pagamento
if (i == Convert.ToInt32(txtXPrazos.Text) - 1)
{
Porpagto = Porpagto + TotalPorc;
txtPorPagto.Text = Porpagto.ToString("n2");
}
txtPorcJuros.Text = "0";
_IDITENSFORMAPAGTO = -1;
ITENSFORMAPAGTOP.Save(Entity2);
Dias += 30;
}
SalveIMEXAPP(Entity);
Entity2 = null;
GetItensFormaPagamento();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (ValidacoesFormaPagamento())
{
//Grava Forma de pagamento antes de inserir itens
if (_IDFORMAPAGAMENTO == -1)
{
if (Validacoes())
{
_IDFORMAPAGAMENTO = FORMAPAGAMENTOP.Save(Entity);
}
}
try
{
if (_IDFORMAPAGAMENTO != -1)
{
_IDITENSFORMAPAGTO = ITENSFORMAPAGTOP.Save(Entity2);
GetItensFormaPagamento();
Entity2 = null;
Util.ExibirMSg(ConfigMessage.Default.MsgSave, "Blue");
}
}
catch (Exception)
{
MessageBox.Show(ConfigMessage.Default.MsgSaveErro);
}
}
}
private void TSBNovo_Click(object sender, EventArgs e)
{
Entity = null;
Entity2 = null;
GetItensFormaPagamento();
tabControl1.SelectTab(0);
txtNome.Focus();
}
private static ITENSFORMAPAGTOEntity FillEntityObject(ref FbDataReader DataReader)
{
ITENSFORMAPAGTOEntity entity = new ITENSFORMAPAGTOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDITENSFORMAPAGTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDITENSFORMAPAGTO"));
entity.IDFORMAPAGAMENTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFORMAPAGAMENTO"));
entity.DIAS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("DIAS"));
entity.PORCPAGTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCPAGTO"));
entity.PORCJUROS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCJUROS"));
return(entity);
}
private void DgItensFormaPagamento_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
int rowindex = e.RowIndex;
if (FORMAPAGAMENTOColl.Count > 0 && rowindex > -1)
{
int ColumnSelecionada = e.ColumnIndex;
int CodSelect = -1;
if (ColumnSelecionada == 0)//Editar
{
CodSelect = Convert.ToInt32(ITENSFORMAPAGTOColl[rowindex].IDITENSFORMAPAGTO);
Entity2 = ITENSFORMAPAGTOP.Read(CodSelect);
}
else if (ColumnSelecionada == 1)//Excluir
{
DialogResult dr = MessageBox.Show(ConfigMessage.Default.MsgDelete,
ConfigSistema1.Default.NameSytem, MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
try
{
CodSelect = Convert.ToInt32(ITENSFORMAPAGTOColl[rowindex].IDITENSFORMAPAGTO);
ITENSFORMAPAGTOP.Delete(CodSelect);
GetItensFormaPagamento();
Entity2 = null;
Util.ExibirMSg(ConfigMessage.Default.MsgDelete2, "Blue");
}
catch (Exception)
{
MessageBox.Show(ConfigMessage.Default.MsgDeleteErro);
}
}
}
}
}
private void btnCancel_Click(object sender, EventArgs e)
{
Entity2 = null;
}
public ITENSFORMAPAGTOEntity Read(int IDITENSFORMAPAGTO)
{
FbDataReader reader = null;
try
{
//Verificando a existência de um transação aberta
if (dbTransaction != null)
{
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Rea_ITENSFORMAPAGTO", dbCnn);
dbCommand.Transaction = ((FbTransaction)(dbTransaction));
}
else
{
if (dbCnn == null)
{
dbCnn = ((FbConnection)GetConnectionDB());
}
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Rea_ITENSFORMAPAGTO", dbCnn);
dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbCommand.CommandType = CommandType.StoredProcedure;
dbCommand.Parameters.AddWithValue("@IDITENSFORMAPAGTO", IDITENSFORMAPAGTO); //PrimaryKey
reader = dbCommand.ExecuteReader();
ITENSFORMAPAGTOEntity entity = null;
if (reader.HasRows)
{
while (reader.Read())
{
entity = FillEntityObject(ref reader);
}
}
// Deleta reader
if (reader != null)
{
reader.Close();
reader.Dispose();
}
// Fecha conexão
if (dbTransaction == null)
{
dbCommand.Transaction.Commit();
if (dbCnn.State == ConnectionState.Open)
{
dbCnn.Close();
}
}
return(entity);
}
catch (Exception ex)
{
// Deleta reader
if (reader != null)
{
reader.Close();
reader.Dispose();
}
if (dbTransaction != null)
{
this.RollbackTransaction();
}
else
{
if (dbCommand.Transaction != null)
{
dbCommand.Transaction.Rollback();
}
if (dbCnn.State == ConnectionState.Open)
{
dbCnn.Close();
}
}
throw ex;
}
}
public int Save(ITENSFORMAPAGTOEntity Entity)
{
int result = 0;
try
{
//Verificando a existência de um transação aberta
if (dbTransaction != null)
{
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Sav_ITENSFORMAPAGTO", dbCnn);
dbCommand.Transaction = ((FbTransaction)(dbTransaction));
}
else
{
if (dbCnn == null)
{
dbCnn = ((FbConnection)GetConnectionDB());
}
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Sav_ITENSFORMAPAGTO", dbCnn);
dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbCommand.CommandType = CommandType.StoredProcedure;
if (Entity.IDITENSFORMAPAGTO != -1)
{
dbCommand.Parameters.AddWithValue("@IDITENSFORMAPAGTO", Entity.IDITENSFORMAPAGTO); //PrimaryKey
}
else
{
dbCommand.Parameters.AddWithValue("@IDITENSFORMAPAGTO", DBNull.Value); //PrimaryKey
}
dbCommand.Parameters.AddWithValue("@IDFORMAPAGAMENTO", Entity.IDFORMAPAGAMENTO); //Coluna
dbCommand.Parameters.AddWithValue("@DIAS", Entity.DIAS); //Coluna
dbCommand.Parameters.AddWithValue("@PORCPAGTO", Entity.PORCPAGTO); //Coluna
dbCommand.Parameters.AddWithValue("@PORCJUROS", Entity.PORCJUROS); //Coluna
//Retorno da Procedure
FbParameter returnValue;
returnValue = dbCommand.CreateParameter();
dbCommand.Parameters["@IDITENSFORMAPAGTO"].Direction = ParameterDirection.InputOutput;
//Executando consulta
dbCommand.ExecuteNonQuery();
result = int.Parse(dbCommand.Parameters["@IDITENSFORMAPAGTO"].Value.ToString());
if (dbTransaction == null)
{
dbCommand.Transaction.Commit();
dbCnn.Close();
}
}
catch (Exception ex)
{
if (dbTransaction != null)
{
this.RollbackTransaction();
}
else
{
if (dbCommand.Transaction != null)
{
dbCommand.Transaction.Rollback();
}
if (dbCnn.State == ConnectionState.Open)
{
dbCnn.Close();
}
}
throw ex;
}
return(result);
}
