Beispiel #1
0
        //============================================================================================
        private void getRowsNumber(string sqlWhere)
        {
            int r = 0;

            r            = Convert.ToInt32(DBFc.doSqlWithResultReturn("SELECT count(*) FROM Users " + sqlWhere, Glob.cnn));
            lblRows.Text = r.ToString();
            rowsTotal    = r;
        }
Beispiel #2
0
        //========================================================
        public string Update()
        {
            string sql = "dbo.Users_Update @u_id=" + this.id.ToString()
                         + ", @u_Name = N'" + this.uName.Replace("'", "''")
                         + "', @u_Login = N'" + this.uLogin.Replace("'", "''")
                         + "', @u_Password = N'" + this.uPassword.Replace("'", "''") + "'";

            return(DBFc.doSqlWithResultReturn(sql, Glob.cnn));
        }
Beispiel #3
0
        //========================================================
        public string SaveNew()
        {
            string sql = "dbo.Users_AddNew @uName = N'"
                         + this.uName + "', @uLogin = N'"
                         + this.uLogin + "', @uPassword = N'"
                         + this.uPassword + "', @uEmail = N'"
                         + this.uEmail + "', @uAddress = N'No address provided', @uIP = N'0.0.0.0'";
            string r = DBFc.doSqlWithResultReturn(sql, Glob.cnn);

            if (r == "Fail")
            {
                r = "Error on creating a new DataBase record.";
            }
            else
            {
                this.id = Convert.ToInt32(r);
                r       = "";
            }
            return(r);
        }