static void Main(string[] args)
{
var usersDataProvider = new UsersDataProvider.UsersDataProvider();
List <RolesModel> rolesModel = new List <RolesModel>()
{
new RolesModel()
{
Id = 1, Role = "1", Description = "1"
},
new RolesModel()
{
Id = 2, Role = "2", Description = "2"
},
new RolesModel()
{
Id = 3, Role = "3", Description = "3"
},
new RolesModel()
{
Id = 4, Role = "4", Description = "4"
},
new RolesModel()
{
Id = 5, Role = "5", Description = "5"
}
};
usersDataProvider.SaveRoles(new RolesModel()
{
Role = "Vlad", Description = "1"
}); //.ForEach(i =>System.Console.WriteLine($"{i.Id} {i.Role} {i.Description}"));
System.Console.ReadKey();
}
public ActionResult CreateUser(UserViewModel indexUserViewModel)
{
var usersDataProvider = new UsersDataProvider.UsersDataProvider();
usersDataProvider.Create(indexUserViewModel.Name, indexUserViewModel.Email, indexUserViewModel.Password);
return(RedirectToAction("Index"));
}
public JsonResult RemoveUserJson(int id)
{
var userDataProvider = new UsersDataProvider.UsersDataProvider();
BaseResponse baseResponse = new BaseResponse(userDataProvider.Delete(id));
return(Json(baseResponse, JsonRequestBehavior.AllowGet));
}
public JsonResult GetRoles(int userId)
{
var usersDataProvaider = new UsersDataProvider.UsersDataProvider();
var roles = usersDataProvaider.GetUserRoles(userId);
var response = new BaseResponse(roles);
return(Json(response));
}
public JsonResult CreateUserJson(UserViewModel indexUserViewModel)
{
var usersDataProvider = new UsersDataProvider.UsersDataProvider();
var deleted = usersDataProvider.Create(indexUserViewModel.Name, indexUserViewModel.Email, indexUserViewModel.Password);
var response = new BaseResponse(deleted);
return(Json(response));
}
public ActionResult Login(UserViewModel indexViewModel)
{
var usersDataProvider = new UsersDataProvider.UsersDataProvider();
var userInfo = usersDataProvider.Login(indexViewModel.Email, indexViewModel.Password, out bool checkLogin);
if (checkLogin)
{
CookiesUser.CookiesSet(userInfo.Id, userInfo.Name, userInfo.Email);
return(RedirectToAction("AcceptGood"));
}
return(View(indexViewModel));
}
public ActionResult Index(int pageIndex = 1, int pageSize = 50)
{
var model = new IndexViewModel();
model.CurrentUser = UsersDataProvider.UsersDataProvider.CurrentUser();
var usersDataProvider = new UsersDataProvider.UsersDataProvider();
model.PageIndex = pageIndex;
model.PageSize = pageSize;
model.ListUsers = usersDataProvider.GetUserPage(null, pageIndex - 1, pageSize, out double totalUsers);
model.CountPage = Convert.ToInt32(Math.Ceiling(totalUsers / pageSize));
model.AllRoles = usersDataProvider.GetRoles();
return(View(model));
}
public JsonResult SaveRoles(int userId, List <int> listRole)
{
if (listRole == null)
{
return(Json(new BaseResponse(null, 400, "List")));
}
var usersDataProvaider = new UsersDataProvider.UsersDataProvider();
usersDataProvaider.SaveUserRoles(userId, listRole);
var roles = usersDataProvaider.GetUserRoles(userId);
var response = new BaseResponse(roles);
return(Json(response));
}
public ActionResult UpdateUser(UserViewModel indexUserViewModel)
{
var usersDataProvider = new UsersDataProvider.UsersDataProvider();
UserModel userModel = new UserModel()
{
Id = indexUserViewModel.Id,
Name = indexUserViewModel.Name,
Email = indexUserViewModel.Email,
Password = indexUserViewModel.Password
};
usersDataProvider.Update(userModel);
return(RedirectToAction("Index"));
}
public JsonResult UpdateUserJson(UserViewModel indexUserViewModel)
{
var usersDataProvider = new UsersDataProvider.UsersDataProvider();
UserModel userModel = new UserModel()
{
Id = indexUserViewModel.Id,
Name = indexUserViewModel.Name,
Email = indexUserViewModel.Email,
Password = indexUserViewModel.Password
};
var update = usersDataProvider.Update(userModel);
var response = new BaseResponse(update);
return(Json(response));
}
public JsonResult UserListJson(string nameUser, int pageIndex = 1, int pageSize = 50)
{
var model = new IndexViewModel();
model.CurrentUser = UsersDataProvider.UsersDataProvider.CurrentUser();
var usersDataProvider = new UsersDataProvider.UsersDataProvider();
model.PageIndex = pageIndex;
model.PageSize = pageSize;
model.ListUsers = usersDataProvider.GetUserPage(nameUser, pageIndex - 1, pageSize, out double totalUsers);
model.CountPage = Convert.ToInt32(Math.Ceiling(totalUsers / pageSize));
BaseResponse baseResponse = new BaseResponse(model);
return(Json(baseResponse, JsonRequestBehavior.AllowGet));
}
public ActionResult Registration(UserViewModel indexViewModel)
{
var usersDataProvider = new UsersDataProvider.UsersDataProvider();
bool checkAgain = true;
foreach (var i in usersDataProvider.Get())
{
if (i.Name == indexViewModel.Name || i.Email == indexViewModel.Email)
{
checkAgain = false;
}
}
if (checkAgain)
{
usersDataProvider.Create(indexViewModel.Name, indexViewModel.Email, indexViewModel.Password);
}
return(RedirectToAction("Login"));
}
//public List<RolesModel> GetRoles()
//{
// string SqlQuetion = "GetRoles";
// var listUserRolesModel = new List<RolesModel>();
// using (var connection = new SqlConnection(connectionLine))
// {
// if (connection.State != ConnectionState.Open)
// {
// connection.Open();
// }
// using (var command = new SqlCommand(SqlQuetion, connection))
// {
// command.CommandType = CommandType.StoredProcedure;
// using (var reader = command.ExecuteReader())
// {
// while (reader.Read())
// {
// var RolesModel = new RolesModel();
// RolesModel.Id = reader.GetInt32(0);
// RolesModel.Roles = reader.GetString(1);
// RolesModel.Description = reader.GetString(2);
// listUserRolesModel.Add(RolesModel);
// }
// }
// }
// }
// return listRolesModel;
//}
public static UserModel CurrentUser()
{
var usersDataProvider = new UsersDataProvider();
var valueUser = usersDataProvider.GetByIdUser(CookiesUser.CookiesGet()._Id);
if (HttpContext.Current.Request.Cookies.AllKeys.Contains("cookieUser"))
{
if (CookiesUser.CookiesGet() != null)
{
if (valueUser.Name == CookiesUser.CookiesGet()._Name)
{
return new UserModel()
{
Id = CookiesUser.CookiesGet()._Id,
Name = valueUser.Name,
Email = valueUser.Email,
UserRolesModels = usersDataProvider.GetUserRoles(CookiesUser.CookiesGet()._Id)
}
}
}
}
;
