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