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