public object getShowBlackTv(int ftgid, int grupp)
{
/* int ftgid = 1;
* int grupp = 1;*/
List <TVrader> T = new List <TVrader>();
using (SqlConnection con = new SqlConnection(sConn))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.Connection.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spShowBlackTv";
cmd.Parameters.Add("@ftgid", SqlDbType.Int).Value = ftgid;
cmd.Parameters.Add("@gruppID", SqlDbType.Int).Value = grupp;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
TVrader t = new TVrader();
t.id = int.Parse(reader["id"].ToString());
t.ForetagsID = int.Parse(reader["ForetagsID"].ToString());
t.info = reader["info"].ToString();
t.tag = reader["tag"].ToString();
t.grupp = int.Parse(reader["grupp"].ToString());
T.Add(t);
}
cmd.Connection.Close();
}
}
string json = JsonConvert.SerializeObject(T, Formatting.Indented);
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.DeserializeObject(json));
}
public List <TVrader> getTV(int foretagsid)
{
List <TVrader> T = new List <TVrader>();
using (SqlConnection con = new SqlConnection(sConn))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.Connection.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spBlackTVedit";
cmd.Parameters.Add("@foretagsid", SqlDbType.Int).Value = foretagsid;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
TVrader t = new TVrader();
t.id = int.Parse(reader["id"].ToString());
t.ForetagsID = int.Parse(reader["ForetagsID"].ToString());
t.info = reader["info"].ToString();
t.tag = reader["tag"].ToString();
t.grupp = int.Parse(reader["grupp"].ToString());
t.Video = int.Parse(reader["video"].ToString());
T.Add(t);
}
cmd.Connection.Close();
}
}
return(T);
}
public object getShowBlackTvWEB(string ftgid)
{
int id = int.Parse(ftgid);
List <TVrader> T = new List <TVrader>();
using (SqlConnection con = new SqlConnection(sConn))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.Connection.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spBlackTVedit";
cmd.Parameters.Add("@foretagsid", SqlDbType.Int).Value = id;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
TVrader t = new TVrader();
t.id = int.Parse(reader["id"].ToString());
t.ForetagsID = int.Parse(reader["ForetagsID"].ToString());
t.info = reader["info"].ToString().Trim();
t.tag = reader["tag"].ToString().Trim();
t.grupp = int.Parse(reader["Gruppid"].ToString());
t.Gruppnamn = reader["Grupp"].ToString().Trim();
string text1 = reader["Video"].ToString();
int num1;
bool res = int.TryParse(text1, out num1);
if (res == false)
{
// String is not a number.
}
t.Video = num1;
//S**t datum
int i = reader["Datum"].ToString().Length;
if (i > 0)
{
t.Datum = reader["Datum"].ToString().Substring(0, 10);
}
else
{
t.Datum = reader["Datum"].ToString();
}
T.Add(t);
}
cmd.Connection.Close();
}
}
string json = JsonConvert.SerializeObject(T, Formatting.Indented);
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.DeserializeObject(json));
}
