private void button1_Click(object sender, EventArgs e)
{
try
{
PhongDTO Phong = listView1.Tag as PhongDTO;
int machiphi = ChiPhiBUS.kiemtrachiphi(Phong.maphong);
DataGridViewRow dgvr = dataGridView1.CurrentRow;
string madv = dgvr.Cells["MaDichVu"].Value.ToString();
int SL = (int)numericUpDown1.Value;
if (machiphi == -1)
{
ChiPhiBUS.ThemVaoChiPhi(Phong.maphong);
PhieuChiTietBUS.UpdateChiTietChiPhi(ChiPhiBUS.MaxChiTiet(), madv, SL);
MessageBox.Show("Thêm Thành Cộng!");
}
else
{
PhieuChiTietBUS.UpdateChiTietChiPhi(machiphi, madv, SL);
MessageBox.Show("Cập Nhật Thành Công!");
}
PhongShow(Phong.maphong);
LoadPhong();
}
catch (Exception ex)
{
MessageBox.Show("Vui lòng chọn phòng trước khi thêm dịch vụ");
}
}
public static bool Them(ChiPhiBUS chiphi, DoanBUS doan)
{
int result = 0;
Connection connection = new Connection();
String query = "insert into ChiPhi (tien,maLoaiChiPhi,maDoan,thoigian) values (@sotien,@maloaichiphi,@madoan,@thoigian)";
using (SqlCommand command = new SqlCommand(query, connection.getConnection()))
{
connection.open();
command.Parameters.AddWithValue("@sotien", chiphi.Tien);
command.Parameters.AddWithValue("@thoigian", chiphi.Thoigian);
command.Parameters.AddWithValue("@maloaichiphi", chiphi.LoaiChiPhi.MaLoaiChiPhi);
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
result = command.ExecuteNonQuery();
connection.close();
}
if (result == 1)
{
using (SqlCommand command = new SqlCommand("select max(maChiPhi) as myid from ChiPhi", connection.getConnection()))
{
connection.open();
var reader = command.ExecuteReader();
reader.Read();
chiphi.MaChiPhi = int.Parse(reader["myid"].ToString());
connection.close();
}
}
return(result == 1);
}
public static List <ChiPhiBUS> getChiPhiByDoan(DoanBUS doan)
{
List <ChiPhiBUS> dsChiPhi = new List <ChiPhiBUS>();
Connection connection = new Connection();
String query = "select * from ChiPhi,LoaiChiPhi where maDoan=@madoan and ChiPhi.maLoaiChiPhi=LoaiChiPhi.maLoaiChiPhi";
using (SqlCommand command = new SqlCommand(query, connection.getConnection()))
{
connection.open();
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
var reader = command.ExecuteReader();
while (reader.Read())
{
ChiPhiBUS chiphi = new ChiPhiBUS();
chiphi.MaChiPhi = int.Parse(reader["maChiPhi"].ToString());
chiphi.Thoigian = DateTime.Parse(reader["thoigian"].ToString());
chiphi.Tien = long.Parse(reader["tien"].ToString());
chiphi.LoaiChiPhi.MaLoaiChiPhi = reader["maLoaiChiPhi"].ToString();
chiphi.LoaiChiPhi.TenLoaiChiPhi = reader["tenLoaiChiPhi"].ToString();
dsChiPhi.Add(chiphi);
}
connection.close();
}
return(dsChiPhi);
}
private void bnThanhToán_Click(object sender, EventArgs e)
{
PhongDTO Phong = listView1.Tag as PhongDTO;
int machiphi = ChiPhiBUS.kiemtrachiphi(Phong.maphong);
if (machiphi != 1)
{
ChiPhiBUS.TinhTien(machiphi);
PhongShow(Phong.maphong);
LoadPhong();
MessageBox.Show("Thanh Toán Thành Công");
}
}
public static bool Xoa(ChiPhiBUS chiphi)
{
int result = 0;
Connection connection = new Connection();
String query = "delete ChiPhi where maChiphi=@machiphi";
using (SqlCommand command = new SqlCommand(query, connection.getConnection()))
{
connection.open();
command.Parameters.AddWithValue("@machiphi", chiphi.MaChiPhi);
result = command.ExecuteNonQuery();
connection.close();
}
return(result == 1);
}
public void PhongShow(string maphong)
{
listView1.Items.Clear();
PhongDTO Phong = listView1.Tag as PhongDTO;
int machiphi = ChiPhiBUS.kiemtrachiphi(Phong.maphong);
float tong = 0;
List <PhieuChiTietDTO> show = PhieuChiTietBUS.CPP(maphong, machiphi);
foreach (PhieuChiTietDTO item in show)
{
ListViewItem lsvItem = new ListViewItem(item.madv.ToString());
lsvItem.SubItems.Add(item.TenDichVu.ToString());
lsvItem.SubItems.Add(item.dongia.ToString());
lsvItem.SubItems.Add(item.soluong.ToString());
lsvItem.SubItems.Add(item.TongTien.ToString());
tong += item.TongTien;
listView1.Items.Add(lsvItem);
}
tbTongTien.Text = tong.ToString();
}
public static bool Sua(ChiPhiBUS chiphi)
{
int result = 0;
Connection connection = new Connection();
String query = "update ChiPhi set tien=@sotien,thoigian=@thoigian,maLoaiChiPhi=@maloaichiphi where maChiphi=@machiphi";
using (SqlCommand command = new SqlCommand(query, connection.getConnection()))
{
connection.open();
command.Parameters.AddWithValue("@machiphi", chiphi.MaChiPhi);
command.Parameters.AddWithValue("@sotien", chiphi.Tien);
command.Parameters.AddWithValue("@thoigian", chiphi.Thoigian);
command.Parameters.AddWithValue("@maloaichiphi", chiphi.LoaiChiPhi.MaLoaiChiPhi);
result = command.ExecuteNonQuery();
connection.close();
}
return(result == 1);
}
