public IEnumerable <T> GetList()
{
using (var connection = new SqlConnection(_connectionString))
{
return(connection.GetAll <T>());
}
}
public IEnumerable <Shuttle> GetAllShuttles()
{
IEnumerable <Shuttle> list;
using (var conn = new SqlConnection(conStr))
{
conn.Open();
list = conn.GetAll <Shuttle>();
conn.Close();
}
return(list);
}
public IEnumerable <Asrs> GetAllAsrs()
{
IEnumerable <Asrs> list;
using (var conn = new SqlConnection(conStr))
{
conn.Open();
list = conn.GetAll <Asrs>();
conn.Close();
}
return(list);
}
public List <Place> GetAllPlaces()
{
List <Place> list;
using (var conn = new SqlConnection(conStr))
{
conn.Open();
list = conn.GetAll <Place>().ToList();
conn.Close();
}
return(list);
}
//optimizasyonu yazarken bu satırları global değişken olarak yazmak için global class ve propertyleri set et
public IEnumerable <SystemParameter> GetAllSystemParameters()
{
IEnumerable <SystemParameter> list;
using (var conn = new SqlConnection(conStr))
{
conn.Open();
list = conn.GetAll <SystemParameter>();
conn.Close();
}
return(list);
}
public List <Order> GetAllOrders()
{
List <Order> list;
using (var conn = new SqlConnection(conStr))
{
conn.Open();
list = conn.GetAll <Order>().ToList();
conn.Close();
}
var newList = list.OrderByDescending(x => x.Id).ToList();
return(newList);
}