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); }