public void add(CSSaleItemDiscount csSaleItemDiscount)
{
using (context = new CSFPOSWareContext())
{
context.CSSaleItemDiscounts.Add(csSaleItemDiscount);
try
{
context.SaveChanges();
}
catch (Exception e)
{
Logger.log.Error(e.Message);
Logger.log.Error(e.StackTrace);
}
}
}
public void remove(CSSaleItemDiscount csSaleItemDiscount)
{
csSaleItemDiscount = get(csSaleItemDiscount.CSSaleItemDiscountID);
if (null != csSaleItemDiscount)
{
using (context = new CSFPOSWareContext())
{
context.CSSaleItemDiscounts.Remove(csSaleItemDiscount);
try
{
context.SaveChanges();
}
catch (Exception e)
{
Logger.log.Error(e.Message);
Logger.log.Error(e.StackTrace);
Logger.log.Error(e.InnerException.StackTrace);
}
}
}
}
public void remove(CSSaleItemTax csSaleItemTax)
{
csSaleItemTax = get(csSaleItemTax.CSSaleItemTaxID);
using (context = new CSFPOSWareContext())
{
if (null != csSaleItemTax)
{
context.CSSaleItemTaxes.Remove(csSaleItemTax);
try
{
context.SaveChanges();
}
catch (Exception e)
{
Logger.log.Error(e.Message);
Logger.log.Error(e.StackTrace);
Logger.log.Error(e.InnerException.StackTrace);
}
}
}
}
public void removeBySaleItem(CSSaleItem csSaleItem)
{
List<CSSaleItemDiscount> CSSaleItemDiscountList = null;
using (context = new CSFPOSWareContext())
{
var query = from sid in context.CSSaleItemDiscounts
where sid.CSSaleItemID == csSaleItem.CSSaleItemID
select sid;
CSSaleItemDiscountList = query.ToList();
}
using (context = new CSFPOSWareContext())
{
foreach (CSSaleItemDiscount CSSaleItemDiscount in CSSaleItemDiscountList)
{
context.CSSaleItemDiscounts.Remove(CSSaleItemDiscount);
context.SaveChanges();
}
}
}
//public void removeBySaleItem(SaleItem saleItem)
//{
// List<CSSaleItemTax> CSSaleItemTaxes = findBySaleItem(saleItem.SaleItemID);
// if (CSSaleItemTaxes != null)
// {
// using (context = new CSFPOSWareContext())
// {
// foreach (CSSaleItemTax csSaleItemTax in CSSaleItemTaxes)
// {
// Logger.log.Debug("deleting CSSaleItemTaxes...");
// context.CSSaleItemTaxes.Remove(csSaleItemTax);
// try
// {
// context.SaveChanges();
// }
// catch (Exception e)
// {
// Logger.log.Error(e.Message);
// Logger.log.Error(e.StackTrace);
// Logger.log.Error(e.InnerException.StackTrace);
// }
// }
// }
// }
// else
// {
// Logger.log.Debug("no CSSaleItemTaxes to delete");
// }
//}
public void removeBySaleItem(CSSaleItem csSaleItem)
{
List<CSSaleItemTax> CSSaleItemTaxList = null;
using (context = new CSFPOSWareContext())
{
var query = from sit in context.CSSaleItemTaxes
where sit.CSSaleItemID == csSaleItem.CSSaleItemID
select sit;
CSSaleItemTaxList = query.ToList();
}
using (context = new CSFPOSWareContext())
{
foreach (CSSaleItemTax CSSaleItemTax in CSSaleItemTaxList)
{
context.CSSaleItemTaxes.Remove(CSSaleItemTax);
context.SaveChanges();
}
}
}
public List<CSSaleItem> removeByCSSale(CSSale CSSale)
{
List<CSSaleItem> CSSaleItemList = null;
using (context = new CSFPOSWareContext())
{
var query = from si in context.CSSaleItems
where si.CSSaleID == CSSale.CSSaleID
select si;
CSSaleItemList = query.ToList();
}
using (context = new CSFPOSWareContext())
{
foreach (CSSaleItem CSSaleItem in CSSaleItemList)
{
context.CSSaleItems.Remove(CSSaleItem);
context.SaveChanges();
}
}
return CSSaleItemList;
}