private void okbutton_Click(object sender, EventArgs e) { CSVC_DTO obj = new CSVC_DTO(); if (maptext.Text != "") { obj.MaPhong = Convert.ToInt32(maptext.Text); } obj.TenPhong = tenptext.Text; obj.Tang = Convert.ToInt32(tangbox.SelectedItem); obj.MaLoaiPhong = Convert.ToInt32(loaipbox.SelectedValue); if (radio1.Checked == true) { obj.TrangThai = true; } else { obj.TrangThai = false; } obj.NgaySuDung = ngaypicker.Value; if (OKclick != null) { OKclick.Invoke(obj); } this.Close(); }
public CSVC_DTO GetF_DAL(int id) { CSVC_DTO s = new CSVC_DTO(); string query = "select * from dbo.CSVC where MaPhong = " + id.ToString(); DataTable dt = helpF.GetTable(query); s = GetF_DAL(dt.Rows[0]); return(s); }
private void AddCSVC(CSVC_DTO obj) { //CSVC_DTO i = new CSVC_DTO(); //i.TenPhong = obj.TenPhong; //i.Tang = obj.Tang; //i.MaLoaiPhong = obj.MaLoaiPhong; //i.TrangThai = obj.TrangThai; //i.NgaySuDung = obj.NgaySuDung; blf.AddF_BLL(obj); ShowData(blf.GetListF_BLL()); }
public CSVC_DTO GetF_DAL(DataRow d) { CSVC_DTO s = new CSVC_DTO(); s.MaPhong = Convert.ToInt32(d["MaPhong"]); s.TenPhong = d["TenPhong"].ToString(); s.Tang = Convert.ToInt32(d["Tang"]); s.MaLoaiPhong = Convert.ToInt32(d["MaLoaiPhong"]); s.TrangThai = Convert.ToBoolean(d["TrangThai"]); s.NgaySuDung = Convert.ToDateTime(d["NgaySuDung"]); return(s); }
public void AddF_DAL(CSVC_DTO i) { string query = "insert into dbo.CSVC values (@tenp,@tang,@malp,@tthai,@nsd)"; SqlCommand cmd = new SqlCommand(query, helpF.data); cmd.Parameters.AddWithValue("@tenp", i.TenPhong); cmd.Parameters.AddWithValue("@tang", i.Tang); cmd.Parameters.AddWithValue("@malp", i.MaLoaiPhong); cmd.Parameters.AddWithValue("@tthai", i.TrangThai); cmd.Parameters.AddWithValue("@nsd", i.NgaySuDung); helpF.ExcuteDB(cmd); }
public void UpdateF_DAL(CSVC_DTO i) { string query = "update dbo.CSVC set TenPhong=@tenp,Tang=@tang,MaLoaiPhong=@malp,TrangThai=@tthai,NgaySuDung=@nsd where MaPhong=@map"; SqlCommand cmd = new SqlCommand(query, helpF.data); cmd.Parameters.AddWithValue("@map", i.MaPhong); cmd.Parameters.AddWithValue("@tenp", i.TenPhong); cmd.Parameters.AddWithValue("@tang", i.Tang); cmd.Parameters.AddWithValue("@malp", i.MaLoaiPhong); cmd.Parameters.AddWithValue("@tthai", i.TrangThai); cmd.Parameters.AddWithValue("@nsd", i.NgaySuDung); helpF.ExcuteDB(cmd); }
public void Show(int id) { CSVC_DTO room = blf.GetF_BLL(id); maptext.Text = room.MaPhong.ToString(); tenptext.Text = room.TenPhong.ToString(); tangbox.SelectedItem = tangbox.Items[tangbox.Items.IndexOf(room.Tang.ToString())]; loaipbox.SelectedValue = room.MaLoaiPhong; if (room.TrangThai == true) { radio1.Checked = true; } else { radio2.Checked = true; } ngaypicker.Value = room.NgaySuDung; }
public void UpdateF_BLL(CSVC_DTO i) { daf.UpdateF_DAL(i); }
public void AddF_BLL(CSVC_DTO i) { daf.AddF_DAL(i); }
private void UpdateCSVC(CSVC_DTO obj) { blf.UpdateF_BLL(obj); ShowData(blf.GetListF_BLL()); }