public static List<Merchant> Merchants(string merchantType)
{
List<Merchant> merchants = new List<Merchant>();
string cmdText = "select * from tblMerchant";
switch (merchantType)
{
case "Local Merchants *":
cmdText += " where LocalMerchant = true";
break;
case "National Merchants *":
cmdText += " where LocalMerchant = false";
break;
}
cmdText += " order by MerchantName";
using (OleDbConnection myConnection = new OleDbConnection(
ConfigurationManager.ConnectionStrings["BeanCounterDB"].ToString()))
{
using (OleDbCommand myCommand = new OleDbCommand(cmdText, myConnection))
{
myConnection.Open();
using (OleDbDataReader myDataReader = myCommand.ExecuteReader())
{
while (myDataReader.Read())
{
Merchant merchant = new Merchant(
myDataReader["MerchantName"].ToString(),
myDataReader["CategoryName"].ToString(),
Convert.ToBoolean(myDataReader["AutoCategorize"].ToString()),
Convert.ToBoolean(myDataReader["LocalMerchant"].ToString()),
Convert.ToInt32(myDataReader["MerchantID"].ToString()));
merchants.Add(merchant);
}
}
}
}
return merchants;
}
public static List<Merchant> NationalMerchants()
{
List<Merchant> merchants = new List<Merchant>();
string cmdText = "SELECT MerchantName, CategoryName FROM tblMerchant where LocalMerchant = false and AutoCategorize = true order by MerchantName";
using (OleDbConnection myConnection = new OleDbConnection(
ConfigurationManager.ConnectionStrings["BeanCounterDB"].ToString()))
{
using (OleDbCommand myCommand = new OleDbCommand(cmdText, myConnection))
{
myConnection.Open();
using (OleDbDataReader myDataReader = myCommand.ExecuteReader())
{
while (myDataReader.Read())
{
//if (merchant.Contains(myDataReader["MerchantName"].ToString()))
//{
// categoryName = myDataReader["CategoryName"].ToString();
// break;
//}
Merchant merchant = new Merchant();
merchant.MerchantName = myDataReader["MerchantName"].ToString();
merchant.CategoryName = myDataReader["CategoryName"].ToString();
merchants.Add(merchant);
}
}
}
}
return merchants;
}