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