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));
}
