Пример #1
0
        private void FormMain_Load(object sender, EventArgs e)
        {
            //Count Rows of Order & Cause & plagnt
            int CountCause   = 0;
            int Countplainte = 0;
            int Countorder   = 0;

            try
            {
                if (cnx.State == ConnectionState.Closed)
                {
                    cnx.Open();
                }
                cmd.Connection          = cnx;
                cmd.CommandText         = "select count(id_cause) from cause";
                CountCause              = (int)cmd.ExecuteScalar();
                barStaticItem62.Caption = CountCause.ToString();

                cmd.Connection          = cnx;
                cmd.CommandText         = "select count(id_plainte)  from plainte";
                Countplainte            = (int)cmd.ExecuteScalar();
                barStaticItem71.Caption = Countplainte.ToString();

                cmd.Connection          = cnx;
                cmd.CommandText         = "select count(id_order) from orderr";
                Countorder              = (int)cmd.ExecuteScalar();
                barStaticItem73.Caption = Countorder.ToString();


                cnx.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            //------------------------------------

            try
            {
                if (cnx.State == ConnectionState.Closed)
                {
                    cnx.Open();
                }

                DateTime      DateDesition;
                int           Delai      = 0;
                DateTime      DateMoment = DateTime.Now;
                int           Constante  = 5;
                DateTime      DateFin;
                DateTime      NotificationDay;
                SqlDataReader dr2;
                SqlDataReader dr1;
                cmd.Connection  = cnx;
                cmd.CommandText = "select id_cause,duree from cause ";
                dr1             = cmd.ExecuteReader();
                bool show = false;

                while (dr1.Read())
                {
                    Delai = Convert.ToInt32(dr1[1].ToString());


                    SqlCommand cmd2 = new SqlCommand();
                    cmd2.Connection  = cnx;
                    cmd2.CommandText = "select date_session,decision from sessione where id_cause='" + dr1[0].ToString() + "' and (decision='مداولة' or decision='المداولة')";
                    dr2 = cmd2.ExecuteReader();

                    while (dr2.Read())
                    {
                        DateDesition    = (DateTime)dr2[0];
                        DateFin         = DateDesition.AddDays(Delai);
                        NotificationDay = DateFin.AddDays(-5);
                        if (DateMoment.Day >= NotificationDay.Day)
                        {
                            show = true;
                        }
                    }
                    dr2.Close();
                }
                dr1.Close();
                cnx.Close();
                if (show == true)
                {
                    alertControl1.AutoFormDelay   = 5000;
                    alertControl1.ShowPinButton   = true;
                    alertControl1.ShowCloseButton = true;
                    alertControl1.LookAndFeel.SetStyle3D();
                    alertControl1.Show(this, "هناك قضايا أجالاتها قريبة الانتهاء ", "المرجوا الدهاب الى جدول الاجالات  ");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            //-------------------------------------
            DateTime datenow = DateTime.Now;

            String fileContent;
            string pathString;

            pathString = System.IO.Path.GetDirectoryName(System.Windows.Forms.Application.ExecutablePath) + @"\dll\";

            fileContent = System.IO.File.ReadLines(pathString + "ver.txt").First();
            if (fileContent == GetSerial.GetSerialNumber())
            {
                if (Properties.Settings.Default.DateInisial <= datenow && Properties.Settings.Default.DateFinal >= datenow)
                {
                    barButtonItem2.Enabled            = true;
                    barButtonItem3.Enabled            = true;
                    barButtonItem4.Enabled            = true;
                    ادارة.Enabled                     = true;
                    barButtonItem6.Enabled            = true;
                    barButtonItem5.Enabled            = true;
                    ezsffdsfdsfsd.Enabled             = true;
                    barButtonItem9.Enabled            = true;
                    barButtonItem10.Enabled           = true;
                    barButtonItem11.Enabled           = true;
                    barButtonItem12.Enabled           = true;
                    barButtonItem16.Enabled           = true;
                    barButtonItem17.Enabled           = true;
                    barButtonItem18.Enabled           = true;
                    barButtonItem19.Enabled           = true;
                    barButtonItem20.Enabled           = true;
                    barButtonItem23.Enabled           = true;
                    barButtonItem24.Enabled           = true;
                    barButtonItem25.Enabled           = true;
                    barButtonItem33.Enabled           = true;
                    barButtonItem27.Enabled           = true;
                    barButtonItem28.Enabled           = true;
                    barButtonItem31.Enabled           = true;
                    barButtonItem31.Enabled           = true;
                    barButtonItem32.Enabled           = true;
                    barButtonItem14.Enabled           = true;
                    barButtonItem31.Enabled           = true;
                    barButtonItem35.Enabled           = true;
                    barButtonItem36.Enabled           = true;
                    barButtonItem15.Enabled           = true;
                    barButtonItem26.Enabled           = true;
                    barButtonItem38.Enabled           = true;
                    barButtonItem39.Enabled           = true;
                    barButtonItem30.Enabled           = true;
                    accordionControlElement20.Enabled = true;
                    barButtonItem40.Enabled           = true;
                }

                else
                {
                    MessageBox.Show("البرنامج غير مفعل / يرجى الدهاب الى الاعدادات لتفعيل البرنامج", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    //this.Close();
                    barButtonItem2.Enabled  = false;
                    barButtonItem3.Enabled  = false;
                    barButtonItem4.Enabled  = false;
                    ادارة.Enabled           = false;
                    barButtonItem6.Enabled  = false;
                    barButtonItem5.Enabled  = false;
                    ezsffdsfdsfsd.Enabled   = false;
                    barButtonItem9.Enabled  = false;
                    barButtonItem10.Enabled = false;
                    barButtonItem11.Enabled = false;
                    barButtonItem12.Enabled = false;
                    barButtonItem16.Enabled = false;
                    barButtonItem17.Enabled = false;
                    barButtonItem18.Enabled = false;
                    barButtonItem19.Enabled = false;
                    barButtonItem20.Enabled = false;
                    barButtonItem23.Enabled = false;
                    barButtonItem24.Enabled = false;
                    barButtonItem29.Enabled = false;
                    barButtonItem25.Enabled = false;
                    barButtonItem33.Enabled = false;
                    barButtonItem27.Enabled = false;
                    barButtonItem28.Enabled = false;
                    barButtonItem31.Enabled = false;
                    barButtonItem31.Enabled = false;
                    barButtonItem32.Enabled = false;
                    barButtonItem14.Enabled = false;
                    barButtonItem30.Enabled = false;
                    hg.Enabled = false;
                    accordionControlElement5.Enabled  = false;
                    accordionControlElement9.Enabled  = false;
                    accordionControlElement10.Enabled = false;
                    barButtonItem31.Enabled           = true;
                    accordionControlElement2.Enabled  = false;
                    accordionControlElement3.Enabled  = false;
                    accordionControlElement4.Enabled  = false;
                    accordionControlElement1.Enabled  = false;
                    accordionControlElement12.Enabled = false;
                    accordionControlElement13.Enabled = false;
                    accordionControlElement6.Enabled  = false;
                    accordionControlElement7.Enabled  = false;
                    accordionControlElement8.Enabled  = false;
                    accordionControlElement14.Enabled = false;
                    accordionControlElement15.Enabled = false;
                    accordionControlElement16.Enabled = false;
                    accordionControlElement17.Enabled = false;
                    accordionControlElement18.Enabled = false;
                    accordionControlElement19.Enabled = false;
                    barButtonItem35.Enabled           = false;
                    barButtonItem36.Enabled           = false;
                    barButtonItem15.Enabled           = false;
                    barButtonItem26.Enabled           = false;
                    barButtonItem38.Enabled           = false;
                    barButtonItem39.Enabled           = false;
                    barButtonItem30.Enabled           = false;
                    accordionControlElement20.Enabled = false;
                    barButtonItem40.Enabled           = false;
                    Activation ac = new Activation();
                    ac.Show();
                }
            }
            else
            {
                MessageBox.Show("البرنامج غير مفعل / يرجى الدهاب الى الاعدادات لتفعيل البرنامج", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
                //this.Close();
                barButtonItem2.Enabled  = false;
                barButtonItem3.Enabled  = false;
                barButtonItem4.Enabled  = false;
                ادارة.Enabled           = false;
                barButtonItem6.Enabled  = false;
                barButtonItem5.Enabled  = false;
                ezsffdsfdsfsd.Enabled   = false;
                barButtonItem9.Enabled  = false;
                barButtonItem10.Enabled = false;
                barButtonItem11.Enabled = false;
                barButtonItem12.Enabled = false;
                barButtonItem16.Enabled = false;
                barButtonItem17.Enabled = false;
                barButtonItem18.Enabled = false;
                barButtonItem19.Enabled = false;
                barButtonItem20.Enabled = false;
                barButtonItem23.Enabled = false;
                barButtonItem24.Enabled = false;
                barButtonItem29.Enabled = false;
                barButtonItem25.Enabled = false;
                barButtonItem33.Enabled = false;
                barButtonItem27.Enabled = false;
                barButtonItem28.Enabled = false;
                barButtonItem31.Enabled = false;
                barButtonItem31.Enabled = false;
                barButtonItem32.Enabled = false;
                barButtonItem14.Enabled = false;
                barButtonItem30.Enabled = false;
                hg.Enabled = false;
                accordionControlElement5.Enabled  = false;
                accordionControlElement9.Enabled  = false;
                accordionControlElement10.Enabled = false;
                barButtonItem31.Enabled           = true;
                accordionControlElement2.Enabled  = false;
                accordionControlElement3.Enabled  = false;
                accordionControlElement4.Enabled  = false;
                accordionControlElement1.Enabled  = false;
                accordionControlElement12.Enabled = false;
                accordionControlElement13.Enabled = false;
                accordionControlElement6.Enabled  = false;
                accordionControlElement7.Enabled  = false;
                accordionControlElement8.Enabled  = false;
                accordionControlElement14.Enabled = false;
                accordionControlElement15.Enabled = false;
                accordionControlElement16.Enabled = false;
                accordionControlElement17.Enabled = false;
                accordionControlElement18.Enabled = false;
                accordionControlElement19.Enabled = false;
                barButtonItem35.Enabled           = false;
                barButtonItem36.Enabled           = false;
                barButtonItem15.Enabled           = false;
                barButtonItem26.Enabled           = false;
                barButtonItem38.Enabled           = false;
                barButtonItem39.Enabled           = false;
                barButtonItem30.Enabled           = false;
                accordionControlElement20.Enabled = false;
                barButtonItem40.Enabled           = false;
                Activation ac = new Activation();
                ac.Show();
            }
        }
Пример #2
0
        private void FormMain_Load(object sender, EventArgs e)
        {
            string[]   files = System.IO.Directory.GetFiles(System.IO.Path.GetDirectoryName(System.Windows.Forms.Application.ExecutablePath) + "\\Dashboard");
            FileStream fs    = new FileStream("Dashboard\\" + "FormMainDashBoard" + ".xml", FileMode.Open, FileAccess.Read);

            dashboardViewer1.LoadDashboard(fs);
            dashboardViewer1.Refresh();

            //DevExpress.XtraBars.Ribbon.RibbonStatusBar.DefaultForeColor

            //------------------------------------

            try
            {
                if (cnx.State == ConnectionState.Closed)
                {
                    cnx.Open();
                }

                DateTime      DateDesition;
                int           Delai      = 0;
                DateTime      DateMoment = DateTime.Now;
                int           Constante  = 5;
                DateTime      DateFin;
                DateTime      NotificationDay;
                SqlDataReader dr2;
                SqlDataReader dr1;
                cmd.Connection  = cnx;
                cmd.CommandText = "select id_cause,duree from cause ";
                dr1             = cmd.ExecuteReader();
                bool show = false;

                while (dr1.Read())
                {
                    Delai = Convert.ToInt32(dr1[1].ToString());


                    SqlCommand cmd2 = new SqlCommand();
                    cmd2.Connection  = cnx;
                    cmd2.CommandText = "select date_session,decision from sessione where id_cause='" + dr1[0].ToString() + "' and (decision='مداولة' or decision='المداولة')";
                    dr2 = cmd2.ExecuteReader();

                    while (dr2.Read())
                    {
                        DateDesition    = (DateTime)dr2[0];
                        DateFin         = DateDesition.AddDays(Delai);
                        NotificationDay = DateFin.AddDays(-5);
                        if (DateMoment.Day >= NotificationDay.Day)
                        {
                            show = true;
                        }
                    }
                    dr2.Close();
                }
                dr1.Close();
                cnx.Close();
                if (show == true)
                {
                    alertControl1.AutoFormDelay   = 5000;
                    alertControl1.ShowPinButton   = true;
                    alertControl1.ShowCloseButton = true;
                    alertControl1.LookAndFeel.SetStyle3D();
                    alertControl1.Show(this, "هناك قضايا أجالاتها قريبة الانتهاء ", "المرجوا الدهاب الى جدول الاجالات  ");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            //-------------------------------------
            DateTime datenow = DateTime.Now;

            //String fileContent;
            //string pathString;
            //pathString = System.IO.Path.GetDirectoryName(System.Windows.Forms.Application.ExecutablePath) + @"\dll\";

            //fileContent = System.IO.File.ReadLines(pathString + "ver.txt").First();
            //if (fileContent == GetSerial.GetSerialNumber())
            //{
            //    if (Properties.Settings.Default.DateInisial <= datenow && Properties.Settings.Default.DateFinal >= datenow)
            //    {
            //        barButtonItem2.Enabled = true;
            //        barButtonItem3.Enabled = true;
            //        barButtonItem4.Enabled = true;
            //        ادارة.Enabled = true;
            //        barButtonItem6.Enabled = true;
            //        barButtonItem5.Enabled = true;
            //        ezsffdsfdsfsd.Enabled = true;
            //        barButtonItem9.Enabled = true;
            //        barButtonItem10.Enabled = true;
            //        barButtonItem11.Enabled = true;
            //        barButtonItem12.Enabled = true;
            //        barButtonItem16.Enabled = true;
            //        barButtonItem17.Enabled = true;
            //        barButtonItem18.Enabled = true;
            //        barButtonItem19.Enabled = true;
            //        barButtonItem20.Enabled = true;
            //        barButtonItem23.Enabled = true;
            //        barButtonItem24.Enabled = true;
            //        barButtonItem25.Enabled = true;
            //        barButtonItem33.Enabled = true;
            //        barButtonItem27.Enabled = true;
            //        barButtonItem28.Enabled = true;
            //        barButtonItem31.Enabled = true;
            //        barButtonItem31.Enabled = true;
            //        barButtonItem32.Enabled = true;
            //        barButtonItem14.Enabled = true;
            //        barButtonItem31.Enabled = true;
            //        barButtonItem35.Enabled = true;
            //        barButtonItem36.Enabled = true;
            //        barButtonItem15.Enabled = true;
            //        barButtonItem26.Enabled = true;
            //        barButtonItem38.Enabled = true;
            //        barButtonItem39.Enabled = true;
            //        barButtonItem30.Enabled = true;
            //        accordionControlElement20.Enabled = true;
            //        barButtonItem40.Enabled = true;
            //    }

            //    else
            //    {
            //        MessageBox.Show("البرنامج غير مفعل / يرجى الدهاب الى الاعدادات لتفعيل البرنامج", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
            //        //this.Close();
            //        barButtonItem2.Enabled = false;
            //        barButtonItem3.Enabled = false;
            //        barButtonItem4.Enabled = false;
            //        ادارة.Enabled = false;
            //        barButtonItem6.Enabled = false;
            //        barButtonItem5.Enabled = false;
            //        ezsffdsfdsfsd.Enabled = false;
            //        barButtonItem9.Enabled = false;
            //        barButtonItem10.Enabled = false;
            //        barButtonItem11.Enabled = false;
            //        barButtonItem12.Enabled = false;
            //        barButtonItem16.Enabled = false;
            //        barButtonItem17.Enabled = false;
            //        barButtonItem18.Enabled = false;
            //        barButtonItem19.Enabled = false;
            //        barButtonItem20.Enabled = false;
            //        barButtonItem23.Enabled = false;
            //        barButtonItem24.Enabled = false;
            //        barButtonItem29.Enabled = false;
            //        barButtonItem25.Enabled = false;
            //        barButtonItem33.Enabled = false;
            //        barButtonItem27.Enabled = false;
            //        barButtonItem28.Enabled = false;
            //        barButtonItem31.Enabled = false;
            //        barButtonItem31.Enabled = false;
            //        barButtonItem32.Enabled = false;
            //        barButtonItem14.Enabled = false;
            //        barButtonItem30.Enabled = false;
            //        hg.Enabled = false;
            //        accordionControlElement5.Enabled = false;
            //        accordionControlElement9.Enabled = false;
            //        accordionControlElement10.Enabled = false;
            //        barButtonItem31.Enabled = true;
            //        accordionControlElement2.Enabled = false;
            //        accordionControlElement3.Enabled = false;
            //        accordionControlElement4.Enabled = false;
            //        accordionControlElement1.Enabled = false;
            //        accordionControlElement12.Enabled = false;
            //        accordionControlElement13.Enabled = false;
            //        accordionControlElement6.Enabled = false;
            //        accordionControlElement7.Enabled = false;
            //        accordionControlElement8.Enabled = false;
            //        accordionControlElement14.Enabled = false;
            //        accordionControlElement15.Enabled = false;
            //        accordionControlElement16.Enabled = false;
            //        accordionControlElement17.Enabled = false;
            //        accordionControlElement18.Enabled = false;
            //        accordionControlElement19.Enabled = false;
            //        barButtonItem35.Enabled = false;
            //        barButtonItem36.Enabled = false;
            //        barButtonItem15.Enabled = false;
            //        barButtonItem26.Enabled = false;
            //        barButtonItem38.Enabled = false;
            //        barButtonItem39.Enabled = false;
            //        barButtonItem30.Enabled = false;
            //        accordionControlElement20.Enabled = false;
            //        barButtonItem40.Enabled = false;
            //        Activation ac = new Activation();
            //        ac.Show();
            //    }
            //}
            //else
            //{
            //    MessageBox.Show("البرنامج غير مفعل / يرجى الدهاب الى الاعدادات لتفعيل البرنامج", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
            //    //this.Close();
            //    barButtonItem2.Enabled = false;
            //    barButtonItem3.Enabled = false;
            //    barButtonItem4.Enabled = false;
            //    ادارة.Enabled = false;
            //    barButtonItem6.Enabled = false;
            //    barButtonItem5.Enabled = false;
            //    ezsffdsfdsfsd.Enabled = false;
            //    barButtonItem9.Enabled = false;
            //    barButtonItem10.Enabled = false;
            //    barButtonItem11.Enabled = false;
            //    barButtonItem12.Enabled = false;
            //    barButtonItem16.Enabled = false;
            //    barButtonItem17.Enabled = false;
            //    barButtonItem18.Enabled = false;
            //    barButtonItem19.Enabled = false;
            //    barButtonItem20.Enabled = false;
            //    barButtonItem23.Enabled = false;
            //    barButtonItem24.Enabled = false;
            //    barButtonItem29.Enabled = false;
            //    barButtonItem25.Enabled = false;
            //    barButtonItem33.Enabled = false;
            //    barButtonItem27.Enabled = false;
            //    barButtonItem28.Enabled = false;
            //    barButtonItem31.Enabled = false;
            //    barButtonItem31.Enabled = false;
            //    barButtonItem32.Enabled = false;
            //    barButtonItem14.Enabled = false;
            //    barButtonItem30.Enabled = false;
            //    hg.Enabled = false;
            //    accordionControlElement5.Enabled = false;
            //    accordionControlElement9.Enabled = false;
            //    accordionControlElement10.Enabled = false;
            //    barButtonItem31.Enabled = true;
            //    accordionControlElement2.Enabled = false;
            //    accordionControlElement3.Enabled = false;
            //    accordionControlElement4.Enabled = false;
            //    accordionControlElement1.Enabled = false;
            //    accordionControlElement12.Enabled = false;
            //    accordionControlElement13.Enabled = false;
            //    accordionControlElement6.Enabled = false;
            //    accordionControlElement7.Enabled = false;
            //    accordionControlElement8.Enabled = false;
            //    accordionControlElement14.Enabled = false;
            //    accordionControlElement15.Enabled = false;
            //    accordionControlElement16.Enabled = false;
            //    accordionControlElement17.Enabled = false;
            //    accordionControlElement18.Enabled = false;
            //    accordionControlElement19.Enabled = false;
            //    barButtonItem35.Enabled = false;
            //    barButtonItem36.Enabled = false;
            //    barButtonItem15.Enabled = false;
            //    barButtonItem26.Enabled = false;
            //    barButtonItem38.Enabled = false;
            //    barButtonItem39.Enabled = false;
            //    barButtonItem30.Enabled = false;
            //    accordionControlElement20.Enabled = false;
            //    barButtonItem40.Enabled = false;
            //    Activation ac = new Activation();
            //    ac.Show();
            //}
        }