コード例 #1
0
        public static bool Update(ItemViewModel model)
        {
            bool result = true;

            try
            {
                using (var db = new VapeContext())
                {
                    if (model.Id == 0)
                    {
                        Mst_Item ite = new Mst_Item();
                        ite.ItemCode     = model.ItemCode;
                        ite.ItemName     = model.ItemName;
                        ite.CategoryCode = model.CategoryCode;
                        ite.Description  = model.Description;
                        ite.Stock        = ite.Stock;
                        ite.IsActive     = model.IsActive;
                        db.Mst_Item.Add(ite);
                        db.SaveChanges();
                    }
                    else
                    {
                        Mst_Item ite = db.Mst_Item.Where(o => o.Id == model.Id).FirstOrDefault();
                        if (ite != null)
                        {
                            ite.ItemCode     = model.ItemCode;
                            ite.ItemName     = model.ItemName;
                            ite.CategoryCode = model.CategoryCode;
                            ite.Description  = ite.Description;
                            ite.Stock        = ite.Stock;
                            ite.IsActive     = model.IsActive;
                            db.SaveChanges();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Message = ex.Message;
                result  = false;
            }
            return(result);
        }
コード例 #2
0
        public static bool Delete(int id)
        {
            bool result = true;

            try
            {
                using (var db = new VapeContext())
                {
                    Mst_Item ite = db.Mst_Item.Where(o => o.Id == id).FirstOrDefault();
                    if (ite != null)
                    {
                        db.Mst_Item.Remove(ite);
                        db.SaveChanges();
                    }
                }
            }
            catch (Exception ex)
            {
                Message = ex.Message;
                result  = false;
            }
            return(result);
        }