public IActionResult CityList() { var cities = _db.Set <City>().Select(x => new SelectListItem { Value = x.Id.ToString(), Text = x.Name, }).OrderBy(x => x.Text); return(Ok(cities)); }
public IActionResult Index() { // Anonim Yaklaşım: //var rlist = _db.Set<Roles>().Select(x => new //{ // x.RoleId, x.RoleAd //}).ToList(); // DTo Yaklaşım _model.rlist = _db.Set <Roles>().Select(x => new RolesDTO { RoleAd = x.RoleAd, RolId = x.RoleId }).ToList(); return(View(_model)); }
public IActionResult GetList() { var invList = _db.Set <Inventory>().Select(x => new InventoryListModel { name = x.Name, model = x.Model, marka = x.Marka, feature = x.Feature, seriNo = x.SeriNo, status = x.Status, createTime = x.CreateTime, id = x.Id, accountMail = x.Account.Email }).ToList(); return(Ok(invList)); }
public IActionResult CategoryList() { var categories = _db.Set <Category>().Select(x => new CategoryListModel { name = x.CategoryName, categoryid = x.Id }).ToList(); return(Json(categories)); }
public IActionResult ProductList(Guid id) { var products = _db.Set <Products>().Where(x => x.CategoryId == id).Select(x => new ProductModel { name = x.ProductName, price = x.Price, amount = x.Amount, size = x.Size, title = x.Title, //image = x.Image }).ToList(); if (products.Count == 0) { return(BadRequest("Ürün Bulunamadı")); } return(Json(products)); }
public Microsoft.EntityFrameworkCore.DbSet <T> Set() { return(_db.Set <T>()); }
public IActionResult Register([FromBody] registerModel model) { string Defaultrole; if (string.IsNullOrEmpty(model.Name)) { return(BadRequest("İsim Boş Bırakılamaz")); } if (string.IsNullOrEmpty(model.Surname)) { return(BadRequest("Soyİsim Boş Bırakılamaz")); } if (string.IsNullOrEmpty(model.Email)) { return(BadRequest("Email Boş Bırakılamaz")); } if (string.IsNullOrEmpty(model.Password)) { return(BadRequest("Parola Boş Bırakılamaz")); } if (string.IsNullOrEmpty(model.ConfirPassword)) { return(BadRequest("Parola Tekrar Boş Bırakılamaz")); } if (model.Password != model.ConfirPassword) { return(BadRequest("Parola Eşleşmedi!")); } if (!model.isActive) { return(BadRequest("Sözleşmeyi Onaylamanız Gerekmektedir.")); } var message = "Kayıt İşlemi Başarılı"; var test = _db.Set <Account>().FirstOrDefault(x => x.Email == model.Email); if (test != null) { if (test.Email == model.Email) { return(BadRequest("Aynı Mail Adresi Sistemde Bulunmaktadır. Farklı bir mail adresi ile kayıt olmayı deneyiniz")); } } if (model.role == null) { Defaultrole = "User"; } else { Defaultrole = model.role; } if (ModelState.IsValid) { var user = new Account { Id = Guid.NewGuid(), Name = model.Name, Surname = model.Surname.ToUpperInvariant(), Age = model.Age, Email = model.Email, isActive = model.isActive, Role = Defaultrole }; _db.Entry(user).State = Microsoft.EntityFrameworkCore.EntityState.Added; CreatePassword(user.Id, model.Password, model.ConfirPassword); _db.SaveChanges(); return(Json(message)); //if (model.Password == model.ConfirPassword) //{ // model.isActive = true; // _db.Entry(model).State = Microsoft.EntityFrameworkCore.EntityState.Added; // _db.SaveChanges(); // return Json(message); //} } return(BadRequest()); }
public DbSet <T> Set() { return(_db.Set <T>()); }
public IActionResult managerList() { //var cityList = _db.Set<City>().ToList(); var manager = _db.Set <Manager>().Select(x => new SelectListItem { Value = x.Id.ToString(), Text = x.FullName, }); return(Json(manager)); }
//public IActionResult AccountList() //{ // var list = _db.Set<Account>().Select(x => new AccountModel // { // id = x.Id, // name = x.Name, // surname = x.Surname, // email = x.Email, // isActive = (bool)x.isActive, // createTime = (DateTime)x.CreateTime, // role = x.Role // }).OrderBy(x => x.role)/*.OrderByDescending(x=> x.name).Take(1)*/.Where(x => x.isActive).ToList(); // return Json(list); //} public IActionResult AccountList(int id) { if (id == 1) { var total = _db.Set <Account>().Where(x => (bool)x.isActive).Sum(x => x.TL); var list = _db.Set <Account>().Select(x => new AccountModel { id = x.Id, name = x.Name, surname = x.Surname, email = x.Email, isActive = (bool)x.isActive, createTime = x.CreateTime, role = x.Role, image = x.Image, bakiye = x.TL, Total = total }).OrderBy(x => x.role).Where(x => x.isActive).ToList(); return(Json(list)); } else if (id == 0) { var list = _db.Set <Account>().Select(x => new AccountModel { id = x.Id, name = x.Name, surname = x.Surname, email = x.Email, isActive = (bool)x.isActive, createTime = x.CreateTime, role = x.Role, bakiye = x.TL }).OrderBy(x => x.role).Where(x => x.isActive == false).ToList(); return(Json(list)); } else if (id == 2) { var list = _db.Set <Account>().Select(x => new AccountModel { id = x.Id, name = x.Name, surname = x.Surname, email = x.Email, isActive = (bool)x.isActive, createTime = x.CreateTime, role = x.Role, bakiye = x.TL }).OrderBy(x => x.email).ToList(); return(Json(list)); } else if (id == 3) { var list = _db.Set <Account>().Select(x => new AccountModel { id = x.Id, name = x.Name, surname = x.Surname, email = x.Email, isActive = (bool)x.isActive, createTime = x.CreateTime, role = x.Role, bakiye = x.TL }).OrderBy(x => x.createTime).OrderByDescending(x => x.createTime).ToList(); return(Json(list)); } else if (id == 4) { var list = _db.Set <Account>().Select(x => new AccountModel { id = x.Id, name = x.Name, surname = x.Surname, email = x.Email, isActive = (bool)x.isActive, createTime = x.CreateTime, role = x.Role, bakiye = x.TL }).OrderBy(x => x.role).ToList(); return(Json(list)); } else if (id == 5) { var list = _db.Set <Account>().Select(x => new AccountModel { id = x.Id, name = x.Name, surname = x.Surname, email = x.Email, isActive = (bool)x.isActive, createTime = x.CreateTime, role = x.Role, bakiye = x.TL }).OrderByDescending(x => x.role).ToList(); return(Json(list)); } return(Ok()); }