public BingoResult(int? dbResult, string dbResultDetail)
{
if (dbResult == null)
{
Result = BingoResultType.Null;
ResultDetail = null;
}
else
{
Result = (BingoResultType) dbResult.Value;
ResultDetail = dbResultDetail;
}
}
public BingoResult(int?dbResult, string dbResultDetail)
{
if (dbResult == null)
{
Result = BingoResultType.Null;
ResultDetail = null;
}
else
{
Result = (BingoResultType)dbResult.Value;
ResultDetail = dbResultDetail;
}
}
public static int GetClubEquipmentGainCount(int clubID, BingoResultType type, string resultDetail)
{
var sql = string.Empty;
switch (type)
{
case BingoResultType.Strip:
sql =
"SELECT COUNT(*) FROM AcnClub_LogBingo WHERE ClubID = @clubID AND Result = @result AND (ResultDetail = @resultDetail OR ResultDetail = 'strip')";
break;
case BingoResultType.Card:
if (resultDetail == "legend")
{
sql =
"SELECT COUNT(*) FROM AcnClub_LogBingo WHERE ClubID = @clubID AND Result = @result AND ResultDetail = @resultDetail";
}
else
{
sql =
"SELECT COUNT(*) FROM AcnClub_LogBingo WHERE ClubID = @clubID AND Result = @result AND ResultDetail <> 'legend'";
}
break;
case BingoResultType.Cash:
case BingoResultType.Both:
sql = "SELECT COUNT(*) FROM AcnClub_LogBingo WHERE ClubID = @clubID AND Result = @result";
break;
}
if (sql != string.Empty)
{
using (var con = SQLConn.GetConnection())
{
var com = new SqlCommand(sql, con);
com.Parameters.Add(new SqlParameter("@clubID", clubID));
com.Parameters.Add(new SqlParameter("@result", (int)type));
com.Parameters.Add(new SqlParameter("@resultDetail", resultDetail));
con.Open();
var count = (int)com.ExecuteScalar();
//con.Close();
return(count);
}
}
return(0);
}
public static int GetClubEquipmentGainCount(int clubID, BingoResultType type, string resultDetail)
{
var sql = string.Empty;
switch (type)
{
case BingoResultType.Strip:
sql =
"SELECT COUNT(*) FROM AcnClub_LogBingo WHERE ClubID = @clubID AND Result = @result AND (ResultDetail = @resultDetail OR ResultDetail = 'strip')";
break;
case BingoResultType.Card:
if (resultDetail == "legend")
{
sql =
"SELECT COUNT(*) FROM AcnClub_LogBingo WHERE ClubID = @clubID AND Result = @result AND ResultDetail = @resultDetail";
}
else
{
sql =
"SELECT COUNT(*) FROM AcnClub_LogBingo WHERE ClubID = @clubID AND Result = @result AND ResultDetail <> 'legend'";
}
break;
case BingoResultType.Cash:
case BingoResultType.Both:
sql = "SELECT COUNT(*) FROM AcnClub_LogBingo WHERE ClubID = @clubID AND Result = @result";
break;
}
if (sql != string.Empty)
{
using (var con = SQLConn.GetConnection())
{
var com = new SqlCommand(sql, con);
com.Parameters.Add(new SqlParameter("@clubID", clubID));
com.Parameters.Add(new SqlParameter("@result", (int) type));
com.Parameters.Add(new SqlParameter("@resultDetail", resultDetail));
con.Open();
var count = (int) com.ExecuteScalar();
//con.Close();
return count;
}
}
return 0;
}
