示例#1
0
 public bool userAuthentication(string username, string password)
 {
     ConnectionManager.DataBaseConn con = new ConnectionManager.DataBaseConn(1);
     SqlConnection sql=con.DBConnect();
     DatabaseAccess.Query query = new DatabaseAccess.Query();
     bool status= query.checkAuthentication(username, password,sql);
     return status;
 }
示例#2
0
        private void threadStartFun(Socket soc, string req)
        {
            Program.ServerForm.addtoConsole("Service SignUpReq Thread Started");
            //parse msg received
            //System.Windows.Forms.MessageBox.Show("Signup service started:"+ req, "Server");
            Message.MessageParser parser = new Message.MessageParser();
            MessageClasses.MsgSignUp.req reqobj = new MessageClasses.MsgSignUp.req();
            reqobj = parser.signUpParseReq(req);

            //create connection with sql
            ConnectionManager.DataBaseConn con = new ConnectionManager.DataBaseConn(1);
            SqlConnection conn = con.DBConnect();
            //check if user already exits
            DatabaseAccess.Query q = new DatabaseAccess.Query();

            if (true == q.checkIfUserExists(reqobj.userName, conn))
            {
                con.DBClose();
                //System.Windows.Forms.MessageBox.Show("Signup service if user exists", "Server");
                MessageClasses.MsgSignUp.resp resp = new MessageClasses.MsgSignUp.resp();
                resp.ack = "ERRORS";
                resp.addiMsg = "AlreadyExist";
                Message.CreateMsg msg = new Message.CreateMsg();
                string res=  msg.signUpResp(resp);
                SocketCommunication.ReaderWriter rw = new SocketCommunication.ReaderWriter();
                rw.writetoSocket(soc, res);
                Program.ServerForm.addtoConsole("Writing response to Socket");
                Program.ServerForm.addtoConsole("Exiting");
                Thread.CurrentThread.Abort();
            }
            else
            {
                ConnectionManager.DataBaseConn con1 = new ConnectionManager.DataBaseConn(1);
                SqlConnection conn1 = con.DBConnect();
                if (true == q.insertNewUser(reqobj.userName, reqobj.psw, conn1))
                {

                    Program.ServerForm.addtoConsole("New User Added");
                    conn1.Close();
                    //System.Windows.Forms.MessageBox.Show("Signup service insert user", "Server");
                    MessageClasses.MsgSignUp.resp resp = new MessageClasses.MsgSignUp.resp();
                    resp.ack = "OK";
                    resp.addiMsg = "Added";
                    Message.CreateMsg msg = new Message.CreateMsg();
                    string res = msg.signUpResp(resp);
                    SocketCommunication.ReaderWriter rw = new SocketCommunication.ReaderWriter();
                    rw.writetoSocket(soc, res);
                    Program.ServerForm.addtoConsole("Wrote response to Socket");

                    //conn.Close();
                }
                else
                {
                    conn1.Close();
                    Program.ServerForm.addtoConsole("Sign Up Error while inserting to Database");
                    //System.Windows.Forms.MessageBox.Show("Signup service could insert", "Server");
                    MessageClasses.MsgSignUp.resp resp = new MessageClasses.MsgSignUp.resp();
                    resp.ack = "ERRORS";
                    resp.addiMsg = "ERRORWHILEINSERTING";
                    Message.CreateMsg msg = new Message.CreateMsg();
                    string res = msg.signUpResp(resp);
                    SocketCommunication.ReaderWriter rw = new SocketCommunication.ReaderWriter();
                    rw.writetoSocket(soc, res);
                    Program.ServerForm.addtoConsole("Wrote Respose to Socket");
                    //conn.Close();
                }
                //conn.Close();
                Program.ServerForm.addtoConsole("Exiting");
                Thread.CurrentThread.Abort();
            }
            //TBD
        }
示例#3
0
        private void button1_Click(object sender, EventArgs e)
        {
            button1.Visible = false;
            if(button1.Text.Equals(GetLabel(DictionaryFileName,"StopButton")))
            {
                // Clean panel
                Close_panel();

                // Back
                comboBox1.Enabled = true;
                comboBox2.Enabled = true;
                maskedTextBox1.Enabled = true;
                radioButton1.Enabled = true;
                radioButton2.Enabled = true;
                panel4.Visible = true;
                radioButton3.Enabled = true;
                radioButton4.Enabled = true;
                button1.Text = GetLabel(DictionaryFileName, "RunButton");
            }
            else if (button1.Text.Equals(GetLabel(DictionaryFileName,"RunButton")))
            {
                List<bool> validation = new List<bool>();
                validation.Add(ValidateAsSelectedfromCombobox(comboBox2, label3));

                if (radioButton1.Checked == false && radioButton2.Checked == false && radioButton3.Checked == false && radioButton4.Checked == false)
                {
                    validation.Add(false);
                    ShowError(989, label2.Text.Split(':')[0]);
                }
                else
                {
                    validation.Add(true);
                }

                validation.Add(ValidateAsSelectedfromCombobox(comboBox1, label1));

                if (CompleteValidation(validation) == true)
                {
                    bool noerror = false;
                    // Testar conexão
                    DatabaseAccess.Query databaseAccess = new DatabaseAccess.Query();
                    List<string[]> matrix = new List<string[]>();
                    bool errorShown = false;
                    try
                    {
                       matrix = databaseAccess.query(GetLabel("config.ini", "Host"), GetLabel("config.ini", "UserID"), GetLabel("config.ini", "DatabaseName"), maskedTextBox1.Text, "SELECT * FROM `case`");
                       if (matrix[0][0].ToLower().Contains("*error*") && matrix[0][0].ToLower().Contains("access denied for user"))
                       {
                           ShowError(997, label4.Text.Split(':')[0]);
                           errorShown = true;
                       }
                       else if (matrix[0][0].ToLower().Contains("*error*"))
                       {
                           ShowError(984, GetLabel(DictionaryFileName,"InternetConnection"));
                           errorShown = true;
                       }
                       else
                       {
                           noerror = true;
                       }
                    }
                    catch
                    {
                        if (matrix.Count == 0)
                        {
                            // Means that read ok but there  isn't anything on the database
                            noerror = true;
                        }
                    }
                    if (noerror == false)
                    {
                        if ( errorShown == false)
                        {
                            ShowError(997, label4.Text.Split(':')[0]);
                        }
                    }
                    else
                    {
                        comboBox1.Enabled = false;
                        comboBox2.Enabled = false;
                        label5.Text = GetLabel(DictionaryFileName, "NoError.OK");
                        maskedTextBox1.Enabled = false;
                        radioButton1.Enabled = false;
                        int operationSelectedValue = -1;
                        if (radioButton1.Checked == true)
                        {
                            operationSelectedValue = 0;
                        }
                        radioButton2.Enabled = false;
                        if (radioButton2.Checked == true)
                        {
                            operationSelectedValue = 1;
                        }
                        radioButton3.Enabled = false;
                        if (radioButton3.Checked == true)
                        {
                            operationSelectedValue = 2;
                        }
                        radioButton4.Enabled = false;
                        if (radioButton4.Checked == true)
                        {
                            operationSelectedValue = 3;
                        }

                        GenerateNewForm(maskedTextBox1.Text, comboBox1.SelectedIndex, comboBox2.SelectedIndex, operationSelectedValue);
                        button1.Text = GetLabel(DictionaryFileName, "StopButton");
                    }
                }
                else
                {

                }
            }
            else
            {
                ShowError(992, "dictionary.dat");
            }
            button1.Visible = true;
        }
示例#4
0
 private List<string[]> Query(string msgQuery)
 {
     List<string[]> matrix = new List<string[]>();
     DatabaseAccess.Query databaseAccess = new DatabaseAccess.Query();
     matrix = databaseAccess.query(GetLabel("config.ini", "Host"), GetLabel("config.ini", "UserID"), GetLabel("config.ini", "DatabaseName"), maskedTextBox1.Text, msgQuery);
     return matrix;
 }
示例#5
0
 private List<string[]> GetTransmissionMatrix()
 {
     DatabaseAccess.Query databaseAccess = new DatabaseAccess.Query();
     List<string[]> matrix = new List<string[]>();
     matrix = databaseAccess.query(GetLabel("config.ini", "Host"), GetLabel("config.ini", "UserID"), GetLabel("config.ini", "DatabaseName"), maskedTextBox1.Text,"SELECT * FROM  `case`");
     matrix = CaseTransmissionFiltering(matrix);
     return matrix;
 }
示例#6
0
        private int GetAreaID(int selectedIndex)
        {
            if (selectedIndex >= 0)
            {
                List<string[]> matrix = new List<string[]>();
                DatabaseAccess.Query databaseAccess = new DatabaseAccess.Query();
                matrix = databaseAccess.query(GetLabel("config.ini", "Host"), GetLabel("config.ini", "UserID"), GetLabel("config.ini", "DatabaseName"), maskedTextBox1.Text, "SELECT * FROM  `area`");
                try
                {
                    return Convert.ToInt32(matrix[selectedIndex][0]);
                }
                catch
                {
                    return -1;
                }

            }
            else
            {
                return -1;
            }
        }