public HG_Floor_or_ScreenMaster GetOne(int Floor_or_ScreenID) { SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString()); Con.Open(); SqlCommand cmd = null; SqlDataReader SDR = null; HG_Floor_or_ScreenMaster ObjTmp = new HG_Floor_or_ScreenMaster(); try { string Query = "SELECT * FROM HG_Floor_or_ScreenMaster where Floor_or_ScreenID=@Floor_or_ScreenID"; cmd = new SqlCommand(Query, Con); cmd.Parameters.AddWithValue("@Floor_or_ScreenID", Floor_or_ScreenID); SDR = cmd.ExecuteReader(); while (SDR.Read()) { ObjTmp.Floor_or_ScreenID = SDR.GetInt32(0); ObjTmp.Name = SDR.GetString(1); ObjTmp.CreatedBy = SDR.GetInt32(2); ObjTmp.CreatonDate = SDR.GetDateTime(3); ObjTmp.UpdatedBy = SDR.GetInt32(4); ObjTmp.UpdateionDate = SDR.GetInt32(5); ObjTmp.Type = SDR.GetString(6); ObjTmp.OrgID = SDR.GetInt32(7); } } catch (System.Exception e) { e.ToString(); } finally { Con.Close(); } return(ObjTmp); }
public List <HG_Floor_or_ScreenMaster> 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_Floor_or_ScreenMaster> ListTmp = new List <HG_Floor_or_ScreenMaster>(); try { string Query = "SELECT * FROM HG_Floor_or_ScreenMaster where Type=" + Type.ToString() + " ORDER BY Floor_or_ScreenID DESC"; if (OrgId > 0) { Query = "SELECT * FROM HG_Floor_or_ScreenMaster where OrgID=" + OrgId.ToString() + " and Type=" + Type.ToString() + " ORDER BY Floor_or_ScreenID DESC"; } else if (CurrOrgID != null && int.Parse(CurrOrgID["OrgId"]) > 0) { Query = "SELECT * FROM HG_Floor_or_ScreenMaster where OrgID=" + CurrOrgID["OrgId"] + " and Type=" + Type.ToString() + " ORDER BY Floor_or_ScreenID DESC"; } cmd = new SqlCommand(Query, Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { HG_Floor_or_ScreenMaster ObjTmp = new HG_Floor_or_ScreenMaster(); ObjTmp.Floor_or_ScreenID = SDR.GetInt32(0); ObjTmp.Name = SDR.GetString(1); ObjTmp.CreatedBy = SDR.GetInt32(2); ObjTmp.CreatonDate = SDR.GetDateTime(3); ObjTmp.UpdatedBy = SDR.GetInt32(4); ObjTmp.UpdateionDate = SDR.GetInt32(5); ObjTmp.Type = SDR.GetString(6); ObjTmp.OrgID = SDR.GetInt32(7); 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); }