Esempio n. 1
0
        /// <summary>
        /// serverUserPass
        /// </summary>
        /// <param name="loginPath">مسیر فایل اطلاعات ورود به سرور</param>
        /// <param name="strServer">سرور</param>
        /// <returns>لیست شامل نام سرور ، نام کاربری و رمز عبور سرور</returns>
        public List <string> ServerUserPass(string loginPath, string strServer)
        {
            //  return list
            List <string> lst = new List <string>();

            lst.Add(strServer); // add server



            //  all servers login info
            List <string> lstLogin = new List <string>();

            lstLogin = ReadTxt(loginPath);


            //  get this server user & pass add to lst
            for (int i = 0; i < lstLogin.Count; i++)
            {
                //  find this server info
                if (lstLogin[i].Contains(strServer))
                {
                    //  finde index of separator
                    List <int> lstIndexOf = new List <int>();
                    lstIndexOf = IndexOfAll(lstLogin[i], ",");

                    //  add user & pass to lst
                    lst.Add(lstLogin[i].Substring(lstIndexOf[0], (lstIndexOf[1] - lstIndexOf[0]) - 1));
                    lst.Add(lstLogin[i].Substring(lstIndexOf[1], lstLogin[i].Length - lstIndexOf[1]));
                }
            }


            //  set user & pass when server is local
            if (strServer == ".")
            {
                lst[1] = lst[2] = "";
            }

            //  decrypt pass
            try { lst[2] = CryptorEngine.Decrypt(lst[2], true); }
            catch (Exception) { }


            return(lst);
        }
Esempio n. 2
0
        private void btnConnect_Click(object sender, EventArgs e)
        {
            // get server info ==> server , user , pass
            string strServer = cmbServer.Text, strUser = txtUser.Text, strPass = txtPass.Text;


            //  create sql connection
            sqlCon = functions.SqlConnect(strServer, strUser, strPass);


            //  test sql connection //  result yes
            if (functions.TestConn(sqlCon))
            {
                #region save login info with encrypt pass

                //  save login info with encrypt pass
                if (chbRemember.CheckState == CheckState.Checked)
                {
                    //  encrypt pass
                    string strPassEncrypt = CryptorEngine.Encrypt(strPass, true);

                    List <string> lst = functions.ReadTxt(strPathLoginFolder);


                    //  save login when login file info is empty
                    if (File.ReadAllText(strPathLoginFolder) == "")
                    {
                        File.WriteAllText(strPathLoginFolder, strServer + "," + strUser + "," + strPassEncrypt);
                    }


                    //  save or replace login when login file info is not empty
                    if (File.ReadAllText(strPathLoginFolder) != "")
                    {
                        int intFind = functions.ListFind(lst, strServer);

                        if (intFind != -1)
                        {
                            lst[intFind] = strServer + "," + strUser + "," + strPassEncrypt;
                            functions.SaveListToText(lst, strPathLoginFolder);
                        }

                        else
                        {
                            File.WriteAllText(strPathLoginFolder, File.ReadAllText(strPathLoginFolder) + "\r\n" + strServer + "," + strUser + "," + strPassEncrypt);
                        }
                    }

                    //  load server name
                    cmbServer.DataSource = functions.ListServerName(strPathLoginFolder);
                }

                #endregion


                //  load all database name  // set source cmbDBNames
                functions.ComboBoxSource(cmbDB, functions.SqlGetDBName(sqlCon));

                // list of all database name
                lstAllDataBases = functions.DataTableToList(functions.SqlGetDBName(sqlCon));


                // set btnConnect text
                btnConnect.Text = "اتصال مجدد";
            }


            //  test sql connection //  result no
            else
            {
                btnConnect.Text = "اتصال"; MessageBox.Show("عدم برقراری ارتباط", "!هشدار");
            }


            //*********** defult!!!!!!

            cmbDB.Text = "_Main";
        }