public bool AddAgentUser(AgentUserInfo info, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = null;
try
{
mycmd = trans.CreateCommand();
string sqlText = "insert into agentuserinfo " +
" (`UserID`,`TotalAwardRMB`,`InvitationURL`) " +
" values (@UserID,@TotalAwardRMB,@InvitationURL)";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@UserID", info.Player.SimpleInfo.UserID);
mycmd.Parameters.AddWithValue("@TotalAwardRMB", info.TotalAwardRMB);
mycmd.Parameters.AddWithValue("@InvitationURL", info.InvitationURL);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
private AgentUserInfo GetReferredAgent(PlayerInfo player)
{
PlayerInfo AgentUser = DBProvider.UserDBProvider.GetPlayerByUserID(player.SimpleInfo.AgentUserID);
if (AgentUser == null)
{
return(null);
}
AgentUserInfo agent = DBProvider.AgentUserInfoDBProvider.GetAgentUserInfo(AgentUser);
return(agent);
}
public AgentUserInfo GetAgentUserInfo(PlayerInfo player)
{
if (player.SimpleInfo.GroupType != PlayerGroupType.AgentPlayer)
{
return(null);
}
MySqlConnection myconn = null;
MySqlCommand mycmd = null;
try
{
myconn = MyDBHelper.Instance.CreateConnection();
string sqlTextA = "select * from agentuserinfo where UserID = @UserID; ";
mycmd = myconn.CreateCommand();
mycmd.CommandText = sqlTextA;
mycmd.Parameters.AddWithValue("@UserID", player.SimpleInfo.UserID);
myconn.Open();
MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
DataTable tableAgents = new DataTable();
adapter.Fill(tableAgents);
if (tableAgents.Rows.Count == 0)
{
return(null);
}
AgentUserInfo agent = new AgentUserInfo();
agent.ID = Convert.ToInt32(tableAgents.Rows[0]["id"]);
agent.TotalAwardRMB = Convert.ToDecimal(tableAgents.Rows[0]["TotalAwardRMB"]);
agent.InvitationURL = Convert.ToString(tableAgents.Rows[0]["InvitationURL"]);
agent.Player = player;
tableAgents.Clear();
tableAgents.Dispose();
adapter.Dispose();
return(agent);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
if (myconn != null)
{
myconn.Close();
myconn.Dispose();
}
}
}
