コード例 #1
0
        public static bool InsertRoomLease(RoomLeaseDTO lease)
        {
            try
            {
                if (connection.State != ConnectionState.Open)
                {
                    connection.Open();
                }

                var command = new SqlCommand("ThemPhieuThuePhong", connection);
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.Add(new SqlParameter("@MaPhong", lease.RoomID));
                command.Parameters.Add(new SqlParameter("@NgayThue", lease.LeaseDate));
                command.Parameters.Add(new SqlParameter("@LoaiPhong", lease.RoomTypeID));
                command.Parameters.Add(new SqlParameter("@DonGia", lease.RoomPrice));
                command.ExecuteNonQuery();
                return(true);
            }
            catch (SqlException)
            {
                return(false);
            }
            finally
            {
                connection.Close();
            }
        }
コード例 #2
0
ファイル: RoomLeaseForm.cs プロジェクト: nhidh99/uitSQL
        private void BtnCreate_Click(object sender, EventArgs e)
        {
            var lease = new RoomLeaseDTO();

            lease.RoomID     = this.tbRoomID.Text;
            lease.RoomTypeID = this.tbRoomType.Text;
            lease.RoomPrice  = Int64.Parse(this.tbRoomPrice.Text.Split()[0].Replace(",", ""));
            lease.LeaseDate  = DateTime.ParseExact(tbRoomDate.Text, "d/M/yyyy", CultureInfo.InvariantCulture).ToString("d");

            if (RoomLeaseBUS.InsertRoomLease(lease))
            {
                RoomLeaseDetailDTO detail = new RoomLeaseDetailDTO();
                detail.LeaseID = RoomLeaseBUS.GetLastLeaseIDOfRoom(lease.RoomID);

                foreach (DataGridViewRow row in dgvCustomerData.Rows)
                {
                    detail.CustomerName       = row.Cells["CustomerName"].Value.ToString();
                    detail.CustomerPassportID = row.Cells["CustomerPassportID"].Value.ToString();
                    detail.CustomerTypeID     = Convert.ToInt32(row.Cells["CustomerTypeID"].Value);
                    detail.CustomerAddress    = row.Cells["CustomerAddress"].Value.ToString();
                    RoomLeaseDetailBUS.InsertDetail(detail);
                }

                MainForm mainForm = (MainForm)Owner;
                mainForm.ReLoadAvailableRoom();
                mainForm.ReLoadRoomData();
                mainForm.ReCreateLease();

                MessageBox.Show("Lập phiếu thuê phòng " + lease.RoomID + " thành công!", "LẬP PHIẾU THUÊ PHÒNG THÀNH CÔNG",
                                MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            this.Close();
        }
コード例 #3
0
        public RoomLeaseDTO GetRoomLease()
        {
            var lease = new RoomLeaseDTO();

            lease.RoomID     = cbLeaseRoomID.Text;
            lease.RoomTypeID = RoomTypeBUS.GetRoomTypeByID(lease.RoomID);
            lease.LeaseDate  = DateTime.ParseExact(deLeaseRoomDate.Text, "d/M/yyyy", CultureInfo.InvariantCulture).ToString("d");
            lease.RoomPrice  = Convert.ToInt64(tbLeaseRoomPrice.Text.Split()[0].Replace(",", ""));
            return(lease);
        }
コード例 #4
0
 public static bool InsertRoomLease(RoomLeaseDTO lease)
 {
     return(RoomLeaseDAO.InsertRoomLease(lease));
 }