public List <HG_Tables_or_Sheat> GetAllWithTakeAwya(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_Tables_or_Sheat> listTemp = new List <HG_Tables_or_Sheat>(); string Query = "SELECT * FROM HG_Tables_or_Sheat ORDER BY Table_or_RowID DESC"; if (OrgId > 0) { Query = "SELECT * FROM HG_Tables_or_Sheat where OrgId=" + OrgId.ToString() + " and ( Type=" + Type.ToString() + " or Type=3 ) ORDER BY Table_or_RowID DESC"; } else if (CurrOrgID != null && int.Parse(CurrOrgID["OrgId"]) > 0) { Query = "SELECT * FROM HG_Tables_or_Sheat where OrgId=" + CurrOrgID["OrgId"] + " and ( Type=" + Type.ToString() + " or Type=3) ORDER BY Table_or_RowID DESC"; } try { cmd = new SqlCommand(Query, Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { HG_Tables_or_Sheat ObjTemp = new HG_Tables_or_Sheat(); ObjTemp.Table_or_RowID = SDR.GetInt64(0); ObjTemp.OrgId = SDR.GetInt32(1); ObjTemp.Table_or_SheetName = SDR.GetString(2); ObjTemp.Floor_or_ScreenId = SDR.GetInt32(3); ObjTemp.FloorSide_or_RowNoID = SDR.GetInt32(4); ObjTemp.Type = SDR.GetString(5); ObjTemp.CreateDate = SDR.GetDateTime(6); ObjTemp.CreateBy = SDR.GetInt32(7); ObjTemp.Status = SDR.IsDBNull(8) ? 1 : SDR.GetInt32(8); ObjTemp.Otp = SDR.IsDBNull(9) ? 1000 : SDR.GetInt32(9); ObjTemp.OMID = SDR.IsDBNull(10) ? 0 : SDR.GetInt32(10); ObjTemp.QrCode = SDR.IsDBNull(11) ? "0" : SDR.GetString(11); ObjTemp.FDBKId = SDR.GetInt32(12); listTemp.Add(ObjTemp); } } catch (System.Exception e) { e.ToString(); } finally { Con.Close(); } return(listTemp); }
public HG_Tables_or_Sheat GetOne(Int64 Table_or_RowID = 0, string QrOcde = "") { SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString()); Con.Open(); SqlCommand cmd = null; SqlDataReader SDR = null; HG_Tables_or_Sheat ObjTemp = new HG_Tables_or_Sheat(); try { string Query = ""; if (Table_or_RowID > 0) { Query = "SELECT * FROM HG_Tables_or_Sheat where Table_or_RowID=" + Table_or_RowID.ToString(); } else { Query = "SELECT * FROM HG_Tables_or_Sheat where QrCode='" + QrOcde + "'"; } cmd = new SqlCommand(Query, Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { ObjTemp.Table_or_RowID = SDR.GetInt64(0); ObjTemp.OrgId = SDR.GetInt32(1); ObjTemp.Table_or_SheetName = SDR.GetString(2); ObjTemp.Floor_or_ScreenId = SDR.GetInt32(3); ObjTemp.FloorSide_or_RowNoID = SDR.GetInt32(4); ObjTemp.Type = SDR.GetString(5); ObjTemp.CreateDate = SDR.GetDateTime(6); ObjTemp.CreateBy = SDR.GetInt32(7); ObjTemp.Status = SDR.IsDBNull(8) ? 1: SDR.GetInt32(8); ObjTemp.Otp = SDR.IsDBNull(9) ? 1000 : SDR.GetInt32(9); ObjTemp.OMID = SDR.IsDBNull(10) ? 0 : SDR.GetInt32(10); ObjTemp.QrCode = SDR.IsDBNull(11) ? "0" : SDR.GetString(11); ObjTemp.FDBKId = SDR.GetInt32(12); } } catch (System.Exception e) { e.ToString(); } finally { Con.Close(); } return(ObjTemp); }
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); }