public static List <InvoiceCatalogModel> FindInvoices(DSModel db, InvoiceCatalogFilter filter) { if (db == null) { throw new ArgumentNullException("db"); } if (filter == null) { throw new ArgumentNullException("filter"); } string sql = SqlCache.Get(db, "invoice catalog load"); List <MySqlParameter> par = new List <MySqlParameter>(); if (!string.IsNullOrWhiteSpace(filter.InvoiceNumber)) { sql = sql.Replace("#InvoiceNumber", string.Empty); par.Add(new MySqlParameter("InvoiceNumber", filter.InvoiceNumber + "%")); } if (filter.IssuedFrom.HasValue && filter.IssuedFrom.Value != DateTime.MinValue) { sql = sql.Replace("#IssuedFrom", string.Empty); par.Add(new MySqlParameter("IssuedFrom", filter.IssuedFrom.Value.Date)); } if (filter.IssuedTo.HasValue && filter.IssuedTo.Value != DateTime.MinValue) { sql = sql.Replace("#IssuedTo", string.Empty); par.Add(new MySqlParameter("IssuedTo", filter.IssuedTo.Value.Date)); } if (filter.PeriodFrom.HasValue && filter.PeriodFrom.Value != DateTime.MinValue) { sql = sql.Replace("#PeriodFrom", string.Empty); par.Add(new MySqlParameter("PeriodFrom", filter.PeriodFrom.Value.Date)); } if (filter.PeriodTo.HasValue && filter.PeriodTo.Value != DateTime.MinValue) { sql = sql.Replace("#PeriodTo", string.Empty); par.Add(new MySqlParameter("PeriodTo", filter.PeriodTo.Value.Date)); } if (!string.IsNullOrWhiteSpace(filter.CompanyID)) { sql = sql.Replace("#CompanyID", string.Empty); sql = sql.Replace("@CompanyID", filter.CompanyID); } if (!string.IsNullOrWhiteSpace(filter.LocationID)) { sql = sql.Replace("#LocationID", string.Empty); sql = sql.Replace("@LocationID", filter.LocationID); } return(db.ExecuteQuery <InvoiceCatalogModel>(sql, par.ToArray()).ToList()); }
public void AddAndGetTest() { var cache = new SqlCache(); cache.Add(typeof(TestModel), "SELECT", null, null, "Test"); Assert.AreEqual(1, cache.Count); var sql = cache.Get(typeof(TestModel), "SELECT", null, null); Assert.AreEqual("Test", sql.SqlString); }
public void GetItem() { string key = "GetItem"; string data = "data"; SqlCache cache = new SqlCache(connectionString); cache.Add(key, data, DateTime.Now.AddMinutes(30)); var getData = cache.Get(key); Assert.AreEqual(data, getData); cache.Remove(key); // Clean DB for further testing }
public void GetItem() { var key = "GetItem"; var data = "data"; var cache = new SqlCache(connectionString, serializer); cache.Add(key, data, DateTime.Now.AddMinutes(30)); var getData = cache.Get(key); Assert.AreEqual(data, getData); cache.Remove(key); // Clean DB for further testing }
public void GetItem() { // ARRANGE string key = "GetItem"; string data = "data"; SqlCache cache = new SqlCache(connectionString); cache.Add(key, data, DateTime.Now.AddMinutes(30)); // ACT var getData = cache.Get(key); // ASSERT Assert.AreEqual(data, getData); }
public static DataSet PrintInvoice(DSModel db, uint invoiceID) { if (db == null) { throw new ArgumentNullException("db"); } if (invoiceID == 0) { throw new ArgumentException("invoiceID cannot be 0!", "invoiceID"); } string sql = SqlCache.Get("invoice print"); return(db.ADO.SelectTwo(sql, new MySqlParameter("InvoiceID", invoiceID))); }
public void RemoveItem() { // ARRANGE string key = "RemoveItem"; string data = "data"; SqlCache cache = new SqlCache(connectionString); cache.Add(key, data, DateTime.Now.AddMinutes(30)); // ACT cache.Remove(key); // ASSERT var result = cache.Get(key); Assert.IsNull(result); }
public void AddOrGetExisting() { string key = "AddOrGetExisting"; string data = "data"; SqlCache cache = new SqlCache(connectionString); // Try to get data var getData = cache.Get(key); Assert.IsNull(getData); // Add new entry getData = cache.AddOrGetExisting(key, data, DateTime.Now.AddMinutes(30)); Assert.IsNull(getData); // Retrieve added entry getData = cache.AddOrGetExisting(key, data, DateTime.Now.AddMinutes(30)); Assert.IsNotNull(getData); }
public void AddOrGetExisting() { string key = "AddOrGetExisting"; string data = "data"; SqlCache cache = new SqlCache(connectionString); // Try to get data var getData = cache.Get(key); Assert.IsNull(getData); // Add new entry getData = cache.AddOrGetExisting(key, data, DateTime.Now.AddMinutes(30)); Assert.IsNull(getData); // Retrieve added entry getData = cache.AddOrGetExisting(key, data, DateTime.Now.AddMinutes(30)); Assert.IsNotNull(getData); cache.Remove(key); // Clean DB for further testing }
public void AddOrGetExisting() { var key = "AddOrGetExisting"; var data = "data"; var cache = new SqlCache(connectionString, serializer); // Try to get data var getData = cache.Get(key); Assert.IsNull(getData); // Add new entry getData = cache.AddOrGetExisting(key, data, DateTime.Now.AddMinutes(30)); Assert.IsNull(getData); // Retrieve added entry getData = cache.AddOrGetExisting(key, data, DateTime.Now.AddMinutes(30)); Assert.IsNotNull(getData); cache.Remove(key); // Clean DB for further testing }
public static List <DriverMedicalCatalogModel> FindMedicals(DSModel db, DriverMedicalFilterModel filter) { if (db == null) { throw new ArgumentNullException("db"); } if (filter == null) { throw new ArgumentNullException("filter"); } string sql = SqlCache.Get(db, "medicals catalog refresh"); List <MySqlParameter> par = new List <MySqlParameter>(); if (!string.IsNullOrWhiteSpace(filter.DriverID)) { sql = sql.Replace("#DriverID", string.Empty); sql = sql.Replace("@DriverID", filter.DriverID); } if (!string.IsNullOrWhiteSpace(filter.MedTypeID)) { sql = sql.Replace("#MedTypeID", string.Empty); sql = sql.Replace("@MedTypeID", filter.MedTypeID); } if (filter.ValidityDateFrom.HasValue) { sql = sql.Replace("#ValidityDateFrom", string.Empty); par.Add(new MySqlParameter("ValidityDateFrom", filter.ValidityDateFrom.Value.Date)); } if (filter.ValidityDateTo.HasValue) { sql = sql.Replace("#ValidityDateTo", string.Empty); par.Add(new MySqlParameter("ValidityDateTo", filter.ValidityDateTo.Value.Date)); } return(db.ExecuteQuery <DriverMedicalCatalogModel>( sql, par.ToArray()) .ToList()); }
public static List <DriverModel> FindDrivers(DSModel db, DriverFilterModel filter) { if (db == null) { throw new ArgumentNullException("db"); } if (filter == null) { throw new ArgumentNullException("filter"); } List <MySqlParameter> parameters = new List <MySqlParameter>(); string sql = SqlCache.Get(db, "drivers catalog load"); if (!string.IsNullOrWhiteSpace(filter.DriverCode)) { sql = sql.Replace("#DriverCode", string.Empty); parameters.Add(new MySqlParameter("DriverCode", filter.DriverCode + "%")); } if (!string.IsNullOrWhiteSpace(filter.FirstName)) { sql = sql.Replace("#FirstName", string.Empty); parameters.Add(new MySqlParameter("FirstName", filter.FirstName + "%")); } if (!string.IsNullOrWhiteSpace(filter.SecondName)) { sql = sql.Replace("#SecondName", string.Empty); parameters.Add(new MySqlParameter("SecondName", filter.SecondName + "%")); } if (!string.IsNullOrWhiteSpace(filter.LastName)) { sql = sql.Replace("#LastName", string.Empty); parameters.Add(new MySqlParameter("LastName", filter.LastName + "%")); } if (!string.IsNullOrWhiteSpace(filter.CellPhone)) { sql = sql.Replace("#CellPhone", string.Empty); parameters.Add(new MySqlParameter("CellPhone", filter.CellPhone + "%")); } if (!string.IsNullOrWhiteSpace(filter.Email)) { sql = sql.Replace("#Email", string.Empty); parameters.Add(new MySqlParameter("Email", filter.Email + "%")); } if (!string.IsNullOrWhiteSpace(filter.LicenseID)) { sql = sql.Replace("#LicenseID", string.Empty); sql = sql.Replace("@LicenseID", filter.LicenseID); } if (!string.IsNullOrWhiteSpace(filter.PermitID)) { sql = sql.Replace("#PermitID", string.Empty); sql = sql.Replace("@PermitID", filter.PermitID); } string isEnabled = (filter.IncludeDisabled ? "0,1" : "1"); sql = sql.Replace("@IsEnabled", isEnabled); parameters.Add(new MySqlParameter("TodayDate", DateTime.Now.Date)); return(db.ExecuteQuery <DriverModel>(sql, parameters.ToArray()) .ToList()); }