private void btnJoinRoom_Click(object sender, EventArgs e) { ResortManagerDTO.DTO.DbAck ack = new ResortManagerDTO.DTO.DbAck(); String strIdRoom = cmbRoom.SelectedItem.ToString().Split('-')[0]; ResortManagerDTO.DTO.CTGiaoDich ctgd = new ResortManagerDTO.DTO.CTGiaoDich(); for (int i = 0; i < dgvLst.Rows.Count; i++) { ctgd.CMND = dgvLst.Rows[i].Cells[0].Value.ToString().Trim(); ctgd.MADOAN = this.MaDoan; ctgd.MAPHONG = strIdRoom; ack = ResortManagerBUS.BUS.CTGiaoDich.ThemCTGD(ctgd); if (ack != ResortManagerDTO.DTO.DbAck.Ok) { MessageBox.Show("Thêm CTGD thất bại"); return; } String MaCTGD = ResortManagerBUS.BUS.CTGiaoDich.LayMaCTDG(out ack, ctgd.CMND); ack = ResortManagerBUS.BUS.PhieuTra.ThemPhieuTra(MaCTGD); if (ack != ResortManagerDTO.DTO.DbAck.Ok) { MessageBox.Show("Thêm PHIEUTRA thất bại"); return; } } txtCMND_TV1.Text = ""; dgvLst.Rows.Clear(); cmbRoom.Items.Remove(cmbRoom.SelectedItem); cmbRoom.SelectedIndex = -1; }
public static ResortManagerDTO.DTO.DbAck ErrThemChiTietGiaoDich(ResortManagerDTO.DTO.CTGiaoDich ctgd) { Provider provider = new Provider(); ResortManagerDTO.DTO.DbAck result = provider.Connect(); if (result == ResortManagerDTO.DTO.DbAck.NetworkError) { goto Network; // net nhu la networkerror thi nhay den lable network } SqlParameter[] para = new SqlParameter[] { new SqlParameter("@cmnd", ctgd.CMND), new SqlParameter("@maDoan", ctgd.MADOAN), new SqlParameter("@maPhong", ctgd.MAPHONG) }; result = provider.ExcuteNonQuery(CommandType.StoredProcedure, "usp_ErrThemChiTietGiaoDich", para); provider.Disconnect(); //lable network Network: return(result); }
public static List <ResortManagerDTO.DTO.CTGiaoDich> SelectByIdRoom(out ResortManagerDTO.DTO.DbAck ack, String IdRoom) { Provider provider = new Provider(); ack = provider.Connect(); if (ack == ResortManagerDTO.DTO.DbAck.NetworkError) { return(null); } DataTable dt = new DataTable(); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@maphong", IdRoom) }; dt = provider.Select(CommandType.StoredProcedure, "usp_LayCTGDtheoMaPhong", out ack, para); List <ResortManagerDTO.DTO.CTGiaoDich> lstItem = new List <ResortManagerDTO.DTO.CTGiaoDich>(); if (dt == null) { return(null); } foreach (DataRow row in dt.Rows) { ResortManagerDTO.DTO.CTGiaoDich item = new ResortManagerDTO.DTO.CTGiaoDich(); item.MACHITIET = int.Parse(row["MACHITIET"].ToString()); item.HOTEN = (row["HOTEN"].ToString()); item.CMND = (row["CMND"].ToString()); item.GIA = int.Parse(row["GIA"].ToString()); item.MADOAN = (row["MADOAN"].ToString()); item.MAPHONG = (row["MAPHONG"].ToString()); lstItem.Add(item); } provider.Disconnect(); return(lstItem); }
public static ResortManagerDTO.DTO.DbAck ErrThemChiTietGiaoDich(ResortManagerDTO.DTO.CTGiaoDich ctgd) { return(ResortManagerDAO.DAO.CTGiaoDich.ErrThemChiTietGiaoDich(ctgd)); }
public static ResortManagerDTO.DTO.DbAck ThemCTGD(ResortManagerDTO.DTO.CTGiaoDich ctgd) { return(ResortManagerDAO.DAO.CTGiaoDich.ThemCTGD(ctgd)); }