public object ContentList(ContentListSongster contentList) { if (contentList.PortalCode == "stk") { var listOfContents = _context.Database.SqlQuery <sp_GetContentList_Result>("sp_GetContentList_stk").ToList(); return(Ok(listOfContents)); } else if (contentList.PortalCode == "sb") { var listOfContents = _context.Database.SqlQuery <sp_GetContentList_Sb1_Result>("EXEC sp_GetContentList_Sb").ToList(); return(Ok(listOfContents)); } else if (contentList.PortalCode == "lp") { var listOfContents = _hoiChoiEntities.Database.SqlQuery <sp_GetGameData_Result>("EXEC sp_GetGameData").ToList(); return(Ok(listOfContents)); } else if (contentList.PortalCode == "song") { // var listOfContents = MySqlList(); return(Ok()); } else { var listOfContents = _context.Database.SqlQuery <sp_GetContentList_Result>("sp_GetContentList @portalcode,@catcode", new SqlParameter("@portalcode", contentList.PortalCode ?? "123"), new SqlParameter("@catcode", contentList.CatCode ?? "123") ).ToList(); return(Ok(listOfContents)); } }
public object ContentListSongster(ContentListSongster contentList) { var uid = contentList.Uid; var caption = contentList.Caption; var listOfContents = MySqlList(uid, caption); return(Ok(listOfContents)); return(Ok()); }