public override int REQUISICION_INSERT(REQUISICION_BE z) { DbCommand Command = null; int returnValue = 0; try { Database DB = DatabaseFactory.CreateDatabase(); using (TransactionScope MyTranasaccion = new TransactionScope()) { Command = DB.GetStoredProcCommand(Constants.CSP_REQUISICION); DB.AddInParameter(Command, "@ID", DbType.String, string.Empty); DB.AddInParameter(Command, "@FECHA", DbType.Date, z.FECHA); DB.AddInParameter(Command, "@USUARIO", DbType.Int32, z.USUARIO); DB.AddInParameter(Command, "@ACCION", DbType.Int32, Constants.AccionesTabla.ADD); returnValue = DB.ExecuteNonQuery(Command); MyTranasaccion.Complete(); return(1); } } catch (Exception ex) { string strError = ex.Message.ToString(); return(0); } finally { Command.Dispose(); } }
public List <REQUISICION_BE> REQUISICION_GET(IDataReader reader) { List <REQUISICION_BE> zeban_p = new List <REQUISICION_BE>(); try { while (reader.Read()) { REQUISICION_BE z = new REQUISICION_BE(); z.ID = Int32.Parse(reader["ID"].ToString()); z.FECHA = DateTime.Parse(reader["FECHA_CREA"].ToString()); z.USUARIO = Int32.Parse(reader["USUARIO"].ToString()); zeban_p.Add(z); } } catch (Exception ex) { throw ex; } finally { reader.Close(); } return(zeban_p); }
public static int INSERT(REQUISICION_BE V) { return(AbstractDataAccesLayerHelper.GetDataAccessLayer().REQUISICION_INSERT(V)); }
public abstract int REQUISICION_INSERT(REQUISICION_BE V);