public IEnumerable <ECategorias> GetAll(bool status) { using (SqlConnection cnx = new SqlConnection()) { cnx.ConnectionString = MiCadena.CadenaCnx(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "usp_Categorias_getAll"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Estado", status); cmd.Connection = cnx; cnx.Open(); var reader = cmd.ExecuteReader(); var lista = new List <ECategorias>(); while (reader.Read()) { lista.Add(new ECategorias { ID = Convert.ToInt32(reader["ID"]), Nombre = (reader["Nombre"].ToString()), Descripcion = (reader["Descripcion"].ToString()), // Estado = Convert.ToBoolean(reader["Estado"]), }); } return(lista); } }
public IEnumerable <EProveedor> GetAll(bool status) { using (SqlConnection cnx = new SqlConnection()) { cnx.ConnectionString = MiCadena.CadenaCnx(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "usp_Proveedor_getAll"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Estado", status); cmd.Connection = cnx; cnx.Open(); var reader = cmd.ExecuteReader(); var lista = new List <EProveedor>(); while (reader.Read()) { lista.Add(new EProveedor { ID = Convert.ToInt32(reader["ID"]), Razon_social = (reader["RazonSocial"].ToString()), RUC = (reader["Ruc"].ToString()), Direccion = (reader["Direccion"].ToString()), Telefono = (reader["Telefono"].ToString()), Mail = (reader["Mail"].ToString()), // Estado = Convert.ToBoolean(reader["Estado"]), }); } return(lista); } }
public int Delete(int id) { using (SqlConnection cnx = new SqlConnection()) { cnx.ConnectionString = MiCadena.CadenaCnx(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "usp_Categoria_IDelete"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", id); cmd.Connection = cnx; cnx.Open(); int filasafectadas = cmd.ExecuteNonQuery(); return(filasafectadas); } }
public int Create(ECategorias t) { using (SqlConnection cnx = new SqlConnection()) { cnx.ConnectionString = MiCadena.CadenaCnx(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "usp_Categoria_ICreate"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Nombre", t.Nombre); cmd.Parameters.AddWithValue("@Descripcion", t.Descripcion); cmd.Parameters.AddWithValue("@Estado", t.Estado); cmd.Connection = cnx; cnx.Open(); int filasafectadas = cmd.ExecuteNonQuery(); return(filasafectadas); } }
public int Create(EProveedor t) { using (SqlConnection cnx = new SqlConnection()) { cnx.ConnectionString = MiCadena.CadenaCnx(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "usp_Proveedor_ICreate"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@RazonSocial", t.Razon_social); cmd.Parameters.AddWithValue("@RUC", t.RUC); cmd.Parameters.AddWithValue("@Direccion", t.Direccion); cmd.Parameters.AddWithValue("@Telefono", t.Telefono); cmd.Parameters.AddWithValue("@Mail", t.Mail); cmd.Parameters.AddWithValue("@Estado", t.Estado); cmd.Connection = cnx; cnx.Open(); int filasafectadas = cmd.ExecuteNonQuery(); return(filasafectadas); } }