public static DbCollection <DbUser> LoadAll(Dbase database = null)
{
var sql = SQL /* + @" ORDER BY Role"*/;
var result = DbaseTools.ExecuteQuery <DbUser>(database, sql);
return(result);
}
public static DbCollection <DbCompany> LoadAll(int userId, Dbase database = null)
{
var sql = SQL + @" WHERE UserID=@UserID ORDER BY CompanyName";
var di = new DbItem("UserID", userId);
var result = DbaseTools.ExecuteQuery <DbCompany>(database, sql, di);
return(result);
}
public static DbCollection <DbItems> LoadAll(int proposalId, Dbase database = null)
{
var sql = SQL + @" WHERE ProposalID=@ProposalID ORDER BY ID";
var di = new DbItem("ProposalID", proposalId);
var result = DbaseTools.ExecuteQuery <DbItems>(database, sql, di);
return(result);
}
public static DbCollection <DbProposals> LoadTop3(int userId, Dbase database = null)
{
var sql = @"SELECT TOP 3 ID, ProposalName, DateSaved FROM Proposals WHERE UserID=@UserID ORDER BY DateSaved DESC";
var di = new DbItem("UserID", userId);
var result = DbaseTools.ExecuteQuery <DbProposals>(database, sql, di);
return(result);
}
public static DbCollection <DbProposals> LoadAll(int userId, Dbase database = null)
{
var sql = SQL + @" WHERE UserID=@UserID ORDER BY DateSaved DESC";
var di = new DbItem("UserID", userId);
var result = DbaseTools.ExecuteQuery <DbProposals>(database, sql, di);
return(result);
}
public static DbCompany Load(int coId, Dbase database = null)
{
var sql = SQL + @" WHERE ID=@ID";
var di = new DbItem("ID", coId);
DbCompany result = null;
var dc = DbaseTools.ExecuteQuery <DbCompany>(database, sql, di);
if (dc.Count > 0)
{
result = dc[0];
}
return(result);
}
public static DbItems Load(string query, Dbase database = null)
{
//var sql = SQL + @" WHERE (Username=@Username) AND (Password=@Password) ORDER BY Name";
//var di = new DbItem("Username", username, "Password", password);
DbItems result = null;
var dc = DbaseTools.ExecuteQuery <DbItems>(database /*, sql, di*/);
if (dc.Count > 0)
{
result = dc[0];
}
return(result);
}
public static DbUser Load(string username, Dbase database = null)
{
var sql = SQL + @" WHERE Username=@Username";
var di = new DbItem("Username", username);
DbUser result = null;
var dc = DbaseTools.ExecuteQuery <DbUser>(database, sql, di);
if (dc.Count > 0)
{
result = dc[0];
}
return(result);
}
public static DbProposals Load(Int32 id, Dbase database = null)
{
var sql = SQL + @" WHERE ID=@ID";
var di = new DbItem("ID", id);
DbProposals result = null;
var dc = DbaseTools.ExecuteQuery <DbProposals>(database, sql, di);
if (dc.Count > 0)
{
result = dc[0];
}
return(result);
}