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)); }