public CSSaleItemTax get(Guid csSaleItemTaxID)
 {
     using (context = new CSFPOSWareContext())
     {
         var query = from s in context.CSSaleItemTaxes
                     where s.CSSaleItemTaxID == csSaleItemTaxID
                     select s;
         return query.FirstOrDefault();
     }
 }
Пример #2
0
 public List<Discount> getDiscounts()
 {
     using (context = new CSFPOSWareContext())
     {
         var query = from d in context.Discounts
                     orderby d.DiscountIndex
                     select d;
         return query.ToList();
     }
 }
Пример #3
0
 public Item get(string itemName)
 {
     using (context = new CSFPOSWareContext())
     {
         var query = from i in context.Items
                     where i.ItemName == itemName
                     select i;
         return query.FirstOrDefault();
     }
 }
Пример #4
0
 public List<Media> getMedia()
 {
     using (context = new CSFPOSWareContext())
     {
         var query = from m in context.Medias
                     orderby m.MediaIndex
                     select m;
         return query.ToList();
     }
 }
 public List<SaleItemDiscount> find(string saleItemID)
 {
     using (context = new CSFPOSWareContext())
     {
         var query = from sid in context.SaleItemDiscounts
                     where sid.SaleItemID.ToString() == saleItemID
                     select sid;
         return query.ToList<SaleItemDiscount>();
     }
 }
 public CSConfiguration get(string section, string parameter)
 {
     using (context = new CSFPOSWareContext())
     {
         var query = from c in context.CSConfigurations
                     where c.Section == section
                     where c.Parameter == parameter
                     select c;
         return query.FirstOrDefault();
     }
 }
 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);
         }
     }
 }
Пример #8
0
 public Sale getById(Guid saleID)
 {
     using (context = new CSFPOSWareContext())//found in BaseDAO
     {
         var query = from s in context.Sales
                     where s.SaleID.Equals(saleID)
                     select s;
         //Logger.log.Debug(query.Expression.ToString());
         //Logger.log.Debug(query.First().SaleID.ToString());
         //foreach (var s in query)
         //{
         //    Logger.log.Debug(s.SaleID);
         //}
         return query.FirstOrDefault();
     }
 }
Пример #9
0
 public List<SaleItem> find(string saleID)
 {
     using (context = new CSFPOSWareContext())
     {
         var query = from si in context.SaleItems
                     where si.SaleID.ToString() == saleID
                     orderby si.ItemIndex
                     select si;
         //Logger.log.Debug(query.Expression.ToString());
         //Logger.log.Debug(query.First().SaleID.ToString());
         //foreach (var s in query)
         //{
         //    Logger.log.Debug(s.SaleID);
         //}
         return query.ToList<SaleItem>();
     }
 }
Пример #10
0
 public Sale get(Guid saleID)
 {
     using (context = new CSFPOSWareContext())//found in BaseDAO
     {
         var query = from s in context.Sales
                     where s.IsSuspend.Equals(true) //bit converts to boolean
                     where s.IsRetrieved.Equals(1) //but tinyint does not. @#$%!!@#
                     select s;
         //Logger.log.Debug(query.Expression.ToString());
         //Logger.log.Debug(query.First().SaleID.ToString());
         //foreach (var s in query)
         //{
         //    Logger.log.Debug(s.SaleID);
         //}
         return query.FirstOrDefault();
     }
 }
Пример #11
0
 public List<CSSaleItemTax> findBySaleItem(Guid saleItemID)
 {
     List<CSSaleItemTax> CSSaleItemTaxList = null;
     using (context = new CSFPOSWareContext())
     {
         var query = from sit in context.CSSaleItemTaxes
                     where sit.CSSaleItemID == saleItemID
                     select sit;
         try
         {
             CSSaleItemTaxList = query.ToList();
         }
         catch (Exception e)
         {
             //Logger.log.Error(e.Message);
             //Logger.log.Error(e.StackTrace);
         }
         return CSSaleItemTaxList;
     }
 }
        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 CSSaleItemDiscount get(Guid csSaleItemDiscountID)
 {
     CSSaleItemDiscount CSSaleItemDiscount = null;
     using (context = new CSFPOSWareContext())
     {
         var query = from d in context.CSSaleItemDiscounts
                     where d.CSSaleItemDiscountID == csSaleItemDiscountID
                     select d;
         try
         {
             CSSaleItemDiscount = query.FirstOrDefault();
         }
         catch (Exception e)
         {
             //Logger.log.Error(e.Message);
             //Logger.log.Error(e.StackTrace);
         }
         return CSSaleItemDiscount;
     }
 }
Пример #14
0
 public CSSaleItem get(Guid saleItemID)
 {
     CSSaleItem CSSaleItem = null;
     using (context = new CSFPOSWareContext())
     {
         var query = from s in context.CSSaleItems
                     where s.CSSaleItemID == saleItemID
                     select s;
         //return query.FirstOrDefault();
         try
         {
             CSSaleItem = query.FirstOrDefault();
         }
         catch (Exception e)
         {
             Logger.log.Error(e.Message);
             Logger.log.Error(e.StackTrace);
         }
         return CSSaleItem;
     }
 }
 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);
             }
         }
     }
 }
Пример #16
0
 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);
             }
         }
     }
 }
Пример #17
0
        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;
        }
Пример #18
0
        //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();
                }
            }
        }