//============================================================================================ 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; }
//======================================================== 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)); }
//======================================================== 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); }