/// <summary>
/// This method uses to update a DataSet of SysRole
/// </summary>
/// <param name="pData">SysRole Data</param>
public void UpdateDataSet(DataSet pData)
{
const string METHOD_NAME = THIS + ".UpdateDataSet()";
try
{
using (var trans = new TransactionScope())
{
var dsSysRole = new Sys_RoleDS();
dsSysRole.UpdateDataSet(pData);
trans.Complete();
}
}
catch (SqlException ex)
{
if (ex.Errors.Count > 1)
{
if (ex.Number == ErrorCode.SQLDUPLICATE_KEYCODE)
{
throw new PCSDBException(ErrorCode.DUPLICATE_KEY, METHOD_NAME, ex);
}
throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex);
}
throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex);
}
}
/// <summary>
/// This method uses to get all visibility data
/// </summary>
/// <returns>DataSet</returns>
/// <Author> Hung LA, Dec 13, 2004</Author>
public DataSet GetVisibilityData()
{
const string METHOD_NAME = THIS + "GetVisibilityData()";
// TODO : Remove after constant approved
const int CANNOT_GET_VISIBILITY_DATA = -1;
DataSet dstData = new DataSet();
try
{
Sys_VisibilityGroupDS dsVisibilityGroup = new Sys_VisibilityGroupDS();
dstData.Merge(dsVisibilityGroup.List().Tables[0]);
Sys_VisibilityItemDS dsVisibilityItem = new Sys_VisibilityItemDS();
dstData.Merge(dsVisibilityItem.List().Tables[0]);
Sys_VisibilityGroup_RoleDS dsVisibilityGroup_Role = new Sys_VisibilityGroup_RoleDS();
dstData.Merge(dsVisibilityGroup_Role.List().Tables[0]);
Sys_RoleDS dsRole = new Sys_RoleDS();
dstData.Merge(dsRole.ListAll().Tables[0]);
}
catch (PCSDBException ex)
{
throw new PCSBOException(CANNOT_GET_VISIBILITY_DATA, METHOD_NAME, ex);
}
catch (Exception ex)
{
throw ex;
}
return(dstData);
}
/// <summary>
/// Get a list of all Role that doesn't grant to User
/// </summary>
/// <param name="intUserId"></param>
/// <returns></returns>
/// <Author> Thien HD, Jan 07, 2005</Author>
public DataSet ListRoleNotGrantToUser(int intUserId)
{
try
{
Sys_RoleDS objSysRoleDs = new Sys_RoleDS();
return(objSysRoleDs.ListRoleNotGrantToUser(intUserId));
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Return a list of Field Length
/// </summary>
/// <returns>DataRow</returns>
/// <Author>Thien HD, Jan-07-2005 </Author>
public DataRow GetFieldLength()
{
try
{
Sys_RoleDS objSysRoleDS = new Sys_RoleDS();
return(objSysRoleDS.GetFieldLength());
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Return a list of role
/// </summary>
/// <returns></returns>
/// <Author>Thien HD, Jan-07-2005 </Author>
public DataSet List()
{
try
{
Sys_RoleDS objSysRoleDS = new Sys_RoleDS();
return(objSysRoleDS.List());
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Update Dataset of table Sys_Role
/// </summary>
/// <param name="dstData">DataSet</param>
/// <Author>Thien HD, Jan-07-2005 </Author>
public void UpdateDataSet(DataSet dstData)
{
// TODO: Add ManageRoleBO.UpdateDataSet implementation
try
{
//Init the DS object
Sys_RoleDS objSysRoleDs = new Sys_RoleDS();
objSysRoleDs.UpdateDataSet(dstData);
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// list all roles
/// </summary>
/// <returns>DataSet</returns>
/// <author>Trada</author>
/// <date>Wednesday, Nov 16 2005</date>
public DataSet ListRole()
{
Sys_RoleDS dsSys_Role = new Sys_RoleDS();
return(dsSys_Role.List());
}
public DataSet GetSecurityInfo(string pstrUserName, string pstrFormName)
{
var dsRole = new Sys_RoleDS();
return(dsRole.GetSecurityInfo(pstrUserName, pstrFormName));
}
/// <summary>
/// Get Role for a specify user and some system properties for this.
/// And get all system params
/// </summary>
/// <param name="pintUserID"></param>
/// <param name="pstrUserName"></param>
/// <param name="pintCCNID"></param>
/// <returns></returns>
/// <author>Trada</author>
/// <date>Wednesday, December 14 2005</date>
public DataSet ListRoleAndSysParam(int pintUserID, string pstrUserName)
{
var objSysRoleDs = new Sys_RoleDS();
return(objSysRoleDs.ListRoleAndSysParam(pintUserID, pstrUserName));
}
/// <summary>
/// This method uses to get all data in SysRole table
/// </summary>
/// <returns></returns>
public DataSet List()
{
var dsSysRole = new Sys_RoleDS();
return(dsSysRole.List());
}
/// <summary>
/// Update Dataset of table Sys_Role after deleting related rights
/// </summary>
/// <param name="dstData"></param>
/// <Author>Duong NA, Oct-10-2005 </Author>
public void UpdateDataSetAndDelete(DataSet dstData, string pstrDeletedRoleIDs)
{
const char CHR_SEPARATOR = ',';
//const int DEFAULT_PERMISSION = 1;
string strAddedRole = string.Empty;
//Begin edit by duongna 10-10-2005 to add default menus to new role and delete all menus assigned to role
//mark added role
foreach (DataRow drRole in dstData.Tables[0].Rows)
{
if (drRole.RowState == DataRowState.Added)
{
strAddedRole += "'" + drRole[Sys_RoleTable.NAME_FLD].ToString().Replace("'", "''") + "' ,";
}
}
if (strAddedRole.EndsWith(CHR_SEPARATOR.ToString()))
{
strAddedRole = strAddedRole.Substring(0, strAddedRole.Length - 1);
}
//Delete all menu entries assigned to this role
Sys_RightDS objRightDS = new Sys_RightDS();
if (pstrDeletedRoleIDs.Length > 0)
{
pstrDeletedRoleIDs = pstrDeletedRoleIDs.Replace(';', ',');
objRightDS.DeleteRightsOfRole(pstrDeletedRoleIDs);
}
//End edit by duongna 10-10-2005
//Init the DS object
Sys_RoleDS objSysRoleDs = new Sys_RoleDS();
objSysRoleDs.UpdateDataSet(dstData);
//
if (strAddedRole.Length > 0)
{
Sys_VisibilityGroup_RoleDS dsVisibility = new Sys_VisibilityGroup_RoleDS();
dsVisibility.InsertDefaultVisibility(strAddedRole);
objRightDS.InsertDefaultMenu(strAddedRole);
}
//Begin edit by duongna 10-10-2005
#region // HACK: DEL SonHT 2005-12-09
//Add default menus for added role
// foreach (string strIndex in strAddedRole.Split(CHR_SEPARATOR))
// {
// try
// {
// nIndex = Convert.ToInt32(strIndex);
// }
// catch
// {
// continue;
// }
// if (dstData.Tables[0].Rows[nIndex].RowState == DataRowState.Unchanged)
// {
// //Get all default menu entry
// Sys_Menu_EntryDS objSysMenuDS = new Sys_Menu_EntryDS();
// Sys_RightDS objSysRight = new Sys_RightDS();
// ArrayList arrDefaultMenus = objSysMenuDS.GetAllDefaultMenus();
// //Do add default rights here
// foreach (int nMenuID in arrDefaultMenus)
// {
// Sys_RightVO voRight = new Sys_RightVO();
// voRight.Menu_EntryID = nMenuID;
// voRight.Permission = DEFAULT_PERMISSION;
// try
// {
// voRight.RoleID = Convert.ToInt32(dstData.Tables[0].Rows[nIndex][Sys_RoleTable.ROLEID_FLD]);
// }
// catch
// {
// continue;
// }
// objSysRight.Add(voRight);
// }
// }
// }
//End edit by duongna
#endregion // END: DEL SonHT 2005-12-09
}
