//public static List<StoreBrandFilter> GetStoreBrandFilterList(string searchValue, int linked, int accountId)
//{
// List<StoreBrandFilter> list = new List<StoreBrandFilter>();
// Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
// string sqlCommand = "GetStoreBrandFilterList";
// DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
// db.AddInParameter(dbCommand, "@SearchValue", DbType.String, searchValue);
// db.AddInParameter(dbCommand, "@Linked", DbType.Int32, linked);
// db.AddInParameter(dbCommand, "@AccountId", DbType.Int32, accountId);
// using (IDataReader dataReader = db.ExecuteReader(dbCommand))
// {
// while (dataReader.Read())
// {
// StoreBrandFilter storeBrandFilter = new StoreBrandFilter();
// storeBrandFilter.StoreBrandFilterId = Convert.ToInt32(dataReader["StoreBrandFilterId"]);
// storeBrandFilter.StoreId = Convert.ToInt32(dataReader["StoreId"]);
// storeBrandFilter.Description = dataReader["Store"].ToString();
// storeBrandFilter.Region = dataReader["Region"].ToString();
// storeBrandFilter.Location = dataReader["Location"].ToString();
// storeBrandFilter.StoreBrandFilterLinkChickaChicken = (linked == 1) ? true : false;
// storeBrandFilter.Format = dataReader["Format"].ToString();
// list.Add(storeBrandFilter);
// }
// }
// return list;
//}
public static List <StoreBrandFilter> GetStoreBrandFilterList(string searchValue, int linked, int accountId)
{
List <StoreBrandFilter> list = new List <StoreBrandFilter>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetStoreBrandFilterList";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@SearchValue", DbType.String, searchValue);
db.AddInParameter(dbCommand, "@Linked", DbType.Int32, linked);
db.AddInParameter(dbCommand, "@AccountId", DbType.Int32, accountId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
StoreBrandFilter storeBrandFilter = new StoreBrandFilter();
storeBrandFilter.StoreBrandFilterId = Convert.ToInt32(dataReader["StoreBrandFilterId"]);
storeBrandFilter.SparStoreId = Convert.ToInt32(dataReader["SparStoreId"]);
storeBrandFilter.Description = dataReader["Store"].ToString();
storeBrandFilter.Region = dataReader["Region"].ToString();
storeBrandFilter.Location = dataReader["Location"].ToString();
storeBrandFilter.StoreBrandFilterLinkChickaChicken = (Convert.ToInt32(dataReader["StoreBrandIdChickaChicken"]) == 1) ? true : false;
storeBrandFilter.StoreBrandFilterLinkMcCoy = (Convert.ToInt32(dataReader["StoreBrandIdMcCoy"]) == 2) ? true : false;
storeBrandFilter.Format = dataReader["Format"].ToString();
storeBrandFilter.StoreBrandApplianceId = Convert.ToInt32(dataReader["StoreBrandApplianceId"]);
list.Add(storeBrandFilter);
}
}
return(list);
}
public static List <StoreBrandFilter> GetStoreBrandApplianceList(int companyId)
{
List <StoreBrandFilter> list = new List <StoreBrandFilter>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetStoreBrandApplianceList";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, companyId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
StoreBrandFilter storeBrandFilter = new StoreBrandFilter();
storeBrandFilter.StoreBrandApplianceId = Convert.ToInt32(dataReader["StoreBrandApplianceId"]);
storeBrandFilter.Description = dataReader["Description"].ToString();
list.Add(storeBrandFilter);
}
}
return(list);
}
