/// <summary> /// GetByGroupAndFunction /// Calls [usp_select_SecurityGroupSecurityFunctionPermission_by_Group_and_Function] /// </summary> public override SecurityGroupSecurityFunctionPermissionDetails GetByGroupAndFunction(System.Int32?securityGroupNo, System.Int32?securityFunctionNo) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_select_SecurityGroupSecurityFunctionPermission_by_Group_and_Function", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@SecurityGroupNo", SqlDbType.Int).Value = securityGroupNo; cmd.Parameters.Add("@SecurityFunctionNo", SqlDbType.Int).Value = securityFunctionNo; cn.Open(); DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow); if (reader.Read()) { //return GetSecurityGroupSecurityFunctionPermissionFromReader(reader); SecurityGroupSecurityFunctionPermissionDetails obj = new SecurityGroupSecurityFunctionPermissionDetails(); obj.SecurityGroupSecurityFunctionPermissionId = GetReaderValue_Int32(reader, "SecurityGroupSecurityFunctionPermissionId", 0); obj.SecurityGroupNo = GetReaderValue_Int32(reader, "SecurityGroupNo", 0); obj.SecurityFunctionNo = GetReaderValue_Int32(reader, "SecurityFunctionNo", 0); obj.IsAllowed = GetReaderValue_Boolean(reader, "IsAllowed", false); obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); return(obj); } else { return(null); } } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get SecurityGroupSecurityFunctionPermission", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
private static SecurityGroupSecurityFunctionPermission PopulateFromDBDetailsObject(SecurityGroupSecurityFunctionPermissionDetails obj) { SecurityGroupSecurityFunctionPermission objNew = new SecurityGroupSecurityFunctionPermission(); objNew.SecurityGroupSecurityFunctionPermissionId = obj.SecurityGroupSecurityFunctionPermissionId; objNew.SecurityGroupNo = obj.SecurityGroupNo; objNew.SecurityFunctionNo = obj.SecurityFunctionNo; objNew.IsAllowed = obj.IsAllowed; objNew.UpdatedBy = obj.UpdatedBy; objNew.DLUP = obj.DLUP; return(objNew); }