Esempio n. 1
0
        public static List <Product> BySearch(string search)
        {
            List <Product> result = new List <Product>();

            using (var db = new XPosContext())
            {
                result = db.Products
                         .Where(p => p.Active == true &&
                                (p.Initial.Contains(search) || p.Name.Contains(search) || p.Description.Contains(search)))
                         .Take(10)
                         .ToList();
            }
            return(result);
        }
Esempio n. 2
0
        public static ResponseResult Insert(OrderHeader entity)
        {
            ResponseResult result = new ResponseResult();

            try
            {
                using (var db = new XPosContext())
                {
                    string      newRef = GetNewReference();
                    OrderHeader oh     = new OrderHeader();
                    oh.Amount    = entity.Amount;
                    oh.Reference = newRef;
                    oh.Active    = true;

                    oh.CreateBy   = "Dimas";
                    oh.CreateDate = DateTime.Now;

                    db.OrderHeaders.Add(oh);

                    foreach (var item in entity.OrderDetails)
                    {
                        OrderDetail od = new OrderDetail();
                        //OrderHeader -> Id
                        od.HeaderId  = oh.Id;
                        od.ProductId = item.ProductId;
                        od.Price     = item.Price;
                        od.Quantity  = item.Quantity;
                        od.Active    = true;

                        od.CreateBy   = "Dimas";
                        od.CreateDate = DateTime.Now;

                        db.OrderDetails.Add(od);
                    }

                    db.SaveChanges();

                    entity.Reference = newRef;
                    result.Entity    = entity;
                }
            }
            catch (Exception ex)
            {
                result.Success = false;
                result.Message = ex.Message;
            }
            return(result);
        }
Esempio n. 3
0
        public void TestInsertCategory()
        {
            Trace.WriteLine("-- Start Insert Category --");
            using (var db = new XPosContext())
            {
                //var listCategory = db.Categories.ToList();
                Category category = new Category();
                category.Initial     = "ManCo";
                category.Name        = "Main Course";
                category.Active      = true;
                category.CreatedBy   = "Atur";
                category.CreatedDate = DateTime.Now;

                db.Categories.Add(category);
                db.SaveChanges();
            }
            Trace.WriteLine("-- End Insert Category --");
        }
Esempio n. 4
0
        public void TestInsertVariant()
        {
            Trace.WriteLine("-- Start Insert Variant --");
            using (var db = new XPosContext())
            {
                //var listCategory = db.Categories.ToList();
                Variant variant = new Variant();
                variant.CategoryId  = 1;
                variant.Initial     = "DSR";
                variant.Name        = "Desert";
                variant.Active      = true;
                variant.CreatedBy   = "Atur";
                variant.CreatedDate = DateTime.Now;

                db.Variants.Add(variant);
                db.SaveChanges();
            }
            Trace.WriteLine("-- End Insert Variant --");
        }
Esempio n. 5
0
        public static Category ById(long id)
        {
            Category result = new Category();

            try
            {
                using (var db = new XPosContext())
                {
                    result = db.Categories
                             .Where(o => o.Id == id)
                             .FirstOrDefault();
                    //if (result == null)
                    //{
                    //    result = new Category();
                    //}
                }
            }
            catch (Exception ex)
            {
                throw;
            }
            return(result == null ? new Category() : result);
        }