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