private void UserControl1_Click(object sender, EventArgs e) { //lay so luong phong dataPhong_LinQDataContext data_phongtro = new dataPhong_LinQDataContext(); var phong = (from p in data_phongtro.PHONGTROs select p).Count(); int slphong = phong; taoControldong(slphong); }
public UserControl1() { InitializeComponent(); //lay so luong phong dataPhong_LinQDataContext data_phongtro = new dataPhong_LinQDataContext(); var phong = (from p in data_phongtro.PHONGTROs select p).Count(); int slphong = phong; taoControldong(slphong); }
private void button1_Click(object sender, EventArgs e) { dataPhong_LinQDataContext dataphong = new dataPhong_LinQDataContext(); var so_phong = (from p in dataphong.PHONGTROs where p.MaPT == maPTTextEdit.Text select p).Count(); if (so_phong != 0) { MessageBox.Show("Đã tồn tại mã phòng !!!"); } else { this.tableAdapterManager.PHONGTROTableAdapter.Insert(maPTTextEdit.Text, kHUVUCComboBox.SelectedValue.ToString().Trim(), bangGiaTien_DKComboBox.SelectedValue.ToString().Trim(), tenPhongTextEdit.Text, int.Parse(sLToiDaSpinEdit.Text), true, false, 0); this.pHONGTROTableAdapter.Fill(this.dataSet_phong.PHONGTRO); MessageBox.Show("Thêm Thành Công!!!"); } }
public string kt_trangthaithue(int sophong) { dataPhong_LinQDataContext dataphong = new dataPhong_LinQDataContext(); if (sophong <= 9) { var tt_phong = from p in dataphong.PHONGTROs where p.MaPT == "PT00" + sophong select new { p.TrangThaiThue }; foreach (var TT in tt_phong) { string x = TT.TrangThaiThue.ToString(); return x; } return ""; } else { var tt_phong = from p in dataphong.PHONGTROs where p.MaPT == "PT0" + sophong select new { p.TrangThaiThue }; foreach (var TT in tt_phong) { string x = TT.TrangThaiThue.ToString(); return x; } return ""; } }