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