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