protected void Page_Load(object sender, EventArgs e)
{
String cmd = Request["cmd"];
int showid = Convert.ToInt32(Request["showid"]);
int showDetailsID = -1;
if (!String.IsNullOrEmpty(Request["ShowDetailsID"])) showDetailsID = Convert.ToInt32(Request["ShowDetailsID"]);
ShowDetails showDetails = new ShowDetails();
showDetails.ShowID = showid;
DataTable showDays = showDetails.GetDays();
foreach (DataRow showDayRow in showDays.Rows)
{
showDetailsID = Convert.ToInt32(showDayRow["ShowDetailID"]);
DateTime showDate = Convert.ToDateTime(showDayRow["ShowDate"]);
Response.Write( showDate.ToString("<h2>ddd, dd MMM yyyy</h2>"));
ShowDetails currentShowDate = new ShowDetails(showDetailsID);
Rings rings = new Rings();
DataSet ringsTable = rings.GetRingsForShowDay(showDetailsID);
int lastRingNo = 0;
foreach (DataRow row in ringsTable.Tables[0].Rows)
{
int ringID = Convert.ToInt32(row["RingID"]);
if (ringID > -1 && lastRingNo != Convert.ToInt32(row["RingNo"]))
{
lastRingNo = Convert.ToInt32(row["RingNo"]);
Response.Write(String.Format("<p>Ring: {0}</p>", lastRingNo));
DataSet judgesDS = rings.GetJudgesForRing(ringID);
if (judgesDS.Tables.Count > 0)
{
foreach (DataRow judgeRow in judgesDS.Tables[0].Rows)
{
Response.Write(String.Format("<p>Judge: {0}</p>", judgeRow["Name"]));
Judge judge = new Judge(judgeRow);
DataSet classesDS = judge.getClassesForJudge();
if (classesDS.Tables.Count > 0)
{
foreach (DataRow classRow in classesDS.Tables[0].Rows)
{
Response.Write(String.Format(" {2,-5} {3} {4} {7} {5} {6} ({1})<br>",
classRow["ClassID"], CalcDogsInCalc(classRow), classRow["ClsNo"], ShowClasses.expandHeight(classRow), ShowClasses.expandCatagory(classRow), classRow["LongName"], classRow["Name"], ShowClasses.shortenGrades(classRow)
));
}
}
}
}
//ringContainer.InnerHtml += String.Format(ringTemplate, lastRingNo, 1, judges, classes, ringID, helperList);
Response.Write("<br><br>");
}
}
Response.Write("<br><hr><br>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
String cmd = Request["cmd"];
int showid = Convert.ToInt32(Request["showid"]);
int showDetailsID = -1;
if (!String.IsNullOrEmpty(Request["ShowDetailsID"])) showDetailsID = Convert.ToInt32(Request["ShowDetailsID"]);
ShowID.Value = showid.ToString();
ShowDetails showDetails = new ShowDetails();
showDetails.ShowID = showid;
DataTable showDays = showDetails.GetDays();
foreach ( DataRow row in showDays.Rows) {
int currentShowDetailsID = Convert.ToInt32(row["ShowDetailID"]);
if (showDetailsID == -1) showDetailsID = currentShowDetailsID;
DateTime showDate = Convert.ToDateTime(row["ShowDate"]);
selShowDays.Items.Add(new ListItem(showDate.ToString("ddd, dd MMM yyyy"), row["ShowDetailID"].ToString() )) ;
if (showDetailsID == currentShowDetailsID)
{
selShowDays.SelectedIndex = selShowDays.Items.Count - 1;
}
}
ShowDetails currentShowDate = new ShowDetails(showDetailsID);
ShowDetailsID.Value = showDetailsID.ToString();
String tmp = "";
DataRowCollection unallocatedClasses = showDetails.getUnallocatedClassFoDay(showDetailsID);
foreach (DataRow row in unallocatedClasses)
{
tmp += String.Format("<li class='ui-state-default classDetails'><div clsid='{0}' dogsinclass='{1}' judgeid='{7}' class='clsDetails' ><div class='clsNo'>{2}</div><div class='clsName'>{3} {4} {8} {5} {6}</div></div></li>",
row["ClassID"], row["DogsInClass"], row["ClsNo"], ShowClasses.expandHeightShort(row), ShowClasses.expandCatagoryShort(row), row["ShortName"], row["Name"], row["JudgeID"], ShowClasses.shortenGrades(row)
);
}
classesAvailable.InnerHtml = tmp;
Rings rings = new Rings();
DataSet ringsTable = rings.GetRingsForShowDay(showDetailsID);
//DataSet judgesTable = rings.GetJudgesRingsForShow(showid);
//DataSet helpersTable = rings.GetHelpersRingsForShow(showid);
String ringTemplate = "<div class='ring ui-droppable ui-sortable' ringid='{0}' ringno='{1}' dogsinclass='0' judges='' helpers=''><h1 class='ui-widget-header'>Ring {1} (<span class='dogtotal'>0</span>)<span class='delthing'>X</span></h1>";
String ringJudgeClassTemplate = "<div class='judgeAndClasses'><h2 class='judgeInfo'><span class='judgeName'>{0}</span></h2><div class='classListArea'><ul class='ui-sortable fpp_sort'>{1}</ul><ul class='ui-sortable helperlist' style='display:none'>{2}</ul></div></div>";
int lastRingNo = 0;
foreach (DataRow ringTableRow in ringsTable.Tables[0].Rows)
{
Rings ring = new Rings(ringTableRow);
if (ring.ID> -1 && lastRingNo != ring.RingNo )
{
lastRingNo = ring.RingNo;
String ringTmp = String.Format(ringTemplate, ring.ID, ring.RingNo);
DataSet judgesDS = rings.GetJudgesForRing(ring.ID);
if (judgesDS.Tables[0].Rows.Count > 0)
{
foreach (DataRow judgeRow in judgesDS.Tables[0].Rows)
{
Judge judge = new Judge(judgeRow);
ringTmp += CreateRing(currentShowDate, ring, judge, ringJudgeClassTemplate, lastRingNo);
}
}
else
{
ringTmp += CreateRing(currentShowDate, ring, new Judge(), "", lastRingNo);
}
ringTmp += "</div>";
ringContainer.InnerHtml += ringTmp;
}
}
tmp = "";
DataSet ds = Judge.GetAllFreeJudgesForShow(showDetailsID);
foreach (DataRow row in ds.Tables[0].Rows)
{
tmp += String.Format("<li class='ui-state-default judgeDetails'><div judgeid='{0}' class='judgeDetails'>{1}</div></li>",
row["JudgeID"], row["Name"]
);
}
judgesAvailable.InnerHtml = tmp;
tmp = "";
Helpers helpers = new Helpers();
ds = helpers.GetAllFreeHelpersForShow(showid, currentShowDate.ShowDate);
if (ds.Tables.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
Helpers h = new Helpers(row);
String job = expandJob(h.Job, h.JobDetails);
tmp += String.Format("<li class='ui-state-default'><div helperid='{0}' judgeid='{2}' class='helperDetails'>{1} ({3})</div></li>",
h.ID, h.Name, row["judgeid"], job
);
}
}
helpersAvailable.InnerHtml = tmp;
}
}