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