public csPlayer GetPlayerInfo(string p)
{
var player = new csPlayer();
try
{
parameters.Clear();
parameters.Add("@pPlayer", p);
dataset = csConnection.ExecutePA("[dbo].[web_playerInfo]", parameters);
if (dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow fila in dataset.Tables[0].Rows)
{
player.Name = Convert.ToString(fila["Name"]);
player.Agent = Convert.ToString(fila["Agent"]);
player.Phone = Convert.ToString(fila["Phone"]);
player.Email = Convert.ToString(fila["Email"]);
}
}
}
catch (Exception ex)
{
return(null);
}
finally
{
parameters.Clear();
}
return(player);
}
void PlayerChange()
{
if (!currentstats && Input.GetKeyDown(KeyCode.Alpha1) && currentPlayer.IsJump && Time.time - changeTime >= changeCoolTime)
{
changeTime = Time.time;
Skull2.SetActive(false);
currentPlayer = csPlayer1;
Skull1.transform.position = Skull2.transform.position + new Vector3(0f, 0.38f, 0f);
float dir = Skull1.transform.localScale.x > 0 ? 1f : -1f;
Skull1.transform.localScale = new Vector3(4f * dir, 4f, 1f);
camera2.SetActive(false);
camera1.SetActive(true);
currentstats = true;
Skull1.SetActive(true);
}
else if (currentstats && Input.GetKeyDown(KeyCode.Alpha2) && currentPlayer.IsJump && Time.time - changeTime >= changeCoolTime)
{
changeTime = Time.time;
Skull1.SetActive(false);
currentPlayer = csPlayer2;
Skull2.transform.position = Skull1.transform.position + new Vector3(0f, -0.38f, 0f);
float dir = Skull1.transform.localScale.x > 0 ? 1f : -1f;
Skull2.transform.localScale = new Vector3(3f * dir, 3f, 1f);
currentstats = false;
camera1.SetActive(false);
camera2.SetActive(true);
Skull2.SetActive(true);
}
}
protected void LoadData(object sender, EventArgs e)
{
csPlayer p = playerDB.GetPlayerInfo(inPlayer.Items[inPlayer.SelectedIndex].Value);
if (p != null)
{
inEmail.InnerText = p.Email;
inAgent.InnerText = p.Agent;
idCategory.InnerText = "...";
inphone.InnerText = p.Phone;
}
}
// Use this for initialization
void Start()
{
revengeGuage = GameObject.Find("RevengeGuage").GetComponent <Slider>();
btnRevenge = GameObject.Find("BtnHigh").GetComponent <Button>();
playerMethod = player.GetComponent <csPlayer>();
fever = FALSE;
life.transform.GetChild(0).gameObject.SetActive(true);
life.transform.GetChild(1).gameObject.SetActive(true);
life.transform.GetChild(2).gameObject.SetActive(true);
}
public static bool PlayerSave(ciFramework frameW, csPlayer player)
{
if (string.IsNullOrEmpty(player.Name)) return frameW.ErrorAdd("İsim girilmeli");
//
csPlayers players = null;
if (!Load(frameW, ref players)) return false;
XDocument docPlayers = null;
if (!King.Utils.LoadDb(frameW, ref docPlayers, "Players")) return false;
player.Key =Convert.ToInt16( players.Count+1);
var playNode = new XElement("player");
playNode.Add(new XAttribute("id",player.Key));
playNode.Add(new XAttribute("name", player.Name));
docPlayers.Element("players").Add(playNode);
King.Utils.SaveDb(docPlayers, "Players");
return true;
}
void ChangePlay()
{
if (changePlayer.Currentstats)
{
currentAnimator = playeranimator1;
currentRigid2D = playerrigidbody2D1;
player = player1;
}
else
{
currentAnimator = playeranimator2;
currentRigid2D = playerrigidbody2D2;
player = player2;
}
}
public static bool Load(ciFramework frameW, ref csPlayers ret)
{
ret = new csPlayers();
XDocument docPlayers = null;
if (!King.Utils.LoadDb(frameW, ref docPlayers, "Players")) return false;
foreach (XElement lcNode in docPlayers.Element("players").Descendants("player"))
{
var lcRec = new csPlayer
{
Key = Convert.ToInt16(lcNode.Attribute("id").Value),
Name = lcNode.Attribute("name").Value
};
ret.Add(lcRec);
}
return true;
}
public ObservableCollection <csPlayer> GetPlayersByAgent(int id)
{
ObservableCollection <csPlayer> data = new ObservableCollection <csPlayer>();
csPlayer player = null;
try
{
parameters.Clear();
parameters.Add("@pIdAgent", id);
dataset = csConnection.ExecutePA("[dbo].[web_getPlayerBYAgent]", parameters);
data.Add(new csPlayer("ALL", ""));
if (dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow fila in dataset.Tables[0].Rows)
{
player = new csPlayer();
player.Player = Convert.ToString(fila["Player"]);
player.IdPlayer = Convert.ToString(fila["IdPlayer"]);
data.Add(player);
}
}
else
{
data = null;
}
}
catch (Exception ex)
{
data = null;
throw new Exception("Error: " + ex.Message);
}
finally
{
parameters.Clear();
}
return(data);
}
void Awake()
{
changeTime -= changeCoolTime;
if (currentstats)
{
Skull2.SetActive(false);
currentPlayer = csPlayer1;
camera2.SetActive(false);
camera1.SetActive(true);
Skull1.SetActive(true);
currentstats = true;
}
else
{
Skull1.SetActive(false);
currentPlayer = csPlayer2;
camera1.SetActive(false);
camera2.SetActive(true);
Skull2.SetActive(true);
currentstats = false;
}
}
public static string LastWeeks(string player, string wagertype, string sport)
{
//****************************** THIS WEEK *********************************
var obj = new ObservableCollection <Object>();
sport = (sport == "ALL") ? "" : sport;
DateTime dt1 = DateTime.Now;
dt1 = dt1.AddDays(TW());
DateTime dt2 = DateTime.Now;
dt2 = dt2.AddDays(1);
string date1 = dt1.Year + "-" + dt1.Month + "-" + dt1.Day;
string date2 = dt2.Year + "-" + dt2.Month + "-" + dt2.Day;
csPlayer pla = playerDB.GetPlayerInfo(player);
var p = summaryDB.InfoBySeasons(date1, date2, sport, player, wagertype);
if (p != null)
{
p.Agent = pla.Agent;
p.Phone = pla.Phone;
p.Email = pla.Email;
p.DateRange = "Current Week";
obj.Add(p);
}
//************************************ LAST WEEK *********************************
dt1 = DateTime.Now;
dt1 = dt1.AddDays(TW() - 7);
dt2 = DateTime.Now;
dt2 = dt2.AddDays(TW());
date1 = dt1.Year + "-" + dt1.Month + "-" + dt1.Day;
date2 = dt2.Year + "-" + dt2.Month + "-" + dt2.Day;
p = summaryDB.InfoBySeasons(date1, date2, sport, player, wagertype);
if (p != null)
{
p.DateRange = "Last Week";
obj.Add(p);
}
// ******************************** LAST MONTH *****************************
dt1 = DateTime.Now;
dt1 = dt1.AddMonths(-1);
dt1 = dt1.AddDays(TM());
dt2 = DateTime.Now;
dt2 = dt2.AddDays(TM());
date1 = dt1.Year + "-" + dt1.Month + "-01";
date2 = dt2.Year + "-" + dt2.Month + "-01";
p = summaryDB.InfoBySeasons(date1, date2, sport, player, wagertype);
if (p != null)
{
p.DateRange = "Last Month";
obj.Add(p);
}
// ************************* CURRENT SEASON *******************************
var current = seasonDB.GetSeasonBySport(sport);
p = summaryDB.InfoBySeasons(current.startDateCurrentSeason, current.endDateCurrentSeason, sport, player, wagertype);
if (p != null)
{
p.DateRange = "Current Season";
obj.Add(p);
}
// ************************* LAST SEASON *******************************
p = summaryDB.InfoBySeasons(current.startDateLastSeason, current.endDateLastSeason, sport, player, wagertype);
if (p != null)
{
p.DateRange = "Last Season";
obj.Add(p);
}
return(Json.Encode(obj));
}
// Use this for initialization
void Start()
{
playerMethod = player.GetComponent <csPlayer>();
eventSystem = GameObject.Find("EventSystem").GetComponent <EventSystem>();
}
