Esempio n. 1
0
 public static void FILL_COMBOBOX(hyflexComboBox CMB_CATEGORY, string QRY, string DisplayMember, string ValueMember, int SelectedIndex)
 {
     try
     {
         CONNECTION.open_connection();
         using (MySqlDataAdapter DA = new MySqlDataAdapter(QRY, CONNECTION.CON))
         {
             DataTable DT = new DataTable();
             DA.Fill(DT);
             if (DT.Rows.Count > 0)
             {
                 CMB_CATEGORY.DataSource    = DT;
                 CMB_CATEGORY.DisplayMember = DisplayMember;
                 CMB_CATEGORY.ValueMember   = ValueMember;
                 CMB_CATEGORY.SelectedIndex = SelectedIndex;
             }
             else
             {
                 CMB_CATEGORY.DataSource = null;
             }
         }
     }
     catch (Exception EX)
     {
         MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), EX.Message, MessageAlertImage.Error());
         mdg.ShowDialog();
     }
 }
 public static void LOAD_CATEGORY(hyflexComboBox CMB_CATEGORY)
 {
     try
     {
         CONNECTION.open_connection();
         using (MySqlDataAdapter DA = new MySqlDataAdapter("SELECT categry_id,caegory_name FROM category", CONNECTION.CON))
         {
             DataTable DT = new DataTable();
             DA.Fill(DT);
             if (DT.Rows.Count > 0)
             {
                 CMB_CATEGORY.DataSource    = DT;
                 CMB_CATEGORY.DisplayMember = "caegory_name";
                 CMB_CATEGORY.ValueMember   = "categry_id";
                 CMB_CATEGORY.SelectedIndex = -1;
             }
             else
             {
                 CMB_CATEGORY.DataSource = null;
             }
         }
     }
     catch (Exception EX)
     {
         MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), EX.Message, MessageAlertImage.Error());
         mdg.ShowDialog();
     }
 }
Esempio n. 3
0
 public static string GetServer()
 {
     try
     {
         string       serverip = Application.StartupPath + "\\config.ini";
         string       ip;
         StreamReader oReader = new StreamReader(serverip);
         ip = null;
         if (File.Exists(serverip))
         {
             ip = oReader.ReadToEnd();
             oReader.Close();
         }
         else
         {
             MSGBOX mdg = new MSGBOX(MessageAlertHeder.Warning(), "invalied ip address", MessageAlertImage.Warning());
             mdg.ShowDialog();
             Application.Exit();
         }
         return(ip);
     }
     catch (Exception EX)
     {
         return(EX.Message);
     }
 }
Esempio n. 4
0
 public void MessageBox_Action(string szMsg, string szTitle, MSGBOX nType, string szAction)
 {
     m_szMessageBox_Type   = (uint)nType;
     m_szMessageBox_Msg    = szMsg;
     m_szMessageBox_Title  = szTitle;
     m_szMessageBox_Action = szAction;
 }
Esempio n. 5
0
        private void rpt_customers_details_Load(object sender, EventArgs e)
        {
            try
            {
                String         RES_NO = REPORT.RESERVATION_NO;
                ReportDocument cryRpt = new ReportDocument();
                cryRpt.Load(Application.StartupPath + "\\reports\\RECEIPT.rpt");
                ParameterFieldDefinitions crParameterFieldDefinitions;
                ParameterFieldDefinition  crParameterFieldDefinition;
                ParameterValues           crParameterValues        = new ParameterValues();
                ParameterDiscreteValue    crParameterDiscreteValue = new ParameterDiscreteValue();

                crParameterFieldDefinitions    = cryRpt.DataDefinition.ParameterFields;
                crParameterDiscreteValue.Value = RES_NO;
                crParameterFieldDefinition     = crParameterFieldDefinitions["RESERVATION_NO"];
                crParameterValues = crParameterFieldDefinition.CurrentValues;
                crParameterValues.Clear();
                crParameterValues.Add(crParameterDiscreteValue);
                crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

                crystalReportViewer1.ReportSource = cryRpt;
                crystalReportViewer1.Refresh();
            }
            catch (Exception EX)
            {
                MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), EX.Message, MessageAlertImage.Error());
                mdg.ShowDialog();
            }
        }
        private async Task ImportAsync()
        {
            string res = string.Empty;

            loadingCircle1.Visible = true;
            loadingCircle1.Size    = new Size(75, 75);
            loadingCircle1.Active  = true;
            btn_login.Enabled      = false;
            await Task.Run(() => {
                res = login();
            });

            loadingCircle1.Active  = false;
            loadingCircle1.Visible = false;
            loadingCircle1.Size    = new Size(1, 1);
            btn_login.Enabled      = true;
            if (res == "1")
            {
                UPDATE_LOGIN();
                DASHBOARD d = new DASHBOARD();
                d.Show();
                this.Hide();
            }
            else if (res == "0")
            {
                MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), "username or password invalied!", MessageAlertImage.Error());
                mdg.ShowDialog();
            }
            else
            {
                MSGBOX mdg = new MSGBOX(MessageAlertHeder.Alert(), login(), MessageAlertImage.Alert());
                mdg.ShowDialog();
            }
        }
Esempio n. 7
0
 private void LOADCATEGORYlIST_SEARCH_BY_NAME(TextBox txt_cat_name)
 {
     try
     {
         CONNECTION.open_connection();
         using (MySqlDataAdapter DA = new MySqlDataAdapter("SELECT categry_id,caegory_name FROM category where caegory_name LIKE @caegory_name", CONNECTION.CON))
         {
             DA.SelectCommand.Parameters.Clear();
             DA.SelectCommand.Parameters.AddWithValue("@caegory_name", "%" + txt_category_name.Text + "%");
             DataTable DT = new DataTable();
             DA.Fill(DT);
             if (DT.Rows.Count > 0)
             {
                 DGV_CATEGORY.DataSource          = DT;
                 DGV_CATEGORY.AutoGenerateColumns = false;
             }
             else
             {
                 DGV_CATEGORY.DataSource = null;
             }
         }
     }
     catch (Exception EX)
     {
         MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), EX.Message, MessageAlertImage.Error());
         mdg.ShowDialog();
     }
 }
Esempio n. 8
0
 private void LOADCATEGORYlIST()
 {
     try
     {
         CONNECTION.open_connection();
         using (MySqlDataAdapter DA = new MySqlDataAdapter("SELECT categry_id,caegory_name FROM category", CONNECTION.CON))
         {
             DataTable DT = new DataTable();
             DA.Fill(DT);
             if (DT.Rows.Count > 0)
             {
                 DGV_CATEGORY.DataSource          = DT;
                 DGV_CATEGORY.AutoGenerateColumns = false;
             }
             else
             {
                 DGV_CATEGORY.DataSource = null;
             }
         }
     }
     catch (Exception EX)
     {
         MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), EX.Message, MessageAlertImage.Error());
         mdg.ShowDialog();
     }
 }
Esempio n. 9
0
 private void btn_save_ClickAsync(object sender, EventArgs e)
 {
     if (txt_category_name.Text.Length == 0)
     {
         txt_category_name.Focus();
         MSGBOX mdg = new MSGBOX(MessageAlertHeder.Warning(), "PLEASE ENTER CATEGORY NAME", MessageAlertImage.Warning());
         mdg.ShowDialog();
     }
     else if (btn_save.Text == "SAVE")
     {
         Cursor.Current = Cursors.WaitCursor;
         saveCategory();
         LOADCATEGORYlIST();
         if (DGV_CATEGORY.Rows.Count > 0)
         {
             DGV_CATEGORY.FirstDisplayedScrollingRowIndex = DGV_CATEGORY.RowCount - 1;
         }
         Cursor.Current = Cursors.Default;
     }
     else if (btn_save.Text == "UPDATE")
     {
         Cursor.Current = Cursors.WaitCursor;
         Updatecategory();
         LOADCATEGORYlIST();
         BTN_NEW.PerformClick();
         Cursor.Current = Cursors.Default;
     }
 }
Esempio n. 10
0
 private void Updatecategory()
 {
     try
     {
         CONNECTION.open_connection();
         using (MySqlCommand da = new MySqlCommand("UPDATE category SET caegory_name=@caegory_name WHERE categry_id=@categry_id", CONNECTION.CON))
         {
             da.Parameters.Clear();
             da.Parameters.AddWithValue("@categry_id", lbl_category.Text);
             da.Parameters.AddWithValue("@caegory_name", txt_category_name.Text);
             if (da.ExecuteNonQuery() > 0)
             {
                 MSGBOX mdg = new MSGBOX(MessageAlertHeder.Success(), "CATEGORY UPDATED SUCCESFULLY!", MessageAlertImage.Success());
                 mdg.ShowDialog();
             }
             else
             {
                 MSGBOX mdg = new MSGBOX(MessageAlertHeder.Alert(), "CATEGORY UPDATED SUCCESFULLY!", MessageAlertImage.Alert());
                 mdg.ShowDialog();
             }
         }
     }
     catch (Exception ex)
     {
         MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), ex.Message, MessageAlertImage.Error());
         mdg.ShowDialog();
     }
     finally
     {
         CONNECTION.close_connection();
     }
 }
Esempio n. 11
0
        //private async Task lOADgRIDVIEW()
        //{

        //    loadingCircle1.Visible = true;
        //    loadingCircle1.Size = new Size(75, 75);
        //    loadingCircle1.Active = true;
        //    await Task.Run(() => {
        //         LOADCATEGORYlIST();
        //    });
        //    loadingCircle1.Active = false;
        //    loadingCircle1.Visible = false;
        //    loadingCircle1.Size = new Size(1, 1);


        //}
        //private async Task SAVECATEGORY()
        //{

        //    loadingCircle1.Visible = true;
        //    loadingCircle1.Size = new Size(75, 75);
        //    loadingCircle1.Active = true;
        //    btn_save.Enabled = false;
        //    await Task.Run(() => {
        //        res = saveCategory();
        //    });
        //    loadingCircle1.Active = false;
        //    loadingCircle1.Visible = false;
        //    loadingCircle1.Size = new Size(1, 1);
        //    btn_save.Enabled = true;
        //    BTN_NEW.Focus();
        //    txt_category_name.Clear();
        //    if (res == "1")
        //    {
        //        lbl_category.Text = GETMAXID();
        //        MSGBOX mdg = new MSGBOX(MessageAlertHeder.Warning(), "CATEGORY ADDED SUCCESFULLY!", MessageAlertImage.Warning());
        //        mdg.ShowDialog();
        //    }
        //    else if (res == "0")
        //    {
        //        MSGBOX mdg = new MSGBOX(MessageAlertHeder.Warning(), "CATEGORY ADDED FAILED!", MessageAlertImage.Warning());
        //        mdg.ShowDialog();
        //    }
        //    else
        //    {
        //        MSGBOX mdg = new MSGBOX(MessageAlertHeder.Alert(), saveCategory(), MessageAlertImage.Alert());
        //        mdg.ShowDialog();
        //    }

        //}
        //private async Task UPDATE_CATEGORY_NAME()
        //{

        //    loadingCircle1.Visible = true;
        //    loadingCircle1.Size = new Size(75, 75);
        //    loadingCircle1.Active = true;
        //    btn_save.Enabled = false;
        //    await Task.Run(() => {
        //        res = updatecategory();
        //        // LOADCATEGORYlIST();
        //    });
        //    loadingCircle1.Active = false;
        //    loadingCircle1.Visible = false;
        //    loadingCircle1.Size = new Size(1, 1);
        //    btn_save.Enabled = true;
        //    BTN_NEW.Focus();
        //    txt_category_name.Clear();
        //    lbl_category.Text = "N/A";
        //    btn_save.Text = "SAVE";
        //    if (res == "1")
        //    {
        //        lbl_category.Text = GETMAXID();
        //        MSGBOX mdg = new MSGBOX(MessageAlertHeder.Warning(), "CATEGORY UPDATED SUCCESFULLY!", MessageAlertImage.Warning());
        //        mdg.ShowDialog();
        //    }
        //    else if (res == "0")
        //    {
        //        MSGBOX mdg = new MSGBOX(MessageAlertHeder.Warning(), "CATEGORY UPDATED FAILED!", MessageAlertImage.Warning());
        //        mdg.ShowDialog();
        //    }
        //    else
        //    {
        //        MSGBOX mdg = new MSGBOX(MessageAlertHeder.Alert(), saveCategory(), MessageAlertImage.Alert());
        //        mdg.ShowDialog();
        //    }

        //}
        private void saveCategory()
        {
            try
            {
                CONNECTION.open_connection();
                using (MySqlCommand da = new MySqlCommand("INSERT INTO category(caegory_name) VALUES(@caegory_name)", CONNECTION.CON))
                {
                    da.Parameters.Clear();
                    da.Parameters.AddWithValue("@caegory_name", txt_category_name.Text);
                    if (da.ExecuteNonQuery() > 0)
                    {
                        lbl_category.Text = GETMAXID();
                        MSGBOX mdg = new MSGBOX(MessageAlertHeder.Success(), "CATEGORY ADDED SUCCESFULLY!", MessageAlertImage.Success());
                        mdg.ShowDialog();
                    }
                    else
                    {
                        MSGBOX mdg = new MSGBOX(MessageAlertHeder.Alert(), "CATEGORY 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();
            }
        }
Esempio n. 12
0
 public static double GetTotalTaxPercentage()
 {
     try
     {
         using (MySqlDataAdapter adp = new MySqlDataAdapter("SELECT IFNULL(SUM(precentage),0.00) FROM tax_details", CONNECTION.CON))
         {
             DataTable tbl = new DataTable();
             adp.Fill(tbl);
             if (tbl.Rows.Count > 0)
             {
                 return(tbl.Rows[0].Field <double>(0));
             }
             else
             {
                 return(0);
             }
         }
     }
     catch (Exception ex)
     {
         MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), ex.Message, MessageAlertImage.Error());
         mdg.ShowDialog();
         return(0);
     }
 }
Esempio n. 13
0
        public void MessageBox(string szMsg, string szTitle, MSGBOX nType, string szURL)
        {
            string szAction = "";

            if (!string.IsNullOrEmpty(szURL))
            {
                szAction = "location.href='" + szURL + "';";
            }
            MessageBox_Action(szMsg, szTitle, nType, szAction);
        }
 private async void shapedButton1_Click(object sender, EventArgs e)
 {
     if (txt_uname.Text.Length == 0)
     {
         pb_u_warning.Visible = true;
         txt_uname.Focus();
         MSGBOX mdg = new MSGBOX(MessageAlertHeder.Success(), "Please enter username", MessageAlertImage.Success());
         mdg.ShowDialog();
     }
     else if (txt_pass.Text.Length == 0)
     {
         pb_p_warning.Visible = true;
         txt_pass.Focus();
         MSGBOX mdg = new MSGBOX(MessageAlertHeder.Alert(), "Please enter password", MessageAlertImage.Alert());
         mdg.ShowDialog();
     }
     else
     {
         pb_u_warning.Visible = false;
         pb_u_warning.Visible = false;
         await ImportAsync();
     }
 }
Esempio n. 15
0
        public void MessageBox(string szMsg, string szTitle, MSGBOX nType, MSGBOX_ACTION nBack)
        {
            string szAction = "";

            if (nBack == MSGBOX_ACTION.BACK)
            {
                //szAction = "history.go(-2);";
                string szUrl = PopHistory();
                if (szUrl != null)
                {
                    szAction = "location.href='" + szUrl + "';";
                }
            }
            else if (nBack == MSGBOX_ACTION.OK)
            {
                szAction = "Dlg_OK()";
            }
            else if (nBack == MSGBOX_ACTION.CANCEL)
            {
                szAction = "Dlg_Cancel()";
            }
            MessageBox_Action(szMsg, szTitle, nType, szAction);
        }
Esempio n. 16
0
 public void MessageBox(string szMsg, string szTitle, MSGBOX nType)
 {
     MessageBox_Action(szMsg, szTitle, nType, null);
 }