public ActionResult UrunBazliIndirim() { var model = uow.UrunRepository.GetAll().ToList(); ViewBag.Urun_ID = new SelectList(uow.GetRepository <tbl_Urun>().GetAll(), "Urun_Id", "Urun_Adi"); return(View("UrunBazliIndirim", model)); }
public bool Update(CategoryModel entity) { try { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitofwork = new EfUnitOfWork(context)) { var category = unitofwork.GetRepository <Category>().GetById(entity.CategoryId); category.CategoryName = entity.CategoryName; category.Description = entity.Description; unitofwork.GetRepository <Category>().Update(category); int saveCount = unitofwork.SaveChanges(); if (saveCount == 0) { return(false); } return(true); } } catch (Exception ex) { Console.WriteLine(ex); throw; } }
private void SiparisKaydet(Cart cart) { var girenkullanici = HttpContext.User.Identity.Name; var kullanici = uow.GetRepository <tbl_Kullanici>().Get(i => i.Kullanici_Adi == girenkullanici); Siparis siparis = new Siparis(); siparis.SiparisNumarasi = "O" + (new Random()).Next(1000000, 9999999).ToString(); siparis.ToplamTutar = cart.Total(); siparis.KullaniciId = kullanici.Kullanici_Id; siparis.SiparisTarihi = DateTime.Now; siparis.SiparisDetay = new List <SiparisDetay>(); foreach (var sd in cart.CartLines) { SiparisDetay siparisdetay = new SiparisDetay(); siparisdetay.Adet = sd.Adet; siparisdetay.Fiyat = (sd.Urun.Fiyat * (decimal)sd.Adet); siparisdetay.UrunId = sd.Urun.Urun_Id; siparisdetay.UrunSiparisTarihi = DateTime.Now; siparis.SiparisDetay.Add(siparisdetay); } uow.GetRepository <Siparis>().Add(siparis); uow.SaveChanges(); }
public ActionResult Ekle() { var urun = new tbl_Urun(); ViewBag.Kategori_ID = new SelectList(uow.GetRepository <tbl_Kategori>().GetAll(), "Kategori_Id", "Kategori"); ViewBag.Marka_ID = new SelectList(uow.MarkaRepository.GetAll(), "Marka_Id", "Marka_Adi"); return(View(urun)); }
// GET: Profil public ActionResult Siparislerim() { var kullanici = HttpContext.User.Identity.Name; var kulid = uow.GetRepository <tbl_Kullanici>().Get(i => i.Kullanici_Adi == kullanici); var siparisler = uow.GetRepository <Siparis>().GetAll().Where(i => i.KullaniciId == kulid.Kullanici_Id) .OrderByDescending(i => i.SiparisId); return(View(siparisler)); }
// GET: Admin/Duyuru public ActionResult Index() { var duyuru = uow.GetRepository <tbl_Duyuru>().GetById(1); if (duyuru == null) { HttpNotFound(); } return(View(duyuru)); }
public ActionResult Login(tbl_Kullanici kullanici) { var Girenkullanici = uow.GetRepository <tbl_Kullanici>().Get(x => x.Eposta == kullanici.Eposta && x.Sifre == kullanici.Sifre); if (Girenkullanici != null) { FormsAuthentication.SetAuthCookie(Girenkullanici.Kullanici_Adi, false); return(RedirectToAction("Anasayfa", "Anasayfa")); } else { ViewBag.mesaj = "Geçersiz kullanıcı adı veya şifre"; return(View()); } }
public ActionResult MesajAt(tbl_Mesaj mesaj) { var Kullanici = uow.GetRepository <tbl_Kullanici>() .Get(x => x.Kullanici_Adi == HttpContext.User.Identity.Name); var body = new StringBuilder(); if (HttpContext.User.Identity.Name != "") { body.AppendLine("Kullanıcı mesajı"); body.AppendLine("Eposta: " + Kullanici.Eposta); body.AppendLine("isim: " + Kullanici.Ad + " " + Kullanici.Soyad); } else { body.AppendLine("Ziyaretçi mesajı"); body.AppendLine("Eposta: " + mesaj.Eposta); body.AppendLine("isim: " + mesaj.AdSoyad); } body.AppendLine("Konu: " + mesaj.Konu); body.AppendLine("içerik: " + mesaj.Icerik); Eposta.SendMail(body.ToString()); ViewBag.succes = true; return(View("Index")); }
// GET: AnaSayfa public ActionResult Anasayfa(int page = 1, int pageSize = 12) { tbl_Duyuru popup = GetPopup(); var urunler = uow.GetRepository <tbl_Urun>().GetAll().ToList(); ViewBag.Duyuru = uow.GetRepository <tbl_Duyuru>().GetById(1); AnasayfaModelView anasayfamodel = new AnasayfaModelView { Duyuru = null, Urunler = urunler }; PagedList <tbl_Urun> personModel = new PagedList <tbl_Urun>(urunler, page, pageSize); return(View(personModel)); }
void Session_Start(object sender, EventArgs e) { uow.GetRepository <Ziyaretci>().Add(new Ziyaretci { ZiyaretTarihi = DateTime.Now }); uow.SaveChanges(); }
public EmployeeModel GetById(Guid id) { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitOfWork = new EfUnitOfWork(context)) { var employee = unitOfWork.GetRepository <Employee>().GetById(id); EmployeeModel employeeModel = StockMapper.EmployeeModelMap(employee); return(employeeModel); } }
public bool Delete(Guid id) { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitofwork = new EfUnitOfWork(context)) { unitofwork.GetRepository <Employee>().Delete(id); int saveCount = unitofwork.SaveChanges(); if (saveCount == 0) { return(false); } return(true); } }
public bool Delete(EmployeeModel entity) { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitOfWork = new EfUnitOfWork(context)) { Employee employee = StockMapper.EmployeeMap(entity); unitOfWork.GetRepository <Employee>().Delete(employee); int saveCount = unitOfWork.SaveChanges(); if (saveCount == 0) { return(false); } return(true); } }
public bool Delete(OrderModel entity) { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitOfWork = new EfUnitOfWork(context)) { Order order = StockMapper.OrderMap(entity); unitOfWork.GetRepository <Order>().Delete(order); int saveCount = unitOfWork.SaveChanges(); if (saveCount == 0) { return(false); } return(true); } }
public ActionResult Liste() { var kategoriler = uow.GetRepository <tbl_Kategori>().GetAll().ToList(); if (kategoriler == null) { HttpNotFound(); } return(PartialView(kategoriler)); }
public ActionResult Login(tbl_Kullanici kullanici) { var admin = uow.GetRepository <tbl_Kullanici>() .Get(k => k.Eposta == kullanici.Eposta && k.Sifre == kullanici.Sifre && k.Rol_ID == 1); if (admin != null) { Session["LogonAdmin"] = admin; return(Redirect("/")); } else { ViewBag.Error = "kullanıcı ve şifre yanlış"; return(View()); } }
public void AddProduct(tbl_Urun product, int adet) { var line = _cartlines.FirstOrDefault(i => i.Urun.Urun_Id == product.Urun_Id); if (line == null) { _cartlines.Add(new Cartline { Urun = product, Adet = adet }); } else { line.Adet += adet; } uow.GetRepository <tbl_Sepet>().Add(new tbl_Sepet { Urun_ID = product.Urun_Id, Adet = adet }); uow.SaveChanges(); //var varsa = uow.GetRepository<tbl_Satin_Alma>().Get(i => i.Urun_ID == product.Urun_Id); //if (varsa != null) //{ // tbl_Satin_Alma sa = new tbl_Satin_Alma(); // sa.Satis_Id = varsa.Satis_Id; // sa.Adet = varsa.Adet + adet; // sa.Urun_ID = varsa.Urun_ID; // // db.tbl_Satin_Alma.Attach(sa); // // db.Entry(sa).State = EntityState.Modified; // db.SaveChanges(); // // db.SaveChanges(); // uow.GetRepository<tbl_Satin_Alma>().Update(sa); // uow.SaveChanges(); //} //else //{ // } }
public List <CategoryModel> GetAlls() { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitOfWork = new EfUnitOfWork(context)) { var category = unitOfWork.GetRepository <Category>().GetAll(); List <CategoryModel> categoryModels = category.Select(s => new CategoryModel() { CategoryId = s.CategoryId, CategoryName = s.CategoryName, Description = s.Description, Picture = s.Picture }).ToList(); return(categoryModels); } }
public bool Delete(CustomerModel entity) { try { if (entity != null) { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitofwork = new EfUnitOfWork(context)) { Customer customer = new Customer { CustomerId = Guid.NewGuid(), City = entity.City, CompanyName = entity.CompanyName, Address = entity.Address, Region = entity.Region, Phone = entity.Phone, ContactTitle = entity.ContactTitle, ContactName = entity.ContactName, PostalCode = entity.PostalCode, Country = entity.Country, Fax = entity.Fax, }; unitofwork.GetRepository <Customer>().Delete(customer); int saveCount = unitofwork.SaveChanges(); if (saveCount == 0) { return(false); } return(true); } } } catch (Exception ex) { Console.WriteLine(ex); throw; } return(true); }
public Model.Result.CustomerAddResult AddCustomer(CustomerAddRequest request) { CustomerAddResult result = new CustomerAddResult(); try { if (request != null && request.CustomerModel != null) { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitofwork = new EfUnitOfWork(context)) { Customer customer = new Customer { CustomerId = Guid.NewGuid(), City = request.CustomerModel.City, CompanyName = request.CustomerModel.CompanyName, Address = request.CustomerModel.Address, Region = request.CustomerModel.Region, Phone = request.CustomerModel.Phone, ContactTitle = request.CustomerModel.ContactTitle, ContactName = request.CustomerModel.ContactName, PostalCode = request.CustomerModel.PostalCode, Country = request.CustomerModel.Country, Fax = request.CustomerModel.Fax, }; unitofwork.GetRepository <Customer>().Add(customer); result.SaveCount = unitofwork.SaveChanges(); if (result.SaveCount > 0) { return(result); } } } } catch (Exception ex) { Console.WriteLine(ex); throw; } return(result); }
TestMethodProductAdd() { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitofwork = new EfUnitOfWork(context)) { Product product = new Product() { ProductId = Guid.NewGuid(), Discontinued = true, ProductName = "At", SupplierId = Guid.NewGuid(), CategoryId = Guid.NewGuid(), UnitPrice = 5, UnitsInStock = 15, QuantityPerUnit = "kestanesi", }; unitofwork.GetRepository <Product>().Add(product); unitofwork.SaveChanges(); } }
public CustomerModel GetById(Guid id) { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitOfWork = new EfUnitOfWork(context)) { var customer = unitOfWork.GetRepository <Customer>().GetById(id); CustomerModel customerModel = new CustomerModel { City = customer.City, CompanyName = customer.CompanyName, Address = customer.Address, Region = customer.Region, Phone = customer.Phone, ContactTitle = customer.ContactTitle, ContactName = customer.ContactName, PostalCode = customer.PostalCode, Country = customer.Country, Fax = customer.Fax, }; return(customerModel); } }
public bool Delete(Guid id) { try { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitofwork = new EfUnitOfWork(context)) { unitofwork.GetRepository <Customer>().Delete(id); int savecount = unitofwork.SaveChanges(); if (savecount == 0) { return(false); } return(true); } } catch (Exception ex) { Console.WriteLine(ex); throw; } }
public bool Update(ProductModel entity) { try { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitofwork = new EfUnitOfWork(context)) { Product product = StockMapper.ProductMap(entity); unitofwork.GetRepository <Product>().Update(product); int saveCount = unitofwork.SaveChanges(); if (saveCount == 0) { return(false); } return(true); } } catch (Exception ex) { Console.WriteLine(ex); throw; } }
public bool Delete(CategoryModel entity) { try { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitofwork = new EfUnitOfWork(context)) { Category category = StockMapper.CategoryMap(entity); unitofwork.GetRepository <Category>().Delete(category); int saveCount = unitofwork.SaveChanges(); if (saveCount == 0) { return(false); } return(true); } } catch (Exception ex) { Console.WriteLine(ex); throw; } }
public void TestMethodAdd() { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitofwork = new EfUnitOfWork(context)) { Customer customer = new Customer { CustomerId = Guid.NewGuid(), City = "ankara", CompanyName = "Tc", Address = "Yenımahalle", Region = "Tr", Phone = "5555555", ContactTitle = "Onuur", ContactName = "Onur", PostalCode = "000", Country = "Turkiye", Fax = "00000", }; unitofwork.GetRepository <Customer>().Add(customer); int saveCount = unitofwork.SaveChanges(); } }
public void TestMethodUpdate() { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitofwork = new EfUnitOfWork(context)) { Customer customer = new Customer { CustomerId = new Guid("6CA80A72-F581-4E95-98AB-20DA9E310808"), City = "Niğde", CompanyName = "Çiftliği", Address = "Yenımahalle", Region = "Tr", Phone = "5555555", ContactTitle = "Ali", ContactName = "Babanın", PostalCode = "000", Country = "Turkiye", Fax = "00000", }; Guid Id = new Guid("6CA80A72-F581-4E95-98AB-20DA9E310808"); unitofwork.GetRepository <Customer>().Update(customer); unitofwork.SaveChanges(); } }
public void TestMethodDelete() { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitofwork = new EfUnitOfWork(context)) { Customer customer = new Customer { CustomerId = new Guid("1B67D5CA-CFFD-447C-84BA-49651E9CE601"), City = "ankara", CompanyName = "Tc", Address = "Yenımahalle", Region = "Tr", Phone = "5555555", ContactTitle = "Onuur", ContactName = "Onur", PostalCode = "000", Country = "Turkiye", Fax = "00000", }; Guid Id = new Guid("1B67D5CA-CFFD-447C-84BA-49651E9CE601"); unitofwork.GetRepository <Customer>().Delete(Id); unitofwork.SaveChanges(); } }
public List <ProductModel> GetAlls() { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitOfWork = new EfUnitOfWork(context)) { var product = unitOfWork.GetRepository <Product>().GetAll(); List <ProductModel> productModels = product.Select(s => new ProductModel { ProductId = s.ProductId, Discontinued = s.Discontinued, CategoryId = s.CategoryId, SupplierId = s.SupplierId, ProductName = s.ProductName, UnitsInStock = s.UnitsInStock, UnitPrice = s.UnitPrice, QuantityPerUnit = s.QuantityPerUnit, ReorderLevel = s.ReorderLevel, UnitsOnOrder = s.UnitsOnOrder }).ToList(); return(productModels); } }
public List <CustomerModel> GetAlls() { using (StockDbContext context = new StockDbContext()) using (IUnitOfWork unitOfWork = new EfUnitOfWork(context)) { var customer = unitOfWork.GetRepository <Customer>().GetAll(); List <CustomerModel> customerModels = customer.Select(s => new CustomerModel { Address = s.Address, Region = s.Region, CompanyName = s.CompanyName, City = s.City, Phone = s.Phone, ContactName = s.ContactName, PostalCode = s.PostalCode, Country = s.Country, ContactTitle = s.ContactTitle, Fax = s.Fax }).ToList(); return(customerModels); } }