public void Read(MySqlDataReader rdr, bool StubOnly = false)
{
this.PageID = rdr.GetInt32("PageID");
this.PageNo = rdr.GetInt32("PageNo");
this.FrameNo = rdr.GetInt32("FrameNo");
this.Title = rdr.GetString("Title").Trim();
if (string.IsNullOrEmpty(this.Title))
{
this.Title = "None";
}
decimal toPageFrameNo = rdr.GetDecimal("ToPageFrameNo");
this.ToPageNo = Convert.ToInt32(toPageFrameNo);
this.ToFrameNo = Convert.ToInt32((toPageFrameNo - this.ToPageNo) * 100);
this.OwnerID = rdr.GetInt32Safe("OwnerID");
this.Updated = rdr.GetDateTimeNullable("Updated");
this.UpdatedByID = rdr.GetInt32Safe("UpdatedBy");
if (StubOnly)
{
return;
}
this.Contents = rdr.GetBytesNullable("Contents");
this.URL = rdr.GetStringNullable("URL").Trim();
this.BoxMode = rdr.GetBoolean("BoxMode");
this.TeleSoftwareID = rdr.GetInt32Nullable("TeleSoftwareID");
this.IsCarousel = rdr.GetBooleanSafe("IsCarousel");
this.CarouselWait = rdr.GetInt32Safe("CarouselWait");
this.ConvertContentsFromURL();
}
public void Read(MySqlDataReader rdr, bool IncludeKeyCode = true)
{
if (IncludeKeyCode)
{
this.KeyCode = rdr.GetByte("KeyCode");
}
int CurrentPageNo = rdr.GetInt32Safe("CurrentPageNo");
int CurrentFrameNo = rdr.GetInt32Safe("CurrentFrameNo");
this.NextPageNo = rdr.GetInt32Nullable("NextPageNo");
this.NextFrameNo = rdr.GetInt32Nullable("NextFrameNo");
this.GoNextPage = rdr.GetBoolean("GoNextPage");
this.GoNextFrame = rdr.GetBoolean("GoNextFrame");
var master = Routes.MasterList.FirstOrDefault(r => r.KeyCode == KeyCode);
this.Description = (master == null) ? Convert.ToChar(KeyCode).ToString() : master.Description;
// 1) Next Page checked
if (GoNextPage && !GoNextFrame)
{
this.GoesToPageID = rdr.GetInt32Safe("NextPageID");
if (this.GoesToPageID > 0)
{
this.GoesToPageNo = rdr.GetInt32Safe("NextPagePageNo");
this.GoesToFrameNo = rdr.GetInt32Safe("NextPageFrameNo");
this.GoesToPageFrameDesc = this.GoesToPageNo.ToString()
+ ((char)Convert.ToByte(((byte)"a"[0]) + this.GoesToFrameNo)).ToString();
}
else
{
this.GoesToPageID = Options.MainIndexPageID;
this.GoesToPageNo = Options.MainIndexPageNo;
this.GoesToFrameNo = Options.MainIndexFrameNo;
this.GoesToPageFrameDesc = Options.MainIndexPage;
}
}
// 2) Next Frame checked
else if (GoNextFrame && !GoNextPage)
{
this.GoesToPageID = rdr.GetInt32Safe("NextFrameID");
if (this.GoesToPageID > 0)
{
this.GoesToPageNo = rdr.GetInt32Safe("NextFramePageNo");
this.GoesToFrameNo = rdr.GetInt32Safe("NextFrameFrameNo");
this.GoesToPageFrameDesc = this.GoesToPageNo.ToString()
+ ((char)Convert.ToByte(((byte)"a"[0]) + this.GoesToFrameNo)).ToString();
}
else
{
this.GoesToPageID = rdr.GetInt32Safe("NextPageID");
if (this.GoesToPageID > 0 && CurrentFrameNo == 25)
{
this.GoesToPageNo = rdr.GetInt32Safe("NextPagePageNo");
this.GoesToFrameNo = rdr.GetInt32Safe("NextPageFrameNo");
this.GoesToPageFrameDesc = this.GoesToPageNo.ToString()
+ ((char)Convert.ToByte(((byte)"a"[0]) + this.GoesToFrameNo)).ToString();
}
else
{
this.GoesToPageID = Options.MainIndexPageID;
this.GoesToPageNo = Options.MainIndexPageNo;
this.GoesToFrameNo = Options.MainIndexFrameNo;
this.GoesToPageFrameDesc = Options.MainIndexPage;
}
}
}
// 3) Both checked
else if (GoNextFrame && GoNextPage)
{
this.GoesToPageID = rdr.GetInt32Safe("NextFrameID");
if (this.GoesToPageID > 0)
{
this.GoesToPageNo = rdr.GetInt32Safe("NextFramePageNo");
this.GoesToFrameNo = rdr.GetInt32Safe("NextFrameFrameNo");
this.GoesToPageFrameDesc = this.GoesToPageNo.ToString()
+ ((char)Convert.ToByte(((byte)"a"[0]) + this.GoesToFrameNo)).ToString();
}
if (this.GoesToPageID <= 0)
{
this.GoesToPageID = rdr.GetInt32Safe("NextPageID");
if (this.GoesToPageID > 0)
{
this.GoesToPageNo = rdr.GetInt32Safe("NextPagePageNo");
this.GoesToFrameNo = rdr.GetInt32Safe("NextPageFrameNo");
this.GoesToPageFrameDesc = this.GoesToPageNo.ToString()
+ ((char)Convert.ToByte(((byte)"a"[0]) + this.GoesToFrameNo)).ToString();
}
}
if (this.GoesToPageID <= 0)
{
this.GoesToPageID = Options.MainIndexPageID;
this.GoesToPageNo = Options.MainIndexPageNo;
this.GoesToFrameNo = Options.MainIndexFrameNo;
this.GoesToPageFrameDesc = Options.MainIndexPage;
}
}
// 4) Neither checked
else
{
this.GoesToPageID = rdr.GetInt32Safe("DirectPageID");
if (this.GoesToPageID > 0)
{
this.GoesToPageNo = rdr.GetInt32Safe("DirectPageNo");
this.GoesToFrameNo = rdr.GetInt32Safe("DirectFrameNo");
this.GoesToPageFrameDesc = this.GoesToPageNo.ToString()
+ ((char)Convert.ToByte(((byte)"a"[0]) + this.GoesToFrameNo)).ToString();
}
else
{
this.GoesToPageID = -1;
this.GoesToPageNo = -1;
this.GoesToFrameNo = 0;
this.GoesToPageFrameDesc = "No Page";
}
}
}
