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; } }
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; } }
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; } }