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