public List<AdminTransaction> AllMemberTransactionData()
{
List<AdminTransaction> AdminDataList = new List<AdminTransaction>();
string conStr = ConfigurationManager.ConnectionStrings["ConnectToStopNShopDatabase"].ConnectionString;
string queryString = null;
queryString = "Select * from Transactions";
try
{
using (SqlConnection connection = new SqlConnection(conStr))
{
SqlCommand command = new SqlCommand(queryString, connection);
//command.Parameters.AddWithValue("userid", UserID);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
AdminTransaction AdminTrans = new AdminTransaction();
AdminTrans.TransactionID = Convert.ToInt32(reader[0]);
AdminTrans.UserID = Convert.ToInt32(reader[2]);
AdminTrans.ItemID = Convert.ToInt32(reader[4]);
AdminTrans.SeasonNO = Convert.ToString(reader[5]);
AdminTrans.Category = Convert.ToString(reader[3]);
AdminTrans.QuantityRequired = Convert.ToInt32(reader[6]);
AdminTrans.AccountNo = Convert.ToString(reader[8]);
AdminTrans.TotalAmount = Convert.ToInt32(reader[9]);
AdminTrans.TransactionDate = Convert.ToDateTime(reader[7]);
AdminTrans.Description = Convert.ToString(reader[1]);
AdminDataList.Add(AdminTrans);
}
reader.Close();
}
}
catch (Exception) { }
return AdminDataList;
}
public List<AdminTransaction> ViewTransaction(int UserIDList, string TransactionCategory, string ItemCategory)
{
List<AdminTransaction> TransactionList = new List<AdminTransaction>();
string conStr = ConfigurationManager.ConnectionStrings["ConnectToStopNShopDatabase"].ConnectionString;
string queryString = null;
queryString = "Select * from Transactions where UserID=@userid and TransactionType=@transaction and ItemCategory=@itemcat";
using (SqlConnection connection = new SqlConnection(conStr))
{
SqlCommand command = new SqlCommand(queryString, connection);
command.Parameters.AddWithValue("userid", UserIDList);
command.Parameters.AddWithValue("transaction", TransactionCategory);
command.Parameters.AddWithValue("itemcat", ItemCategory);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
AdminTransaction transList = new AdminTransaction();
transList.TransactionID = Convert.ToInt32(reader[0]);
transList.UserID = Convert.ToInt32(reader[2]);
transList.ItemID = Convert.ToInt32(reader[4]);
transList.SeasonNO = Convert.ToString(reader[5]);
transList.Category = Convert.ToString(reader[3]);
transList.QuantityRequired = Convert.ToInt32(reader[6]);
transList.AccountNo = Convert.ToString(reader[8]);
transList.TotalAmount = Convert.ToInt32(reader[9]);
transList.TransactionDate = Convert.ToDateTime(reader[7]);
transList.Description = Convert.ToString(reader[1]);
TransactionList.Add(transList);
}
reader.Close();
}
return TransactionList;
}