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