public LoteNoInventariable InsertarLoteNoInventariable(LoteNoInventariable ALote) { string pSentencia = "INSERT INTO LOTES_NO_INVENTARIABLES (LOTE) VALUES (@LOTE) RETURNING ID"; FbConnection con = _Conexion.ObtenerConexion(); FbCommand com = new FbCommand(pSentencia, con); com.Parameters.Add("@LOTE", FbDbType.Integer).Value = ALote.Lote; FbParameter pOutParameter = new FbParameter("@ID", FbDbType.Integer); pOutParameter.Direction = ParameterDirection.Output; com.Parameters.Add(pOutParameter); try { con.Open(); com.ExecuteNonQuery(); } finally { if (con.State == System.Data.ConnectionState.Open) { con.Close(); } } return(ObtenerLote((int)pOutParameter.Value)); }
public List <LoteNoInventariable> ObtenerLotes() { List <LoteNoInventariable> pResult = new List <LoteNoInventariable>(); LoteNoInventariable lote; string pSentencia = "SELECT * FROM LOTES_NO_INVENTARIABLES ORDER BY LOTE"; FbConnection con = _Conexion.ObtenerConexion(); FbCommand com = new FbCommand(pSentencia, con); try { con.Open(); FbDataReader reader = com.ExecuteReader(); while (reader.Read()) { lote = new LoteNoInventariable(); lote.Clave = (int)reader["ID"]; lote.Lote = (int)reader["LOTE"]; pResult.Add(lote); } } finally { if (con.State == System.Data.ConnectionState.Open) { con.Close(); } } return(pResult); }
public LoteNoInventariable ObtenerLote(int AClave) { LoteNoInventariable lote = null; string pSentencia = "SELECT * FROM LOTES_NO_INVENTARIABLES WHERE ID=@ID"; FbConnection con = _Conexion.ObtenerConexion(); FbCommand com = new FbCommand(pSentencia, con); com.Parameters.Add("@ID", FbDbType.Integer).Value = AClave; try { con.Open(); FbDataReader reader = com.ExecuteReader(); while (reader.Read()) { lote = new LoteNoInventariable(); lote.Clave = (int)reader["ID"]; lote.Lote = (int)reader["LOTE"]; } } finally { if (con.State == System.Data.ConnectionState.Open) { con.Close(); } } return(lote); }
public LoteNoInventariable Insertar(LoteNoInventariable ALote) { if (!_LotesNoInventariablesPersistencia.ExisteLote(ALote.Lote)) { return(_LotesNoInventariablesPersistencia.InsertarLoteNoInventariable(ALote)); } else { return(null); } }
public JsonResult Insertar(LoteNoInventariable lote) { return(Json(_LotesNoInventariablesLogica.Insertar(lote))); }