public static void SubmitOrder(Order order)
{
using (var db = new WorkersBenefitsDB2())
{
db.orders.Add(order.ToDB());
}
}
public static bool IsWorkerPreRegistered(string idNumber)
{
using (var db = new WorkersBenefitsDB2())
{
return(db.workers.Any(item => item.id_number == idNumber));
}
}
/// <summary>
/// Returns the most featured product in the system.
/// </summary>
/// <returns></returns>
public static List <Product> GetFeaturedProduct()
{
using (var db = new WorkersBenefitsDB2())
{
return(db.products.Select(ServiceObjectsExtensions.ToSvc).ToList());
}
}
public static void SaveWorker(Worker worker)
{
using (var db = new WorkersBenefitsDB2())
{
db.Entry(worker).State = EntityState.Modified;
db.SaveChanges();
}
}
//Company Point-Of-View :::
/// <summary>
/// Returns all workers of the given company.
/// </summary>
/// <param name="companyId"></param>
/// <returns></returns>
public static List <Worker> GetAllWorkers(int companyId)
{
using (var db = new WorkersBenefitsDB2())
{
return(db.workers.Where(worker => worker.company_id == companyId).AsEnumerable()
.Select(ServiceObjectsExtensions.ToSvc)
.ToList());
}
}
public static void SetWorkerRegistered(string idNumber)
{
using (var db = new WorkersBenefitsDB2())
{
var workerToUpdate = db.workers.Single(item => item.id_number == idNumber);
db.Entry(workerToUpdate).State = EntityState.Modified;
db.SaveChanges();
}
}
//public static void SaveWorker(Worker worker)
//{
// try
// {
// using (var db = new WorkersBenefitsDB2())
// {
// db.Entry(worker).State = EntityState.Modified;
// db.SaveChanges();
// }
// }
// catch (Exception ex)
// {
// m_logger.Error(ex);
// throw;
// }
//}
public static void DeleteWorker(int workerId)
{
using (var db = new WorkersBenefitsDB2())
{
var workerToDelete = db.workers.Find(workerId);
db.workers.Remove(workerToDelete);
db.SaveChanges();
}
}
/// <summary>
/// Returns the most featured product in the given category.
/// </summary>
/// <returns></returns>
public static List <Product> GetFeaturedProduct(int categoryId)
{
using (var db = new WorkersBenefitsDB2())
{
return(db.products
.Where(item => item.category_id == categoryId).AsEnumerable()
.Select(ServiceObjectsExtensions.ToSvc).ToList());
}
}
public static Company GetCompany(int company_id)
{
using (var db = new WorkersBenefitsDB2())
{
var dbObj = db.companies
.SingleOrDefault(item => item.company_id == company_id);
return(dbObj?.ToSvc());
}
}
public static Voucher GetVoucher(int voucherId)
{
using (var db = new WorkersBenefitsDB2())
{
var dbObj = db.vouchers
.SingleOrDefault(item => item.voucher_id == voucherId);
return(dbObj?.ToSvc());
}
}
//CategoryPage:
public static Category GetCategory(int categoryId)
{
using (var db = new WorkersBenefitsDB2())
{
var dbObj = db.categories
.SingleOrDefault(item => item.category_id == categoryId);
return(dbObj?.ToSvc());
}
}
/// <summary>
/// Returns all categories in the systems.
/// sequence is returned in the order of precedence.
/// </summary>
/// <returns></returns>
public static List <Category> GetAllCategories()
{
using (var db = new WorkersBenefitsDB2())
{
return(db.categories
.Select(ServiceObjectsExtensions.ToSvc)
.OrderBy(item => item.Precedence)
.ToList());
}
}
public static Product GetProduct(int productId)
{
using (var db = new WorkersBenefitsDB2())
{
var dbObj = db.products
.SingleOrDefault(item => item.product_id == productId);
return(dbObj?.ToSvc());
}
}
public static Order GetOrder(int orderId)
{
using (var db = new WorkersBenefitsDB2())
{
var dbObj = db.orders
.SingleOrDefault(item => item.order_id == orderId);
return(dbObj?.ToSvc());
}
}
//Orders Page:
/// <summary>
/// Returns all orders associated with the given workerId.
/// </summary>
/// <param name="workerId"></param>
/// <returns></returns>
public static List <Order> GetOrders(int workerId)
{
using (var db = new WorkersBenefitsDB2())
{
return(db.orders.Where(item => item.worker_id == workerId)
.AsEnumerable()
.Select(ServiceObjectsExtensions.ToSvc)
.ToList());
}
}
//MainPage:
public static FeaturedProductsList GetFeaturedProducts()
{
using (var db = new WorkersBenefitsDB2())
{
var items = db.products.Take(10).AsEnumerable()
.Select(ServiceObjectsExtensions.ToSvc)
.OrderBy(item => item.Precedence).ToList();
return(new FeaturedProductsList(items)); //todo. add random
}
}
/// <summary>
/// Returns all vouchers of the given worker.
/// </summary>
public static List <Voucher> GetAll(int workerId)
{
using (var db = new WorkersBenefitsDB2())
{
return(db.voucher_grants.Where(item => item.worker_id == workerId)
.Select(voucherGrant => voucherGrant.voucher)
.AsEnumerable()
.Select(ServiceObjectsExtensions.ToSvc)
.ToList());
}
}
/// <summary>
/// Applies a search and returns the search results.
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public static ProductsSearchResults Search(string criteria)
{
using (var db = new WorkersBenefitsDB2())
{
var items = db.products.Take(10).AsEnumerable()
.Where(item => item.title.Contains(criteria)).AsEnumerable()
.Select(ServiceObjectsExtensions.ToSvc)
.OrderBy(item => item.Precedence).ToList();
return(new ProductsSearchResults(items)); //todo. add random
}
}
/// <summary>
///
/// </summary>
/// <param name="full">if fill with their corresponding featured products</param>
/// <returns></returns>
public static FeaturedCategoriesList GetFeaturedCategories(bool full)
{
using (var db = new WorkersBenefitsDB2())
{
var items = db.categories.Take(5).AsEnumerable()
.Select(ServiceObjectsExtensions.ToSvc)
.OrderBy(item => item.Precedence).ToList();
for (int i = 0; i < items.Count; i++) //Todo. nativize.
{
items[i].Products = GetFeaturedProducts(items[i].CategoryId).Values.ToList();
}
return(new FeaturedCategoriesList(items)); //todo. add random
}
}
/// <summary>
/// Preliminarily creates the worker (by company side)
/// </summary>
/// <param name="worker"></param>
public static void CreateWorker(Worker worker)
{
try
{
using (var db = new WorkersBenefitsDB2())
{
db.workers.Add(worker.ToDB());
db.SaveChanges();
}
}
catch (Exception ex)
{
m_logger.Error(ex);
throw;
}
}