public bool ElimarDocumento(int Id) { try { SqlCommand command = new SqlCommand { CommandText = ConstStoredProcedures.SpDeleteImagenClienteFlex }; command.Parameters.Add("@Id", SqlDbType.Int).Value = Id; SqlDataReader datosStored = iGenericDataAccess.StoredProcedure(command); iGenericDataAccess.CloseConnection(); } catch (Exception e) { iGenericDataAccess.CloseConnection(); throw new DalException(Codes.ERR_00_01, e); } return(true); }
public IList <CategoriaModel> ConsultarCategoria() { List <CategoriaModel> listDatos = new List <CategoriaModel>(); try { SqlCommand command = new SqlCommand { CommandText = ConstStoredProcedures.SpObtieneDatosCategoriaFlex }; SqlDataReader datosStored = iGenericDataAccess.StoredProcedure(command); if (datosStored.HasRows) { while (datosStored.Read()) { listDatos.Add(new CategoriaModel { Id = Convert.ToInt32(datosStored["Id"]), NombreCategoria = Convert.ToString(datosStored["Categoria"]) }); } iGenericDataAccess.CloseConnection(); } } catch (Exception e) { iGenericDataAccess.CloseConnection(); throw new DalException(Codes.ERR_00_01, e); } return(listDatos); }
/* INDRA FJQP Implementacion de config Emisión Multiple */ public FiltroConfigMultiple FiltrosConfigMultiple(string IdUsuario) { // var Datos = new FiltroConfigMultiple(); List <Commons.Modelos.ConfigMultiple.ClientesConfig> listClientes = new List <Commons.Modelos.ConfigMultiple.ClientesConfig>(); List <Commons.Modelos.ConfigMultiple.ProductosConfig> listProdcutos = new List <Commons.Modelos.ConfigMultiple.ProductosConfig>(); try { SqlCommand command = new SqlCommand { CommandText = ConstStoredProcedures.SpSelAseguradorasConfigMultiple }; command.Parameters.Add("@UsuarioId", SqlDbType.VarChar).Value = IdUsuario; SqlDataReader datosStored = iGenericDataAccess.StoredProcedure(command); if (datosStored.HasRows) { while (datosStored.Read()) { listClientes.Add(new Commons.Modelos.ConfigMultiple.ClientesConfig { Clave = Convert.ToString(datosStored["Clave"]), Nombre = Convert.ToString(datosStored["Nombre"]), }); } iGenericDataAccess.CloseConnection(); } SqlCommand command2 = new SqlCommand { CommandText = ConstStoredProcedures.SpSelProductosPorUsuarioFlex }; command2.Parameters.Add("@UsuarioId", SqlDbType.VarChar).Value = IdUsuario; SqlDataReader datosStored2 = iGenericDataAccess.StoredProcedure(command2); if (datosStored2.HasRows) { while (datosStored2.Read()) { listProdcutos.Add(new Commons.Modelos.ConfigMultiple.ProductosConfig { Clave = Convert.ToString(datosStored2["Clave"]), Nombre = Convert.ToString(datosStored2["Nombre"]), }); } iGenericDataAccess.CloseConnection(); } Datos.ClientesList = listClientes; Datos.ProductosList = listProdcutos; } catch (Exception e) { iGenericDataAccess.CloseConnection(); throw new DalException(Codes.ERR_00_01, e); } return(Datos); }