public void TestDropTable()
{
Db.CreateTable("newtable", Pairing.Of("name", "text"), Pairing.Of("number", "int")).Execute();
Db.DropTable("newtable").Execute();
var table = Db.Take("information_schema.tables").Where(Pairing.Of("table_name", "newtable")).Execute();
Assert.AreEqual(0, table[0].Count);
}
public int AddAdminMessage(MessageModel messageModel)
{
return(_dataAccessService.ExecuteProcedureAsync("InsertAdminMessage", null,
Pairing.Of("@sender", messageModel.Sender),
Pairing.Of("@message", messageModel.Message),
Pairing.Of("@date", messageModel.Date),
Pairing.Of("@subject", messageModel.Subject)
).Result);
}
void CreateTestTable()
{
Db.CreateTable("test", Pairing.Of("name", "text"), Pairing.Of("age", "int")).Execute();
Db.Insert("test", Pairing.Of("name", "Marla"), Pairing.Of("age", 36)).Execute();
Db.Insert("test", Pairing.Of("name", "Susan"), Pairing.Of("age", 100)).Execute();
Db.Insert("test", Pairing.Of("name", "John"), Pairing.Of("age", 67)).Execute();
Db.Insert("test", Pairing.Of("name", "Jenna"), Pairing.Of("age", 34)).Execute();
Db.Insert("test", Pairing.Of("name", "RJ"), Pairing.Of("age", 29)).Execute();
}
public int AddComment(CommentModel commentModel)
{
return(_dataAccessService.ExecuteProcedureAsync("InsertComment", "commentId",
Pairing.Of("@content", commentModel.Content),
Pairing.Of("@userId", commentModel.UserId),
Pairing.Of("@datestamp", commentModel.DateStamp),
Pairing.Of("@eventId", commentModel.EventId),
Pairing.Of("@username", commentModel.UserName),
Pairing.Of("@parentId", commentModel.ParentCommentId)).Result);
}
public void TestInsert()
{
Db.Insert("test", Pairing.Of("name", "Bob")).Execute();
var results = Db.Take("test").Where(Pairing.Of("name", "Bob")).Execute();
Assert.IsNotNull(results);
Assert.AreEqual("Bob", results[1][0]);
Assert.AreEqual(1, results[0].Count);
Db.Delete("test").Where(Pairing.Of("name", "Bob")).Execute();
}
public int CreateQueuedDate(HouseShow houseShow, string userId)
{
bool nullTimeEnd = houseShow.TimeEnd == DateTime.MinValue;
var end = houseShow.TimeEnd;
return(_dataAccessService.ExecuteProcedureAsync("InsertShowToApprovalQueue", null,
Pairing.Of("@userId", userId),
Pairing.Of("@event", houseShow.Artists),
Pairing.Of("@venueName", houseShow.VenueName),
Pairing.Of("@timeStart", houseShow.TimeStart),
Pairing.Of("@flyerurl", houseShow.FlyerUrl),
Pairing.Of("@timeend", (nullTimeEnd) ? null : end)).Result);
}
public void TestDelete()
{
Db.Insert("test", Pairing.Of("name", "Bob")).Execute();
Db.Delete("test").Where(Pairing.Of("name", "Bob")).Execute();
var results1 = Db.Take("test").Where(Pairing.Of("name", "Bob")).Execute();
var results2 = Db.Take("test").Execute();
Assert.AreEqual(0, results1[0].Count);
Assert.AreEqual(5, results2[0].Count);
Assert.AreEqual("Marla", results2[1].Find(name => name == "Marla"));
Assert.AreEqual(-1, results2[1].FindIndex(name => name == "Bob"));
}
public void TestWhere()
{
var results = Db.Take("test").Where(Pairing.Of("name", "Susan"), Pairing.Of("id", 2)).Execute();
Assert.IsNotNull(results);
Assert.AreEqual(1, results[0].Count);
Assert.AreEqual("Susan", results[1][0]);
results = Db.Take("test").Where(Pairing.Of("age", 100)).Execute();
Assert.IsNotNull(results);
Assert.AreEqual(1, results[0].Count);
Assert.AreEqual("Susan", results[1][0]);
}
// Admin create concert
public int CreateConcertDate(LocalConcert localConcert)
{
bool nullTimeEnd = localConcert.TimeEnd == DateTime.MinValue;
var end = localConcert.TimeEnd;
// 0 : parent row Id(event), 1: child row id (concert)
return(_dataAccessService.ExecuteProcedureAsync("InsertLocalConcert", "@concertId",
Pairing.Of("@artists", localConcert.Artists),
Pairing.Of("@flyerurl", localConcert.FlyerUrl),
Pairing.Of("@timestart", localConcert.TimeStart),
Pairing.Of("@timeend", (nullTimeEnd) ? null : end),
Pairing.Of("isapproved", localConcert.IsApproved),
Pairing.Of("@venue", localConcert.VenueName)
).Result);
}
public int UseTrustedCode(string code, string userId)
{
// first check if code exists in db
int exists = _dataAccessService.ExecuteProcedureAsync("CheckTrustedCode", "@count",
Pairing.Of("@code", code)).Result;
// if exists = 1 continue, if 0 immediately exit
if (exists == 0)
{
return(exists);
}
// else, use the code
return(_dataAccessService.ExecuteProcedureAsync("UseCodeUser", null,
Pairing.Of("@codeString", code),
Pairing.Of("@userId", userId)).Result);
}
private Dictionary <int?, List <CommentModel> > GetAllComments(int eventId)
{
// Key: parentId; Value: list of child comments for that parentId
var commentDict = new Dictionary <int?, List <CommentModel> >();
var allComments
= _dataAccessService.ExecuteProcedureAsync <CommentModel>("GetAllEventComments",
Pairing.Of("@eventId", eventId)).Result.ToList();
// sort into dictionary
foreach (var comment in allComments)
{
// root case:
if (!commentDict.ContainsKey(0))
{
commentDict.Add(0, new List <CommentModel>());
}
if (comment.ParentCommentId == null)
{
commentDict[0].Add(comment);
continue;
}
// leaf case:
var parentid = comment.ParentCommentId;
if (!commentDict.ContainsKey(parentid))
{
commentDict.Add(parentid, new List <CommentModel>());
}
if (comment.ParentCommentId == null)
{
commentDict[0].Add(comment);
}
else
{
commentDict[parentid].Add(comment);
}
}
return(commentDict);
}
public int DeleteConcert(int localConcertId)
{
return(_dataAccessService.ExecuteProcedureAsync("DeleteLocalConcert", "",
Pairing.Of("@concertId", localConcertId)).Result);
}
public int CreateTrustedCode(string code, int?max)
{
return(_dataAccessService.ExecuteProcedureAsync("InsertTrustedCode", "@codeId",
Pairing.Of("@codetext", code.ToUpper()),
Pairing.Of("@maxTimes", max)).Result);
}
public int CreateTrustedCode(string code)
{
return(_dataAccessService.ExecuteProcedureAsync("InsertTrustedCode", null,
Pairing.Of("@codetext", code.ToUpper())).Result);
}
public int ApproveQueueItem(int itemId)
{
return(_dataAccessService.ExecuteProcedureAsync("ApproveQueueItem", "",
Pairing.Of("@queueId", itemId)).Result);
}
public void Awake()
{
addRecipe(DrinkType.TequilaSunrise,
Pairing.Of(SolidType.OrangeSlice, 1),
Pairing.Of(LiquidType.Tequila, 45),
Pairing.Of(LiquidType.OrangeJuice, 90),
Pairing.Of(LiquidType.Grenadine, 15)
);
addRecipe(DrinkType.Caipirinha,
Pairing.Of(SolidType.Ice, 1),
Pairing.Of(SolidType.Lime, 1),
Pairing.Of(SolidType.Sugar, 2),
Pairing.Of(LiquidType.Cachaca, 50)
);
addRecipe(DrinkType.Mojito,
Pairing.Of(SolidType.Ice, 1),
Pairing.Of(SolidType.Mint, 3),
Pairing.Of(SolidType.Sugar, 2),
Pairing.Of(LiquidType.Rum, 60),
Pairing.Of(LiquidType.LimeJuice, 30),
Pairing.Of(LiquidType.SimpleSyrup, 20),
Pairing.Of(LiquidType.Soda, 20)
);
addRecipe(DrinkType.LongIslandIcedTea,
Pairing.Of(SolidType.Ice, 1),
Pairing.Of(SolidType.LemonSlice, 1),
Pairing.Of(LiquidType.Tequila, 15),
Pairing.Of(LiquidType.Vodka, 15),
Pairing.Of(LiquidType.TripleSec, 15),
Pairing.Of(LiquidType.Gin, 15),
Pairing.Of(LiquidType.LemonJuice, 25),
Pairing.Of(LiquidType.GommeSyrup, 30),
Pairing.Of(LiquidType.Cola, 10)
);
addRecipe(DrinkType.Cosmopolitan,
Pairing.Of(SolidType.Lime, 1),
Pairing.Of(LiquidType.Vodka, 20),
Pairing.Of(LiquidType.LimeJuice, 10),
Pairing.Of(LiquidType.TripleSec, 10),
Pairing.Of(LiquidType.Cointreau, 10),
Pairing.Of(LiquidType.CranberryJuice, 20)
);
addRecipe(DrinkType.PinaColada,
Pairing.Of(SolidType.Ice, 1),
Pairing.Of(SolidType.Cherry, 1),
Pairing.Of(LiquidType.Rum, 30),
Pairing.Of(LiquidType.CoconutCream, 40),
Pairing.Of(LiquidType.PineappleJuice, 90),
Pairing.Of(LiquidType.Cream, 10)
);
addRecipe(DrinkType.CubaLibre,
Pairing.Of(SolidType.Ice, 1),
Pairing.Of(SolidType.Lime, 1),
Pairing.Of(LiquidType.Rum, 50),
Pairing.Of(LiquidType.Cola, 120),
Pairing.Of(LiquidType.LimeJuice, 10)
);
addRecipe(DrinkType.Magarita,
Pairing.Of(SolidType.Ice, 1),
Pairing.Of(SolidType.Lime, 1),
Pairing.Of(LiquidType.Tequila, 40),
Pairing.Of(LiquidType.Cointreau, 20),
Pairing.Of(LiquidType.LimeJuice, 20),
Pairing.Of(LiquidType.SimpleSyrup, 10)
);
addRecipe(DrinkType.Daiquiri,
Pairing.Of(SolidType.Ice, 1),
Pairing.Of(SolidType.Lime, 1),
Pairing.Of(LiquidType.Rum, 45),
Pairing.Of(LiquidType.LimeJuice, 25),
Pairing.Of(LiquidType.SimpleSyrup, 15)
);
addRecipe(DrinkType.RumAndCoke,
Pairing.Of(SolidType.Ice, 1),
Pairing.Of(LiquidType.Cola, 12),
Pairing.Of(LiquidType.Rum, 5),
Pairing.Of(LiquidType.LimeJuice, 2)
);
addRecipe(DrinkType.GinTonic,
Pairing.Of(SolidType.Ice, 1),
Pairing.Of(SolidType.Lime, 1),
Pairing.Of(LiquidType.Gin, 4),
Pairing.Of(LiquidType.TonicWater, 25)
);
addRecipe(DrinkType.Manhatten,
Pairing.Of(SolidType.Cherry, 1),
Pairing.Of(LiquidType.Whiskey, 40),
Pairing.Of(LiquidType.Vermouth, 20),
Pairing.Of(LiquidType.Angostura, 20)
);
//print();
}
public int DeleteQueueEntry(int queueId)
{
return(_dataAccessService.ExecuteProcedureAsync("DeleteQueueEntry", "",
Pairing.Of("@queueid", queueId)).Result);
}
public int DeleteCode(int codeId)
{
return(_dataAccessService.ExecuteProcedureAsync("DeleteTrustedCode", "",
Pairing.Of("@codeid", codeId)).Result);
}
public int DeleteShow(int showId)
{
return(_dataAccessService.ExecuteProcedureAsync("DeleteHouseShow", "",
Pairing.Of("@houseshowId", showId)).Result);
}
