public List <Customers> RandevulariGetirIptaller()
{
List <Customers> cstm = new List <Customers>();
using (PGDatabase dbd = new PGDatabase())
{
string command = "select *,rooms.roomnumber as roomnumbernum from customers inner join rooms on customers.roomnumber = rooms.roomid inner join odatype on rooms.odatur = odatype.id and customers.rezervasyoniptal =true ";
NpgsqlDataReader reader = dbd.Reader(command);
while (reader.Read())
{
Customers customer = new Customers();
customer.ad = reader["ad"].ToString();
customer.soyad = reader["soyad"].ToString();
customer.email = reader["email"].ToString();
customer.odaturu = (reader["odaturadi"]).ToString();
customer.odanumarasi = Convert.ToInt32(reader["roomnumbernum"]);
customer.id = Convert.ToInt32(reader["id"]);
customer.r_baslama = Convert.ToDateTime(reader["r_baslama"]);
customer.r_bitis = Convert.ToDateTime(reader["r_bitis"]);
customer.cocukvarmi = Convert.ToBoolean(reader["haschildren"]);
customer.cocuksayisi = (reader["cocuksayisi"]).ToString();
customer.notlar = (reader["notlar"]).ToString();
cstm.Add(customer);
}
reader.Close();
dbd.connClose();
}
return(cstm);
}
public List <RoomTypeModel> OdaTurlerComboBoxDoldur()
{
List <RoomTypeModel> roomTypeModels = new List <RoomTypeModel>();
using (PGDatabase dbd = new PGDatabase())
{
string command = "select * from odatype ";
NpgsqlDataReader reader = dbd.Reader(command);
while (reader.Read())
{
RoomTypeModel roomType = new RoomTypeModel();
roomType.id = Convert.ToInt32(reader["id"]);
roomType.odaTurAdi = (reader["odaturadi"]).ToString();
roomTypeModels.Add(roomType);
}
reader.Close();
dbd.connClose();
}
return(roomTypeModels);
}
public List <RoomModel> odalarDonmeId(int id)
{
List <RoomModel> roomModels = new List <RoomModel>();
using (PGDatabase dbd = new PGDatabase())
{
string command = "select rooms.* , odatype.odaturadi as odaturu from rooms inner join odatype on rooms.odatur = odatype.id where odatype.id = " + id;
NpgsqlDataReader reader = dbd.Reader(command);
while (reader.Read())
{
RoomModel roomModel = new RoomModel();
roomModel.RoomId = Convert.ToInt32(reader["roomid"]);
roomModel.kat = Convert.ToInt32(reader["kat"]);
roomModel.roomNumber = Convert.ToInt32(reader["roomnumber"]);
roomModel.odaTurAdi = (reader["odaturu"]).ToString();
roomModels.Add(roomModel);
}
reader.Close();
dbd.connClose();
}
return(roomModels);
}
public List <Customers> RezervasyonlariGetirIdle(int roomId)
{
List <Customers> customers = new List <Customers>();
string command = "select r_baslama,r_bitis,roomnumber from customers where roomnumber =" + roomId + "";
using (PGDatabase dbd = new PGDatabase())
{
NpgsqlDataReader reader = dbd.Reader(command);
while (reader.Read())
{
Customers customer = new Customers();
customer.roomId = Convert.ToInt32(reader["roomnumber"]);
customer.r_baslama = Convert.ToDateTime(reader["r_baslama"]);
customer.r_bitis = Convert.ToDateTime(reader["r_bitis"]);
customers.Add(customer);
}
reader.Close();
dbd.connClose();
}
return(customers);
}