public static int?SaveTempData(int CountryId, int BrandId, int Year, string UserName)
{
int status = 0;
using (PJEntities entity = new PJEntities())
{
var currentPdf = entity.Journey_Pdf_TempData.Where(s => s.UserName.ToUpper() == UserName.ToUpper());
foreach (var _currentPdf in currentPdf)
{
entity.Journey_Pdf_TempData.Remove(_currentPdf);
}
entity.SaveChanges();
Journey_Pdf_TempData pdfTempData = new Journey_Pdf_TempData();
pdfTempData.Brand_Id = Convert.ToInt32(BrandId);
pdfTempData.Country_Id = Convert.ToInt32(CountryId);
pdfTempData.Year = Convert.ToInt32(Year);
pdfTempData.UserName = UserName.ToUpper();
pdfTempData.CreatedBy = UserName;
pdfTempData.CreatedDate = DateTime.UtcNow;
pdfTempData.ModifiedDate = DateTime.UtcNow;
entity.Journey_Pdf_TempData.Add(pdfTempData);
entity.SaveChanges();
status = 1;
}
return(status);
}
public static Int32?AddSubClinicalInterventionToTemp(List <Patient_Journey_Trans_SubClin_Interventions_Temp> subclinicalIntervention)
{
try
{
using (PJEntities entity = new PJEntities())
{
Patient_Journey_Trans_SubClin_Interventions_Temp subClinical = null;
if (subclinicalIntervention != null)
{
for (int i = 0; i < subclinicalIntervention.Count; i++)
{
subClinical = new Patient_Journey_Trans_SubClin_Interventions_Temp();
subClinical.Patient_Journey_Trans_Clin_Interventions_Temp_Id = subclinicalIntervention[i].Patient_Journey_Trans_Clin_Interventions_Temp_Id;
subClinical.SubClinical_Intervention_Master_Id = subclinicalIntervention[i].SubClinical_Intervention_Master_Id;
subClinical.Created_By = subclinicalIntervention[i].Created_By;
subClinical.Created_Date = subclinicalIntervention[i].Created_Date;
subClinical.Modified_By = subclinicalIntervention[i].Modified_By;
subClinical.Modified_Date = subclinicalIntervention[i].Modified_Date;
entity.Patient_Journey_Trans_SubClin_Interventions_Temp.Add(subClinical);
entity.SaveChanges();
}
return(1);
}
else
{
return(0);
}
}
}
catch (Exception)
{
return(0);
}
}
public static Int32?AddClinicalInterventionToTemp(Patient_Journey_Trans_Clin_Interventions_Temp clinicalIntervention, int[] lstSubClinical)
{
try
{
using (PJEntities entity = new PJEntities())
{
entity.Patient_Journey_Trans_Clin_Interventions_Temp.Add(clinicalIntervention);
Patient_Journey_Trans_SubClin_Interventions_Temp subClinical = null;
if (lstSubClinical != null)
{
for (int i = 0; i < lstSubClinical.Length; i++)
{
subClinical = new Patient_Journey_Trans_SubClin_Interventions_Temp();
subClinical.Patient_Journey_Trans_Clin_Interventions_Temp_Id = clinicalIntervention.Patient_Journey_Trans_Clin_Interventions_Temp_Id;
subClinical.SubClinical_Intervention_Master_Id = lstSubClinical[i];
subClinical.Created_By = clinicalIntervention.Created_By;
subClinical.Created_Date = clinicalIntervention.Created_Date;
subClinical.Modified_By = clinicalIntervention.Modified_By;
subClinical.Modified_Date = clinicalIntervention.Modified_Date;
entity.Patient_Journey_Trans_SubClin_Interventions_Temp.Add(subClinical);
}
}
entity.SaveChanges();
return(clinicalIntervention.Patient_Journey_Trans_Clin_Interventions_Temp_Id);
}
}
catch (Exception)
{
return(0);
}
}
public LogOnAuditBuilder LogOnUserAuditForMs(String UserName, String ClientTime, String ClientTimeZone, String UtcTime)
{
LogOnAuditBuilder _LogonAuditBuilder = new LogOnAuditBuilder();
var userdetails = _dbAuthentication.GetUserforADlogonID(UserName);
using (PJEntities db = new PJEntities())
{
User_Logon_Audit_MS userLogonAudit = new User_Logon_Audit_MS();
userLogonAudit.User_511 = userdetails.User_511;
userLogonAudit.UPI = userdetails.UPI == null ? String.Empty : userdetails.UPI.ToString();
userLogonAudit.First_Name = userdetails.First_Name;
userLogonAudit.Middle_Initial = userdetails.Middle_Initial;
userLogonAudit.Last_Name = userdetails.Last_Name;
userLogonAudit.Email_Id = userdetails.Email_Id;
userLogonAudit.Logon_Client_Date = DateTimeOffset.Parse(ClientTime.Substring(0, Math.Min(ClientTime.Length, 25)));
userLogonAudit.Logon_UTC_Date = DateTimeOffset.Parse(UtcTime.Substring(0, Math.Min(UtcTime.Length, 25)));
userLogonAudit.Logon_Client_TimeZone = ClientTimeZone;
userLogonAudit.Created_By = "RANGARX6";
userLogonAudit.Created_Date = DateTimeOffset.Now;
userLogonAudit.Modified_By = "RANGARX6";
userLogonAudit.Modified_Date = DateTimeOffset.Now;
db.User_Logon_Audit_MS.Add(userLogonAudit);
db.SaveChanges();
}
return(_LogonAuditBuilder);
}
public static Int32?InsertNewUser(User userdetails)
{
using (PJEntities _entity = new PJEntities())
{
//USER _user = new USER();
//_user.FIRST_NAME = userdetail.FirstName;
//_user.LAST_NAME = userdetail.LastName;
//_user.MIDDLE_INITIAL = userdetail.MiddleInitial;
//_user.IS_ACTIVE = userdetail.IsActive;
//_user.USER_511 = userdetail.User511;
//_user.UPI = Convert.ToDecimal(userdetail.UPI);
//_user.EMAILID = userdetail.Email;
//_user.CREATED_BY = userdetail.CreatedBy;
//_user.CREATED_DATE = Convert.ToDateTime(userdetail.CreatedDate);
//_user.MODIFIED_BY = userdetail.ModifiedBy;
//_user.MODIFIED_DATE = Conveuserdetail.ModifiedDate;
try
{
_entity.Users.Add(userdetails);
_entity.SaveChanges();
return(userdetails.User_Id);
}
catch
{
return(0);
}
}
}
public static Int32?UpdateUserDetails(User _user)
{
using (PJEntities _entity = new PJEntities())
{
try
{
var _selectedUser = _entity.Users.Where(x => x.User_Id == _user.User_Id).FirstOrDefault();
_selectedUser.First_Name = _user.First_Name;
_selectedUser.Last_Name = _user.Last_Name;
_selectedUser.Middle_Initial = _user.Middle_Initial;
_selectedUser.Email_Id = _user.Email_Id;
_selectedUser.User_511 = _user.User_511;
_selectedUser.UPI = _user.UPI;
_selectedUser.Is_Active = _user.Is_Active;
_selectedUser.Modified_Date = _user.Modified_Date;
_selectedUser.Modified_By = _user.Modified_By;
_entity.SaveChanges();
return(_selectedUser.User_Id);
}
catch
{
return(0);
}
}
}
public static Int32?UpdateStrategicMomentTemp(Patient_Journey_Strategic_Moment_Temp strategicMomentsTemp)
{
try
{
using (PJEntities entity = new PJEntities())
{
var currentStrategic = entity.Patient_Journey_Strategic_Moment_Temp.Where(s => s.Patient_Journey_Strategic_Moment_Temp_Id == strategicMomentsTemp.Patient_Journey_Strategic_Moment_Temp_Id).FirstOrDefault();
if (currentStrategic != null)
{
currentStrategic.Title = strategicMomentsTemp.Title;
currentStrategic.Patient_Journey_Temp_Id = strategicMomentsTemp.Patient_Journey_Temp_Id;
currentStrategic.Patient_Journey_Start_Stage_Temp_Id = strategicMomentsTemp.Patient_Journey_Start_Stage_Temp_Id;
currentStrategic.Patient_Journey_End_Stage_Temp_Id = strategicMomentsTemp.Patient_Journey_End_Stage_Temp_Id;
currentStrategic.Patient_Journey_Start_Transaction_Temp_Id = strategicMomentsTemp.Patient_Journey_Start_Transaction_Temp_Id;
currentStrategic.Patient_Journey_End_Transaction_Temp_Id = strategicMomentsTemp.Patient_Journey_End_Transaction_Temp_Id;
currentStrategic.Description = strategicMomentsTemp.Description;
currentStrategic.Category = strategicMomentsTemp.Category;
currentStrategic.Modified_By = strategicMomentsTemp.Modified_By;
currentStrategic.Modified_Date = strategicMomentsTemp.Modified_Date;
}
entity.SaveChanges();
return(1);
}
}
catch (Exception)
{
return(0);
}
}
public static int?SavePDF(int CountryId, int BrandId, int Year, byte[] file)
{
int status = 0;
using (PJEntities entity = new PJEntities())
{
int Yearid = entity.Year_Master.Where(x => x.Year_Name == Year).Select(x => x.Year_Master_Id).FirstOrDefault();
var currentPdf = entity.Journey_Pdf.Where(s => s.Country_Id == CountryId && s.Brand_Id == BrandId && s.Year == Yearid);
foreach (var _currentPdf in currentPdf)
{
entity.Journey_Pdf.Remove(_currentPdf);
}
entity.SaveChanges();
//if (currentPdf != null)
//{
// currentPdf.Country_Id = CountryId;
// currentPdf.Brand_Id = BrandId;
// currentPdf.Year = Yearid;
// currentPdf.Pdf_Byte = file;
// entity.SaveChanges();
// status = 2;
//}
//else
//{
Journey_Pdf pdf = new Journey_Pdf();
pdf.Brand_Id = Convert.ToInt32(BrandId);
pdf.Country_Id = Convert.ToInt32(CountryId);
pdf.Year = Convert.ToInt32(Yearid);
pdf.Pdf_Byte = file;
pdf.CreatedBy = "ALAGAKX";
pdf.CreatedDate = DateTime.Now;
entity.Journey_Pdf.Add(pdf);
entity.SaveChanges();
status = 1;
//}
}
return(status);
}
public static bool InsertUserRolesforUserID(User_Roles _userRole)
{
using (PJEntities _entity = new PJEntities())
{
try
{
_entity.User_Roles.Add(_userRole);
_entity.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public static Int32?AddAssociatedCostToTemp(Patient_Journey_Transactions_AssociatedCosts_Temp associatedCost)
{
try
{
using (PJEntities entity = new PJEntities())
{
entity.Patient_Journey_Transactions_AssociatedCosts_Temp.Add(associatedCost);
entity.SaveChanges();
return(associatedCost.Patient_Journey_Transactions_AssociatedCosts_Temp_Id);
}
}
catch (Exception)
{
return(0);
}
}
public static Int32?AddStrategicMoment(Patient_Journey_Strategic_Moment strategicMoments)
{
try
{
using (PJEntities entity = new PJEntities())
{
entity.Patient_Journey_Strategic_Moment.Add(strategicMoments);
entity.SaveChanges();
return(1);
}
}
catch (Exception)
{
return(0);
}
}
public static bool InsertUserCountryAssociation(User_Country_Association _userCountry)
{
using (PJEntities _entity = new PJEntities())
{
try
{
_entity.User_Country_Association.Add(_userCountry);
_entity.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public static Int32?AddDesiredOutcomeToTemp(Patient_Journey_Transactions_DesiredOutcomes_Temp desiredOutcome)
{
try
{
using (PJEntities entity = new PJEntities())
{
entity.Patient_Journey_Transactions_DesiredOutcomes_Temp.Add(desiredOutcome);
entity.SaveChanges();
return(desiredOutcome.Patient_Journey_Transactions_DesiredOutcomes_Temp_Id);
}
}
catch (Exception)
{
return(0);
}
}
public static bool RemoveUserRolesAssocation(Int32?User_Id, Int32?Role_Id)
{
using (PJEntities _entity = new PJEntities())
{
try
{
var _userRole = _entity.User_Roles.Where(x => x.User_Id == User_Id && x.Role_Master_Id == Role_Id).FirstOrDefault();
_entity.User_Roles.Remove(_userRole);
_entity.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public static bool RemoveUser(Int32?User_Id)
{
using (PJEntities _entity = new PJEntities())
{
try
{
var _users = _entity.Users.Where(x => x.User_Id == User_Id).FirstOrDefault();
_entity.Users.Remove(_users);
_entity.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public static Int32?UpdateClinicalInterventionToTemp(Patient_Journey_Trans_Clin_Interventions_Temp clinicalIntervention, int[] lstSubClinical)
{
try
{
using (PJEntities entity = new PJEntities())
{
var currentclinical = entity.Patient_Journey_Trans_Clin_Interventions_Temp.Where(s => s.Patient_Journey_Trans_Clin_Interventions_Temp_Id == clinicalIntervention.Patient_Journey_Trans_Clin_Interventions_Temp_Id).FirstOrDefault();
var existingSubClinical = entity.Patient_Journey_Trans_SubClin_Interventions_Temp.Where(s => s.Patient_Journey_Trans_Clin_Interventions_Temp_Id == clinicalIntervention.Patient_Journey_Trans_Clin_Interventions_Temp_Id).ToList();
for (int i = 0; i < existingSubClinical.Count; i++)
{
entity.Patient_Journey_Trans_SubClin_Interventions_Temp.Remove(existingSubClinical[i]);
}
if (currentclinical != null)
{
currentclinical.Clinical_Intervention_Master_Id = clinicalIntervention.Clinical_Intervention_Master_Id;
currentclinical.Description = clinicalIntervention.Description;
currentclinical.Evidence = clinicalIntervention.Evidence;
currentclinical.Modified_By = clinicalIntervention.Modified_By;
currentclinical.Modified_Date = clinicalIntervention.Modified_Date;
Patient_Journey_Trans_SubClin_Interventions_Temp subClinical = null;
if (lstSubClinical != null)
{
for (int i = 0; i < lstSubClinical.Length; i++)
{
subClinical = new Patient_Journey_Trans_SubClin_Interventions_Temp();
subClinical.Patient_Journey_Trans_Clin_Interventions_Temp_Id = clinicalIntervention.Patient_Journey_Trans_Clin_Interventions_Temp_Id;
subClinical.SubClinical_Intervention_Master_Id = lstSubClinical[i];
subClinical.Created_By = clinicalIntervention.Created_By;
subClinical.Created_Date = DateTime.Now;
subClinical.Modified_By = clinicalIntervention.Modified_By;
subClinical.Modified_Date = clinicalIntervention.Modified_Date;
entity.Patient_Journey_Trans_SubClin_Interventions_Temp.Add(subClinical);
}
}
}
entity.SaveChanges();
return(currentclinical.Patient_Journey_Trans_Clin_Interventions_Temp_Id);
}
}
catch (Exception)
{
return(0);
}
}
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 bool RemoveUserCountryAssocation(Int32?User_Id, Int32?Country_Id)
{
using (PJEntities _entity = new PJEntities())
{
try
{
var _userCountry = _entity.User_Country_Association.Where(x => x.User_Id == User_Id && x.Country_Master_Id == Country_Id).FirstOrDefault();
if (_userCountry != null)
{
_entity.User_Country_Association.Remove(_userCountry);
_entity.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
}
public static bool DeleteFavSearch(Int32?User_Id)
{
using (PJEntities _entity = new PJEntities())
{
try
{
var _userSearch = _entity.Favourite_Search.Where(x => x.User_Id == User_Id);
foreach (var userSearch in _userSearch)
{
_entity.Favourite_Search.Remove(userSearch);
}
_entity.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public static bool DeleteUserCountryAssocation(Int32?User_Id)
{
using (PJEntities _entity = new PJEntities())
{
try
{
var _userCountry = _entity.User_Country_Association.Where(x => x.User_Id == User_Id);
foreach (var userCountry in _userCountry)
{
_entity.User_Country_Association.Remove(userCountry);
}
_entity.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public static Int32?DeleteStrategicMomentTemp(int TempMomentId)
{
try
{
using (PJEntities entity = new PJEntities())
{
var moment = entity.Patient_Journey_Strategic_Moment_Temp.Where(x => x.Patient_Journey_Strategic_Moment_Temp_Id == TempMomentId).FirstOrDefault();
if (moment != null)
{
entity.Patient_Journey_Strategic_Moment_Temp.Remove(moment);
entity.SaveChanges();
}
return(1);
}
}
catch (Exception)
{
return(0);
}
}
public static bool DeleteUserRolesAssocation(Int32?User_Id)
{
using (PJEntities _entity = new PJEntities())
{
try
{
var _userRole = _entity.User_Roles.Where(x => x.User_Id == User_Id);
foreach (var userRole in _userRole)
{
_entity.User_Roles.Remove(userRole);
}
_entity.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public static Int32?UpdateAssociatedCostToTemp(Patient_Journey_Transactions_AssociatedCosts_Temp associatedCost)
{
try
{
using (PJEntities entity = new PJEntities())
{
var currentassociated = entity.Patient_Journey_Transactions_AssociatedCosts_Temp.Where(s => s.Patient_Journey_Transactions_AssociatedCosts_Temp_Id == associatedCost.Patient_Journey_Transactions_AssociatedCosts_Temp_Id).FirstOrDefault();
if (currentassociated != null)
{
currentassociated.AssociatedCosts = associatedCost.AssociatedCosts;
currentassociated.Description = associatedCost.Description;
currentassociated.Evidence = associatedCost.Evidence;
currentassociated.Modified_By = associatedCost.Modified_By;
currentassociated.Modified_Date = associatedCost.Modified_Date;
}
entity.SaveChanges();
return(currentassociated.Patient_Journey_Transactions_AssociatedCosts_Temp_Id);
}
}
catch (Exception)
{
return(0);
}
}
public static Int32?UpdateDesiredOutcomeToTemp(Patient_Journey_Transactions_DesiredOutcomes_Temp desiredOutcome)
{
try
{
using (PJEntities entity = new PJEntities())
{
var currentdesired = entity.Patient_Journey_Transactions_DesiredOutcomes_Temp.Where(s => s.Patient_Journey_Transactions_DesiredOutcomes_Temp_Id == desiredOutcome.Patient_Journey_Transactions_DesiredOutcomes_Temp_Id).FirstOrDefault();
if (currentdesired != null)
{
currentdesired.DesiredOutcomes = desiredOutcome.DesiredOutcomes;
currentdesired.Description = desiredOutcome.Description;
currentdesired.Evidence = desiredOutcome.Evidence;
currentdesired.MODIFIED_Date = desiredOutcome.MODIFIED_Date;
currentdesired.MODIFIED_By = desiredOutcome.MODIFIED_By;
}
entity.SaveChanges();
return(currentdesired.Patient_Journey_Transactions_DesiredOutcomes_Temp_Id);
}
}
catch (Exception)
{
return(0);
}
}
public static Int32?UpdateViabilityRatingToTemp(Patient_Journey_Transactions_Temp transaction)
{
try
{
using (PJEntities entity = new PJEntities())
{
var currenttransaction = entity.Patient_Journey_Transactions_Temp.Where(s => s.Patient_Journey_Transactions_Temp_Id == transaction.Patient_Journey_Transactions_Temp_Id).FirstOrDefault();
if (currenttransaction != null)
{
currenttransaction.Viability_Rating = transaction.Viability_Rating;
currenttransaction.Viability_Description = transaction.Viability_Description;
currenttransaction.Viability_Evidence = transaction.Viability_Evidence;
currenttransaction.Modified_By = transaction.Modified_By;
currenttransaction.Modified_Date = transaction.Modified_Date;
}
entity.SaveChanges();
return(currenttransaction.Patient_Journey_Transactions_Temp_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");
}
