//// To check UserHas SPocsor Folder and retrive the values //public static int CheckForUserSponsorFolder(int SpocorFolderId, int UserId) //{ // using (EditorsEntities entity = new EditorsEntities()) // { // var UserSposorFolder = (from us in entity.UserHasSponsorFolders // where us.SponsorFolderId == SpocorFolderId && us.UserId == UserId // select us).FirstOrDefault(); // if (UserSposorFolder == null) // { // return SpocorFolderId; // } // else // { // return 0; // } // } //} // To Add Sposor folder Id //public static bool AddSponsorFolder(int sfid, int userid) //{ // using (EditorsEntities entity = new EditorsEntities()) // { // var CheckForUserHas = (from us in entity.UserHasSponsorFolders // where us.UserId == userid && us.SponsorFolderId == sfid // select us).FirstOrDefault(); // if (CheckForUserHas != null) // { // return false; // } // var CheckSposorFolderExists = (from s in entity.SponsorFolders // where s.id == sfid // select s).FirstOrDefault(); // if (CheckSposorFolderExists == null) // { // return false; // } // string query = "[lib_CreateSponsorFolderSFE] @UserID,@UserSpecialty,@SponsorFolderID,@TopicFolderID OUT"; // var parameters = new[] // { // new SqlParameter("@UserID", userid), // new SqlParameter("@UserSpecialty", 1), // new SqlParameter("@SponsorFolderID", sfid), // new SqlParameter("@TopicFolderID",SqlDbType.Int){ Direction = ParameterDirection.Output } // }; // var AddSponsorFolderResult = entity.Database.SqlQuery<AddSponsorFolderTemp>(query, parameters).FirstOrDefault(); // int TopicFolderID; // TopicFolderID = (Int32)parameters[0].Value; // string query1 = "[lib_GetDefaultSubTopic] @UserID,@TopicID,@SubTopicID OUT"; // var parameters1 = new[] // { // new SqlParameter("@UserID", userid), // new SqlParameter("@TopicID", TopicFolderID), // new SqlParameter("@SubTopicID",SqlDbType.Int){ Direction = ParameterDirection.Output } // }; // var GetSubTopicResult = entity.Database.SqlQuery<AddSponsorFolderTemp>(query1, parameters1).ToList(); // int SubTopicId = (Int32)parameters1[0].Value; // // // if (CheckSposorFolderExists.FolderName == "EUSA") // { // //SearchBL.ManageQuery Model = new SearchBL.ManageQuery(); // //Model.SearchId = 0; // //Model.Name="Caphosol(EUSA)"; // //Model.Autosearch = true; // //Model.resultFolder2 = 2182; // //Model.ShelfLife = "7"; // //Model.Description = ""; // //Model.KeepDelete = 0; // //Model.tab // //if (!string.IsNullOrEmpty(Collection["ddlUserSubTopic"])) // // Model.resultFolder2 = Convert.ToInt32(Collection["ddlUserSubTopic"]); // //TempData["SavedQueryDet"] = SearchBL.UpdateSearchQuery(Model); // } // // <!--- Create the Auto Query ---> // //<!--- we need a search ID no matter what for the update code below ---> // UserHasSponsorFolder NewSposorFolder = new UserHasSponsorFolder(); // NewSposorFolder.AutoQueryId = 0; // NewSposorFolder.createtime = DateTime.Now; // NewSposorFolder.SponsorFolderId = sfid; // NewSposorFolder.UserFolderId = Convert.ToInt32(SubTopicId); // NewSposorFolder.UserId = userid; // entity.UserHasSponsorFolders.Add(NewSposorFolder); // entity.SaveChanges(); // return true; // } //} // To Get Genes public static List <GeneMyLibrary> GetGenesMyLibrary(int PMID) { using (EditorsEntities entity = new EditorsEntities()) { var Result = entity.lib_GetGenesForCitation(PMID); List <GeneMyLibrary> ResultMain = new List <GeneMyLibrary>(); foreach (var item in Result) { GeneMyLibrary Gene = new GeneMyLibrary(); Gene.GeneId = item.GeneID; Gene.Name = item.name; ResultMain.Add(Gene); } return(ResultMain); } }