public decimal GetMoneyById(int rezCesitId)
{
//cnn = new SqlConnection(@"server=DESKTOP-UGHD8MH; database=OtelRezervasyon; Integrated Security = true");
cnn = new SqlConnection("server=.;database=OtelRezervasyon;Integrated Security = true");
cmd = new SqlCommand("Select Fiyat from RezervasyonCesidi where RezervasyonCesidiID=@rcid", cnn);
cmd.Parameters.AddWithValue("@rcid", rezCesitId);
RezervasyonCesidi rezCesit = new RezervasyonCesidi();
try
{
cnn.Open();
SqlDataReader rd = cmd.ExecuteReader();
rd.Read();
rezCesit.Fiyat = (decimal)rd["Fiyat"];
return(rezCesit.Fiyat);
}
catch (Exception)
{
throw;
}
finally
{
cnn.Close();
}
}
public int AddRezervasyonCesit(RezervasyonCesidi rezervasyonCesidi)
{
cmd = new SqlCommand("insert into RezervasyonCesidi (CesitAd,Fiyat,Aciklama) values (@CesitAd,@Fiyat,@Aciklama)", cnn);
cmd.Parameters.AddWithValue("@CesitAD", rezervasyonCesidi.CesitAd);
cmd.Parameters.AddWithValue("@Fiyat", rezervasyonCesidi.Fiyat);
cmd.Parameters.AddWithValue("@Aciklama", rezervasyonCesidi.Aciklama);
return(ExecuteCommand());
}
public frmRezCesidineGoreList()
{
InitializeComponent();
OdaCesidiBLL = new OdaCesidiBLL();
RC = new RezervasyonCesidi();
RCBLL = new RezervasyonCesidiBLL();
OdaCesidiBLL = new OdaCesidiBLL();
yoneticiBLL = new YoneticiBLL();
rez = new Rezervasyon();
var skinManager = MaterialSkinManager.Instance;
skinManager.AddFormToManage(this);
skinManager.Theme = MaterialSkinManager.Themes.LIGHT;
skinManager.ColorScheme = new ColorScheme(Primary.Green900, Primary.Green300, Primary.BlueGrey500, Accent.Yellow400, TextShade.BLACK);
}
public Rezervasyon()
{
InitializeComponent();
var skinManager = MaterialSkinManager.Instance;
skinManager.AddFormToManage(this);
skinManager.Theme = MaterialSkinManager.Themes.LIGHT;
skinManager.ColorScheme = new ColorScheme(Primary.Green900, Primary.Green300, Primary.BlueGrey500, Accent.Yellow400, TextShade.BLACK);
RCBLL = new RezervasyonCesidiBLL();
RC = new RezervasyonCesidi();
OBLL = new OdaCesidiBLL();
OVCBLL = new OdaVeOdaCesidiBLL();
_musteriRezervasyonBLL = new MusteriRezervasyonBLL();
_totalBLL = new TotalBLL();
_rezervasyonBLL = new RezervasyonBLL();
}
private void Button1_Click_1(object sender, EventArgs e)
{
RezervasyonCesidi RC = new RezervasyonCesidi();
RC.CesitAd = txtAd.Text;
RC.Fiyat = int.Parse(txtFiyat.Text);
RC.Aciklama = txtAciklama.Text;
if (RCBLL.Add(RC))
{
this.Hide();
MessageBox.Show("Rezervasyon Çeşidi Başarıyla Eklendi");
frmRezCesidineGoreList frmRezCesidineGoreList = new frmRezCesidineGoreList();
frmRezCesidineGoreList.FormClosing += FrmRezCesidineGoreList_FormClosing;;
frmRezCesidineGoreList.ShowDialog();
}
}
public RezervasyonCesidi RezervasyonCesidiGosterID(int RezervasyonCesidiID)
{
cmd = new SqlCommand("Select * from RezervasyonCesidi where RezervasyonCesidiID=@RCID", cnn);
cmd.Parameters.AddWithValue("@RCID", RezervasyonCesidiID);
RezervasyonCesidi rc = null;
try
{
cnn.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
rc = new RezervasyonCesidi()
{
RezervasyonCesidiID = (int)reader["RezervasyonCesidiID"],
CesitAd = reader["CesitAd"].ToString(),
Aciklama = reader["Aciklama"].ToString(),
Fiyat = (int)reader["Fiyat"]
};
reader.Close();
return(rc);
}
catch (Exception)
{
return(rc);
}
finally
{
cnn.Close();
}
}
public bool Add(RezervasyonCesidi rezervasyonCesidi)
{
int result = RCD.AddRezervasyonCesit(rezervasyonCesidi);
return(result > 0);
}
