/// <summary> /// /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> public void dataBind(int pageIndex = 1, int pageSize = 10, string startTime = null, string endTime = null) { PetaPoco.Sql sql = new PetaPoco.Sql(); sql.Select("m.[description] as name,a.*").From("t_MachineStop_rd a"); sql.LeftJoin("Point_Machine_Map m").On("m.pointname=a.pointname"); if (!String.IsNullOrEmpty(startTime)) { sql.Where("a.starttime>@0", startTime); } if (!String.IsNullOrEmpty(endTime)) { sql.Where("a.starttime<@0", endTime); } List<int> machineids = new List<int>(); for (int i = 0; i < chkboxlist.Items.Count; i++) { if (chkboxlist.Items[i].Selected) { machineids.Add(int.Parse(chkboxlist.Items[i].Value)); } } if (machineids.Count > 1) sql.Where("m.machineid in (@0)", machineids); else if (machineids.Count == 1) sql.Where("m.machineid=@0", machineids[0]); sql.OrderBy("a.starttime desc"); var db = new PetaPoco.Database("dbconn"); PetaPoco.Page<BootRecordSelect> pageitems = db.Page<BootRecordSelect>(pageIndex, pageSize, sql); rpt_RulelogS_Des.DataSource = pageitems.Items; rpt_RulelogS_Des.DataBind(); AspNetPager1.RecordCount = (int)pageitems.TotalItems; }
public override bool Add() { try { PetaPoco.Sql query = PetaPoco.Sql.Builder .Append("SELECT * FROM Students") .Append("WHERE FirstName=@0 AND LastName=@1", FirstName, LastName); var a = db.Fetch <Student>(query); if (a.Count > 0) { //If so, return false and state the error // this.Error = "Duplicates not allowed."; return(false); } //Try to insert using (var scope = db.GetTransaction()) { db.Insert("Students", "StudentId", this); scope.Complete(); } } catch { // this.Error = "Opened database, but couldn't save."; return(false); } return(true); }
public ActionResult Bill(int id, ItemTypesEnum ite) { ViewBag.Order = db.Single <OrderTicket>(id); PetaPoco.Sql sq = new PetaPoco.Sql("Select od.*, ItemName from orderTicketDetails od, Items i where od.itemId=i.ItemId and OTID=@0", id); switch (ite) { case ItemTypesEnum.DrinksNAlc: { sq.Append(" and i.itemTypeId <>@0", ItemTypesEnum.DrinksAlc); break; } case ItemTypesEnum.DrinksAlc: { sq.Append(" and i.itemTypeId =@0", ItemTypesEnum.DrinksAlc); break; } default: break; } ViewBag.orderDetails = db.Query <OrderDetailsVw>(sq); return(View()); }
// GET: Reports public ActionResult Index(int?VehicleId, int?ticketno, int?SupplierId, int?MaterialId) { ViewBag.MaterialId = new SelectList(db.Fetch <Material>("Select MaterialId,MaterialName from Material"), "MaterialId", "MaterialName"); ViewBag.SupplierId = new SelectList(db.Fetch <Supplier>("Select SupplierId,SupplierName from Supplier"), "SupplierId", "SupplierName"); ViewBag.VehicleId = new SelectList(db.Fetch <VeichleEntry>("Select VeichleId,VeichleNumber from VeichleEntry"), "VeichleId", "VeichleNumber"); PetaPoco.Sql sq = new PetaPoco.Sql("Select t.TicketNo,u.UnitId,u.UnitName,vc.VeichleId,vc.VeichleNumber, " + "t.LoadedWeight,t.EmptyWeight,t.NetWeight,t.RecievedAmt,t.Tdate,su.SupplierId,su.SupplierName,mt.MaterialId,mt.MaterialName from Transactions t " + "inner join Units u on u.UnitId=t.UnitId " + "inner join VeichleEntry vc on vc.VeichleId=t.VeichleId " + "inner join Supplier su on su.SupplierId=t.SupplierId " + "inner join Material mt on mt.MaterialId=t.MaterialId where 1=1"); if (VehicleId != null) { sq.Append($" and vc.VeichleId = {VehicleId}"); } if (ticketno != null) { sq.Append($" and t.TicketNo = {ticketno}"); } if (SupplierId != null) { sq.Append($" and su.SupplierId = {SupplierId}"); } if (MaterialId != null) { sq.Append($" and mt.MaterialId = {MaterialId}"); } var rs = db.Query <Transactionvw>(sq); return(View("Index", rs)); }
public DataTable getEx_Data(int Pl_Code, IList <CRMTreeDatabase.EX_Param> eps) { try { CT_Reports Report = RP.GetReprot_Chat(ChartType.List, Pl_Code); var db = CRMTreeDatabase.DBCRMTree.GetInstance(); PetaPoco.Sql _s = BL_Reports.GetReportSql(Report.RP_Code, eps); var qData = new object(); if (_s.SQL.IndexOf(";Exec", StringComparison.OrdinalIgnoreCase) >= 0) { qData = db.Query <dynamic>(_s); } else { var pSql = PetaPoco.Sql.Builder; pSql.Append("select * from(" + _s.SQL, _s.Arguments); pSql.Append(") as dt"); qData = db.Query <dynamic>(pSql); } //Report.RP_Query = _s.SQL; //DataTable dt = BL_Reports.GetReportSqlWithTemplate(Report.RP_Query); //return dt; string _j_d = JsonConvert.SerializeObject(qData); DataTable _d = ToDataTable(_j_d); return(_d); } catch { return(null); } }
private long Count(string clientName, bool completed, DateTime?clientStartTime) { var parameters = new QueryParameters(); parameters.Fields.Add(new QueryField { Name = QueryFieldName.Name, Type = QueryFieldType.Equal, Value = clientName }); parameters.Fields.Add(new QueryField { Name = QueryFieldName.Result, Type = completed ? QueryFieldType.Equal : QueryFieldType.NotEqual, Value = (int)WorkUnitResult.FinishedUnit }); if (clientStartTime.HasValue) { parameters.Fields.Add(new QueryField { Name = completed ? QueryFieldName.CompletionDateTime : QueryFieldName.DownloadDateTime, Type = QueryFieldType.GreaterThan, Value = clientStartTime.Value }); } PetaPoco.Sql where = WhereBuilder.Execute(parameters); var countSql = PetaPoco.Sql.Builder.Select("ID", "InstanceName", "DownloadDateTime", "CompletionDateTime", "Result", "COUNT(*)") .From("WuHistory") .Append(where); using (var table = Select(countSql.SQL, countSql.Arguments)) { return((long)table.Rows[0][5]); } }
public PartialViewResult RelationFieldSelectPanelMulti(int fieldid, string value = "", int id = 0, string filter = "", int height = 310, string page = "list") { ViewBag.ID = id; ViewBag.Value = value; ViewBag.WhereSql = filter; ViewBag.SelectValue = new List <RelationEntityField>(); Repository <RelationEntityField> crmRepository = new Repository <RelationEntityField>(); var entity = fieldService.Get(fieldid).Data; ViewBag.Field = entity.Name; var RelationEntityID = SystemSetService.Entity.GetEntityID(entity.RelationEntity); ViewBag.EntityID = RelationEntityID; ViewBag.RelationEntity = entity.RelationEntity; var ViewObj = SystemSetService.View.GetViewByTypeEntityID(RelationEntityID, ViewTypeEnum.弹框视图.ToString()); ViewBag.Columns = ViewObj.FieldList; ViewBag.ViewID = ViewObj.ID; ViewBag.page = page; ViewBag.SearchField = SystemSetService.Search.GetDialogSearchFields(RelationEntityID); if (!string.IsNullOrEmpty(value)) { var sql = new PetaPoco.Sql("SELECT ID,Name FROM " + entity.RelationEntity); sql.Where("ID IN(" + value + ")"); ViewBag.SelectValue = crmRepository.GetList <RelationEntityField>(sql); } ViewBag.height = height; return(PartialView()); }
public int UndoUpdate(LogMySqlDataModel LogToUpdate) { try { using (AsignioDatabase db = new AsignioDatabase(ConnectionStringName)) { string sqlFormattedTimeStamp = LogToUpdate.DateTimeStamp.ToString("yyyy-MM-dd HH:mm:ss"); PetaPoco.Sql sql = new PetaPoco.Sql(); string nullString = "null"; sql.Append("SET SQL_SAFE_UPDATES = 0; "); sql.Append(string.Format("UPDATE logmysql SET Important = {0} ", nullString)); string where = string.Format("WHERE DateTimeStamp = \"{0}\" AND logmysql.Function = \"{1}\" AND Message = \"{2}\" AND Type = \"{3}\"; ", sqlFormattedTimeStamp, LogToUpdate.Function, LogToUpdate.Message, LogToUpdate.Type); sql.Append(where); sql.Append("SET SQL_SAFE_UPDATES = 1; "); db.Execute(sql); return(1); } } catch (Exception ex) { string errorMessage = ex.Message; return(0); } finally { } }
public int UndoUpdate(CombinedLogDataModel LogToUpdate) { try { using (AsignioDatabase db = new AsignioDatabase(ConnectionStringName)) { string sqlFormattedTimeStamp = LogToUpdate.TimeStamp.ToString("yyyy-MM-dd HH:mm:ss"); PetaPoco.Sql sql = new PetaPoco.Sql(); string nullString = "null"; sql.Append("SET SQL_SAFE_UPDATES = 0; "); sql.Append(string.Format("UPDATE log SET Important = {0} ", nullString)); string where = string.Format("WHERE TimeStamp = \"{0}\" AND LogID = GuidToBinary(\"{1}\") AND Level = \"{2}\" AND Source = \"{3}\" ; ", sqlFormattedTimeStamp, LogToUpdate.LogID, LogToUpdate.Level, LogToUpdate.Source); sql.Append(where); sql.Append("SET SQL_SAFE_UPDATES = 1; "); db.Execute(sql); return(1); } } catch (Exception ex) { string errorMessage = ex.Message; return(0); } finally { } }
public IEnumerable <Theatre> GetTheatres(int id) { using var db = new PetaPoco.Database(ConnectionString, providerName); var cmd = new PetaPoco.Sql(";EXEC BookMyShowDb1.dbo.GetTheatres @@movieId = @0", id); var Theatres = db.Fetch <Theatre>(cmd); return(Theatres); }
/// <summary> /// wraps up the process of starting an IDatabase instace, executing the query, and closing out the IDatabase instance /// </summary> /// <typeparam name="T"></typeparam> /// <param name="sql"></param> /// <returns></returns> protected IEnumerable <T> Query <T>(PetaPoco.Sql sql) { using (var db = this.GetDatabase()) { return(db.Query <T>(sql) .ToList()); } }
/// <summary> /// Select文の結果をDataTableで返します /// (DataTableをそのまんまWCFで返すのはやめよう) /// </summary> /// <param name="sql">SQL object</param> /// <returns>SELECT文の結果</returns> public DataTable GetDataTable(PetaPoco.Sql sql) { if (sql == null) { throw new ArgumentNullException(nameof(sql)); } return(GetDataTable(sql.SQL, sql.Arguments.ToArray())); }
void HandleSpawnIdlerCommand(string msg, SteamID sender) { string[] args = msg.Split(' '); if (args.Length != 2) { SteamFriends.SendChatMessage(sender, EChatEntryType.ChatMsg, "Invalid arguments."); return; } int id = 0; if (!int.TryParse(args[1], out id)) { SteamFriends.SendChatMessage(sender, EChatEntryType.ChatMsg, "Invalid idler id."); return; } #if DATABASE var sql = new PetaPoco.Sql().Select("*").From("account") .Where("id = @0", id); var accounts = Database.Query <IdleAccount>(sql); foreach (var account in accounts) { var credentials = new BotCredentials() { Username = account.username, Password = account.password, IdlerId = account.id }; SteamFriends.SendChatMessage(sender, EChatEntryType.ChatMsg, string.Format("Spawning idler bot: id {0} {1}", account.id, account.username)); var logger = new SteamLogger() { Id = sender, SteamFriends = SteamFriends }; var idlebot = new Bot(logger, ItemsSchema, credentials); idlebot.OnWebLoggedOn += (b) => { b.SteamFriends.SetPersonaState(EPersonaState.Online); }; idlebot.Initialize(useUDP: true); idlebot.Connect(); IdlerBots.Add(idlebot); } #endif }
public List <TicketViewModel> GetAllTickets() { using (var db = new PetaPoco.Database(ConnectionString, providerName)) { var cmd = new PetaPoco.Sql(";EXEC BookMyShowDb1.dbo.GetAllTickets"); List <TicketViewModel> Tickets = db.Fetch <TicketViewModel>(cmd); return(Tickets); } }
public IEnumerable <TicketViewModel> GetTickets(string userid) { using (var db = new PetaPoco.Database(ConnectionString, providerName)) { var cmd = new PetaPoco.Sql(";EXEC BookMyShowDb1.dbo.GetUserTickets @@userid = @0", userid); var Tickets = db.Fetch <TicketViewModel>(cmd); return(Tickets); } }
public void Join_GivenTable() { _sql = PetaPoco.Sql.Builder .Select("*") .From("articles") .LeftJoin("comments").On("articles.article_id=comments.article_id"); Assert.Equal("SELECT *\r\nFROM articles\r\nLEFT JOIN comments\r\nON articles.article_id=comments.article_id", _sql.SQL); }
public void Append_GivenConsecutiveSets() { _sql = new PetaPoco.Sql() .Append("UPDATE blah"); _sql.Append("SET a = 1"); _sql.Append("SET b = 2"); Assert.Equal("UPDATE blah\r\nSET a = 1\r\n, b = 2", _sql.SQL); }
public void Append_GivenConsecutiveWheres() { _sql = new PetaPoco.Sql() .Append("SELECT * FROM blah"); _sql.Append("WHERE x"); _sql.Append("WHERE y"); Assert.Equal("SELECT * FROM blah\r\nWHERE x\r\nAND y", _sql.SQL); }
public void Append_GivenArray() { _sql = PetaPoco.Sql.Builder.Append("IN (@numbers)", new { numbers = (new[] { 10, 20, 30 }) }); Assert.Equal("IN (@0,@1,@2)", _sql.SQL); Assert.Equal(3, _sql.Arguments.Count); Assert.Equal(10, _sql.Arguments[0]); Assert.Equal(20, _sql.Arguments[1]); Assert.Equal(30, _sql.Arguments[2]); }
public void Append_GivenConsecutiveOrderBys() { _sql = new PetaPoco.Sql() .Append("SELECT * FROM blah"); _sql.Append("ORDER BY x"); _sql.Append("ORDER BY y"); Assert.Equal("SELECT * FROM blah\r\nORDER BY x\r\n, y", _sql.SQL); }
private Database queryForDatabase() { var sql = new PetaPoco.Sql(@"SELECT DatabaseName , ObjectId , EP.value AS [Description] FROM ( SELECT DB_NAME() AS DatabaseName, DB_ID() AS ObjectId ) AS DbInfo LEFT OUTER JOIN sys.extended_properties AS EP ON ( EP.class = 0 AND EP.[name] = 'MS_Description' );"); return this.peta.FirstOrDefault<Database>(sql); }
private Database queryForDatabase() { var sql = new PetaPoco.Sql(@"SELECT DatabaseName , ObjectId , EP.value AS [Description] FROM ( SELECT DB_NAME() AS DatabaseName, DB_ID() AS ObjectId ) AS DbInfo LEFT OUTER JOIN sys.extended_properties AS EP ON ( EP.class = 0 AND EP.[name] = 'MS_Description' );" ); return(this.peta.FirstOrDefault <Database>(sql)); }
public void Append_GivenConsecutiveSetsAndWheres() { _sql = new PetaPoco.Sql() .Append("UPDATE blah"); _sql.Append("SET a = 1"); _sql.Append("SET b = 2"); _sql.Append("WHERE x"); _sql.Append("WHERE y"); Assert.Equal("UPDATE blah\r\nSET a = 1\r\n, b = 2\r\nWHERE x\r\nAND y", _sql.SQL); }
public void Append_GivenArrayString() { var keys = new string[] { "10", "20", "30" }; //_sql = PetaPoco.Sql.Builder.Append("IN (@0)", keys); ←これはダメ。エラーになっちゃう _sql = PetaPoco.Sql.Builder.Append("IN (@1)", null, keys); Assert.Equal("IN (@0,@1,@2)", _sql.SQL); Assert.Equal(3, _sql.Arguments.Count); Assert.Equal("10", _sql.Arguments[0]); Assert.Equal("20", _sql.Arguments[1]); Assert.Equal("30", _sql.Arguments[2]); }
public void Append_GivenArrayAndValue() { // Simple collection parameter expansion _sql = PetaPoco.Sql.Builder.Append("@0 IN (@1) @2", 20, new int[] { 1, 2, 3 }, 30); Assert.Equal("@0 IN (@1,@2,@3) @4", _sql.SQL); Assert.Equal(5, _sql.Arguments.Count); Assert.Equal(20, _sql.Arguments[0]); Assert.Equal(1, _sql.Arguments[1]); Assert.Equal(2, _sql.Arguments[2]); Assert.Equal(3, _sql.Arguments[3]); Assert.Equal(30, _sql.Arguments[4]); }
public JsonResult GetCarBikeList(DTParameters parameters) { var columnSearch = parameters.Columns.Select(s => s.Search.Value).Take(CarBikeColumns.Count()).ToList(); //XMLPath uses nested queries so to avoid that we construct these 4 filters ourselves string geos = ""; if (columnSearch[2]?.Length > 0) { geos = columnSearch[2]; columnSearch[2] = null; } var sql = new PetaPoco.Sql($"Select distinct c.*,Substring(Description,1,100) as Description from CarBike c"); var fromsql = new PetaPoco.Sql(); var wheresql = new PetaPoco.Sql("where c.CarBikeID >0 "); if (geos.Length > 0) { fromsql.Append(", Geotree g"); wheresql.Append($"and g.GeoTreeID=a.GeoTreeID and geoname like '%{geos}%'"); } wheresql.Append($"{GetWhereWithOrClauseFromColumns(CarBikeColumns, columnSearch)}"); sql.Append(fromsql); sql.Append(wheresql); try { var res = db.Query <CarBikeDets>(sql).Skip(parameters.Start).Take(parameters.Length).ToList(); res.ForEach(r => { r.GeoName = String.Join(", ", db.Query <string>("Select GeoName from GeoTree where GeoTreeID=@0", r.GeoTreeID)); }); var dataTableResult = new DTResult <CarBikeDets> { draw = parameters.Draw, data = res, recordsFiltered = 10, recordsTotal = res.Count() }; return(Json(dataTableResult, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw ex; } }
void HandleListIdlersCommand(string msg, SteamID sender) { #if DATABASE var sql = new PetaPoco.Sql().Select("*").From("idle_account"); string order = "id"; string[] args = msg.Split(' '); if (args.Length == 2) { if (args[1].StartsWith("w")) { order = "weapon_count"; } else if (args[1].StartsWith("i")) { order = "item_count"; } else if (args[1].StartsWith("h")) { order = "hat_count"; } else if (args[1].StartsWith("t")) { order = "weapon_count"; } else if (args[1].StartsWith("c")) { order = "crate_count"; } } sql = sql.OrderBy(order); var accounts = Database.Query <IdleAccount>(sql); var sb = new StringBuilder(); sb.AppendLine("Idlers:"); foreach (var account in accounts) { sb.AppendLine(string.Format("{0} {1} | {2} weapons", account.id, account.username, account.weapon_count)); } SteamFriends.SendChatMessage(sender, EChatEntryType.ChatMsg, sb.ToString()); #else SteamFriends.SendChatMessage(sender, EChatEntryType.ChatMsg, "No database support in this build."); #endif }
private static PetaPoco.Sql BuildWhereCondition(PetaPoco.Sql sql, WorkUnitQueryParameter parameter) { string format = "[{0}] {1} @0"; if (parameter.Column.Equals(WorkUnitRowColumn.Assigned) || parameter.Column.Equals(WorkUnitRowColumn.Finished)) { format = "datetime([{0}]) {1} datetime(@0)"; } sql = sql.Append(String.Format(CultureInfo.InvariantCulture, format, ColumnNameOverrides.ContainsKey(parameter.Column) ? ColumnNameOverrides[parameter.Column] : parameter.Column.ToString(), parameter.GetOperatorString()), parameter.Value); return(sql); }
public void Append_GivenListString() { var keys = new List <string> { "い", "ろ", "は", }; _sql = PetaPoco.Sql.Builder.Append("IN (@0)", keys); Assert.Equal("IN (@0,@1,@2)", _sql.SQL); Assert.Equal(3, _sql.Arguments.Count); Assert.Equal("い", _sql.Arguments[0]); Assert.Equal("ろ", _sql.Arguments[1]); Assert.Equal("は", _sql.Arguments[2]); }
public int Update(CombinedLogControllerActionDataModel LogToUpdate, string username) { try { using (AsignioDatabase db = new AsignioDatabase(ConnectionStringName)) { Byte[] bytes = new Byte[16]; Guid allZeros = new Guid(bytes); Guid UserID = GetUserIDFromUsername(username); if (UserID != allZeros) { if (username.Contains("@")) //format email { string[] sections = username.Split(new[] { '@' }); sections[1] = sections[1].Insert(0, "@@"); username = string.Join("", sections); } string sqlFormattedTimeStamp = LogToUpdate.TimeStamp.ToString("yyyy-MM-dd HH:mm:ss"); PetaPoco.Sql sql = new PetaPoco.Sql(); username = string.Format("\"{0}\"", username); sql.Append("SET SQL_SAFE_UPDATES = 0; "); sql.Append(string.Format("UPDATE logcontrolleraction SET Important = {0} ", username)); string where = string.Format("WHERE TimeStamp = \"{0}\" AND WebRequestID = GuidToBinary(\"{1}\") AND ControllerName = \"{2}\" AND ActionName = \"{3}\" AND UserID = GuidToBinary(\"{4}\"); ", sqlFormattedTimeStamp, LogToUpdate.WebRequestID, LogToUpdate.ControllerName, LogToUpdate.ActionName, LogToUpdate.UserID); sql.Append(where); sql.Append("SET SQL_SAFE_UPDATES = 1; "); db.Execute(sql); return(1); } else { return(0); } } } catch (Exception ex) { string errorMessage = ex.Message; } finally { } return(0); }
public void Append_GivenTwoArrays() { // Out of order expansion _sql = PetaPoco.Sql.Builder.Append("IN (@3) (@1)", null, new[] { 10, 20, 30 }, null, new[] { 40, 50, 60 }); Assert.Equal("IN (@0,@1,@2) (@3,@4,@5)", _sql.SQL); Assert.Equal(6, _sql.Arguments.Count); Assert.Equal(40, _sql.Arguments[0]); Assert.Equal(50, _sql.Arguments[1]); Assert.Equal(60, _sql.Arguments[2]); Assert.Equal(10, _sql.Arguments[3]); Assert.Equal(20, _sql.Arguments[4]); Assert.Equal(30, _sql.Arguments[5]); }
private static PetaPoco.Sql BuildWhereCondition(PetaPoco.Sql sql, QueryField queryField) { string format = "[{0}] {1} @0"; if (queryField.Name.Equals(QueryFieldName.DownloadDateTime) || queryField.Name.Equals(QueryFieldName.CompletionDateTime)) { format = "datetime([{0}]) {1} datetime(@0)"; } sql = sql.Append(String.Format(CultureInfo.InvariantCulture, format, ColumnNameOverides.ContainsKey(queryField.Name) ? ColumnNameOverides[queryField.Name] : queryField.Name.ToString(), queryField.Operator), queryField.Value); return(sql); }
// POST api/<controller> public BootRecord Post(EditBootRecord editbootRecord) { string tbname = ""; if (editbootRecord.typeid== 1) tbname = "t_MachineStop_rd"; else if(editbootRecord.typeid == 0) tbname = "t_AsyncSCR_rd"; PetaPoco.Sql sql = new PetaPoco.Sql(); sql.Select("*").From(tbname); sql.Where("id=@0", editbootRecord.id); BootRecord BootRecords = db.Fetch<BootRecord>(sql).FirstOrDefault(); if (editbootRecord != null && BootRecords != null) { PetaPoco.Sql updateSql = new PetaPoco.Sql(); BootRecords.description = editbootRecord.description; db.Update(tbname, "id", BootRecords); } return BootRecords; }
private PetaPoco.Page<HistoryEntry> PageInternal(long page, long itemsPerPage, QueryParameters parameters, BonusCalculationType bonusCalculation) { Debug.Assert(TableExists(SqlTable.WuHistory)); var select = new PetaPoco.Sql(SqlTableCommandDictionary[SqlTable.WuHistory].SelectSql); select.Append(WhereBuilder.Execute(parameters)); GetProduction.BonusCalculation = bonusCalculation; using (var connection = new SQLiteConnection(ConnectionString)) { connection.Open(); using (var database = new PetaPoco.Database(connection)) { PetaPoco.Page<HistoryEntry> query = database.Page<HistoryEntry>(page, itemsPerPage, select); Debug.Assert(query != null); return query; } } }
private IList<HistoryEntry> FetchInternal(QueryParameters parameters, BonusCalculationType bonusCalculation) { Debug.Assert(TableExists(SqlTable.WuHistory)); var select = new PetaPoco.Sql(SqlTableCommandDictionary[SqlTable.WuHistory].SelectSql); select.Append(WhereBuilder.Execute(parameters)); GetProduction.BonusCalculation = bonusCalculation; using (var connection = new SQLiteConnection(ConnectionString)) { connection.Open(); using (var database = new PetaPoco.Database(connection)) { List<HistoryEntry> query = database.Fetch<HistoryEntry>(select); return query; } } }