public long m_lngAddApplUserGroupAndDetail(System.Security.Principal.IPrincipal p_objPrincipal, ref clsApplUserGroup_VO objApplUserGroupVO,
ref clsApplUserGroupDetail_VO[] objApplUserGroupDetailList, ref clsApplUserGroupRelation_VO[] objApplUserGroupRelation,
clsApplUserGroupRelation_VO p_objParentRelation)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngAddApplUserRelation");
if (lngRes < 0)
{
return(-1);
}
if (objApplUserGroupVO.strUserGroupID == null)
{
lngRes = m_lngAddAppUserGroup(p_objPrincipal, ref objApplUserGroupVO);
}
else
{
lngRes = m_lngSetApplUserGroup(p_objPrincipal, ref objApplUserGroupVO);
}
if (lngRes > 0)
{
if (objApplUserGroupDetailList != null)
{
for (int i = 0; i < objApplUserGroupDetailList.Length; i++)
{
objApplUserGroupDetailList[i].strUserGroupID = objApplUserGroupVO.strUserGroupID;
lngRes = m_lngAddApplUserGroupDetail(p_objPrincipal, ref objApplUserGroupDetailList[i]);
}
}
if (lngRes > 0)
{
if (objApplUserGroupRelation != null)
{
for (int i = 0; i < objApplUserGroupRelation.Length; i++)
{
objApplUserGroupRelation[i].strUserGroupID = objApplUserGroupVO.strUserGroupID;
lngRes = m_lngAddApplUserRelation(p_objPrincipal, ref objApplUserGroupRelation[i]);
}
}
}
if (lngRes > 0)
{
if (p_objParentRelation != null)
{
p_objParentRelation.strChildUserGroupID = objApplUserGroupVO.strUserGroupID;
lngRes = m_lngAddApplUserRelation(p_objPrincipal, ref p_objParentRelation);
if (lngRes > 0)
{
lngRes = m_lngUpdApplUserGroup(p_objPrincipal, "1", p_objParentRelation.strUserGroupID);
}
}
}
}
return(lngRes);
}
public long m_lngGetAllApplUserGroupRelation(System.Security.Principal.IPrincipal p_objPrincipal,
out clsApplUserGroupRelation_VO[] p_objResultArr)
{
long lngRes = 0;
p_objResultArr = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngGetCheckItemInApplGroupDetailByApplUserGroupID");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"SELECT * FROM T_AID_LIS_APPUSER_GROUP_RELATE";
try
{
DataTable dtbResult = null;
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult);
if (lngRes > 0 && dtbResult != null && dtbResult.Rows.Count > 0)
{
p_objResultArr = new clsApplUserGroupRelation_VO[dtbResult.Rows.Count];
for (int i = 0; i < p_objResultArr.Length; i++)
{
p_objResultArr[i] = new clsApplUserGroupRelation_VO();
p_objResultArr[i].strUserGroupID = dtbResult.Rows[i]["USER_GROUP_ID_CHR"].ToString().Trim();
p_objResultArr[i].strChildUserGroupID = dtbResult.Rows[i]["CHILD_USER_GROUP_ID_CHR"].ToString().Trim();
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngAddApplUserGroupAndDetailRelation(ref clsApplUserGroup_VO objApplUserGroupVO, ref clsApplUserGroupDetail_VO[] objApplUserGroupDetailVOList,
ref clsApplUserGroupRelation_VO[] objApplUserGroupRelationVOList, clsApplUserGroupRelation_VO p_objParentRelation)
{
long lngRes = 0;
com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc objAppGroupSvc = (com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc)
com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc));
lngRes = objAppGroupSvc.m_lngAddApplUserGroupAndDetail(objPrincipal, ref objApplUserGroupVO, ref objApplUserGroupDetailVOList,
ref objApplUserGroupRelationVOList, p_objParentRelation);
// objAppGroupSvc.Dispose();
return(lngRes);
}
public long m_lngAddApplUserRelation(System.Security.Principal.IPrincipal p_objPrincipal, ref clsApplUserGroupRelation_VO objApplUserGroupRelationVO)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngAddApplUserRelation");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"INSERT INTO t_aid_lis_appuser_group_relate
(user_group_id_chr, child_user_group_id_chr
)
VALUES (?, ?)" ;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
System.Data.IDataParameter[] objApplUserGroupRelationArr = null;
objHRPSvc.CreateDatabaseParameter(2, out objApplUserGroupRelationArr);
objApplUserGroupRelationArr[0].Value = objApplUserGroupRelationVO.strUserGroupID;
objApplUserGroupRelationArr[1].Value = objApplUserGroupRelationVO.strChildUserGroupID;
long lngRecEff = -1;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objApplUserGroupRelationArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
