public IEnumerable <ProductSearchViewModel> GetProducts(string productName, string productCode, int categoryID)
{
try
{
return(_db.Query <ProductSearchViewModel>("prc_GetProducts", new { ProductName = productName, ProductCode = productCode, CategoryID = categoryID }, commandType: CommandType.StoredProcedure));
}
catch (Exception ex)
{
_logger.LogError(ex, "An error occurred", "", "");
throw;
}
}
public IEnumerable <ProductSearchViewModel> GetProducts(string productName, string productCode, int categoryID)
{
try
{
return(_repository.GetProducts(productName, productCode, categoryID));
}
catch (Exception ex)
{
_logger.LogError(ex, "An error occurred", "", "");
throw;
}
}
public IEnumerable <PaymentMode> GetAllPaymentModes()
{
try
{
return(_repository.GetAll());
}
catch (Exception ex)
{
_logger.LogError(ex, "An error occurred", "", "");
throw;
}
}
//#region IService<Sale,string> Members
//public Sale GetEntityID(string id)
//{
// return _saleRepository.GetById(id);
//}
//public List<Sale> GetAll()
//{
// return _saleRepository.GetAll();
//}
//public void Add(Sale bzEntity)
//{
// _saleRepository.AddObject(bzEntity);
//}
//public void Delete(Sale bzEntity)
//{
// _saleRepository.DeleteObject(bzEntity);
//}
//public void Save(Sale bzEntity)
//{
// _saleRepository.SaveObject(bzEntity);
//}
//#endregion
public decimal CalculateTax(decimal saleAmount, decimal tax)
{
try
{
decimal taxamount = ((tax / 100) * saleAmount);
return(taxamount);
}
catch (Exception ex)
{
_logger.LogError(ex, "An error occurred", "", "");
throw;
}
}
public T GetSingle(Func <T, bool> predicate)
{
try
{
return(this._repository.Query(predicate).FirstOrDefault());
}
catch (Exception ex)
{
_logger.LogError(ex, "An error occurred", "", "");
throw;
}
}
public void RollBackSaleTransaction(string invoiceNo)
{
try
{
new SaleDetailService().Remove(new SaleDetail {
InvoiceNumber = invoiceNo
});
Remove(new Sale {
InvoiceNumber = invoiceNo
});
}
catch (Exception ex)
{
_logger.LogError(ex, "An error occurred", "", "");
throw;
}
}
//#region IRepository<Sale> Members
//public Sale GetById(int id)
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// return ctx.Sales.Where(x => x.InvoiceNumber == id.ToString()).FirstOrDefault();
// }
//}
//public List<Sale> GetAll()
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// return (from s in ctx.Sales
// select s).ToList();
// }
//}
//public void SaveObject(Sale entity)
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// ctx.Sales.Attach(new Sale { InvoiceNumber = entity.InvoiceNumber });
// ctx.Sales.ApplyCurrentValues(entity);
// ctx.SaveChanges();
// }
//}
//public void AddObject(Sale entity)
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// ctx.Sales.AddObject(entity);
// ctx.SaveChanges();
// }
//}
//public void DeleteObject(Sale entity)
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// ctx.Sales.DeleteObject(new Sale { InvoiceNumber = entity.InvoiceNumber });
// ctx.SaveChanges();
// }
//}
//#endregion
//#region IRepository<Sale> Members
//public Sale GetById<Tid>(Tid id)
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// return ctx.Sales.Where(x => x.InvoiceNumber == id.ToString()).FirstOrDefault();
// }
//}
//#endregion
#region ISale Members
public void RollBackSaleTransaction(string invoiceNo)
{
try
{
using (StoreManagerDBEntities ctx = new Connection().GetContext())
{
//ctx.SaleDetails.DeleteObject(new SaleDetail { InvoiceNumber = invoiceNo });
//ctx.Sales.DeleteObject(new Sale { InvoiceNumber = invoiceNo });
ctx.SaveChanges();
}
}
catch (Exception ex)
{
_logger.LogError(ex, "An error occurred", "", "");
throw;
}
}
//#region IRepository<Product> Members
//public Product GetById(int id)
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// return ctx.Products.Where(x => x.ProductID == id).FirstOrDefault();
// }
//}
//public List<Product> GetAll()
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// return ctx.Products.Where(p => p.OnSale == true).ToList();
// }
//}
//public void SaveObject(Product entity)
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// ctx.Products.Attach(new Product { ProductID = entity.ProductID });
// ctx.Products.ApplyCurrentValues(entity);
// ctx.SaveChanges();
// }
//}
//public void AddObject(Product entity)
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// ctx.Products.AddObject(entity);
// ctx.SaveChanges();
// }
//}
//public void DeleteObject(Product entity)
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// ctx.Products.DeleteObject(new Product { ProductID = entity.ProductID });
// ctx.SaveChanges();
// }
//}
////public Product GetById(int id)
////{
//// using (StoreManagerDBEntities ctx = conn.GetContext())
//// {
//// return ctx.Products.Where(x => x.ProductID == id).FirstOrDefault();
//// }
////}
//public void Discontinue(int id)
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// Product product = ctx.Products.Where(p => p.ProductID ==id).FirstOrDefault();
// product.OnSale = false;
// SaveObject(product);
// }
//}
//#endregion
public void Discontinue(int id)
{
try
{
using (StoreManagerDBEntities ctx = new Connection().GetContext())
{
Product product = ctx.Products.Where(p => p.ProductID == id).FirstOrDefault();
product.OnSale = false;
UpdateObject(product);
}
}
catch (Exception ex)
{
_logger.LogError(ex, "An error occurred", "", "");
throw;
}
}
public void CalculateSellingPrice(decimal percent, decimal purchasePrice, out decimal sellingPrice, out decimal profitMargin)
{
try
{
decimal percentage = percent / 100;
sellingPrice = Math.Round((percentage * purchasePrice) + purchasePrice, 2);
profitMargin = Math.Round(sellingPrice - purchasePrice, 2);
}
catch (Exception ex)
{
_logger.LogError(ex, "An error occurred", "", "");
throw;
}
}
public void LogError(Exception ex, string message, string formName, string controlName)
{
try
{
_logger.LogError(ex, message, formName, controlName);
}
catch (Exception)
{
throw;
}
}
public IEnumerable <ProductSearchViewModel> GetProducts(string productName, string productCode, int categoryID)
{
try
{
var param = new DbParameter[] { new SqlParameter {
ParameterName = "@ProductName", Value = productName
},
new SqlParameter {
ParameterName = "@ProductCode", Value = productCode
},
new SqlParameter {
ParameterName = "@CategoryID", Value = categoryID
} };
return(conn.GetContext().
ExecuteStoreQuery <ProductSearchViewModel>("Exec prc_GetProducts @ProductName,@ProductCode,@CategoryID", param).ToList());
}
catch (Exception ex)
{
_logger.LogError(ex, "An error occurred", "", "");
throw;
}
}
//#region IRepository<PaymentMode,int> Members
//public PaymentMode GetById(int id)
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// return ctx.PaymentModes.Where(p => p.PaymentModeID == id).FirstOrDefault();
// }
//}
//public List<PaymentMode> GetAll()
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// return ctx.PaymentModes.ToList();
// }
//}
//public void SaveObject(PaymentMode entity)
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// ctx.PaymentModes.Attach(new PaymentMode { PaymentModeID = entity.PaymentModeID });
// ctx.PaymentModes.ApplyCurrentValues(entity);
// ctx.SaveChanges();
// }
//}
//public void AddObject(PaymentMode entity)
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// ctx.PaymentModes.AddObject(entity);
// ctx.SaveChanges();
// }
//}
//public void DeleteObject(PaymentMode entity)
//{
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// ctx.Taxes.DeleteObject(new Tax { TaxID = entity.PaymentModeID });
// ctx.SaveChanges();
// }
//}
//public PaymentMode[] GetPaymentModes()
//{
// try
// {
// using (StoreManagerDBEntities ctx = conn.GetContext())
// {
// return ctx.PaymentModes.ToArray();
// //return null;
// }
// }
// catch (Exception ex)
// {
// throw;
// }
//}
//#endregion
public PaymentMode[] GetPaymentModes()
{
try
{
using (StoreManagerDBEntities ctx = new Connection().GetContext())
{
return(ctx.PaymentModes.ToArray());
//return null;
}
}
catch (Exception ex)
{
_logger.LogError(ex, "An error occurred", "", "");
throw;
}
}
public async Task <IHttpActionResult> Post([FromBody] ErrorLogModel errorlog, int StaffId)
{
_SCResult <Models.ErrorLogModel> results = new _SCResult <Models.ErrorLogModel>();
try
{
_repo.LogError(errorlog, StaffId);
results.DeleteUnsavedChanges = true;
results.UnsavedId = errorlog.ErrorLogId;
}
catch (Exception)
{
results.DeleteUnsavedChanges = true;
results.UnsavedId = errorlog.ErrorLogId;
}
return(Ok(results));
}
public virtual IList <TEntity> GetAll()
{
try
{
IList <TEntity> results;
initializeContext();
results = this.objectSet.ToList();
return(results);
}
catch (Exception ex)
{
_logger.LogError(ex, "An error occurred", "", "");
throw;
}
finally
{
DisposeContext();
}
}
public long LogError(ErrorLog errorLog)
{
return(_errorLogRepository.LogError(errorLog));
}