public static Block RetrieveObj(string szSeatingChartId, string szBlockName)
{
BlockDbo dbo = new BlockDbo();
DataTable dt = dbo.RetrieveALLItems(szSeatingChartId, szBlockName);
if (dt == null || dt.Rows.Count <= 0)
{
return(null);
}
Block obj = ChangeObj(dt.Rows[0]);
return(obj);
}
public static BlockPrice RetrieveObj(string szShowPlanId, string szBlockId)
{
BlockDbo dbo = new BlockDbo();
DataTable dt = dbo.RetrieveALLItems(szShowPlanId, szBlockId);
if (dt == null || dt.Rows.Count <= 0)
{
return(null);
}
BlockPrice obj = ChangeObj(dt.Rows[0]);
return(obj);
}
public static List <SimBlock> RetrieveItems(string szSeatingChartId)
{
List <SimBlock> list = new List <SimBlock>();
DataTable dt = new BlockDbo().RetrieveALLItems(szSeatingChartId);
if (dt == null || dt.Rows.Count <= 0)
{
return(list);
}
foreach (DataRow dr in dt.Rows)
{
SimBlock obj = ChangeObj(dr);
list.Add(obj);
}
return(list);
}
public static bool DeleteObj(Block bk, string szBlockId_Default)
{
BlockDbo dbo = new BlockDbo();
BlockPo po = new BlockPo();
po.BLOCKID = bk.BlockId;
po.BLOCKNAME = bk.BlockName;
po.BGCOLOUR = bk.Bgcolour;
po.HASBLOCKPRICE = bk.HasBlockPrice;
po.SEATINGCHARTID = bk.SeatingChartId;
po.SEATS = bk.Seats;
po.CREATED = DateTime.Now;
po.UPDATED = DateTime.Now;
po.ACTIVEFLAG = 1;
return(dbo.DeleteAll(po, szBlockId_Default));
}
public static bool CreateObj(Block bk)
{
BlockDbo dbo = new BlockDbo();
BlockPo po = new BlockPo();
po.BLOCKID = bk.BlockId.Trim().Length <= 0 ? dbo.BuildId(bk.SeatingChartId) : bk.BlockId;
po.BLOCKNAME = bk.BlockName;
po.BGCOLOUR = bk.Bgcolour;
po.HASBLOCKPRICE = bk.HasBlockPrice;
po.SEATINGCHARTID = bk.SeatingChartId;
po.SEATS = bk.Seats;
po.CREATED = DateTime.Now;
po.UPDATED = DateTime.Now;
po.ACTIVEFLAG = 1;
return(dbo.Insert(po));
}
public static List <BlockPriceRich> RetrieveObjList(string szSeatingChartId, string szShowPlanId)
{
List <BlockPriceRich> list = new List <BlockPriceRich>();
BlockDbo dbo = new BlockDbo();
DataTable dt = dbo.RetrieveALLItems_Ext(szSeatingChartId, szShowPlanId);
if (dt == null || dt.Rows.Count <= 0)
{
return(list);
}
foreach (DataRow dr in dt.Rows)
{
BlockPriceRich bpR = new BlockPriceRich();
bpR._block = Block.ChangeObj(dr);
bpR._blockPrice = BlockPrice.ChangeObj(dr);
list.Add(bpR);
}
return(list);
}
public static string GetDefaultBlock(string szSeatingChartId)
{
BlockDbo dbo = new BlockDbo();
return(dbo.GetDefaultBlock(szSeatingChartId));
}
