public bool InsertTransactionPackage(TransactionPackageBO objTransactionPackageBO)
{
try
{
return(Proxy.InsertTransactionPackage(objTransactionPackageBO));
}
catch
{
return(false);
}
}
public string DetailTransactionPackage(int memberID, string strTransactionCode)
{
string json = "";
TransactionPackageBO objTransactionPackageBO = new TransactionPackageBO();
objTransactionPackageBO = transactionPackage.DetailTransactionPackage(memberID, strTransactionCode);
if (objTransactionPackageBO != null && objTransactionPackageBO.TransactionCode != null && objTransactionPackageBO.TransactionCode != "")
{
json = JsonConvert.SerializeObject(objTransactionPackageBO);
}
return(json.ToString());
}
public TransactionPackageBO DetailTransactionPackage(int memberID, string strTransactionCode)
{
Sqlhelper helper = new Sqlhelper("", "ConnectionString");
try
{
TransactionPackageBO transaction = new TransactionPackageBO();
string sql = "SP_ListTransactionPackageByCode";
SqlParameter[] pa = new SqlParameter[2];
pa[0] = new SqlParameter("@memberID", memberID);
pa[1] = new SqlParameter("@transactioncode", strTransactionCode);
SqlCommand command = helper.GetCommand(sql, pa, true);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
transaction.MemberID = int.Parse(reader["MemberID"].ToString());
transaction.Status = int.Parse(reader["Status"].ToString());
transaction.CoinID = int.Parse(reader["CoinID"].ToString());
transaction.CreateDate = DateTime.Parse(reader["CreateDate"].ToString());
transaction.ExpireDate = DateTime.Parse(reader["ExpireDate"].ToString());
transaction.PackageID = int.Parse(reader["PackageID"].ToString());
transaction.PackageName = reader["PackageName"].ToString();
transaction.TransactionCode = reader["TransactionCode"].ToString();
transaction.PackageValue = float.Parse(reader["PackageValue"].ToString());
transaction.CoinValue = float.Parse(reader["CoinValue"].ToString());
transaction.CoinName = reader["CoinName"].ToString();
transaction.Note = reader["Note"].ToString();
}
return(transaction);
}
catch (Exception ex)
{
Utilitys.WriteLog(fileLog, ex.Message);
return(null);
}
finally
{
helper.destroy();
}
}
public IEnumerable <TransactionPackageBO> ListTransactionPackageByMember(int memberID)
{
Sqlhelper helper = new Sqlhelper("", "ConnectionString");
try
{
List <TransactionPackageBO> lstTransaction = new List <TransactionPackageBO>();
string sql = "SP_ListTransactionByMember";
SqlParameter[] pa = new SqlParameter[1];
pa[0] = new SqlParameter("@memberID", memberID);
SqlCommand command = helper.GetCommand(sql, pa, true);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
TransactionPackageBO transaction = new TransactionPackageBO();
transaction.MemberID = int.Parse(reader["MemberID"].ToString());
transaction.Status = int.Parse(reader["Status"].ToString());
transaction.CoinID = int.Parse(reader["CoinID"].ToString());
transaction.CreateDate = DateTime.Parse(reader["CreateDate"].ToString());
transaction.ExpireDate = DateTime.Parse(reader["ExpireDate"].ToString());
transaction.PackageID = int.Parse(reader["PackageID"].ToString());
transaction.PackageName = reader["PackageName"].ToString();
transaction.PackageValue = float.Parse(reader["PackageValue"].ToString());
transaction.TransactionCode = reader["TransactionCode"].ToString();
transaction.Note = reader["Note"].ToString();
lstTransaction.Add(transaction);
}
return(lstTransaction);
}
catch (Exception ex)
{
Utilitys.WriteLog(fileLog, ex.Message);
return(null);
}
finally
{
helper.destroy();
}
}
public bool InsertTransactionPackage(TransactionPackageBO transaction)
{
Sqlhelper helper = new Sqlhelper("", "ConnectionString");
try
{
bool rs = false;
string sql = "SP_InsertTransactionPackageFE";
SqlParameter[] pa = new SqlParameter[10];
pa[0] = new SqlParameter("@memberid", transaction.MemberID);
pa[1] = new SqlParameter("@packageid", transaction.PackageID);
pa[2] = new SqlParameter("@coinid", transaction.CoinID);
pa[3] = new SqlParameter("@createdate", transaction.CreateDate);
pa[4] = new SqlParameter("@expiredate", transaction.ExpireDate);
pa[5] = new SqlParameter("@status", transaction.Status);
pa[6] = new SqlParameter("@transactioncode", transaction.TransactionCode);
pa[7] = new SqlParameter("@note", transaction.Note);
pa[8] = new SqlParameter("@transactionbitcoin", transaction.TransactionBitcoin);
pa[9] = new SqlParameter("@packagevalue", transaction.PackageValue);
SqlCommand command = helper.GetCommand(sql, pa, true);
int row = command.ExecuteNonQuery();
if (row > 0)
{
rs = true;
}
return(rs);
}
catch (Exception ex)
{
Utilitys.WriteLog(fileLog, ex.Message);
return(false);
}
finally
{
helper.destroy();
}
}