public void PopulateTransactionList()
{
QueryResultRows <FranchiseTransaction> list = Db.SQL <FranchiseTransaction>("SELECT t FROM FranchiseTransaction t WHERE t.Franchise = ?", franchise);
foreach (var trans in list)
{
AddTransaction(trans);
}
}
public Response Respond <T>(QueryResultRows <T> rows)
{
var content = BuildResponseString(rows);
return(new Response()
{
Body = content,
StatusCode = 200
});
}
private void UpdateCorps()
{
this.CorpList.Clear();
QueryResultRows <Corporation> corps = Db.SQL <Corporation>("SELECT c FROM Corporation c");
foreach (Corporation corp in corps)
{
CorpDetails corpDetails = (CorpDetails)Self.GET("/Mohamad/partial/corp/" + corp.GetObjectID());
this.CorpList.Add(corpDetails);
}
}
public static void Main()
{
Handle.GET(AppName + "/CreateNewEntry", () =>
{
CreateEntry();
return("One new entry created");
});
Handle.GET(AppName + "/CreateNewEntry/{?}", (int count) =>
{
if (count <= 0)
{
return($"argument: \"{count}\" needs to be strict greater than 0");
}
for (int i = 0; i < count; i++)
{
CreateEntry();
}
return($"{count} entries created");
});
Handle.GET(AppName + "/DeleteAll", () =>
{
QueryResultRows <ScAppDb> entries = Db.SQL <ScAppDb>(GetAllDbEntriesCommand);
List <ScAppDb> entryList = entries.ToList();
int count = entryList.Count();
Db.Transact(() =>
{
foreach (ScAppDb entry in entryList)
{
entry.Delete();
}
});
return($"{count} entries deleted");
});
Handle.GET(AppName + "/ListAll", () =>
{
QueryResultRows <ScAppDb> entries = Db.SQL <ScAppDb>(GetAllDbEntriesCommand);
string output = $"\"{GetAllDbEntriesCommand}\" entries: " + Environment.NewLine;
foreach (ScAppDb entry in entries)
{
output += $"Name: {entry.Name}, Integer: {entry.Integer}, DateCreated: {entry.DateCreated}" + Environment.NewLine;
}
return(output);
});
}
void PopulateFranchiseList()
{
try
{
if (Data != null)
{
QueryResultRows <Franchise> FranchiseLists = Db.SQL <Franchise>("SELECT f FROM Franchise f WHERE f.Corporation = ?", Data);
foreach (var franchise in FranchiseLists)
{
AddFranchiseVM(franchise);
}
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
}
string BuildResponseString <T>(QueryResultRows <T> rows)
{
var b = new StringBuilder();
b.Append("<html>");
b.Append("<head><style>table, th, td { border: 1px solid black; padding: 5px; } table { border - spacing: 5px; }</style ></head>");
b.Append("<body>");
b.Append("<table>");
int count = 0;
foreach (var r in rows)
{
var view = r as IObjectView;
var tb = view.TypeBinding;
if (count == 0)
{
// Define column headers
b.Append("<tr>");
for (int i = 0; i < tb.PropertyCount; i++)
{
var p = tb.GetPropertyBinding(i);
b.AppendFormat("<th>{0}</th>", p.Name);
}
b.Append("</tr>");
}
count++;
b.Append("<tr>");
reader.AllValues(view, (prop, name, value) => {
b.AppendFormat("<td>{0}</td>", value);
});
b.Append("</tr>");
}
b.Append("</table>");
b.Append("</body></html>");
return(b.ToString());
}
void SortFranchiseList(SortType type)
{
try
{
if (Data != null)
{
string TypeString = "";
switch (type)
{
case SortType.NumberOfHomes:
TypeString = "NumberOfHomesSold";
break;
case SortType.TotalCommission:
TypeString = "TotalCommission";
break;
case SortType.AverageCommission:
TypeString = "AverageCommision";
break;
case SortType.Trend:
TypeString = "Trend";
break;
}
string QueryString = string.Format("SELECT f FROM Franchise f WHERE f.Corporation = ? ORDER BY f.{0}", TypeString);
FranchiseList.Clear();
QueryResultRows <Franchise> FranchiseLists = Db.SQL <Franchise>(QueryString, Data);
foreach (var franchise in FranchiseLists)
{
AddFranchiseVM(franchise);
}
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
}
public StarcounterCollection()
{
this.Query = Db.SQL <T>(this.GetSqlQuery());
}
static void Main()
{
Application.Current.Use(new HtmlFromJsonProvider());
Application.Current.Use(new PartialToStandaloneHtmlProvider());
Handle.GET("/Ahmed", () =>
{
var agency = (AgencyJson)Self.GET("/Ahmed/agency");
agency.Html = "/Ahmed/AgencyJson.html";
return(agency);
});
Handle.GET("/Ahmed/company/{?}", (string id) =>
{
return(Db.Scope(() =>
{
Company Company = Db.SQL <Company>("SELECT c FROM Ahmed.Company c WHERE ObjectID=?", id).First;
QueryResultRows <Sale> Sales = Db.SQL <Sale>("SELECT s FROM Ahmed.Sale s WHERE s.Company.ObjectID=?", id);
CompanyDataJson CompanyData = (CompanyDataJson)Self.GET("/Ahmed/company/data");
if (Company.Address == null)
{
Company.Address = new Address
{
Street = "",
Number = "",
Zip = "",
City = "",
Country = ""
};
}
CompanyData.Company.Data = Company;
CompanyData.Sales.Data = Sales;
return CompanyData;
}));
});
Handle.GET("/Ahmed/company/data", () =>
{
CompanyDataJson CompanyData = new CompanyDataJson();
CompanyData.Html = "/Ahmed/CompanyDataJson.html";
if (Session.Current == null)
{
Session.Current = new Session(SessionOptions.PatchVersioning);
}
CompanyData.Session = Session.Current;
return(CompanyData);
});
Handle.GET("/Ahmed/agency", () =>
{
return(Db.Scope(() =>
{
var agency = Db.SQL <Agency>("SELECT a FROM Agency a").First;
if (agency == null)
{
agency = new Agency
{
Name = ""
};
}
var json = new AgencyJson
{
Data = agency
};
if (Session.Current == null)
{
Session.Current = new Session(SessionOptions.PatchVersioning);
}
json.Session = Session.Current;
return json;
}));
});
}
