private void SAVE_NEW_AGENT()
 {
     try
     {
         CONNECTION.open_connection();
         using (MySqlCommand da = new MySqlCommand("INSERT INTO agent ( agent_name) VALUES ( @agent_name)", CONNECTION.CON))
         {
             da.Parameters.Clear();
             da.Parameters.AddWithValue("@agent_name", TXT_NEW_AGENT_NAME.Text);
             if (da.ExecuteNonQuery() > 0)
             {
                 string QRY2 = "SELECT agent_id, agent_name FROM agent";
                 CLS_METHODS.FILL_COMBOBOX(CMB_AGENT, QRY2, "agent_name", "agent_id", -1);
                 CMB_AGENT.Text = TXT_NEW_AGENT_NAME.Text;
                 PNL_QUICK_ADD_AGENT.Visible = false;
             }
         }
     }
     catch (Exception ex)
     {
         MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), ex.Message, MessageAlertImage.Error());
         mdg.ShowDialog();
     }
     finally
     {
         CONNECTION.close_connection();
     }
 }
        private void NEW_GUEST_Load(object sender, EventArgs e)
        {
            String QRY = "SELECT id,country_name FROM country";

            CLS_METHODS.FILL_COMBOBOX(CMB_COUNTRY, QRY, "country_name", "id", -1);
            TXT_ID_NUMBER.Focus();
        }
        private void FILL_COMBOBOX()
        {
            string QRY1 = "SELECT supplier_id,supplier_name FROM supplier WHERE STATUS='ENABLE'";
            string QRY3 = "SELECT id,bank_name FROM bank";

            CLS_METHODS.FILL_COMBOBOX(CMB_SUPPLIER, QRY1, "supplier_name", "supplier_id", -1);
            CLS_METHODS.FILL_COMBOBOX(CMB_CHEQUE_BANK, QRY3, "bank_name", "id", -1);
        }
        private void DAILY_MENU_Load(object sender, EventArgs e)
        {
            frm_show = true;
            string query = "SELECT DISTINCT i.item_category,c.caegory_name FROM item i JOIN category c ON i.item_category=c.categry_id WHERE i.item_type_id=1 OR i.item_type_id=2";

            CLS_METHODS.FILL_COMBOBOX(CMB_CATEGORY, query, "caegory_name", "item_category", 0);
            frm_show = false;
        }
        private void CHECKBILL_PRINT_Load(object sender, EventArgs e)
        {
            string QRY3 = "SELECT room_id,room_name FROM room";

            LOAD_RESERVATION_NO();
            CLS_METHODS.FILL_COMBOBOX(CMB_ROOM_NAME, QRY3, "room_name", "room_id", -1);
            DTP_FROM_DATE.Value = DTP_FROM_DATE.Value.AddDays(-7);
        }
Exemplo n.º 6
0
        private void VIEW_STOCK_Load(object sender, EventArgs e)
        {
            LOAD_ALL_ITEMS();
            String QRY1 = "SELECT categry_id, caegory_name FROM category";
            String QRY2 = "SELECT id, TYPE FROM item_type";

            CLS_METHODS.FILL_COMBOBOX(CMB_CATEGORY, QRY1, "caegory_name", "categry_id", -1);
            CLS_METHODS.FILL_COMBOBOX(CMB_ITEM_TYPE, QRY2, "TYPE", "id", -1);
        }
        private void CHECKED_IN_Load(object sender, EventArgs e)
        {
            LOAD_AVAILABLE_ROOMS();
            CMB_TAX.SelectedIndex = 0;
            string QRY2 = "SELECT agent_id, agent_name FROM agent";

            CLS_METHODS.FILL_COMBOBOX(CMB_AGENT, QRY2, "agent_name", "agent_id", -1);
            TXT_NIC_NO.Focus();
            flowLayoutPanel1.Controls.Clear();
        }
        private void BTN_MAKE_NEW_AGENT_Click(object sender, EventArgs e)
        {
            if (PNL_QUICK_ADD_AGENT.Visible == true)
            {
                PNL_QUICK_ADD_AGENT.Visible = false;
            }
            else
            {
                PNL_QUICK_ADD_AGENT.Visible = true;
                PNL_QUICK_ADD_AGENT.Size    = new Size(300, 100);
                TXT_NEW_AGENT_NAME.Focus();
                TXT_NEW_AGENT_NAME.Clear();
            }

            string QRY2 = "SELECT agent_id, agent_name FROM agent";

            CLS_METHODS.FILL_COMBOBOX(CMB_AGENT, QRY2, "agent_name", "agent_id", -1);
        }
 private void SAVE_GUEST()
 {
     try
     {
         CONNECTION.open_connection();
         using (MySqlCommand da = new MySqlCommand("INSERT INTO guest ( guest_id, id_no, first_name, last_name, mobile_no, gender, passport_no, address, email, country_id ) VALUES ( @guest_id, @id_no, @first_name, @last_name, @mobile_no, @gender, @passport_no, @address, @email, @country_id )", CONNECTION.CON))
         {
             da.Parameters.Clear();
             da.Parameters.AddWithValue("@guest_id", CLS_GENERATE_ID.GEN_NEXT_GUEST_NO());
             da.Parameters.AddWithValue("@id_no", TXT_ID_NUMBER.Text);
             da.Parameters.AddWithValue("@first_name", TXT_FNAME.Text);
             da.Parameters.AddWithValue("@last_name", TXT_LNAME.Text);
             da.Parameters.AddWithValue("@mobile_no", TXT_MOBILENO.Text);
             da.Parameters.AddWithValue("@gender", CMB_GENDER.Text);
             da.Parameters.AddWithValue("@passport_no", TXT_PASSPORT.Text);
             da.Parameters.AddWithValue("@address", TXT_ADDRESS.Text);
             da.Parameters.AddWithValue("@email", TXT_EMAIL.Text);
             da.Parameters.AddWithValue("@country_id", CMB_COUNTRY.SelectedValue);
             if (da.ExecuteNonQuery() > 0)
             {
                 LBL_GUEST.Text = CLS_METHODS.GET_MAX_STRING_ID("SELECT MAX(guest_id) FROM guest");
                 MSGBOX mdg = new MSGBOX(MessageAlertHeder.Success(), "GUEST ADDED SUCCESFULLY!", MessageAlertImage.Success());
                 mdg.ShowDialog();
             }
             else
             {
                 MSGBOX mdg = new MSGBOX(MessageAlertHeder.Alert(), "GUEST ADDED FAILED!", MessageAlertImage.Alert());
                 mdg.ShowDialog();
             }
         }
     }
     catch (Exception ex)
     {
         MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), ex.Message, MessageAlertImage.Error());
         mdg.ShowDialog();
     }
     finally
     {
         CONNECTION.close_connection();
     }
 }
        private void SAVE_RESERVATION()
        {
            try
            {
                Cursor.Current = Cursors.WaitCursor;
                LOCK_CONTROLLERS();
                CONNECTION.open_connection();
                myTrans         = CONNECTION.CON.BeginTransaction();
                cmd.Connection  = CONNECTION.CON;
                cmd.Transaction = myTrans;
                string GUESTID        = string.Empty;
                string RES            = CHECK_GUEST_DATA();
                string RESERVATION_ID = CLS_GENERATE_ID.GEN_NEXT_RESERVATION_NO();
                if (RES != "N")
                {
                    GUESTID = RES;
                }
                else
                {
                    GUESTID         = CLS_GENERATE_ID.GEN_NEXT_GUEST_NO();
                    cmd.CommandText = "INSERT INTO guest ( guest_id, id_no, first_name, last_name, mobile_no, gender, passport_no, address, email, country_id ) VALUES ( @guest_id, @id_no, @first_name, @last_name, @mobile_no, @gender, @passport_no, @address, @email, @country_id )";
                    cmd.Parameters.Clear();
                    cmd.Parameters.AddWithValue("@guest_id", GUESTID);
                    cmd.Parameters.AddWithValue("@id_no", TXT_NIC_NO.Text);
                    cmd.Parameters.AddWithValue("@first_name", TXT_F_NAME.Text);
                    cmd.Parameters.AddWithValue("@last_name", TXT_L_NAME.Text);
                    cmd.Parameters.AddWithValue("@mobile_no", TXT_TEL.Text);
                    cmd.Parameters.AddWithValue("@gender", "MALE");
                    cmd.Parameters.AddWithValue("@passport_no", "N/A");
                    cmd.Parameters.AddWithValue("@address", "N/A");
                    cmd.Parameters.AddWithValue("@email", TXT_EMAIL.Text);
                    cmd.Parameters.AddWithValue("@country_id", 199);
                    cmd.ExecuteNonQuery();
                }

                TEMP_GUEST_ID = CLS_METHODS.GET_MAX_STRING_ID("SELECT MAX(guest_id) FROM guest");

                cmd.CommandText = "INSERT INTO reservation ( reservation_id, guest_id, no_of_adult, no_of_child, arrival_date, depature_Date, no_of_nights, reserved_by, agent_id, additional_note,added_date,added_time,added_by,no_of_rooms,tax_status ) VALUES ( @reservation_id, @guest_id, @no_of_adult, @no_of_child, @arrival_date, @depature_Date, @no_of_nights, @reserved_by, @agent_id, @additional_note,@added_date,CURTIME(),@added_by,@no_of_rooms,@tax_status )";
                cmd.Parameters.Clear();
                cmd.Parameters.AddWithValue("@reservation_id", RESERVATION_ID);
                cmd.Parameters.AddWithValue("@guest_id", GUESTID);
                cmd.Parameters.AddWithValue("@no_of_adult", Convert.ToInt16(TXT_ADULT.Text));
                cmd.Parameters.AddWithValue("@no_of_child", Convert.ToInt16(TXT_CHILD.Text));
                cmd.Parameters.AddWithValue("@arrival_date", DTP_ARRIVAL_DATE.Value.ToShortDateString());
                cmd.Parameters.AddWithValue("@depature_Date", DTP_DEPATURE_DATE.Value.ToShortDateString());
                cmd.Parameters.AddWithValue("@no_of_nights", (DTP_DEPATURE_DATE.Value - DTP_ARRIVAL_DATE.Value).TotalDays);
                cmd.Parameters.AddWithValue("@reserved_by", CMB_RESERVE_BY.Text);
                cmd.Parameters.AddWithValue("@no_of_rooms", Convert.ToInt16(TXT_NO_OF_ROOMS.Text));
                if (CMB_TAX.SelectedIndex == 0)
                {
                    cmd.Parameters.AddWithValue("@tax_status", "1");
                }
                else
                {
                    cmd.Parameters.AddWithValue("@tax_status", "0");
                }

                if (CMB_RESERVE_BY.SelectedIndex == 3)
                {
                    cmd.Parameters.AddWithValue("@agent_id", CMB_AGENT.SelectedValue);
                }
                else
                {
                    cmd.Parameters.AddWithValue("@agent_id", "0");
                }

                cmd.Parameters.AddWithValue("@additional_note", TXT_NOTE.Text);
                cmd.Parameters.AddWithValue("@added_date", DateTime.Now.ToShortDateString());
                cmd.Parameters.AddWithValue("@added_by", CLS_CURRENT_LOGGER.LOGGED_IN_USERID);
                cmd.ExecuteNonQuery();

                foreach (ListViewItem lvi in LST_SELECTED_ROOM.Items)
                {
                    cmd.CommandText = "INSERT INTO recerved_rooms ( reservation_no, room_id, room_charge ) VALUES ( @reservation_no, @room_id, @room_charge)";
                    cmd.Parameters.Clear();
                    cmd.Parameters.AddWithValue("@reservation_no", RESERVATION_ID);
                    cmd.Parameters.AddWithValue("@room_id", Convert.ToInt32(lvi.SubItems[0].Text));
                    cmd.Parameters.AddWithValue("@room_charge", Convert.ToDouble(lvi.SubItems[3].Text));
                    cmd.ExecuteNonQuery();

                    cmd.CommandText = "UPDATE room SET current_status=@current_status WHERE room_id=@room_id";
                    cmd.Parameters.Clear();
                    cmd.Parameters.AddWithValue("@room_id", Convert.ToInt32(lvi.SubItems[0].Text));
                    cmd.Parameters.AddWithValue("@current_status", "RESERVED");
                    cmd.ExecuteNonQuery();
                }

                myTrans.Commit();


                LBL_RESERVATION_ID.Text = RESERVATION_ID;
                MSGBOX mdg = new MSGBOX(MessageAlertHeder.Success(), "RESERVATION ADDED SUCCESFULLY" + Environment.NewLine + Environment.NewLine + "RESERVATION NO IS : " + RESERVATION_ID, MessageAlertImage.Success());
                mdg.ShowDialog();
                BTN_NEW.Focus();
            }
            catch (Exception EX)
            {
                Cursor.Current = Cursors.Default;
                UNLOCK_CONTROLLERS();
                myTrans.Rollback();
                MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), EX.Message, MessageAlertImage.Error());
                mdg.ShowDialog();
            }
            finally
            {
                UNLOCK_CONTROLLERS();
                Cursor.Current = Cursors.Default;
                CONNECTION.close_connection();
            }
        }
Exemplo n.º 11
0
 public REQUEST_ADDITIONAL_SERVICES()
 {
     InitializeComponent();
     CLS_METHODS.FILL_COMBOBOX(CMB_SERVICES, "SELECT id,service_name FROM additional_service_list WHERE service_status='1'", "service_name", "id", -1);
 }
Exemplo n.º 12
0
 public ITEMS()
 {
     InitializeComponent();
     CLS_METHODS.FILL_COMBOBOX(CMB_ITEM_TYPE, "SELECT id,type FROM item_type ORDER BY type", "type", "id", -1);
 }