Beispiel #1
0
        public RoomChangeForm(int _id, MainForm _owner)
        {
            id = _id;
            InitializeComponent();
            owner = _owner;
            if (id != 0)
            {
                ConectionDB.Connection("select type_id, price, type_of_number.type from type_of_number ", cmType);
                cmType.Text         = ConectionDB.ReturnResultLikeString(String.Format("select type_of_number.type from type_of_number where type_id = (select type_id from hotel_room where room_id = {0})", id));
                tbNum.Text          = ConectionDB.ReturnResultLikeString(String.Format("select number_of_room from hotel_room where room_id = {0}", id));
                nudSleepPoint.Value = Convert.ToInt32(ConectionDB.ReturnResultLikeString(String.Format("select amount_of_sleeppoint from hotel_room where room_id = {0}", id)));
                nupFloor.Value      = Convert.ToInt32(ConectionDB.ReturnResultLikeString(String.Format("select floor_of_room from hotel_room where room_id = {0}", id)));
                ConectionDB.ConnectionSecondCMB("select name_type from type_of_bed", cbBed);
                cmType.Text = ConectionDB.ReturnResultLikeString(String.Format("select name_type from type_of_bed where type_id = (select type_of_bed_id from hotel_room where room_id = {0})", id));
            }
            string    appPath = Path.GetDirectoryName(Application.ExecutablePath) + @"\Images\";
            DataTable result  = ConectionDB.ReturnResult(String.Format("select images_path from rooms_images where rooms_id={0}", id));
            int       y       = result.Rows.Count;

            foreach (DataRow item in result.Rows)
            {
                listOfStr.Add(item[0].ToString());
                PictureBox pb = new PictureBox();
                pb.Name     = count.ToString();
                pb.SizeMode = PictureBoxSizeMode.Zoom;
                pb.Image    = new Bitmap(appPath + listOfStr.Last());
                flpPhotos.Controls.Add(pb);
                globalPBList.Add(pb);
                pb.Click += new EventHandler(pb_Click);
                count++;
            }
        }
Beispiel #2
0
        public void FillField(int id)
        {
            tbClient.Text = ConectionDB.ReturnResultLikeString(String.Format("select surname from clients where clients_id = (select clients_id from final_bill where final_bill_id = {0})", id))  + " " + ConectionDB.ReturnResultLikeString(String.Format("select first_name from clients where clients_id = (select clients_id from final_bill where final_bill_id = {0})", id));
            tbDays.Text = ConectionDB.ReturnResultLikeString(String.Format("select number_of_days from final_bill where final_bill_id = {0}", id));
            tbRoom.Text = ConectionDB.ReturnResultLikeString(String.Format("select number_of_room from hotel_room where room_id = (select room_id from final_bill where final_bill_id = {0})", id));
            tbSum.Text = ConectionDB.ReturnResultLikeString(String.Format("select final_summa from final_bill where final_bill_id = {0}", id));
            if (Convert.ToInt32((ConectionDB.ReturnResultLikeString(String.Format("select count(*) from bill where main_bill_id = {0}", id)))) > 0)
            {
                DataTable result = ConectionDB.ReturnResult(String.Format("select bill_id from bill where main_bill_id={0}", id));

                foreach (DataRow item in result.Rows)
                {
                    flpServces.Controls.Add(new AddServices(Convert.ToInt32(item[0]), false));
                }
            }
        }
        private void ShowImages()
        {
            string        appPath   = Path.GetDirectoryName(Application.ExecutablePath) + @"\Images\";
            List <string> listOfStr = new List <string>();
            DataTable     result    = ConectionDB.ReturnResult(String.Format("select images_path from rooms_images where rooms_id={0}", id));
            int           y         = result.Rows.Count;

            foreach (DataRow item in result.Rows)
            {
                listOfStr.Add(item[0].ToString());
                PictureBox pb = new PictureBox();
                pb.SizeMode = PictureBoxSizeMode.Zoom;
                pb.Image    = new Bitmap(appPath + listOfStr.Last());
                flpPicturesBox.Controls.Add(pb);
                pb.Click += new EventHandler(pb_Click);
            }
        }
Beispiel #4
0
        private void cbNumber_SelectedValueChanged(object sender, EventArgs e)
        {
            ClearCheckedItems();
            if (!isFirstSelection)
            {
                List <string> ds     = new List <string>();
                DataTable     result = ConectionDB.ReturnResult("select name_services from list_of_free_services where service_id in (select service_id from rooms_services where id in (select id from rooms_services where room_id = (select room_id from hotel_room where number_of_room = '" + cbNumber.Text + "')))");
                int           y      = result.Rows.Count;
                foreach (DataRow item in result.Rows)
                {
                    ds.Add(item[0].ToString());

                    if (listOfString.Contains(ds.Last()))
                    {
                        clbFreeServices.SetItemChecked(listOfString.IndexOf(ds.Last()), true);
                    }
                }
                isFirstSelection = false;
            }
            else
            {
                isFirstSelection = false;
            }
        }
Beispiel #5
0
        private void btChange_Click(object sender, EventArgs e)
        {
            ConectionDB.Connection("Delete from rooms_services where room_id = (select room_id from hotel_room where number_of_room = '" + cbNumber.Text + "');");

            for (int i = 0; i < clbFreeServices.Items.Count; i++)
            {
                if (clbFreeServices.GetItemChecked(i))
                {
                    ConectionDB.Connection("Insert into rooms_services (room_id, service_id) values (" + ConectionDB.ReturnResult("select room_id from hotel_room where number_of_room = '" + cbNumber.Text + "';").Rows[0]["room_id"].ToString() + ", " + (i + 1) + ")");
                }
            }
        }