Пример #1
0
        void ObjeSec(ModelObjects.ObjectEnum objectEnum)
        {
            DialogResult dialogResult;
            FrmObjeList  objeSec;

            switch (objectEnum)
            {
            case ModelObjects.ObjectEnum.Marka:
                objeSec      = new FrmObjeList(ModelObjects.ObjectEnum.Marka, 0);
                dialogResult = objeSec.ShowDialog();
                if (dialogResult == DialogResult.OK)
                {
                    _brand            = (PRODUCT_BRANDS)objeSec.secilenObje;
                    btnEditMarka.Text = _brand.BRAND_NAME;
                }
                break;

            case ModelObjects.ObjectEnum.Model:
                objeSec      = new FrmObjeList(ModelObjects.ObjectEnum.Model, 0);
                dialogResult = objeSec.ShowDialog();
                if (dialogResult == DialogResult.OK)
                {
                    _model            = (PRODUCT_BRANDS_MODEL)objeSec.secilenObje;
                    btnEditModel.Text = _model.MODEL_NAME;
                }
                break;

            case ModelObjects.ObjectEnum.Birim:
                objeSec      = new FrmObjeList(ModelObjects.ObjectEnum.Birim, 0);
                dialogResult = objeSec.ShowDialog();
                if (dialogResult == DialogResult.OK)
                {
                    _birim            = (SETUP_UNIT)objeSec.secilenObje;
                    btnEditBirim.Text = _birim.UNIT;
                }
                break;

            case ModelObjects.ObjectEnum.UrunKategori:
                objeSec      = new FrmObjeList(ModelObjects.ObjectEnum.UrunKategori, 0);
                dialogResult = objeSec.ShowDialog();
                if (dialogResult == DialogResult.OK)
                {
                    _urunKategori        = (PRODUCT_CAT)objeSec.secilenObje;
                    btnEditKategori.Text = _urunKategori.PRODUCT_CAT1;
                }
                break;
            }
        }
Пример #2
0
        public void ObjeIslemler2(ObjectEnum objectEnum, ObjectIslem objectIslem, object obje, int iliskiliObjeId, GridControl gridControl)
        {
            switch (objectEnum)
            {
            case ObjectEnum.Marka:
                var            brand = (DataRowView)obje;
                PRODUCT_BRANDS productBrand;
                BindingSource  bi = new BindingSource();
                switch (objectIslem)
                {
                case ObjectIslem.Ekle:
                    /*  productBrand = new PRODUCT_BRANDS
                     * {
                     *    BRAND_NAME = (string) brand["Marka"]
                     * };
                     * _dbproductContext.PRODUCT_BRANDS.Add(productBrand);
                     */

                    _dbproductContext.SaveChanges();
                    break;

                case ObjectIslem.Guncelle:
                    int id = (int)brand["Id"];
                    productBrand            = _dbproductContext.PRODUCT_BRANDS.FirstOrDefault(b => b.BRAND_ID == id);
                    productBrand.BRAND_NAME = brand["Marka"].ToString();
                    _dbproductContext.Entry(productBrand).State = System.Data.Entity.EntityState.Modified;
                    _dbproductContext.SaveChanges();
                    break;

                case ObjectIslem.Listele:

                    _dbproductContext.PRODUCT_BRANDS.Load();
                    // This line of code is generated by Data Source Configuration Wizard

                    bi.DataSource          = _dbproductContext.PRODUCT_BRANDS.Local.ToBindingList();
                    gridControl.DataSource = bi;

                    /*  List<MyGridView> objeList = (from pbs in _dbproductContext.PRODUCT_BRANDS
                     *                              select new MyGridView()
                     *                         {
                     *                             Id= pbs.BRAND_ID,Deger = pbs.BRAND_NAME,
                     *                             kolonAdi = ObjectEnum.Marka.ToString()
                     *                         }
                     *   ).ToList();
                     *
                     * ds = new DataSet();
                     * ds.Tables.Add(GetDataSource(objeList));
                     * gridControl.DataSource = ds.Tables[0];*/
                    break;
                }
                break;

            case ObjectEnum.Model:
                var model = (DataRowView)obje;
                PRODUCT_BRANDS_MODEL productBrandsModel;
                switch (objectIslem)
                {
                case ObjectIslem.Ekle:
                    productBrandsModel = new PRODUCT_BRANDS_MODEL {
                        BRAND_ID = iliskiliObjeId, MODEL_NAME = (string)model[objectEnum.ToString()]
                    };
                    _dbproductContext.PRODUCT_BRANDS_MODEL.Add(productBrandsModel);
                    _dbproductContext.SaveChanges();
                    break;

                case ObjectIslem.Guncelle:
                    int id = (int)model["Id"];
                    productBrandsModel            = _dbproductContext.PRODUCT_BRANDS_MODEL.FirstOrDefault(b => b.MODEL_ID == id);
                    productBrandsModel.MODEL_NAME = model[objectEnum.ToString()].ToString();

                    _dbproductContext.Entry(productBrandsModel).State = System.Data.Entity.EntityState.Modified;
                    _dbproductContext.SaveChanges();
                    break;

                case ObjectIslem.Listele:
                    _dbproductContext.PRODUCT_BRANDS.Load();
                    // This line of code is generated by Data Source Configuration Wizard

                    gridControl.DataSource = _dbproductContext.PRODUCT_BRANDS.Local.ToBindingList();
                    List <MyGridView> objeList = (from pbs in _dbproductContext.PRODUCT_BRANDS_MODEL
                                                  select new MyGridView()
                    {
                        // Id = pbs.BRAND_ID,
                        Id = pbs.MODEL_ID,
                        Deger = pbs.MODEL_NAME,
                        kolonAdi = objectEnum.ToString()
                    }
                                                  ).ToList();
                    ds = new DataSet();
                    ds.Tables.Add(GetDataSource(objeList));
                    gridControl.DataSource = ds.Tables[0];
                    break;
                }
                break;

            case ObjectEnum.Birim:
                var        birim = (Birim)obje;
                SETUP_UNIT setupUnit;
                switch (objectIslem)
                {
                case ObjectIslem.Ekle:
                    setupUnit = new SETUP_UNIT {
                        UNIT_ID = birim.BirimId, UNIT = birim.BirimAd
                    };
                    _dbproductContext.SETUP_UNIT.Add(setupUnit);
                    _dbproductContext.SaveChanges();
                    break;

                case ObjectIslem.Guncelle:
                    setupUnit      = _dbproductContext.SETUP_UNIT.FirstOrDefault(b => b.UNIT_ID == birim.BirimId);
                    setupUnit.UNIT = birim.BirimAd;

                    _dbproductContext.Entry(setupUnit).State = System.Data.Entity.EntityState.Modified;
                    _dbproductContext.SaveChanges();
                    break;

                case ObjectIslem.Listele:
                    List <Birim> objeList = (from pbs in _dbproductContext.SETUP_UNIT
                                             select new Birim()
                    {
                        BirimId = pbs.UNIT_ID,
                        BirimAd = pbs.UNIT
                    }
                                             ).ToList();
                    var bindingSource = new BindingSource(objeList, null);
                    gridControl.DataSource = bindingSource;
                    break;
                }
                break;

            case ObjectEnum.UrunKategori:
                var         productCat_ = (UrunKategori)obje;
                PRODUCT_CAT productCat;
                switch (objectIslem)
                {
                case ObjectIslem.Ekle:
                    productCat = new PRODUCT_CAT {
                        PRODUCT_CATID = productCat_.KategoriId, PRODUCT_CAT1 = productCat_.Kategori, HIERARCHY = productCat_.KategoriKodu
                    };
                    _dbproductContext.PRODUCT_CAT.Add(productCat);
                    _dbproductContext.SaveChanges();
                    break;

                case ObjectIslem.Guncelle:
                    productCat = _dbproductContext.PRODUCT_CAT.FirstOrDefault(b => b.PRODUCT_CATID == productCat_.KategoriId);
                    productCat.PRODUCT_CAT1 = productCat_.Kategori;
                    productCat_.Hiyerarsi   = productCat_.Hiyerarsi;

                    _dbproductContext.Entry(productCat).State = System.Data.Entity.EntityState.Modified;
                    _dbproductContext.SaveChanges();
                    break;

                case ObjectIslem.Listele:
                    List <UrunKategori> objeList = (from pbs in _dbproductContext.PRODUCT_CAT
                                                    select new UrunKategori()
                    {
                        KategoriId = pbs.PRODUCT_CATID,
                        Kategori = pbs.PRODUCT_CAT1,
                        KategoriKodu = pbs.HIERARCHY
                    }
                                                    ).ToList();
                    var bindingSource = new BindingSource(objeList, null);
                    gridControl.DataSource = bindingSource;
                    break;
                }
                break;
            }
        }
Пример #3
0
        public void ObjeIslemler(ObjectEnum objectEnum, ObjectIslem objectIslem, object obje, int iliskiliObjeId, GridControl gridControl)
        {
            switch (objectEnum)
            {
            case ObjectEnum.Marka:
                var            brand = (DataRowView)obje;
                PRODUCT_BRANDS productBrand;
                switch (objectIslem)
                {
                case ObjectIslem.Ekle:
                    productBrand = new PRODUCT_BRANDS
                    {
                        BRAND_NAME = (string)brand["Marka"]
                    };
                    _repositoryBrand.Add(productBrand);
                    _uow.SaveChanges(); break;

                case ObjectIslem.Guncelle:
                    int id = (int)brand["Id"];
                    productBrand            = _repositoryBrand.Get(b => b.BRAND_ID == id);     // _dbproductContext.PRODUCT_BRANDS.FirstOrDefault(b => b.BRAND_ID ==id );
                    productBrand.BRAND_NAME = brand["Marka"].ToString();
                    _repositoryBrand.Update(productBrand);
                    _uow.SaveChanges();
                    break;

                case ObjectIslem.Listele:
                    List <MyGridView> objeList = (from pbs in _repositoryBrand.GetAll()
                                                  select new MyGridView()
                    {
                        Id = pbs.BRAND_ID,
                        Deger = pbs.BRAND_NAME,
                        kolonAdi = ObjectEnum.Marka.ToString()
                    }
                                                  ).ToList();
                    ds = new DataSet();
                    ds.Tables.Add(GetDataSource(objeList, ObjectEnum.Marka.ToString()));
                    gridControl.DataSource = ds.Tables[0];
                    break;
                }
                break;

            case ObjectEnum.Model:
                var model = (DataRowView)obje;
                PRODUCT_BRANDS_MODEL productBrandsModel; switch (objectIslem)
                {
                case ObjectIslem.Ekle:
                    productBrandsModel = new PRODUCT_BRANDS_MODEL {
                        BRAND_ID = iliskiliObjeId, MODEL_NAME = (string)model[objectEnum.ToString()]
                    };
                    _repositoryModel.Add(productBrandsModel);
                    _uow.SaveChanges(); break;

                case ObjectIslem.Guncelle:
                    int id = (int)model["Id"];
                    productBrandsModel            = _repositoryModel.Get(b => b.MODEL_ID == id);
                    productBrandsModel.MODEL_NAME = model[objectEnum.ToString()].ToString();
                    _repositoryModel.Update(productBrandsModel);
                    _uow.SaveChanges();
                    break;

                case ObjectIslem.Listele:
                    List <MyGridView> objeList = (from pbs in _repositoryModel.GetAllList() select new MyGridView()
                    {
                        // Id = pbs.BRAND_ID,
                        Id = pbs.MODEL_ID,
                        Deger = pbs.MODEL_NAME,
                        kolonAdi = objectEnum.ToString()
                    }
                                                  ).ToList();
                    ds = new DataSet();
                    ds.Tables.Add(GetDataSource(objeList, objectEnum.ToString()));
                    gridControl.DataSource = ds.Tables[0];
                    break;
                }
                break;

            case ObjectEnum.Birim:
                var        birim = (DataRowView)obje;
                SETUP_UNIT setupUnit;
                switch (objectIslem)
                {
                case ObjectIslem.Ekle:
                    setupUnit = new SETUP_UNIT {
                        UNIT = (string)birim[objectEnum.ToString()]
                    };
                    _repositoryUnit.Add(setupUnit);
                    _uow.SaveChanges();
                    break;

                case ObjectIslem.Guncelle:
                    int id = (int)birim["Id"];
                    setupUnit      = _repositoryUnit.Get(b => b.UNIT_ID == id);
                    setupUnit.UNIT = birim[objectEnum.ToString()].ToString();
                    _repositoryUnit.Update(setupUnit);
                    _uow.SaveChanges();
                    break;

                case ObjectIslem.Listele:
                    List <MyGridView> objeList = (from pbs in _repositoryUnit.GetAllList()
                                                  select new MyGridView()
                    {
                        Id = pbs.UNIT_ID,
                        Deger = pbs.UNIT,
                        kolonAdi = objectEnum.ToString()
                    }
                                                  ).ToList();
                    ds = new DataSet();
                    ds.Tables.Add(GetDataSource(objeList, objectEnum.ToString()));
                    gridControl.DataSource = ds.Tables[0];
                    break;
                }
                break;

            case ObjectEnum.UrunKategori:
                var         productCat_ = (DataRowView)obje;
                PRODUCT_CAT productCat;
                switch (objectIslem)
                {
                case ObjectIslem.Ekle:
                    productCat = new PRODUCT_CAT {
                        PRODUCT_CAT1 = (string)productCat_[objectEnum.ToString()], HIERARCHY = ""
                    };
                    _repositoryPCat.Add(productCat);
                    _uow.SaveChanges();
                    break;

                case ObjectIslem.Guncelle:
                    int id = (int)productCat_["Id"];
                    productCat = _repositoryPCat.Get(b => b.PRODUCT_CATID == id);
                    productCat.PRODUCT_CAT1 = productCat_[objectEnum.ToString()].ToString();
                    productCat.HIERARCHY    = "";
                    _repositoryPCat.Update(productCat);
                    _uow.SaveChanges();
                    break;

                case ObjectIslem.Listele:
                    List <MyGridView> objeList = (from pbs in _repositoryPCat.GetAllList()
                                                  select new MyGridView()
                    {
                        Id = pbs.PRODUCT_CATID,
                        Deger = pbs.PRODUCT_CAT1,
                        kolonAdi = objectEnum.ToString()
                    }
                                                  ).ToList();
                    ds = new DataSet();
                    ds.Tables.Add(GetDataSource(objeList, objectEnum.ToString()));
                    gridControl.DataSource = ds.Tables[0];
                    break;
                }
                break;
            }
        }