public IEnumerable <Top> Get()
{
IEnumerable <Top> model;
using (MadalyonContext dbContext = new MadalyonContext())
{
List <Top_Book> deneme = dbContext.Top_Book.ToList();
List <Top> aktar = new List <Top>();
foreach (Top_Book item in deneme)
{
Top t = new Top();
t.book_id = item.book_id;
t.book_name = item.book_name;
t.write_name = item.write_name;
aktar.Add(t);
}
model = aktar;
}
return(model);
}
public IEnumerable <Book> Get()
{
IEnumerable <Book> model;
using (MadalyonContext dbContext = new MadalyonContext())
{
List <Book_Table> deneme = dbContext.Book_Table.ToList();
List <Book> aktar = new List <Book>();
foreach (Book_Table item in deneme)
{
Book t = new Book();
t.book_id = item.book_id;
t.user_id = item.user_id;
t.book_choise = item.book_choise;
t.book_name = item.book_name;
t.writer_name = item.writer_name;
aktar.Add(t);
}
model = aktar;
}
return(model);
}
public IEnumerable <Review> Get()
{
IEnumerable <Review> model;
using (MadalyonContext dbContext = new MadalyonContext())
{
List <Review_Table> deneme = dbContext.Review_Table.ToList();
List <Review> aktar = new List <Review>();
foreach (Review_Table item in deneme)
{
Review t = new Review();
t.review_id = item.review_id;
t.user_id = item.user_id;
t.review_name = item.review_name;
t.review_photo = item.review_photo;
t.review_text = item.review_text;
aktar.Add(t);
}
model = aktar;
}
return(model);
}
public IEnumerable <Travel_Map> Get()
{
IEnumerable <Travel_Map> model;
using (MadalyonContext dbContext = new MadalyonContext())
{
List <Travel_Map_Table> deneme = dbContext.Travel_Map_Table.ToList();
List <Travel_Map> aktar = new List <Travel_Map>();
foreach (Travel_Map_Table item in deneme)
{
Travel_Map t = new Travel_Map();
t.Travel_id = item.Travel_id;
t.user_id = item.user_id;
t.travel_date = item.travel_date;
t.travel_country = item.travel_country;
t.travel_city = item.travel_city;
t.travel_choise = item.travel_choise;
aktar.Add(t);
}
model = aktar;
}
return(model);
}
public IEnumerable<Experience> Get()
{
IEnumerable<Experience> model;
using (MadalyonContext dbContext = new MadalyonContext())
{
List<Experience_Table> deneme = dbContext.Experience_Table.ToList();
List<Experience> aktar = new List<Experience>();
foreach (Experience_Table item in deneme)
{
Experience t = new Experience();
t.experience_id = item.experience_id;
t.user_id = item.user_id;
t.experience_location = item.experience_location;
t.experience_name = item.experience_name;
t.experience_photo = item.experience_photo;
t.experience_text = item.experience_text;
aktar.Add(t);
}
model = aktar;
}
return model;
}
public IEnumerable <Read_Questions> Get()
{
IEnumerable <Read_Questions> model;
using (MadalyonContext dbContext = new MadalyonContext())
{
List <Read_Questions_Table> deneme = dbContext.Read_Questions_Table.ToList();
List <Read_Questions> aktar = new List <Read_Questions>();
foreach (Read_Questions_Table item in deneme)
{
Read_Questions m = new Read_Questions();
m.read_questions_id = item.read_questions_id;
m.read_questions_message = item.read_questions_message;
m.read_questions_from_id = item.read_questions_from_id;
m.user_id = item.user_id;
m.read_questions_date = item.read_questions_date;
m.read_answers_message = item.read_answers_message;
m.read_answers_date = item.read_answers_date;
aktar.Add(m);
}
model = aktar;
}
return(model);
}
public IEnumerable <User> Get()
{
IEnumerable <User> model;
using (MadalyonContext dbContext = new MadalyonContext())
{
List <User_Table> deneme = dbContext.User_Table.ToList();
List <User> aktar = new List <User>();
foreach (User_Table item in deneme)
{
User m = new User();
m.user_id = item.user_id;
m.user_email = item.user_email;
m.user_name = item.user_name;
m.user_nickname = item.user_nickname;
m.user_password = item.user_password;
m.user_photo = item.user_photo;
m.user_surname = item.user_surname;
aktar.Add(m);
}
model = aktar;
}
return(model);
}
public IEnumerable <Travel_Question> Get()
{
IEnumerable <Travel_Question> model;
using (MadalyonContext dbContext = new MadalyonContext())
{
List <Travel_Questions_Table> deneme = dbContext.Travel_Questions_Table.ToList();
List <Travel_Question> aktar = new List <Travel_Question>();
foreach (Travel_Questions_Table item in deneme)
{
Travel_Question m = new Travel_Question();
m.travel_questions_id = item.travel_questions_id;
m.travel_questions_from_id = item.travel_questions_from_id;
m.travel_questions_message = item.travel_questions_message;
m.user_id = item.user_id;
m.travel_questions_date = item.travel_questions_date;
m.travel_answers_date = item.travel_answers_date;
m.travel_answers_message = item.travel_answers_message;
aktar.Add(m);
}
model = aktar;
}
return(model);
}
