public bool SimpanKamar(Tarif_Kamar T)
{
DBConnect db = new DBConnect();
MySqlConnection conn = new MySqlConnection(db.connectionString());
MySqlCommand cmd;
conn.Open();
try
{
cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO `tarif_season`(`TGL_MULAI`, `TGL_SELESAI`, `ID_SEASON`, `HARGA_KAMAR`) VALUES ( @tgl_mulai, @tgl_selesai, @id_season, @harga_kamar)";
cmd.Parameters.AddWithValue("@tgl_mulai", T.Tgl_mulai);
cmd.Parameters.AddWithValue("@tgl_selesai", T.Tgl_selesai);
cmd.Parameters.AddWithValue("@id_season", T.Id_season);
//cmd.Parameters.AddWithValue("@id_detil_kamar", T.Id_detil_kamar);
cmd.Parameters.AddWithValue("@harga_kamar", T.Harga_kamar);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
public bool editKamar(Tarif_Kamar T, int id)
{
DBConnect db = new DBConnect();
MySqlConnection conn = new MySqlConnection(db.connectionString());
MySqlCommand cmd;
conn.Open();
try
{
cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE `tarif_season` SET `TGL_MULAI` = @tgl_mulai, `TGL_SELESAI` = @tgl_selesai, `ID_SEASON` = @id_season, `HARGA_KAMAR` = @harga_kamar WHERE ID_TARIF_SEASON = @id";
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@tgl_mulai", T.Tgl_mulai);
cmd.Parameters.AddWithValue("@tgl_selesai", T.Tgl_selesai);
cmd.Parameters.AddWithValue("@id_season", T.Id_season);
//cmd.Parameters.AddWithValue("@id_detil_kamar", T.Id_detil_kamar);
cmd.Parameters.AddWithValue("@harga_kamar", T.Harga_kamar);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
private void btnSimpan_Click(object sender, EventArgs e)
{
try
{
if (txtHargaKamar.Text.Length > 0 && cmbSeason.Text.Length > 0 && dateTimePicker1.Text.Length > 0 && dateTimePicker2.Text.Length > 0)
{
string message = string.Empty;
string id = tempId.Text;
//getId_kamar(cmbNamaKamar.Items.ToString());
getId_season(cmbSeason.Items.ToString());
string id_season = tempIdSeason.Text;
//string id_detilKamar = tempIdDetilKamar.Text;
DateTime tgl_mulai = DateTime.Parse(dateTimePicker1.Text);
DateTime tgl_selesai = DateTime.Parse(dateTimePicker2.Text);
string harga_kamar = txtHargaKamar.Text;
Tarif_Kamar T = new Tarif_Kamar(tgl_mulai, tgl_selesai, int.Parse(id_season), double.Parse(harga_kamar));
if (id.Length > 0 && btnSimpan.Text.ToLower() == "perbarui")
{
if (TKC.EditKamar(T, int.Parse(id)))
{
message = "Edit data sukses";
}
clearData();
enableButton(false);
enableText(false);
btnTambah.Enabled = true;
btnSimpan.Text = "Simpan";
}
else
{
if (TKC.SimpanTarifKamar(T))
{
message = "Input data sukses";
}
clearData();
enableButton(false);
enableText(false);
btnTambah.Enabled = true;
}
MessageBox.Show(message, "INFORMASI", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshGridView();
}
else
{
MessageBox.Show("Tidak boleh kosong", "PERINGATAN", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
//throw;
Console.WriteLine(ex.Message);
}
}
//edit data
public bool EditKamar(Tarif_Kamar T, int id)
{
return(TKD.editKamar(T, id));
}
//input data
public bool SimpanTarifKamar(Tarif_Kamar T)
{
return(TKD.SimpanKamar(T));
}
