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();
}
}