Пример #1
0
 public PriceCalc()
 {
     InitializeComponent();
     SLDataDB.LoadData(queryOrd, out Orders);
     SLDataDB.LoadData(queryClnt, out Clients);
     ClntListLd();
 }
Пример #2
0
        private void SaveOrd_Click(object sender, EventArgs e)
        {
            if (OrdStat.Text != "")
            {
                switch (OrdStat.Text)
                {
                case "Получен":
                {
                    Orders.Rows[Convert.ToInt32(OrdN.Text)][4] = 1;
                }
                break;

                case "Выполняется":
                {
                    Orders.Rows[Convert.ToInt32(OrdN.Text)][4] = 2;
                }
                break;

                case "Завершен":
                {
                    Orders.Rows[Convert.ToInt32(OrdN.Text)][4] = 3;
                }
                break;
                }
                SLDataDB.SaveData(query, Orders);
                Description.Text = "Изменения сохранены.";
            }
        }
Пример #3
0
 public ManagersW()
 {
     InitializeComponent();
     SLDataDB.LoadData(queryMng, out MngrsIsh);
     Mng = MngrsIsh.Copy();
     UnXor();
 }
Пример #4
0
 private void Upd()
 {
     SLDataDB.LoadData(queryOrd, out Orders);
     SLDataDB.LoadData(queryMng, out Managers);
     SLDataDB.LoadData(queryClnt, out Clients);
     SLDataDB.LoadData(queryArchive, out Archive);
 }
Пример #5
0
        private void SaveB_Click(object sender, EventArgs e)
        {
            if (Lgn.Text != "" && NewPass.Text != "")
            {
                string pass = NewPass.Text;
                string ps   = "";
                for (int i = 0; i < pass.Length; i++)
                {
                    ps += (char)(pass[i] ^ 'k');
                }
                if (Lgn.Text != "" && NewPass.Text != "")
                {
                    switch (Lgn.Text)
                    {
                    case "Начальник отдела":
                    {
                        Admins.Rows[1][2] = ps;
                    }
                    break;

                    case "Администратор":
                    {
                        Admins.Rows[0][2] = ps;
                    }
                    break;
                    }
                    SLDataDB.SaveData(queryOrd, Admins);
                    NewPass.Text = "Сохранено";
                }
            }
        }
Пример #6
0
 private void DelSvcB_Click(object sender, EventArgs e)
 {
     if (IdSvc.Text != "")
     {
         Svcs.Rows[Convert.ToInt32(IdSvc.Text) - 1].Delete();
         SLDataDB.SaveData(queryClnt, Svcs);
         IdSvc.Text = "Удалено";
     }
 }
Пример #7
0
 private void DelB_Click(object sender, EventArgs e)
 {
     if (MangrN.Text != "")
     {
         MngrsIsh.Rows[Convert.ToInt32(MangrN.Text)].Delete();
         SLDataDB.SaveData(queryMng, MngrsIsh);
         MangrN.Text = "Удалено";
     }
 }
Пример #8
0
 private void DiscountChngB_Click(object sender, EventArgs e)
 {
     if (IDClient.Text != "" && DiscChng.Text != "")
     {
         for (int i = 0; i < Clnts.Rows.Count; i++)
         {
             if (Convert.ToInt32(Clnts.Rows[i][0]) == Convert.ToInt32(IDClient.Text))
             {
                 Clnts.Rows[i][6] = DiscChng.Text;
                 break;
             }
         }
         SLDataDB.SaveData(queryClnt, Clnts);
     }
 }
Пример #9
0
 private void UpdInfo()
 {
     SLDataDB.LoadData(queryOrd, out Orders);
     SLDataDB.LoadData(queryMng, out Managers);
     SLDataDB.LoadData(queryClnt, out Clients);
     ManagerBx.Items.Clear();
     ClientsBx.Items.Clear();
     for (int i = 0; i < Managers.Rows.Count; i++)
     {
         ManagerBx.Items.Add(Managers.Rows[i][1]);
     }
     for (int i = 0; i < Clients.Rows.Count; i++)
     {
         ClientsBx.Items.Add(Clients.Rows[i][1]);
     }
 }
Пример #10
0
 private void Add_Click(object sender, EventArgs e)
 {
     if (Nam.Text != "")
     {
         DataRow row;
         row              = Svcs.NewRow();
         row["Id"]        = Svcs.Rows.Count + 1;
         row["Название"]  = Nam.Text;
         row["Стоимость"] = Price.Text;
         row["Описание"]  = Description.Text;
         Svcs.Rows.Add(row);
         SLDataDB.SaveData(queryClnt, Svcs);
         Description.Text = "Cохранено.";
         Nam.Text         = "";
         Price.Text       = "";
     }
 }
Пример #11
0
        public Manager()
        {
            int p = 0;

            MngID = Authorization.MngID;
            InitializeComponent();
            SLDataDB.LoadData(query, out Orders);
            SLDataDB.LoadData(queryClnts, out Clients);
            OrdersId = new int[Orders.Rows.Count];
            for (int i = 0; i < Orders.Rows.Count; i++)
            {
                if (MngID == Convert.ToInt32(Orders.Rows[i][5]))
                {
                    NumbersOrd.Text += Orders.Rows[i][0] + "\n";
                    OrdersId[p]      = Convert.ToInt32(Orders.Rows[i][0]);
                    p++;
                }
            }
        }
Пример #12
0
 private void SendTArchive_Click(object sender, EventArgs e)
 {
     if (OrdNArh.Text != "")
     {
         for (int i = 0; i < Orders.Rows.Count; i++)
         {
             if (Convert.ToInt32(OrdNArh.Text) == Convert.ToInt32(Orders.Rows[i][0]))
             {
                 DataRow row;
                 row       = Archive.NewRow();
                 row["Id"] = Orders.Rows[i][0];
                 row["Название заказа"] = Orders.Rows[i][1];
                 row["Описание"]        = Orders.Rows[i][2];
                 row["Стоимость"]       = Orders.Rows[i][8];
                 for (int k = 0; k < Clients.Rows.Count; k++)
                 {
                     if (Convert.ToInt32(Orders.Rows[i][7]) == Convert.ToInt32(Clients.Rows[k][0]))
                     {
                         row["Фамилия"]        = Clients.Rows[k][1];
                         row["Имя"]            = Clients.Rows[k][2];
                         row["Номер телефона"] = Clients.Rows[k][4];
                     }
                 }
                 for (int k = 0; k < Managers.Rows.Count; k++)
                 {
                     if (Convert.ToInt32(Orders.Rows[i][5]) == Convert.ToInt32(Managers.Rows[k][0]))
                     {
                         row["Фамилия менеджера"] = Managers.Rows[k][1];
                         row["Имя менеджера"]     = Managers.Rows[k][2];
                     }
                 }
                 Archive.Rows.Add(row);
                 Orders.Rows[i].Delete();
                 break;
             }
         }
         SLDataDB.SaveData(queryArchive, Archive);
         SLDataDB.SaveData(queryOrd, Orders);
         OrdNArh.Text = "Сохранено";
     }
 }
Пример #13
0
 private void Add_Click(object sender, EventArgs e)
 {
     if (PhoneN.Text != "" && Add.Text != "")
     {
         DataRow row;
         row                   = Clnts.NewRow();
         row["Id"]             = Clnts.Rows.Count + 1;
         row["Фамилия"]        = Srnam.Text;
         row["Имя"]            = Nam.Text;
         row["Отчество"]       = Patrn.Text;
         row["Номер телефона"] = PhoneN.Text;
         row["Адрес"]          = Adress.Text;
         row["Скидка, %"]      = Discount.Text;
         Clnts.Rows.Add(row);
         SLDataDB.SaveData(queryClnt, Clnts);
         Srnam.Text    = "Cохранено.";
         Nam.Text      = "";
         Patrn.Text    = "";
         PhoneN.Text   = "";
         Adress.Text   = "";
         Discount.Text = "";
     }
 }
Пример #14
0
 private void AddB_Click(object sender, EventArgs e)
 {
     if (SrNam.Text != "" && Nam.Text != "" && Pass.Text != "")
     {
         DataRow row;
         string  pass = "";
         row            = MngrsIsh.NewRow();
         row["Id"]      = MngrsIsh.Rows.Count + 1;
         row["Surname"] = SrNam.Text;
         row["Name"]    = Nm.Text;
         for (int i = 0; i < Pass.Text.Length; i++)
         {
             pass += (char)(Pass.Text[i] ^ 'k');
         }
         row["Pass"] = pass;
         MngrsIsh.Rows.Add(row);
         SLDataDB.SaveData(queryMng, MngrsIsh);
         SrNam.Text = "Cохранено.";
         Nm.Text    = "";
         Pass.Text  = "";
         Mng        = MngrsIsh.Copy();
         UnXor();
     }
 }
Пример #15
0
        private void Auth_Click(object sender, EventArgs e)
        {
            if (Log.Text != "")
            {
                DataTable Table = new DataTable();
                if (Log.Text == "Администратор" || Log.Text == "Начальник отдела")
                {
                    string pss;
                    string query  = "SELECT * FROM Admins ORDER BY id";
                    string chkpas = Pass.Text;
                    SLDataDB.LoadData(query, out Table);
                    int  p;
                    bool chk = false;
                    switch (Log.Text)
                    {
                    case "Администратор":
                    {
                        p   = 0;
                        pss = Convert.ToString(Table.Rows[p][2]);
                        PasCheck(chkpas, pss, out chk);
                        if (chk)
                        {
                            this.Hide();
                            Admin g = new Admin();
                            g.ShowDialog();
                            this.Close();
                        }
                    }
                    break;

                    case "Начальник отдела":
                    {
                        p   = 1;
                        pss = Convert.ToString(Table.Rows[p][2]);
                        PasCheck(chkpas, pss, out chk);
                        if (chk)
                        {
                            this.Hide();
                            Head_of_Dep g = new Head_of_Dep();
                            g.ShowDialog();
                            this.Close();
                        }
                    }
                    break;
                    }
                }
                else
                {
                    if (Log.Text != "")
                    {
                        string pss    = "";
                        string query  = "SELECT * FROM Managers ORDER BY Id";
                        string chkpas = Pass.Text;
                        SLDataDB.LoadData(query, out Table);
                        bool chk = false;
                        int  p   = 0;
                        for (int i = 0; i < Table.Rows.Count; i++)
                        {
                            string LT     = Log.Text;
                            string BDSrnm = Convert.ToString(Table.Rows[i][1]);
                            for (int k = 0; k < LT.Length; k++)
                            {
                                if (LT[k] == BDSrnm[k])
                                {
                                    chk = true;
                                }
                                else
                                {
                                    chk = false;
                                    break;
                                }
                            }
                            if (chk)
                            {
                                pss = Convert.ToString(Table.Rows[i][3]);
                                p   = i;
                                break;
                            }
                        }
                        if (chk == false)
                        {
                            WrongPass g = new WrongPass();
                            g.ShowDialog();
                        }
                        if (chk)
                        {
                            PasCheck(chkpas, pss, out chk);
                        }
                        ;
                        if (chk)
                        {
                            MngID = Convert.ToInt32(Table.Rows[p][0]);
                            this.Hide();
                            Manager g = new Manager();
                            g.ShowDialog();
                            this.Close();
                        }
                    }
                }
            }
        }
Пример #16
0
 public SvcManager()
 {
     InitializeComponent();
     SLDataDB.LoadData(queryClnt, out Svcs);
     dataGridView1.DataSource = Svcs;
 }
Пример #17
0
 public Services()
 {
     InitializeComponent();
     SLDataDB.LoadData(queryClnt, out Svcs);
     dGV1.DataSource = Svcs;
 }
Пример #18
0
 private void AddNwOrd_Click(object sender, EventArgs e)
 {
     if (NamOrd.Text != "" && DateSt.Text != "" && ClientsBx.Text != "" && ManagerBx.Text != "")
     {
         DataRow row;
         row                = Orders.NewRow();
         row["Id"]          = Orders.Rows.Count + 1;
         row["Name"]        = NamOrd.Text;
         row["Description"] = Description.Text;
         row["Order_stage"] = 0;
         row["Deadline"]    = DeadLn.Text;
         row["Date"]        = DateSt.Text;
         row["Price"]       = Convert.ToInt32(Price.Text);
         for (int i = 0; i < Managers.Rows.Count; i++)
         {
             bool chk = false;
             for (int k = 0; k < ManagerBx.Text.Length; k++)
             {
                 string a = Convert.ToString(Managers.Rows[i][1]);
                 if (a[k] == ManagerBx.Text[k])
                 {
                     chk = true;
                 }
                 else
                 {
                     chk = false;
                     break;
                 }
             }
             if (chk)
             {
                 row["ManagerID"] = Managers.Rows[i][0];
             }
         }
         for (int i = 0; i < Clients.Rows.Count; i++)
         {
             bool chk = false;
             for (int k = 0; k < ClientsBx.Text.Length; k++)
             {
                 string a = Convert.ToString(Clients.Rows[i][1]);
                 if (a[k] == ClientsBx.Text[k])
                 {
                     chk = true;
                 }
                 else
                 {
                     chk = false;
                     break;
                 }
             }
             if (chk)
             {
                 row["ClientID"] = Clients.Rows[i][0];
             }
         }
         Orders.Rows.Add(row);
         SLDataDB.SaveData(queryOrd, Orders);
         NamOrd.Text      = "";
         DeadLn.Text      = "";
         DateSt.Text      = "";
         ClientsBx.Text   = "";
         Description.Text = "Заказ добавлен.";
         ManagerBx.Text   = "";
         Price.Text       = "";
     }
 }
Пример #19
0
 public Clients()
 {
     InitializeComponent();
     SLDataDB.LoadData(queryClnt, out Clnts);
     dGV1.DataSource = Clnts;
 }
Пример #20
0
 public Arhve()
 {
     InitializeComponent();
     SLDataDB.LoadData(queryArch, out Archive);
     dGV1.DataSource = Archive;
 }
Пример #21
0
 public ChangePassword()
 {
     InitializeComponent();
     SLDataDB.LoadData(queryOrd, out Admins);
 }