public bool AddRTGroup(ResourcesGroups UG, string InsertUser)
{
bool rpta = false;
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[adm].[uspAddResourceGroup]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
//Insert Parameters
SqlParameter pRTID = new SqlParameter
{
ParameterName = "@ResourceTypeID",
SqlDbType = SqlDbType.Int,
Value = UG.ResourceTypeID
};
SqlCmd.Parameters.Add(pRTID);
SqlParameter pGroupID = new SqlParameter
{
ParameterName = "@GroupID",
SqlDbType = SqlDbType.Int,
Value = UG.GroupID
};
SqlCmd.Parameters.Add(pGroupID);
SqlParameter ParInsertUser = new SqlParameter
{
ParameterName = "@InsertUser",
SqlDbType = SqlDbType.VarChar,
Size = 50,
Value = InsertUser
};
SqlCmd.Parameters.Add(ParInsertUser);
//Exec Command
SqlCmd.ExecuteNonQuery();
rpta = true;
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(rpta);
}
public List <ResourcesGroups> RTList(int GroupID)
{
List <ResourcesGroups> List = new List <ResourcesGroups>();
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[config].[uspReadResourcesGroups]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
SqlParameter pID = new SqlParameter
{
ParameterName = "@GroupID",
SqlDbType = SqlDbType.Int,
Value = GroupID
};
SqlCmd.Parameters.Add(pID);
using (var dr = SqlCmd.ExecuteReader())
{
while (dr.Read())
{
var detail = new ResourcesGroups
{
ResourceGroupID = Convert.ToInt32(dr["ResourceGroupID"]),
GroupID = Convert.ToInt32(dr["GroupID"]),
ResourceTypeID = Convert.ToInt32(dr["ResourceTypeID"]),
TypeName = dr["TypeName"].ToString()
};
List.Add(detail);
}
}
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(List);
}
public bool RemoveRG(ResourcesGroups RG, string InsertUser)
{
return(GDAL.RemoveRG(RG, InsertUser));
}
public bool AddRTGroup(ResourcesGroups RG, string InsertUser)
{
return(GDAL.AddRTGroup(RG, InsertUser));
}
