public PhongInfo RowToInfo(DataRow row)
{
PhongInfo phong = new PhongInfo();
phong.MaPhong = row["MAPHG"].ToString();
phong.TenPhong = row["TENPHG"].ToString();
phong.SoLuongToiDa = Convert.ToInt32(row["SOLUONGTOIDA"].ToString());
phong.PhongNam = Convert.ToBoolean(row["PhongNam"].ToString());
DayInfo day = new DayInfo();
day.MaDay = row["MADAY"].ToString();
day.TenDay = row["TENDAY"].ToString();
phong.Day = day;
TrangThaiPhongInfo trangthai = new TrangThaiPhongInfo();
trangthai.MaTrangThai = Convert.ToInt32(row["MATRANGTHAI"].ToString());
trangthai.TenTrangThai = row["TENTRANGTHAI"].ToString();
phong.TrangThai = trangthai;
return(phong);
}
private void btnKetThuc_Click(object sender, EventArgs e)
{
if (ctrl.KiemTra(txtMa, txtTen))
{
TTPhong = ctrl.ControlToInfo(txtMa, txtTen);
this.DialogResult = DialogResult.OK;
}
}
public TrangThaiPhongInfo ControlToInfo(TextBox txtMa, TextBox txtTen)
{
TrangThaiPhongInfo ttp = new TrangThaiPhongInfo();
ttp.MaTrangThai = Convert.ToInt32(txtMa.Text);
ttp.TenTrangThai = txtTen.Text;
return(ttp);
}
public TrangThaiPhongInfo ListViewItemToInfo(ListViewItem item)
{
TrangThaiPhongInfo ttp = new TrangThaiPhongInfo();
ttp.MaTrangThai = Convert.ToInt32(item.Text);
ttp.TenTrangThai = item.SubItems[1].Text;
return(ttp);
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có muốn xóa không?", "Hoạt Động", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (ctrl.KiemTra(txtMa, txtTen))
{
TrangThaiPhongInfo phong = ctrl.ControlToInfo(txtMa, txtTen);
ctrl.Xoa(phong);
ctrl.LayLenListView(listTrangThaiPhong);
}
}
}
public ListViewItem DataRowToListViewItem(DataRow row)
{
ListViewItem item = new ListViewItem();
item.Text = row["MATRANGTHAI"].ToString();
item.SubItems.Add(row["TENTRANGTHAI"].ToString());
TrangThaiPhongInfo info = ListViewItemToInfo(item);
item.Tag = info;
return(item);
}
public bool Xoa(TrangThaiPhongInfo phong)
{
SqlCommand com = new SqlCommand("Delete TrangThaiPhong where MATRANGTHAI=@ma");
com.Parameters.Add("@ma", SqlDbType.Int).Value = phong.MaTrangThai;
try
{
ser.Load(com);
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
public bool Sua(TrangThaiPhongInfo phong)
{
SqlCommand com = new SqlCommand("Update TrangThaiPhong set TENTRANGTHAI=@ten where MATRANGTHAI=@ma");
com.Parameters.Add("@ma", SqlDbType.Int).Value = phong.MaTrangThai;
com.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = phong.TenTrangThai;
try
{
ser.Load(com);
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
public bool Them(TrangThaiPhongInfo phong)
{
SqlCommand com = new SqlCommand("Insert into TrangThaiPhong(MATRANGTHAI,TENTRANGTHAI) values(@ma,@ten)");
com.Parameters.Add("@ma", SqlDbType.Int).Value = phong.MaTrangThai;
com.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = phong.TenTrangThai;
try
{
ser.Load(com);
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
private void btnLuu_Sua_Click(object sender, EventArgs e)
{
if (ctrl.KiemTra(txtMa, txtTen))
{
TrangThaiPhongInfo phong = ctrl.ControlToInfo(txtMa, txtTen);
ctrl.Sua(phong);
ctrl.LayLenListView(listTrangThaiPhong);
Updating = false;
btnSua.Text = "Sửa";
btnXoa.Enabled = true;
btnThem.Enabled = true;
btnKetThuc.Visible = true;
btnLuu_Them.Visible = false;
btnLuu_Sua.Visible = false;
listTrangThaiPhong.Enabled = true;
txtMa.Enabled = false;
txtTen.Enabled = false;
}
}
public PhongInfo ControlToInfo(TextBox ma, TextBox ten, TextBox Sl, CheckBoxX phgNam, ComboBox day, ComboBox trangthai)
{
PhongInfo phong = new PhongInfo();
phong.MaPhong = ma.Text;
phong.TenPhong = ten.Text;
phong.SoLuongToiDa = Convert.ToInt32(Sl.Text);
phong.PhongNam = phgNam.Checked;
DayInfo d = new DayInfo();
d.MaDay = day.SelectedValue.ToString();
d.TenDay = day.Text;
phong.Day = d;
TrangThaiPhongInfo th = new TrangThaiPhongInfo();
th.MaTrangThai = Convert.ToInt32(trangthai.SelectedValue.ToString());
th.TenTrangThai = trangthai.Text;
phong.TrangThai = th;
return(phong);
}
public bool Sua(TrangThaiPhongInfo phong)
{
return(data.Sua(phong));
}
public bool Them(TrangThaiPhongInfo phong)
{
return(data.Them(phong));
}
