public IDataReader ExecuteReader(string sql, Trx trxName)
{
return(ExecuteReader(sql, null, trxName));
}
//public int GetNextID(string Name)
//{
// throw new NotImplementedException();
//}
/// <summary>
/// Drop Existing if any and create new Sequence.
/// </summary>
/// <param name="name"></param>
/// <param name="increment"></param>
/// <param name="minvalue"></param>
/// <param name="maxvalue"></param>
/// <param name="start"></param>
/// <param name="trxName"></param>
/// <returns></returns>
public bool CreateSequence(string name, int increment, int minvalue, int maxvalue, int start, Trx trxName)
{
int no = DB.ExecuteQuery("DROP SEQUENCE " + name.ToUpper() + "_SEQ", null, trxName);
no = DB.ExecuteQuery("CREATE SEQUENCE " + name.ToUpper() + "_SEQ"
+ " MINVALUE " + minvalue
+ " MAXVALUE " + maxvalue
+ " START WITH " + start
+ " INCREMENT BY " + increment, null, trxName)
;
if (no == -1)
{
return(false);
}
else
{
return(true);
}
//if (no == -1 && Common.Common.LenghtyTableNames.IndexOf(name.ToUpper()) > -1)
//{
// name = name.Substring(0, 25);
// DB.ExecuteQuery("DROP SEQUENCE " + name.ToUpper()+ "_SEQ", null, trxName);
// no = DB.ExecuteQuery("CREATE SEQUENCE " + name.ToUpper()+ "_SEQ"
// + " MINVALUE " + minvalue
// + " MAXVALUE " + maxvalue
// + " START WITH " + start
// + " INCREMENT BY " + increment + " CACHE 20", null, trxName);
// if (no == -1)
// return false;
// else
// return true;
//}
//else
// return true;
}
public DataSet ExecuteDataset(string sql, Trx trxName)
{
return(ExecuteDataset(sql, null, trxName));
}
