public HG_FloorSide_or_RowName GetOne(int ID) { SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString()); Con.Open(); SqlCommand cmd = null; SqlDataReader SDR = null; HG_FloorSide_or_RowName ObjTmp = new HG_FloorSide_or_RowName(); try { string Query = "SELECT * FROM HG_FloorSide_or_RowName where ID=@ID"; cmd = new SqlCommand(Query, Con); cmd.Parameters.AddWithValue("@ID", ID); SDR = cmd.ExecuteReader(); while (SDR.Read()) { ObjTmp.ID = SDR.GetInt32(0); ObjTmp.FloorSide_or_RowName = SDR.GetString(1); ObjTmp.RowSize = SDR.GetInt32(2); ObjTmp.Type = SDR.GetString(3); ObjTmp.OrgID = SDR.GetInt32(4); } } catch (System.Exception e) { e.ToString(); } finally { Con.Close(); } return(ObjTmp); }
public List <HG_FloorSide_or_RowName> GetAll(int Type, int Orgid = 0) { var CurrOrgID = HttpContext.Current.Request.Cookies["UserInfo"]; SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString()); Con.Open(); SqlCommand cmd = null; SqlDataReader SDR = null; List <HG_FloorSide_or_RowName> ListTmp = new List <HG_FloorSide_or_RowName>(); try { string Query = "SELECT * FROM HG_FloorSide_or_RowName where Type=" + Type.ToString() + " ORDER BY ID DESC"; if (Orgid > 0) { Query = "SELECT * FROM HG_FloorSide_or_RowName where OrgID=" + Orgid.ToString() + " and Type=" + Type.ToString() + " ORDER BY ID DESC"; } else if (CurrOrgID != null && int.Parse(CurrOrgID["OrgId"]) > 0) { Query = "SELECT * FROM HG_FloorSide_or_RowName where OrgID=" + CurrOrgID["OrgId"] + " and Type=" + Type.ToString() + " ORDER BY ID DESC"; } cmd = new SqlCommand(Query, Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { HG_FloorSide_or_RowName ObjTmp = new HG_FloorSide_or_RowName(); ObjTmp.ID = SDR.GetInt32(0); ObjTmp.FloorSide_or_RowName = SDR.GetString(1); ObjTmp.RowSize = SDR.GetInt32(2); ObjTmp.Type = SDR.GetString(3); ObjTmp.OrgID = SDR.GetInt32(4); ListTmp.Add(ObjTmp); } } catch (System.Exception e) { e.ToString(); } finally { Con.Close(); } return(ListTmp); }
public static string Seating(Int64 SeatId) { HG_Tables_or_Sheat Objseating = new HG_Tables_or_Sheat().GetOne(SeatId); string Seating = ""; if (Objseating.Table_or_RowID > 0) { HG_Floor_or_ScreenMaster floor_Or_ScreenMaster = new HG_Floor_or_ScreenMaster().GetOne(Objseating.Floor_or_ScreenId); if (floor_Or_ScreenMaster.Floor_or_ScreenID > 0) { Seating = floor_Or_ScreenMaster.Name + " "; } HG_FloorSide_or_RowName side_Or_RowName = new HG_FloorSide_or_RowName().GetOne(Objseating.FloorSide_or_RowNoID); if (side_Or_RowName.ID > 0) { Seating += side_Or_RowName.FloorSide_or_RowName + " "; } Seating += Objseating.Table_or_SheetName; } return(Seating); }