public static DataTable getCallLetters_Flagship(DataTable Table)
{
DataTable RTable = new DataTable();
RTable.Columns.Add("Flagship", typeof(String));
RTable.Columns.Add("Repeater Station", typeof(String));
RTable.Columns.Add("State", typeof(String));
RTable.Columns.Add("City", typeof(String));
RTable.Columns.Add("Freq", typeof(String));
RTable.Columns.Add("Member Status", typeof(String));
RTable.Columns.Add("Metro", typeof(String));
RTable.Columns.Add("DMA", typeof(String));
DataSet RDataSet = new DataSet();
RDataSet.Tables.Add(Table);
int row = RDataSet.Tables[0].Rows.Count;
int col = RDataSet.Tables[0].Columns.Count;
string FlagshipStation = "";
for (int x = 0; x < row; x++)
{
DataRow r = RTable.NewRow();
RTable.Rows.Add(r);
for (int y = 0; y < col; y++)
{
if (y == 0)
{
//string temp = (RDataSet.Tables[0].Rows[x][y].ToString());
long?StationId = ((RDataSet.Tables[0].Rows[x][y]) as long?);
if (StationId.HasValue)
{
DataTable tempDataTable = CRCDataAccess.Get_CallLetters(StationId);
DataSet tempDataset = new DataSet();
tempDataset.Tables.Add(tempDataTable);
FlagshipStation = tempDataset.Tables[0].Rows[0][0].ToString();
//FlagshipStation = CRCDataAccess.Get_CallLetters(StationId);
RTable.Rows[x][y] = FlagshipStation;
FlagshipStation = "";
}
else
{
RTable.Rows[x][y] = FlagshipStation;
}
}
else
{
RTable.Rows[x][y] = RDataSet.Tables[0].Rows[x][y];
}
}
}
return(RTable);
}