public List <MaterialLogicalEntity> Buscar(MaterialLogicalEntity _LogicalEntity) { List <MaterialLogicalEntity> _ListLogicalEntity = new List <MaterialLogicalEntity>(); try { SQLServerConnect.OpenConection(); SQLServerConnect.CreateCommand("sp_Material_buscar", CommandType.StoredProcedure, SQLServerConnect.CreateParameter("REPORTE", SqlDbType.VarChar, _LogicalEntity.REPORTE), SQLServerConnect.CreateParameter("Id_Material", SqlDbType.Int, _LogicalEntity.Id_Material) ); using (IDataReader oReader = SQLServerConnect.GetDataReader(CommandBehavior.CloseConnection)) { _ListLogicalEntity = new GenericInstance <MaterialLogicalEntity>().readDataReaderList(oReader); } } catch (Exception ex) { string SYSTEM_MESSAGE = ex.Message; } finally { SQLServerConnect.CloseConection(); } return(_ListLogicalEntity); }
public MaterialLogicalEntity Guardar(MaterialLogicalEntity _LogicalEntity) { MaterialLogicalEntity _ResponseLogicalEntity = new MaterialLogicalEntity(); try { SQLServerConnect.OpenConection(); SQLServerConnect.CreateCommand("SP_Material_guardar", CommandType.StoredProcedure, SQLServerConnect.CreateParameter("Id_Material", SqlDbType.Int, _LogicalEntity.Id_Material), SQLServerConnect.CreateParameter("Descripcion", SqlDbType.VarChar, _LogicalEntity.Descripcion), SQLServerConnect.CreateParameter("Estado", SqlDbType.Char, _LogicalEntity.Estado), SQLServerConnect.CreateParameter("ACCION", SqlDbType.Char, _LogicalEntity.ACCION) ); using (IDataReader oReader = SQLServerConnect.GetDataReader(CommandBehavior.CloseConnection)) { _ResponseLogicalEntity = new GenericInstance <MaterialLogicalEntity>().readDataReader(oReader); } } catch (Exception ex) { string SYSTEM_MESSAGE = ex.Message; } finally { SQLServerConnect.CloseConection(); } return(_ResponseLogicalEntity); }
public MaterialLogicalEntity Guardar([FromBody] JObject data) { MaterialLogicalEntity _LogicalEntity = new MaterialLogicalEntity(); try { string _stringLogic = data["LogicalEntity"].ToString(); _LogicalEntity = JsonConvert.DeserializeObject <MaterialLogicalEntity>(_stringLogic); IMaterialRepository _Repository = new MaterialRepository(); _LogicalEntity = _Repository.Guardar(_LogicalEntity); } catch (Exception ex) { _LogicalEntity.MESSAGE = ex.Message; _LogicalEntity.STATUS = "OFF"; } finally { } return(_LogicalEntity); }