protected void btnThemQuyen_Click(object sender, EventArgs e)
{
SYS_RightOfUser rightOfUser = null;
List <SYS_RightOfUser> sysRightOfUsers = new List <SYS_RightOfUser>();
if (grvChonChucNang.Selection.Count == 0)
{
pcChonChucNang.ShowOnPageLoad = false;
return;
}
List <Object> keyvalues = grvChonChucNang.GetSelectedFieldValues("ID");
int UserID = (int)GridUser.GetRowValues(GridUser.FocusedRowIndex, "ID");
foreach (int key in keyvalues)
{
rightOfUser = new SYS_RightOfUser();
rightOfUser.Approve = true;
rightOfUser.Create = true;
rightOfUser.Delete = true;
rightOfUser.Update = true;
rightOfUser.RightId = key;
rightOfUser.UserId = UserID;
sysRightOfUsers.Add(rightOfUser);
}
_ISYS_RightUserService.InsertSYS_RightOfUser(sysRightOfUsers);
GridUser_CustomCallback(null, null);
grvChonChucNang.Selection.UnselectAll();
pcChonChucNang.ShowOnPageLoad = false;
}
public int InsertSYS_RightOfUser(SYS_RightOfUser sys_rightofuser)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_RIGHTID, sys_rightofuser.RightId, false));
para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_rightofuser.UserId, false));
para.Add(_DbHelper.CreateParameter(FIELD_VIEW, sys_rightofuser.View, false));
para.Add(_DbHelper.CreateParameter(FIELD_UPDATE, sys_rightofuser.Update, false));
para.Add(_DbHelper.CreateParameter(FIELD_CREATE, sys_rightofuser.Create, false));
para.Add(_DbHelper.CreateParameter(FIELD_DELETE, sys_rightofuser.Delete, false));
para.Add(_DbHelper.CreateParameter(FIELD_APPROVE, sys_rightofuser.Approve, false));
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
para.Add(ouput);
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_RightOfUser_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RightOfUserDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public SYS_RightOfUser SelectSYS_RightOfUser(int ID)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
SYS_RightOfUser sys_rightofuser = new SYS_RightOfUser();
DbDataReader reader = null;
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false));
reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_RightOfUser_SelectById]", para.ToArray());
if (reader.HasRows && reader.Read())
{
SYS_RightOfUserDataAccess.SetSYS_RightOfUserInfo(reader, ref sys_rightofuser);
}
return(sys_rightofuser);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RightOfUserDataAccess.SelectById: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
conn.Close();
}
}
private static void SetListSYS_RightOfUserInfo(ref DbDataReader reader, ref List <SYS_RightOfUser> sys_rightofusers)
{
SYS_RightOfUser sys_rightofuser = null;
while (reader.Read())
{
sys_rightofuser = new SYS_RightOfUser();
SYS_RightOfUserDataAccess.SetSYS_RightOfUserInfo(reader, ref sys_rightofuser);
sys_rightofusers.Add(sys_rightofuser);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
List <SYS_RightOfUser> lst = new List <SYS_RightOfUser>();
SYS_RightOfUser rightOfUser = null;
List <Object> keyvalues = grdRightOfRoles.GetSelectedFieldValues("ID");
int UserID = (int)GridUser.GetRowValues(GridUser.FocusedRowIndex, "ID");
foreach (Object key in keyvalues)
{
rightOfUser = new SYS_RightOfUser();
rightOfUser.RightId = (int)key;
rightOfUser.UserId = UserID;
lst.Add(rightOfUser);
}
_ISYS_RightUserService.DeleteSYS_RightOfUser_ByUser(lst);
//_DataBind();
GridUser_CustomCallback(null, null);
grdRightOfRoles.Selection.UnselectAll();
}
public void UpdateSYS_UserAll(SYS_User sys_user)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_user.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_USERNAME, sys_user.UserName, false));
para.Add(_DbHelper.CreateParameter(FIELD_PASSWORD, sys_user.Password, false));
para.Add(_DbHelper.CreateParameter(FIELD_FIRSTNAME, sys_user.FirstName, false));
para.Add(_DbHelper.CreateParameter(FIELD_MIDNAME, sys_user.MidName, false));
para.Add(_DbHelper.CreateParameter(FIELD_LASTNAME, sys_user.LastName, false));
para.Add(_DbHelper.CreateParameter(FIELD_EMAIL, sys_user.Email, false));
para.Add(_DbHelper.CreateParameter(FIELD_ISACTIVE, sys_user.IsActive, false));
para.Add(_DbHelper.CreateParameter(FIELD_NUMBERPHONE, sys_user.NumberPhone, false));
para.Add(_DbHelper.CreateParameter(FIELD_IDORGANIZATION, sys_user.IDOrganization, false));
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_User_Update]", para.ToArray());
SYS_RoleOfUserDataAccess sysRoleOfUserDataAccess = new SYS_RoleOfUserDataAccess();
SYS_RoleOfUser sysRoleOfUser = new SYS_RoleOfUser();
//SYS_RightOfUserDataAccess sysRightOfUserDataAccess = new SYS_RightOfUserDataAccess();
SYS_RightOfUser sysRightOfUserID = new SYS_RightOfUser();
sysRightOfUserID.UserId = sys_user.ID;
sysRoleOfUser.UserId = sys_user.ID;
//sysRightOfUserDataAccess.DeleteSYS_RightOfUser; Xóa toàn bộ quyền của User đó
//sysRightOfUserDataAccess.DeleteSYS_RightOfUserByIDUser(sysRightOfUserID);
sysRoleOfUserDataAccess.DeleteSYS_RoleOfUserByIDUser(sysRoleOfUser);
sysRoleOfUser.RoleId = sys_user.Roles.ID;
sysRoleOfUserDataAccess.InsertSYS_RoleOfUser(sysRoleOfUser);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_UserDataAccess.UpdateAll: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public void DeleteSYS_RightOfUser(SYS_RightOfUser sys_rightofuser)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_rightofuser.ID, false));
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_RightOfUser_Delete]", para.ToArray());
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
}
public void UpdateSYS_UserAll(DM_USER dm_user)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_IDUSER, dm_user.IDUSER, false));
para.Add(_DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, dm_user.IDMA_DVIQLY, false));
para.Add(_DbHelper.CreateParameter(FIELD_XACNHAN, dm_user.XACNHAN, false));
para.Add(_DbHelper.CreateParameter(FIELD_USERNAME, dm_user.USERNAME, false));
para.Add(_DbHelper.CreateParameter(FIELD_HOTEN, dm_user.HOTEN, false));
para.Add(_DbHelper.CreateParameter(FIELD_DIACHI, dm_user.DIACHI, false));
para.Add(_DbHelper.CreateParameter(FIELD_SODT, dm_user.SODT, false));
para.Add(_DbHelper.CreateParameter(FIELD_EMAIL, dm_user.EMAIL, false));
para.Add(_DbHelper.CreateParameter(FIELD_NGAYSINH, dm_user.NGAYSINH, false));
para.Add(_DbHelper.CreateParameter(FIELD_IS_ADMIN, dm_user.IS_ADMIN, false));
para.Add(_DbHelper.CreateParameter(FIELD_CHUCDANH, dm_user.CHUCDANH, false));
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_USER_Update]", para.ToArray());
SYS_RoleOfUserDataAccess sysRoleOfUserDataAccess = new SYS_RoleOfUserDataAccess();
SYS_RoleOfUser sysRoleOfUser = new SYS_RoleOfUser();
SYS_RightOfUser sysRightOfUserID = new SYS_RightOfUser();
sysRightOfUserID.UserId = dm_user.IDUSER;
sysRoleOfUser.UserId = dm_user.IDUSER;
sysRoleOfUserDataAccess.DeleteSYS_RoleOfUserByIDUser(sysRoleOfUser);
sysRoleOfUser.RoleId = dm_user.Roles.ID;
sysRoleOfUserDataAccess.InsertSYS_RoleOfUser(sysRoleOfUser);
}
catch (Exception ex)
{
throw new Exception(String.Format("dm_user_Update.UpdateAll: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public void UpdateSYS_RightOfUser(DbTransaction transaction, SYS_RightOfUser sys_rightofuser)
{
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_RIGHTID, sys_rightofuser.RightId, false));
para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_rightofuser.UserId, false));
para.Add(_DbHelper.CreateParameter(FIELD_VIEW, sys_rightofuser.View, false));
para.Add(_DbHelper.CreateParameter(FIELD_UPDATE, sys_rightofuser.Update, false));
para.Add(_DbHelper.CreateParameter(FIELD_CREATE, sys_rightofuser.Create, false));
para.Add(_DbHelper.CreateParameter(FIELD_DELETE, sys_rightofuser.Delete, false));
para.Add(_DbHelper.CreateParameter(FIELD_APPROVE, sys_rightofuser.Approve, false));
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_rightofuser.ID, false));
_DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_RightOfUser_Update]", para.ToArray());
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RightOfUserDataAccess.Update: {0}", ex.Message));
}
}
public void DeleteSYS_RightOfUserByIDUser(SYS_RightOfUser sys_rightofusers)
{
_sys_rightofuserDataAccess.DeleteSYS_RightOfUserByIDUser(sys_rightofusers);
}
public void UpdateSYS_RightOfUser(SYS_RightOfUser sys_rightofuser)
{
_sys_rightofuserDataAccess.UpdateSYS_RightOfUser(sys_rightofuser);
}
public int InsertSYS_RightOfUser(SYS_RightOfUser sys_rightofuser)
{
return(_sys_rightofuserDataAccess.InsertSYS_RightOfUser(sys_rightofuser));
}
private static void SetSYS_RightOfUserInfo(DbDataReader reader, ref SYS_RightOfUser sys_rightofuser)
{
sys_rightofuser.RightId = int.Parse("0" + reader[FIELD_RIGHTID]);
sys_rightofuser.UserId = int.Parse("0" + reader[FIELD_USERID]);
sys_rightofuser.ID = int.Parse("0" + reader[FIELD_ID]);
}
