public Champions GetChampions(region region, language lang, champData?chamData = null, bool useCaching = false)
{
Champions val = Cache.Get <Champions>(region.ToString(), lang.ToString(), chamData.ToString()); //cache getting
if (val != null)
{
return(val);
}
RiotApiCaller <Champions> caller = new RiotApiCaller <Champions>(suffix.champions);
caller.AddParam(param.region, region);
caller.AddParam(param.locale, lang);
if (chamData != null)
{
caller.AddParam(param.champData, chamData.Value);
}
else
{
caller.AddParam(param.champData, ""); //important for basic information
}
if (useCaching) //your choice
{
Cache.AddOrUpdate(caller.CreateRequest(new System.TimeSpan(1, 0, 0, 0))); // cache adding
}
else
{
caller.CreateRequest();//everytime data coming from riotgames server
}
return(caller.Result.FirstOrDefault());
}
public RuneList GetRunes(region region, language lang, runeListData runeData = runeListData.basic, bool useCaching = false)
{
RuneList val = Cache.Get <RuneList>(region.ToString(), lang.ToString(), runeData.ToString()); //cache getting
if (val != null)
{
return(val);
}
RiotApiCaller <RuneList> caller = new RiotApiCaller <RuneList>(suffix.runes);
caller.AddParam(param.region, region);
caller.AddParam(param.locale, lang);
caller.AddParam(param.runeListData, runeData);
if (useCaching) //your choice
{
Cache.AddOrUpdate(caller.CreateRequest(new System.TimeSpan(1, 0, 0, 0))); // cache adding
}
else
{
caller.CreateRequest();//everytime data coming from riotgames server
}
return(caller.Result.FirstOrDefault());
}
public SummonerSpellList GetSummonerSpells(region region, language lang, spellData?spellData = null, bool useCaching = false)
{
SummonerSpellList val = Cache.Get <SummonerSpellList>(region.ToString(), lang.ToString(), spellData.ToString()); //cache getting
if (val != null)
{
return(val);
}
RiotApiCaller <SummonerSpellList> caller = new RiotApiCaller <SummonerSpellList>(suffix.summonerSpells);
caller.AddParam(param.region, region);
caller.AddParam(param.locale, lang);
if (spellData != null)
{
caller.AddParam(param.spellData, spellData);
}
else
{
caller.AddParam(param.spellData, ""); //important for basic information
}
if (useCaching) //your choice
{
Cache.AddOrUpdate(caller.CreateRequest(new System.TimeSpan(1, 0, 0, 0))); // cache adding
}
else
{
caller.CreateRequest();//everytime data coming from riotgames server
}
return(caller.Result.FirstOrDefault());
}
public MasteryData GetMasteries(region region, language lang, masteryListData?masteryData = null, bool useCaching = false)
{
MasteryData val = Cache.Get <MasteryData>(region.ToString(), lang.ToString(), masteryData.ToString()); //cache getting
if (val != null)
{
return(val);
}
RiotApiCaller <MasteryData> caller = new RiotApiCaller <MasteryData>(suffix.mastery);
caller.AddParam(param.region, region);
caller.AddParam(param.locale, lang);
if (masteryData != null)
{
caller.AddParam(param.masteryListData, masteryData);
}
else
{
caller.AddParam(param.masteryListData, ""); //important for basic information
}
if (useCaching) //your choice
{
Cache.AddOrUpdate(caller.CreateRequest(new System.TimeSpan(1, 0, 0, 0))); // cache adding
}
else
{
caller.CreateRequest();//everytime data coming from riotgames server
}
return(caller.Result.FirstOrDefault());
}
public static void ReadCSV()
{
bool firstLine = true;
int languageKey = 0;
//TextAsset reader = Resources.Load<TextAsset>("Language/Language.csv");
gameTexts.Clear();
//"Assets/Resources/Language/Language.csv"
using (var reader = new StreamReader(Application.streamingAssetsPath + "/Language/Language.csv"))
{
while (!reader.EndOfStream)
{
var splits = reader.ReadLine().Split(';');
if (firstLine)
{
firstLine = false;
int i = 0;
while (languageKey == 0 || i == splits.Length - 1)
{
if (splits[i] == currentLanguage.ToString())
{
languageKey = i;
}
i++;
}
continue;
}
gameTexts.Add(splits[0], splits[languageKey]);
}
}
}
/// <summary>
/// html select controls setting
/// </summary>
/// <param name="sqlcmd">sql command</param>
/// <param name="request">default item </param>
/// <param name="tag">language type</param>
/// <returns></returns>
public static string setHList(string sqlcmd, string request, language tag)
{
StringBuilder sb = new StringBuilder();
using (SmoothEnterprise.Database.DataSet rs = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead))
{
try
{
rs.Open(sqlcmd);
int iCount = rs.Rows.Count + 1;
sb.Append("<option value=\"\">select</option>");
while (!rs.EOF)
{
//rs["hdL"].ToString(), rs["id"].ToString()
string value = rs["rowid"].ToString();
string text = rs[tag.ToString()].ToString();
if (value == request)
{
sb.AppendFormat("<option value=\"{0}\" selected=\"true\" >{1}</option>", value, text);
}
else
{
sb.AppendFormat("<option value=\"{0}\">{1}</option>", value, text);
}
rs.MoveNext();
}
rs.Close();
}
catch (Exception ex)
{
throw ex;
}
}
return(sb.ToString());
}
public MapData GetMaps(region region, language lang, bool useCaching = false)
{
MapData val = Cache.Get <MapData>(region.ToString(), lang.ToString()); //cache getting
if (val != null)
{
return(val);
}
RiotApiCaller <MapData> caller = new RiotApiCaller <MapData>(suffix.map);
caller.AddParam(param.region, region);
caller.AddParam(param.locale, lang);
if (useCaching) //your choice
{
Cache.AddOrUpdate(caller.CreateRequest(new System.TimeSpan(1, 0, 0, 0))); // cache adding
}
else
{
caller.CreateRequest();//everytime data coming from riotgames server
}
return(caller.Result.FirstOrDefault());
}
public string getOptionName(string rowid)
{
string text = "";
using (SmoothEnterprise.Database.DataSet rs = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead))
{
string _sql = string.Format("select {1} 'tag' from eipe.dbo.IPQC_Ra_Option where rowid='{0}' order by en ", rowid, lang.ToString());
text = rs.ExecuteScalar(_sql).ToString();
}
return(text);
}
public ItemData GetItem(long itemId, region region, language lang, itemListData?itemData = null, bool useCaching = false)
{
ItemData val = Cache.Get <ItemData>(itemId.ToString(), region.ToString(), lang.ToString(), itemData.ToString()); //cache getting
if (val != null)
{
return(val);
}
RiotApiCaller <ItemData> caller = new RiotApiCaller <ItemData>(suffix.item);
caller.AddParam(param.region, region);
caller.AddParam(param.locale, lang);
caller.AddParam(param.id, itemId);
if (itemData != null)
{
caller.AddParam(param.itemData, itemData.Value);
}
else
{
caller.AddParam(param.itemData, ""); //important for basic information
}
if (useCaching) //your choice
{
Cache.AddOrUpdate(caller.CreateRequest(new System.TimeSpan(1, 0, 0, 0))); // cache adding
}
else
{
caller.CreateRequest();//everytime data coming from riotgames server
}
return(caller.Result.FirstOrDefault());
}
/// <summary>
/// set DropList Item
/// </summary>
/// <param name="sqlcmd">sql commmand top 3 column is id 'value', tag 'en' , tag name 'tw' </param>
/// <param name="request"> selected or default </param>
/// <param name="lang">將language 配合 sys_option 中的欄位使用 en 為必需欄位 </param>
/// <returns></returns>
public static ListItem[] getOPItem(string sqlcmd, string request, language tag, bool idefault)
{
ListItem[] Item = new ListItem[0];
using (SqlConnection conn = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["EIPAConnectionString"].ConnectionString))
{
try
{
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlcmd, conn);
DataSet ds = new DataSet();
da.Fill(ds, "temp");
DataTable dt = ds.Tables["temp"];
conn.Close();
da.Dispose();
int iCount = dt.Rows.Count + 1;
Item = new ListItem[iCount];
Item[0] = new ListItem("Select", "");
int i = 1;
foreach (DataRow row in dt.Rows)
{
string value = row[0].ToString();
string text = row[tag.ToString()].ToString();
Item[i] = new ListItem(text, value);
request = request.Replace(" ", string.Empty);
if (!string.IsNullOrEmpty(request))
{
if (value == request)
{
Item[i].Selected = true;
}
}
else
{
if (idefault)
{
if (!string.IsNullOrEmpty(row[3].ToString()))
{
bool isDef = (bool)row[3];
if (isDef)
{
Item[i].Selected = true;
}
}
}
}
i++;
}
dt.Dispose();
}
catch (Exception ex)
{
throw ex;
}
}
return(Item);
}
