protected void Grd_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
SYS_RoleOfUser sysRoleOfUser = new SYS_RoleOfUser();
SYS_Roles roles = new SYS_Roles();
roles.Name = e.NewValues["Name"] + "";
roles.IDOrganization = int.Parse(e.NewValues["IDOrganization"] + "");
if (CheckRole(roles.Name))
{
throw new Exception(string.Format("Trùng tên đơn vị! Vui lòng chọn lại."));
}
try
{
if (CheckRole(roles.Name) == false)
{
int RoleID = _ISYS_RolesService.InsertSYS_Roles(roles);
//sysRoleOfUser.RoleId = RoleID;
//sysRoleOfUser.UserId = (int)Session["UserId"];
//isyRoleOfUserService.InsertSYS_RoleOfUser(sysRoleOfUser);
_DataBind();
e.Cancel = true;
Grd.CancelEdit();
//WriteLog("Insert " + e.NewValues["Name"], Action.Create);
}
else
{
throw new Exception(string.Format("Trùng tên! Vui lòng nhập lại."));
}
}
catch (Exception)
{
throw new Exception("Trùng tên! Vui lòng nhập lại.");
}
}
public SYS_RoleOfUser SelectSYS_RoleOfUser(int ID)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
SYS_RoleOfUser sys_roleofuser = new SYS_RoleOfUser();
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_RoleOfUser_SelectById]", para.ToArray());
if (reader.HasRows && reader.Read())
{
SYS_RoleOfUserDataAccess.SetSYS_RoleOfUserInfo(reader, ref sys_roleofuser);
}
return(sys_roleofuser);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RoleOfUserDataAccess.SelectById: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
conn.Close();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (grdUserNotRoles.Selection.Count == 0)
{
return;
}
if (grdUserNotRoles.Selection.Count == 0)
{
return;
}
SYS_RoleOfUser roleOfUser;
List <Object> keyvalues = grdUserNotRoles.GetSelectedFieldValues("ID");
foreach (object key in keyvalues)
{
roleOfUser = new SYS_RoleOfUser();
roleOfUser.RoleId = int.Parse(cmbRoles.Value.ToString());
roleOfUser.UserId = int.Parse(key.ToString());
_sysRoleOfUserService.InsertSYS_RoleOfUser(roleOfUser);
_SYS_Roles.Name = grdUserNotRoles.GetRowValuesByKeyValue(key, "UserName").ToString();
//WriteLog("Insert " + _SYS_Roles.Name,Action.Create);
}
BindGrid();
grdUserOfRoles.Selection.UnselectAll();
grdUserNotRoles.Selection.UnselectAll();
}
public void DeleteSYS_User(SYS_User sys_user)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
SYS_RoleOfUserDataAccess sysRoleOfUserDA = new SYS_RoleOfUserDataAccess();
SYS_RoleOfUser sysRoleOfUser = new SYS_RoleOfUser();
sysRoleOfUser.UserId = sys_user.ID;
sysRoleOfUserDA.DeleteSYS_RoleOfUserByIDUser(sysRoleOfUser);
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_user.ID, false));
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_User_Delete]", para.ToArray());
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
}
protected void btnAddRoles_Click(object sender, EventArgs e)
{
SYS_RoleOfUser sysRoleOfUser = new SYS_RoleOfUser();
SYS_Roles roles = new SYS_Roles();
roles.Name = txtTenNhomQuyen.Text;
roles.IDOrganization = int.Parse(cmbOrganization.Value.ToString());
if (CheckIDOrganization(roles.IDOrganization))
{
throw new Exception(string.Format("Trùng tên đơn vị! Vui lòng chọn lại."));
}
try
{
if (CheckRole(roles.Name) == false)
{
int RoleID = _ISYS_RolesService.InsertSYS_Roles(roles);
//sysRoleOfUser.RoleId = RoleID;
//sysRoleOfUser.UserId = (int)Session["UserId"];
//isyRoleOfUserService.InsertSYS_RoleOfUser(sysRoleOfUser);
_DataBind();
pcAddRoles.ShowOnPageLoad = false;
//WriteLog("Insert " + txtTenNhomQuyen.Text, Action.Create);
}
else
{
throw new Exception(string.Format("Trùng tên! Vui lòng nhập lại."));
}
}
catch (Exception)
{
throw new Exception("Trùng tên! Vui lòng nhập lại.");
}
}
private static void SetListSYS_RoleOfUserInfo(ref DbDataReader reader, ref List <SYS_RoleOfUser> sys_roleofusers)
{
SYS_RoleOfUser sys_roleofuser = null;
while (reader.Read())
{
sys_roleofuser = new SYS_RoleOfUser();
SYS_RoleOfUserDataAccess.SetSYS_RoleOfUserInfo(reader, ref sys_roleofuser);
sys_roleofusers.Add(sys_roleofuser);
}
}
public int InsertSYS_UserAll(DM_USER dm_user)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
SYS_RoleOfUserDataAccess sysRoleOfUserDataAccess = new SYS_RoleOfUserDataAccess();
SYS_RightOfUserDataAccess sysRightOfUserDataAccess = new SYS_RightOfUserDataAccess();
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_IDUSER, DbType.Int32, true);
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_PASSWORD, dm_user.PASSWORD, 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_NGAYTAO, dm_user.NGAYTAO, false));
para.Add(_DbHelper.CreateParameter(FIELD_IS_ADMIN, dm_user.IS_ADMIN, false));
para.Add(_DbHelper.CreateParameter(FIELD_CHUCDANH, dm_user.CHUCDANH, false));
para.Add(ouput);
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_USER_Insert]", para.ToArray());
dm_user.IDUSER = (int)ouput.Value;
SYS_RoleOfUser sysRoleOfUser = new SYS_RoleOfUser();
sysRoleOfUser.RoleId = dm_user.Roles.ID;
//sysRoleOfUser.RoleId = sys_user.IDOrganization;
sysRoleOfUser.UserId = dm_user.IDUSER;
if (dm_user.Roles.ID != 0)
{
sysRoleOfUserDataAccess.InsertSYS_RoleOfUser(sysRoleOfUser);
}
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_UserDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
return(dm_user.IDUSER);
}
public void UpdateSYS_RoleOfUser(DbTransaction transaction, SYS_RoleOfUser sys_roleofuser)
{
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_roleofuser.UserId, false));
para.Add(_DbHelper.CreateParameter(FIELD_ROLEID, sys_roleofuser.RoleId, false));
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_roleofuser.ID, false));
_DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_RoleOfUser_Update]", para.ToArray());
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RoleOfUserDataAccess.Update: {0}", ex.Message));
}
}
public int InsertSYS_UserAll(SYS_User sys_user)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
SYS_RoleOfUserDataAccess sysRoleOfUserDataAccess = new SYS_RoleOfUserDataAccess();
SYS_RightOfUserDataAccess sysRightOfUserDataAccess = new SYS_RightOfUserDataAccess();
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
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));
para.Add(ouput);
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_User_Insert]", para.ToArray());
sys_user.ID = (int)ouput.Value;
SYS_RoleOfUser sysRoleOfUser = new SYS_RoleOfUser();
sysRoleOfUser.RoleId = sys_user.Roles.ID;
//sysRoleOfUser.RoleId = sys_user.IDOrganization;
sysRoleOfUser.UserId = sys_user.ID;
if (sys_user.Roles.ID != 0)
{
sysRoleOfUserDataAccess.InsertSYS_RoleOfUser(sysRoleOfUser);
}
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_UserDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
return(sys_user.ID);
}
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_RoleOfUserByIDUser(SYS_RoleOfUser sys_roleofuser)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_roleofuser.UserId, false));
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_RolesOfUser_Delete_ByIDUser]", para.ToArray());
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
}
public int InsertSYS_RoleOfUser(DbTransaction transaction, SYS_RoleOfUser sys_roleofuser)
{
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_roleofuser.UserId, false));
para.Add(_DbHelper.CreateParameter(FIELD_ROLEID, sys_roleofuser.RoleId, false));
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
para.Add(ouput);
_DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_RoleOfUser_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RoleOfUserDataAccess.Insert: {0}", ex.Message));
}
}
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_RoleOfUser(SYS_RoleOfUser sys_roleofuser)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_roleofuser.UserId, false));
para.Add(_DbHelper.CreateParameter(FIELD_ROLEID, sys_roleofuser.RoleId, false));
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_roleofuser.ID, false));
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_RoleOfUser_Update]", para.ToArray());
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RoleOfUserDataAccess.Update: {0}", ex.Message));
}
finally
{ conn.Close(); }
}
public int InsertSYS_RoleOfUser(SYS_RoleOfUser sys_roleofuser)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_roleofuser.UserId, false));
para.Add(_DbHelper.CreateParameter(FIELD_ROLEID, sys_roleofuser.RoleId, false));
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
para.Add(ouput);
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_RoleOfUser_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RoleOfUserDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
private static void SetSYS_RoleOfUserInfo(DbDataReader reader, ref SYS_RoleOfUser sys_roleofuser)
{
sys_roleofuser.UserId = int.Parse("0" + reader[FIELD_USERID]);
sys_roleofuser.RoleId = int.Parse("0" + reader[FIELD_ROLEID]);
sys_roleofuser.ID = int.Parse("0" + reader[FIELD_ID]);
}
public int InsertSYS_RoleOfUser(SYS_RoleOfUser sys_roleofuser)
{
return(_sys_roleofuserDataAccess.InsertSYS_RoleOfUser(sys_roleofuser));
}
public void UpdateSYS_RoleOfUser(SYS_RoleOfUser sys_roleofuser)
{
_sys_roleofuserDataAccess.UpdateSYS_RoleOfUser(sys_roleofuser);
}
public void DeleteSYS_RoleOfUser(SYS_RoleOfUser sys_roleofusers)
{
_sys_roleofuserDataAccess.DeleteSYS_RoleOfUser(sys_roleofusers);
}
