/// <summary>
/// Get a new empty Sale object ready to fill
/// </summary>
/// <returns></returns>
public Sale GetNewSale()
{
Sale returnValue;
try
{
NANEntities dbContext = new NANEntities();
returnValue = dbContext.Sales.Create();
}
catch (Exception ex)
{
returnValue = null;
mLastErrorMessage = "error occurred" + ex.Message;
}
return returnValue;
}
/// <summary>
/// Get the list of sales for just the specified day
/// </summary>
/// <param name="vSearchDate"></param>
/// <returns></returns>
public List<Sale> ListSalesByDate(DateTime vSearchDate)
{
List<Sale> returnList = new List<Sale>();
try
{
NANEntities dbContext = new NANEntities();
// get the date from the searchdate and tomorrow in order to bracket the search interval
DateTime justDate = vSearchDate.Date;
DateTime plusOneDay = justDate.AddDays(1);
var query = dbContext.Sales.Where(s => EntityFunctions.TruncateTime(s.SaleDate) >= justDate && EntityFunctions.TruncateTime(s.SaleDate) < plusOneDay)
.Select(s => s);
returnList = query.ToList();
}
catch (Exception ex)
{
mLastErrorMessage = "error occurred" + ex.Message;
}
return returnList;
}
public bool SaveNewSale(Sale vSale)
{
bool returnStatus = true;
try
{
NANEntities dbContext = new NANEntities();
dbContext.Sales.Add(vSale);
dbContext.SaveChanges();
dbContext.Entry<Sale>(vSale).Reload();
}
catch (Exception ex)
{
mLastErrorMessage = "error occurred" + ex.Message;
returnStatus = false;
}
return returnStatus;
}