public void MusteriKaydet(string girisGun, string cikisGun, string musteriAd, string musteriSoyad, string ucretToplam, string gunToplam, string odaNumber, string email, string cocukSayisi, string not, bool chckMi)
{
int kayitIDsi = 0;
PGDatabase pgdb = new PGDatabase();
if (chckMi = false)
{
cocukSayisi = "0";
}
using (pgdb)
{
string commandsql = "";
commandsql = ("insert into customers (haschildren,rezervasyoniptal,rezervasyonbitti,ucret,ad,soyad,cocuksayisi,kisiSayisi,roomNumber,r_baslama,r_bitis,kalicakgunsayisi,notlar,email) values("
+ chckMi + ","
+ false + ","
+ false + ","
+ Convert.ToInt32(ucretToplam) + ",'"
+ musteriAd + "','"
+ musteriSoyad + "',"
+ Convert.ToInt32(cocukSayisi) + ","
+ Convert.ToInt32(cocukSayisi) + ","
+ Convert.ToInt32(odaNumber) + ",'"
+ girisGun + "','"
+ cikisGun + "',"
+ Convert.ToInt32(gunToplam) + ",'"
+ not + "','"
+ email +
"')returning id");
string token = pgdb.neSayisi(commandsql);
int.TryParse(token, out kayitIDsi);
pgdb.connClose();
}
}
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 bool RezervasyonIptal(int id)
{
bool success = false;
using (PGDatabase dbd = new PGDatabase())
{
string command = "update customers set rezervasyoniptal = true where id = " + id;
int rowsAffected = dbd.Cmd(command);
if (rowsAffected > 0)
{
success = true;
}
dbd.connClose();
}
return(success);
}
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);
}