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