public int CreatePreco(Entities.Precos e)
{
try
{
using (contexto = new Contexto())
{
var cmd = contexto.Comando();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "CreatePreco";
cmd.Parameters.AddWithValue("@Descricao", SqlDbType.Float).Value = e.Descricao;
cmd.Parameters.AddWithValue("@Preco", SqlDbType.Float).Value = e.Preco;
cmd.Parameters.AddWithValue("@PrecoAdicional", SqlDbType.Float).Value = e.PrecoAdicional;
cmd.Parameters.AddWithValue("@DataCadastro", SqlDbType.DateTime).Value = DateTime.Now;
cmd.Parameters.AddWithValue("@DataAlteracao", SqlDbType.DateTime).Value = DateTime.Now;
cmd.Parameters.AddWithValue("@DataInicioVigencia", SqlDbType.DateTime).Value = e.DataInicioVigencia;
cmd.Parameters.AddWithValue("@DataFimVigencia", SqlDbType.DateTime).Value = e.DataFimVigencia;
cmd.Parameters.AddWithValue("@Flag", SqlDbType.Bit).Value = e.Flag;
Int32 idretorno = Convert.ToInt32(cmd.ExecuteScalar());
return(idretorno);
}
}
catch (Exception ex)
{
return(0);
}
}
public int UpdatePreco(Entities.Precos e)
{
try
{
using (contexto = new Contexto())
{
var cmd = contexto.Comando();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UpdatePreco";
cmd.Parameters.AddWithValue("@IdPreco", SqlDbType.Float).Value = e.IdPreco;
cmd.Parameters.AddWithValue("@Descricao", SqlDbType.Float).Value = e.Descricao;
cmd.Parameters.AddWithValue("@Preco", SqlDbType.Float).Value = e.Preco;
cmd.Parameters.AddWithValue("@PrecoAdicional", SqlDbType.Float).Value = e.PrecoAdicional;
cmd.Parameters.AddWithValue("@DataAlteracao", SqlDbType.DateTime).Value = DateTime.Now;
cmd.Parameters.AddWithValue("@DataInicioVigencia", SqlDbType.DateTime).Value = e.DataInicioVigencia;
cmd.Parameters.AddWithValue("@DataFimVigencia", SqlDbType.DateTime).Value = e.DataFimVigencia;
cmd.Parameters.AddWithValue("@Flag", SqlDbType.Bit).Value = e.Flag;
cmd.ExecuteNonQuery();
return(1);
}
}
catch (Exception ex)
{
return(0);
}
}
private void GravarDados()
{
var e = new Entities.Precos();
var precos = new Repository.RepPrecos();
int verifica = 0;
e.IdPreco = IdPreco;
e.Descricao = txtDescricao.Text;
e.Preco = Convert.ToDouble(txtPreco.Text);
e.PrecoAdicional = Convert.ToDouble(txtPrecoAdicional.Text);
e.DataInicioVigencia = Convert.ToDateTime(txtInicioVigencia.Text);
e.DataFimVigencia = Convert.ToDateTime(txtFimVigencia.Text);
e.Flag = Convert.ToBoolean(chkAtivo.Checked);
precos.ClearFlag();
verifica = IdPreco > 0 ? precos.Update(e) : precos.Create(e);
if (verifica > 0)
{
Response.Redirect("/Taxas.aspx");
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Não foi possível gravar este Registro! Entre em Contato com o Administrador do Sistema')", true);
}
}
public int Update(Entities.Precos e)
{
return repositorio.UpdatePreco(e);
}
public int Create(Entities.Precos e)
{
return repositorio.CreatePreco(e);
}
