public List <Stores> GetAllStoresWithTheSameCatAndFloor(long cat, int floor)
{
List <Stores> result = new List <Stores>();
try
{
using (SqlCommand cmd = new SqlCommand())
{
using (cmd.Connection = new SqlConnection(m_conn_string))
{
cmd.Connection.Open();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = $"SELECT * FROM Stores WHERE Categories_ID={cat} AND Floor={floor};";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Stores s = new Stores()
{
ID = (long)reader["ID"],
Name = reader["Name"].ToString(),
Floor = (int)reader["Floor"],
Categories_ID = (long)reader["Categories_ID"],
};
result.Add(s);
}
}
}
}
catch (Exception ex)
{
my_logger.Error("Failed Function GetAllStoresWithTheSameCatAndFloor by query (SELECT * FROM Stores WHERE Categories_ID={cat} AND Floor={floor})");
my_logger.Error($"Failed to read from data base. Error : {ex}");
}
return(result);
}
static void Main(string[] args)
{
my_logger.Info("...System coming up...");
StoresDAO storesDAO = new StoresDAO("Data Source=.;Initial Catalog=TargilMeskamSSMS;Integrated Security=True;");
Stores s = new Stores("Prada", 2, 1);
//storesDAO.UpdateStore(s, 2);
//storesDAO.AddStore(s);
List <Stores> stores_list = storesDAO.GetAllStores();
Console.WriteLine("GetAllStores`-");
stores_list.ForEach(s1 => Console.WriteLine(s1));
Stores store = storesDAO.GetStoreById(3);
Console.WriteLine("getstorebyID");
Console.WriteLine(store);
List <Stores> stores_list2 = storesDAO.GetAllStoresWithTheSameCatAndFloor(1, 2);
Console.WriteLine("GetAllStoresWithTheSameCatAndFloor");
stores_list2.ForEach(s2 => Console.WriteLine(s2));
Console.WriteLine("GetMaxStoresByCategory");
Console.WriteLine(Newtonsoft.Json.JsonConvert.SerializeObject(storesDAO.GetMaxStoresByCategory()));
my_logger.Info("...System shutting down...");
}
public void AddStore(Stores s)
{
ExecuteNonQuery("INSERT INTO Stores(Name, Floor,Categories_ID)" +
$"VALUES('{s.Name}',{s.Floor},{s.Categories_ID});");
}
public void UpdateStore(Stores s, int id)
{
ExecuteNonQuery(
$"UPDATE Stores SET Name='{s.Name}', Floor={s.Floor},Categories_ID={s.Categories_ID} WHERE ID={id}");
}
