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>");
}
}
public static String getJudgeForClass(int ClassID)
{
var tmp = "";
String moduleSettings = ModuleConfig.GetSettings();
Data.Judge j = new Fpp.WebModules.Data.Judge(moduleSettings);
DataSet ds = j.getJudgeForClass(ClassID);
if (ds.Tables[0].Rows.Count > 0) {
int JudgeID = Convert.ToInt32(ds.Tables[0].Rows[0]["JudgeID"]);
Judge judge = new Judge(JudgeID);
if (judge.ID > -1)
{
tmp = judge.Name;
}
}
return tmp;
}
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;
}
}
private String CreateRing(ShowDetails currentShowDate, Rings ring, Judge judge, String ringTemplate, int lastRingNo)
{
DataSet helperDS;
String judges;
String classes = "";
String helperList = "";
judges = String.Format("<p judgeid='{0}'>{1}</p>", judge.ID.ToString(), judge.Name);
//helperDS = rings.GetHelpersForJudge(currentShowDate, Convert.ToInt32(judgeRow["JudgeID"]));
//if (helperDS.Tables.Count > 0)
//{
// foreach (DataRow helperRow in helperDS.Tables[0].Rows)
// {
// Helpers h = new Helpers(helperRow);
// helperList += String.Format("<li class='ui-draggable' ><div helperid='{0}' class='helperDetails'>{1} ({2})</div></li>", h.ID, h.Name, h.JobName);
// }
//}
helperDS = Helpers.GetHelpersForRing(currentShowDate, ring.ID);
if (helperDS.Tables.Count > 0)
{
foreach (DataRow helperRow in helperDS.Tables[0].Rows)
{
Helpers h = new Helpers(helperRow);
String job = expandJob(h.Job, h.JobDetails);
helperList += String.Format("<li class='ui-draggable' ><div helperid='{0}' class='helperDetails'>{1} ({2})</div></li>", h.ID, h.Name, job);
}
}
DataSet classesDS = Rings.GetClassesForRing(ring.ID);
classesDS = judge.getClassesForJudge();
if (classesDS.Tables.Count > 0)
{
foreach (DataRow classRow in classesDS.Tables[0].Rows)
{
classes += String.Format("<li><div clsid='{0}' dogsinclass='{1}' class='clsDetails'><div class='clstotal'>({1})</div><div class='clsNo'>{2}</div><div class='clsName'>{3} {4} {7} {5} {6}</div></div></li>",
classRow["ClassID"], CalcDogsInCalc(classRow), classRow["ClsNo"], ShowClasses.expandHeightShort(classRow), ShowClasses.expandCatagoryShort(classRow), classRow["ShortName"], classRow["Name"], ShowClasses.shortenGrades(classRow)
);
}
if (classes.Length == 0)
{
classes = "<li class='blank'></li>";
}
}
return String.Format(ringTemplate, judges, classes, helperList);
}
public bool Delete()
{
Data.ShowDetails showDetails = new Fpp.WebModules.Data.ShowDetails(_moduleSettings);
ShowClasses sc = new ShowClasses();
sc.removeRing(_id);
Judge j = new Judge();
j.removeRing(_id);
Helpers h = new Helpers();
h.removeRing(_id);
_ring.Delete(_id);
return true;
}