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