public override int VALOR_INSERT(VALOR_BE z) { DbCommand Command = null; int returnValue = 0; try { Database DB = DatabaseFactory.CreateDatabase(); using (TransactionScope MyTranasaccion = new TransactionScope()) { Command = DB.GetStoredProcCommand(Constants.CSP_VALOR); DB.AddInParameter(Command, "@ID", DbType.String, string.Empty); DB.AddInParameter(Command, "@REQ_ID", DbType.String, z.REQ_ID); DB.AddInParameter(Command, "@FORM_ID", DbType.Int32, z.FORM_ID); DB.AddInParameter(Command, "@PROP_ID", DbType.Int32, z.PROP_ID); DB.AddInParameter(Command, "@VALOR", DbType.String, z.VALOR); 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 <VALOR_BE> VALOR_GET(IDataReader reader) { List <VALOR_BE> zeban_p = new List <VALOR_BE>(); try { while (reader.Read()) { VALOR_BE z = new VALOR_BE(); z.ID = Int32.Parse(reader["ID"].ToString()); z.FORM_ID = Int32.Parse(reader["FORM_ID"].ToString()); z.PROP_ID = Int32.Parse(reader["PROP_ID"].ToString()); z.VALOR = reader["VALOR"].ToString(); zeban_p.Add(z); } } catch (Exception ex) { throw ex; } finally { reader.Close(); } return(zeban_p); }
public abstract int VALOR_INSERT(VALOR_BE V);
public static int INSERT(VALOR_BE V) { return(AbstractDataAccesLayerHelper.GetDataAccessLayer().VALOR_INSERT(V)); }