public ActionResult Create(int groupId, string username)
{
if (ModelState.IsValid)
{
string queryString = "SELECT dbo.AspNetUsers.Id "
+ "FROM dbo.AspNetUsers "
+ "WHERE dbo.AspNetUsers.UserName='******'";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
reader.Read();
AspNetGroupUser gu = new AspNetGroupUser
{
GroupId = groupId,
UserId = reader.GetString(0)
};
db.AspNetGroupUsers.Add(gu);
db.SaveChanges();
reader.Close();
}
}
return(RedirectToAction("../Groups/Index"));
}
// GET: AspNetGroupUsers/Delete/5
public ActionResult Delete(int?id, string username)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
/*if (username == null)
* {
* return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
* }*/
string uid;
string queryString = "SELECT dbo.AspNetUsers.Id "
+ "FROM dbo.AspNetUsers "
+ "WHERE dbo.AspNetUsers.UserName='******'";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
reader.Read();
uid = reader.GetString(0);
reader.Close();
}
AspNetGroupUser aspNetGroupUser = db.AspNetGroupUsers.Find(id, uid);
if (aspNetGroupUser == null)
{
return(HttpNotFound("The id is " + id + " and the uid is " + uid));
}
return(View(aspNetGroupUser));
}
public ActionResult Edit([Bind(Include = "GroupId,UserId")] AspNetGroupUser aspNetGroupUser)
{
if (ModelState.IsValid)
{
db.Entry(aspNetGroupUser).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetGroupUser));
}
public void AddUserToDefaultGroup(string userId, string createdBy)
{
var defaultGroup = _entities.AspNetGroups.FirstOrDefault(x => x.Code.ToLower() == "staffs" && x.Deleted == false && x.Active == true);
if (defaultGroup != null)
{
//Add a record in table aspNetGroupUsers
AspNetGroupUser groupUser = new AspNetGroupUser();
groupUser.UserId = userId;
groupUser.GroupId = defaultGroup.Id;
try
{
_groupUsersRepository.Add(groupUser);
}
catch
{
return;
}
try
{
_applicationLoggingRepository.Log("EVENT", "CREATE", "AspNetGroupUser", userId + '-' + defaultGroup.Id, "", "", groupUser, "", System.Web.HttpContext.Current.Request.UserHostAddress, createdBy);
}
catch
{ }
try
{
//Add all Roles of defaultGroup from table aspNetGroupRoles to table aspNetUserRoles
IEnumerable <AspNetGroupRole> listRoleOfGroup = _aspNetGroupRolesRepository.GetAll().Where(n => n.GroupId == defaultGroup.Id);
if (listRoleOfGroup.Count() > 0)
{
foreach (var item in listRoleOfGroup)
{
AspNetUserRole itemUserRole = new AspNetUserRole();
itemUserRole.UserId = userId;
itemUserRole.RoleId = item.RoleId;
itemUserRole.Grant = true;
_aspNetUserRolesRepository.Add(itemUserRole);
try
{
_applicationLoggingRepository.Log("EVENT", "CREATE", "AspNetUserRole", userId + '-' + item.RoleId, "", "", itemUserRole, "", System.Web.HttpContext.Current.Request.UserHostAddress, createdBy);
}
catch
{ }
}
}
}
catch { }
}
}
// GET: AspNetGroupUsers/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetGroupUser aspNetGroupUser = db.AspNetGroupUsers.Find(id);
if (aspNetGroupUser == null)
{
return(HttpNotFound());
}
return(View(aspNetGroupUser));
}
public BaseResponse <AspNetGroupUser> AddGroupForUser(ComplexGroupUser model)
{
var response = new BaseResponse <AspNetGroupUser>();
AspNetGroupUser groupUser = new AspNetGroupUser();
AspNetUserRole userRole;
try
{
groupUser.UserId = model.UserId;
groupUser.GroupId = model.GroupId;
response.Value = _groupUsersRepository.Add(groupUser);
try
{
_applicationLoggingRepository.Log("EVENT", "CREATE", "AspNetGroupUser", response.Value.UserId + '-' + response.Value.GroupId, "", "", model, "", System.Web.HttpContext.Current.Request.UserHostAddress, model.CreatedBy);
}
catch
{ }
IEnumerable <AspNetGroupRole> listRoleOfGroup = _aspNetGroupRolesRepository.GetAll().Where(n => n.GroupId == model.GroupId);
if (listRoleOfGroup.Count() > 0)
{
foreach (var item in listRoleOfGroup)
{
IEnumerable <AspNetUserRole> listUserRole = _aspNetUserRolesRepository.GetAll().Where(n => n.RoleId == item.RoleId && n.UserId == model.UserId);
if (listUserRole.Count() == 0)
{
userRole = new AspNetUserRole();
userRole.RoleId = item.RoleId;
userRole.UserId = model.UserId;
userRole.Grant = true;
AddUserRole(userRole);
try
{
_applicationLoggingRepository.Log("EVENT", "CREATE", "AspNetUserRole", userRole.UserId + '-' + userRole.RoleId, "", "", model, "", System.Web.HttpContext.Current.Request.UserHostAddress, model.CreatedBy);
}
catch
{ }
}
}
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.Message = "Error: " + ex.Message + " StackTrace: " + ex.StackTrace;
}
return(response);
}
public ActionResult DeleteConfirmed(int groupId, string username)
{
string userId;
string queryString = "SELECT dbo.AspNetUsers.Id "
+ "FROM dbo.AspNetUsers "
+ "WHERE dbo.AspNetUsers.UserName='******'";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
reader.Read();
userId = reader.GetString(0);
reader.Close();
}
AspNetGroupUser aspNetGroupUser = db.AspNetGroupUsers.Find(groupId, userId);
db.AspNetGroupUsers.Remove(aspNetGroupUser);
db.SaveChanges();
return(RedirectToAction("../Groups/Index"));
}
public ActionResult Create([Bind(Include = "GroupId,UserId,GroupName,StatusMessage")] AspNetGroup aspNetGroup)
{
if (ModelState.IsValid)
{
aspNetGroup.UserId = User.Identity.GetUserId();
db.AspNetGroups.Add(aspNetGroup);
db.SaveChanges();
AspNetGroupUser gu = new AspNetGroupUser
{
GroupId = aspNetGroup.GroupId,
UserId = User.Identity.GetUserId(),
};
db.AspNetGroupUsers.Add(gu);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetGroup));
}
