public static Int32?AddStrategicMomentTemp(Patient_Journey_Strategic_Moment_Temp strategicMomentsTemp) { try { using (PJEntities entity = new PJEntities()) { entity.Patient_Journey_Strategic_Moment_Temp.Add(strategicMomentsTemp); entity.SaveChanges(); entity.Entry(strategicMomentsTemp).GetDatabaseValues(); int id = strategicMomentsTemp.Patient_Journey_Strategic_Moment_Temp_Id; return(id); } } catch (Exception) { return(0); } }
public static String SaveSearchCriteria(string TherapeuticId, string SubTherapeuticId, string IndicationId, List <string> lstArchetypeId, List <string> lstCountryId, List <string> lstProductId, List <string> lstAreaId, string Year, string UserName) { Favourite_Search _searchCriteria; Favourite_Search_Brand result1; Favourite_Search_Area result2; Favourite_Search_Country result3; Favourite_Search_Archetype result4; int productID, countryID, areaID, archeTypeID = 0; int therapeuticID = Convert.ToInt32(TherapeuticId); int subTherapeuticID = Convert.ToInt32(SubTherapeuticId); int indicationID = Convert.ToInt32(IndicationId); int year = Convert.ToInt32(Year); using (PJEntities entity = new PJEntities()) { var userData = from r in entity.Users select r; var searchData = from r in entity.Favourite_Search select r; var searchDataBrand = from r in entity.Favourite_Search_Brand select r; var searchDataArea = from r in entity.Favourite_Search_Area select r; var searchDataCountry = from r in entity.Favourite_Search_Country select r; var searchDataArchetype = from r in entity.Favourite_Search_Archetype select r; int userId = userData.Where(x => x.User_511 == UserName.ToUpper()).Select(x => x.User_Id).FirstOrDefault(); bool doesExistAlready = searchData.Any(o => o.User_Id == userId); if (doesExistAlready == true) { var key = searchData.Where(o => o.User_Id == userId).FirstOrDefault().Favourite_Search_Id; var brandData = searchDataBrand.Where(x => x.Favourite_Search_Id == key).ToList(); var areaData = searchDataArea.Where(x => x.Favourite_Search_Id == key).ToList(); var countryData = searchDataCountry.Where(x => x.Favourite_Search_Id == key).ToList(); var archetypeData = searchDataArchetype.Where(x => x.Favourite_Search_Id == key).ToList(); var favData = searchData.Where(x => x.Favourite_Search_Id == key).FirstOrDefault(); for (int i = 0; i < brandData.Count(); i++) { entity.Favourite_Search_Brand.Remove(brandData[i]); } for (int i = 0; i < areaData.Count(); i++) { entity.Favourite_Search_Area.Remove(areaData[i]); } for (int i = 0; i < countryData.Count(); i++) { entity.Favourite_Search_Country.Remove(countryData[i]); } for (int i = 0; i < archetypeData.Count(); i++) { entity.Favourite_Search_Archetype.Remove(archetypeData[i]); } entity.Favourite_Search.Remove(favData); entity.SaveChanges(); } _searchCriteria = new Favourite_Search(); _searchCriteria.User_Id = userId; _searchCriteria.Is_Active = true; _searchCriteria.Therapeutic_Area_Master_Id = therapeuticID; _searchCriteria.SubTherapeutic_Area_Master_Id = subTherapeuticID; _searchCriteria.Indication_Master_Id = indicationID; _searchCriteria.Year = year; _searchCriteria.Created_By = UserName; _searchCriteria.Created_Date = DateTime.Now; _searchCriteria.Modified_By = UserName; _searchCriteria.Modified_Date = DateTime.Now; entity.Favourite_Search.Add(_searchCriteria); entity.SaveChanges(); entity.Entry(_searchCriteria).GetDatabaseValues(); int Fav_Search_Id = _searchCriteria.Favourite_Search_Id; for (int i = 0; i < lstProductId.Count; i++) { result1 = new Favourite_Search_Brand(); productID = Convert.ToInt32(lstProductId[i]); result1.User_Id = userId; result1.Favourite_Search_Id = Fav_Search_Id; result1.Brand_Master_Id = productID; result1.Created_By = UserName; result1.Created_Date = DateTime.Now; result1.Modified_By = UserName; result1.Modified_Date = DateTime.Now; entity.Favourite_Search_Brand.Add(result1); } for (int i = 0; i < lstAreaId.Count; i++) { result2 = new Favourite_Search_Area(); areaID = Convert.ToInt32(lstAreaId[i]); result2.User_Id = userId; result2.Favourite_Search_Id = Fav_Search_Id; result2.Area_Master_Id = areaID; result2.Created_By = UserName; result2.Created_Date = DateTime.Now; result2.Modified_By = UserName; result2.Modified_Date = DateTime.Now; entity.Favourite_Search_Area.Add(result2); } for (int i = 0; i < lstCountryId.Count; i++) { result3 = new Favourite_Search_Country(); countryID = Convert.ToInt32(lstCountryId[i]); result3.User_Id = userId; result3.Favourite_Search_Id = Fav_Search_Id; result3.Country_Master_Id = countryID; result3.Created_By = UserName; result3.Created_Date = DateTime.Now; result3.Modified_By = UserName; result3.Modified_Date = DateTime.Now; entity.Favourite_Search_Country.Add(result3); } for (int i = 0; i < lstArchetypeId.Count; i++) { result4 = new Favourite_Search_Archetype(); archeTypeID = Convert.ToInt32(lstArchetypeId[i]); result4.User_Id = userId; result4.Favourite_Search_Id = Fav_Search_Id; result4.Archetype_Master_Id = archeTypeID; result4.Created_By = UserName; result4.Created_Date = DateTime.Now; result4.Modified_By = UserName; result4.Modified_Date = DateTime.Now; entity.Favourite_Search_Archetype.Add(result4); } entity.SaveChanges(); } return("TRUE"); }