public List <Rewards> GetRandomRows(int lootTableValue, int numRows = 1, int eventType = 0)
{
bool includeEventType = eventType == 0 ? false : true;
string extraSearch = "";
if (includeEventType)
{
extraSearch = " AND EventType = @EventType ";
}
string sqlQuery = "SELECT " + lootColumns + " FROM Reward WHERE LootTableValue = @LootTableValue " + extraSearch + " ORDER BY RANDOM() LIMIT @NumRows;";
List <DBParameter> parameters = new List <DBParameter>();
parameters.Add(new DBParameter("@LootTableValue", lootTableValue));
parameters.Add(new DBParameter("@NumRows", numRows));
if (includeEventType)
{
parameters.Add(new DBParameter("@EventType", eventType));
}
DBResults results = ExecuteReader(sqlQuery, parameters);
List <Rewards> loot = GetList(results);
return(loot);
}
public DLLResults(string filename, RunResults res1, RunResults res2, DBResults resDb)
{
this.filename = filename;
this.res1 = res1;
this.res2 = res2;
this.resDb = resDb;
}
/// <Summary>
/// <Description>This method will fetch Audit results data from the database.</Description>
/// <MethodName>GetAuditResultdData</MethodName>
/// <RetunType>Void</RetunType>
/// <InputParams>
/// <param1>int reci_seq</param1>
/// <param1>string sdate</param1>
/// <param1>string edate</param1>
///
/// </InputParams>
/// </Summary>
public string GetAuditResultdData(int reci_seq, string sdate, string edate)
{
DBResults objDb = new DBResults();
WEIS.AuditResults objAuditResults = new WEIS.AuditResults();
DataSet dsAuditResults = new DataSet();
string abc = string.Empty;
try
{
objDb = objAuditResults.GetAuditResultsData(reci_seq, sdate, edate);
dsAuditResults = objDb.oraResultSet;
//if (dsAuditResults.Tables.Count > 0)
//{
abc = PrepareHTML(dsAuditResults, sdate, edate);
//}
dsAuditResults.Dispose();
dsAuditResults = null;
objDb = null;
objAuditResults = null;
}
catch (Exception ex)
{
Utilities.StopDisplayAndLogMessage(Resources.Resource.AuditResults_Title.ToString(),
Resources.Resource.AuditResults_GetDataError.ToString(), 1, ex.StackTrace.ToString(), WEIS.SessionManager.Current.UserID,
Resources.Resource.Error_Details.ToString() + ex.Message, "");
}
return(abc);
}
private static DBResults ProcessDB(string fullname)
{
var res = new DBResults();
res.Add(fullname + ".sdf");
res.Add(fullname + ".mdf");
res.Add(fullname + "_log.ldf");
return(res);
}
/// <summary
/// Searches with LIKE %RewardName%
/// </summary>
/// <param name="RewardName"></param>
/// <returns></returns>
public List <Rewards> Search(string RewardName)
{
string sqlQuery = "SELECT " + lootColumns + " FROM Reward WHERE RewardName LIKE @RewardName";
List <DBParameter> parameters = new List <DBParameter>();
parameters.Add(new DBParameter("@RewardName", "%" + RewardName + "%"));
DBResults results = ExecuteReader(sqlQuery, parameters);
return(GetList(results));
}
private DBResults ExecuteReader(string commandText, List <DBParameter> parameters)
{
IDbConnection dbconn;
dbconn = (IDbConnection) new SqliteConnection(conn);
dbconn.Open(); //Open connection to the database.
IDbCommand dbcmd = dbconn.CreateCommand();
dbcmd.CommandText = commandText;
AddParameters(dbcmd, parameters);
IDataReader reader = dbcmd.ExecuteReader();
DBResults ret = new DBResults(dbconn, dbcmd, reader);
return(ret);
}
public Rewards Find(int Id)
{
Rewards found = null;
string sqlQuery = "SELECT " + lootColumns + " FROM Reward WHERE Id = @Id ";
DBParameter pId = new DBParameter("@Id", Id);
List <DBParameter> parameters = new List <DBParameter>();
parameters.Add(pId);
DBResults results = ExecuteReader(sqlQuery, parameters);
List <Rewards> list = GetList(results);
if (list.Count != 0)
{
found = list[0];
}
results.Close();
return(found);
}
private List <Rewards> GetList(DBResults results)
{
Rewards found = null;
List <Rewards> ret = new List <Rewards>();
while (results.reader.Read())
{
int Id = results.reader.GetInt32(0);
string RewardName = null;
if (!results.reader.IsDBNull(1))
{
RewardName = results.reader.GetString(1);
}
string RewardImagePath = null;
if (!results.reader.IsDBNull(2))
{
RewardImagePath = results.reader.GetString(2);
}
int RewardTimer = results.reader.GetInt32(3);
int HPChange = results.reader.GetInt32(4);
int EnergyChange = results.reader.GetInt32(5);
int ShieldChange = results.reader.GetInt32(6);
int ShipResourcesFound = results.reader.GetInt32(7);
int SkillFound = results.reader.GetInt32(8);
int CharacterUnlocked = results.reader.GetInt32(9);
int LootTableValue = results.reader.GetInt32(10);
int EventType = results.reader.GetInt32(11);
found = new Rewards(Id, RewardName, RewardImagePath, RewardTimer, HPChange, EnergyChange, ShieldChange, ShipResourcesFound, SkillFound, CharacterUnlocked, LootTableValue, EventType);
ret.Add(found);
Debug.Log("id= " + Id + " rewardName =" + RewardName);
}
results.Close();
return(ret);
}
private static DBResults ProcessDB(string fullname)
{
var res = new DBResults();
res.Add(fullname + ".sdf");
res.Add(fullname + ".mdf");
res.Add(fullname + "_log.ldf");
return res;
}
public DLLResults(string filename, RunResults res1, RunResults res2, DBResults resDb)
{
this.filename = filename;
this.res1 = res1;
this.res2 = res2;
this.resDb = resDb;
}
//
public string getAuditRecordsForCurrentResults(string RSLT_SEQ, string aDate)
{
string strAudit = string.Empty;
DBResults objDb = new DBResults();
WEIS.AuditResults objAuditResults = new WEIS.AuditResults();
DataSet dsAuditResults = new DataSet();
DataTable dt1 = new DataTable();
int i = 0;
string strDate1 = string.Empty;
string strDate2 = string.Empty;
try
{
objDb = objAuditResults.GetAuditRecordsForCurrentResults(RSLT_SEQ, aDate);
dsAuditResults = objDb.oraResultSet;
dt1 = dsAuditResults.Tables[0];
if (dt1.Rows.Count > 0) // if not rs2.eof of ASP
{
for (i = 0; i < dt1.Rows.Count; i++) // while rs2.eof of ASP
{
//calling database function to look up comments between current result and and most recent audited result
if (i == 0)
{
strAudit = strAudit + getCommentsForCurrentResults(RSLT_SEQ, aDate, dt1.Rows[i]["audit_date"].ToString());
}
strAudit = strAudit + "<tr><td> </td><td bgcolor=#99CCFF>";
strAudit = strAudit + dt1.Rows[i]["value"] + "</td><td bgcolor=#99CCFF> </td><td bgcolor=#99CCFF>";
strAudit = strAudit + dt1.Rows[i]["created"] + "</td><td bgcolor=#99CCFF>";
strAudit = strAudit + dt1.Rows[i]["status"] + "</td><td bgcolor=#99CCFF>";
strAudit = strAudit + dt1.Rows[i]["audit_user"] + "</td><td bgcolor=#99CCFF>";
strAudit = strAudit + dt1.Rows[i]["audit_date"] + "</td><td bgcolor=#99CCFF>";
strAudit = strAudit + dt1.Rows[i]["datestamp"] + "</td><td bgcolor=#99CCFF>";
strAudit = strAudit + dt1.Rows[i]["action"] + "</td></tr>";
//'save dates for looking up comments
strDate1 = dt1.Rows[i]["audit_date"].ToString();
if (i <= (dt1.Rows.Count))
{
strDate2 = dt1.Rows[i + 1]["audit_date"].ToString();
}
else
{
strDate2 = "1/1/1999 12:00:00 AM";
}
//'display all comments between current result and previous result
strAudit = strAudit + getCommentsForCurrentResults(RSLT_SEQ, strDate1, strDate2);
}
}
else
{
//if there are no audit records, search for any comments saved before current result
strAudit = strAudit + GetCommentsWhenNoAudit(RSLT_SEQ, aDate);
}
dt1 = null;
dsAuditResults.Dispose();
dsAuditResults = null;
objDb = null;
objAuditResults = null;
}
catch (Exception ex)
{
Utilities.StopDisplayAndLogMessage(Resources.Resource.AuditResults_Title.ToString(),
Resources.Resource.AuditResults_GetDataError.ToString(), 1, ex.StackTrace.ToString(), WEIS.SessionManager.Current.UserID,
Resources.Resource.Error_Details.ToString() + ex.Message, "");
}
return(strAudit);
}
