/// <summary> /// Add new companies to an existing sub-campaign /// </summary> /// <param name="lstAcctIds"></param> /// <param name="SubCampaignId"></param> public static void AddCompaniesToSubCampaign(List<int> lstAcctIds, int SubCampaignId, string ListSource = "") { BrightPlatformEntities _efDbModel = new BrightPlatformEntities(UserSession.EntityConnection); int? _FinalListId = _efDbModel.final_lists.FirstOrDefault(i => i.sub_campaign_id == SubCampaignId).id; if (_FinalListId > 0) { foreach (int _AcctId in lstAcctIds) { sub_campaign_account_lists _item = new sub_campaign_account_lists() { final_list_id = (int)_FinalListId, account_id = _AcctId, created_by = UserSession.CurrentUser.UserId, created_on = DateTime.Now, modified = false, active = true, priority = null, locked = false, locked_by = null, locked_timestamp = null, assigned_to = null, list_source = ListSource, modified_by = UserSession.CurrentUser.UserId, modified_on = DateTime.Now }; _efDbModel.sub_campaign_account_lists.AddObject(_item); } _efDbModel.SaveChanges(); } }
public static void Save(List<CTScEventAndFollowUpLog> pEventList) { using (BrightPlatformEntities _eftDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) { event_followup_log _eftEvent = null; foreach (CTScEventAndFollowUpLog _item in pEventList) { _eftEvent = _eftDbContext.event_followup_log.FirstOrDefault(i => i.id == _item.id); if (_eftEvent == null) continue; _eftEvent.done = _item.done; _eftEvent.assigned_user = Convert.ToBoolean(_item.user_taken) ? UserSession.CurrentUser.UserId : 0; _eftEvent.date_of_transaction = _item.date_of_transaction; _eftEvent.start_time = Convert.ToDateTime(_item.start_time).TimeOfDay; _eftEvent.end_time = Convert.ToDateTime(_item.end_time).TimeOfDay; _eftEvent.title = _item.title; _eftEvent.event_type = _item.event_type; _eftEvent.short_message = _item.short_message; _eftDbContext.event_followup_log.ApplyCurrentValues(_eftEvent); } if (pEventList.Count > 0) { _eftDbContext.SaveChanges(); _eftDbContext.Detach(_eftEvent); } } }
/// <sumamary> /// Save language /// </sumamary> public static int SaveLanguage(language objLanguage) { BrightPlatformEntities objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection); objBrightPlatformEntity.languages.AddObject(objLanguage); objBrightPlatformEntity.SaveChanges(); return objLanguage.id; }
private void btnSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(tbxSubject.Text)) { NotificationDialog.Information("Bright Manager", "Please specify a default send email suject."); return; } else if (string.IsNullOrEmpty(tbxMessage.Text)) { NotificationDialog.Information("Bright Manager", "Please specify a default send email message."); return; } /** * build the subject and message into one text only, * separated by a separator text "[sep]". */ string _SendEmailConfig = string.Format("{0}[sep]{1}", tbxSubject.Text, tbxMessage.Text ); using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) { subcampaign _eftSubCampaign = _efDbContext.subcampaigns.FirstOrDefault(i => i.id == m_SubCampaignId); if (_eftSubCampaign != null) { //_eftSubCampaign.send_email_config = _SendEmailConfig; _efDbContext.subcampaigns.ApplyCurrentValues(_eftSubCampaign); _efDbContext.SaveChanges(); _efDbContext.Detach(_eftSubCampaign); } } NotificationDialog.Information("Bright Manager", "Saved send email config."); this.ParentForm.Close(); }
/// <summary> /// Add new contacts to an existing sub-campaign /// </summary> /// <param name="lstContactIds"></param> /// <param name="SubCampaignId"></param> public static void AddContactsToSubCampaign(List<int> lstContactIds, int SubCampaignId) { BrightPlatformEntities _efDbModel = new BrightPlatformEntities(UserSession.EntityConnection); int? _FinalListId = _efDbModel.final_lists.FirstOrDefault(i => i.sub_campaign_id == SubCampaignId).id; if (_FinalListId > 0) { foreach (int _ContactId in lstContactIds) { sub_campaign_contact_lists _item = new sub_campaign_contact_lists() { final_list_id = (int)_FinalListId, contact_id = _ContactId, created_by = UserSession.CurrentUser.UserId, created_on = DateTime.Now, active = true, modified = false, priority = null, in_list = false }; _efDbModel.sub_campaign_contact_lists.AddObject(_item); } _efDbModel.SaveChanges(); } }
private void btnSave_Click(object sender, EventArgs e) { if (gvNurtureSubCampaign.RowCount < 1) return; WaitDialog.Show("Saving data."); List<string> _lstIds = new List<string>(); for (int i = 0; i < gvNurtureSubCampaign.RowCount; i++) { CTSubCampaignNurtureItem _item = gvNurtureSubCampaign.GetRow(i) as CTSubCampaignNurtureItem; if (!Convert.ToBoolean(_item.selected)) continue; _lstIds.Add(string.Format("<item id=\"{0}\" />", _item.sub_campaign_id)); } if (_lstIds.Count > 0) { string _xml = string.Format("<sub_campaign_config><nurture_sub_campaign>{0}</nurture_sub_campaign></sub_campaign_config>", string.Join("", _lstIds.ToArray())); using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) { subcampaign _efSubCampaign = _efDbContext.subcampaigns.FirstOrDefault(i => i.id == m_SubCampaignId); if (_efSubCampaign != null) { _efSubCampaign.xml_nurture_setting = _xml; _efDbContext.subcampaigns.ApplyCurrentValues(_efSubCampaign); _efDbContext.SaveChanges(); _efDbContext.Detach(_efSubCampaign); } } } WaitDialog.Close(); this.ParentForm.Close(); }
public static void LogEventSMS(string pXML, string pMessage, string pComputerName, string pComputerIP, serverside_report_requests _eftRequest) { string Source = "BrightSales"; string _Connection = ConfigurationManager.ConnectionStrings["DefaultEntityConnection"].ToString(); int? requested_by = _eftRequest.requested_by; string[] _ids = _eftRequest.sub_campaign_ids.Split(','); string _SubCampaignIds = _ids[0]; using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(_Connection)) { _efDbContext.event_log.AddObject(new event_log() { event_id = (int)EventLog.EventTypes.SEND_SMS, user_id = requested_by, subcampaign_id = int.Parse(_SubCampaignIds), account_id = _eftRequest.account_id, contact_id = null, local_datetime = DateTime.Now, computer_name = pComputerName, param1 = pXML, param2 = pMessage, param3 = Source, param4 = _eftRequest.account_id.ToString(), param5 = pComputerIP, param6 = null }); _efDbContext.SaveChanges(); } }
/// <summary> /// De-activate a contact /// </summary> public static void DeActivateContact(int ContactId) { BrightPlatformEntities objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection); var objContact = objBrightPlatformEntity.contacts.Where(i => i.id == ContactId).Single(); objContact.active = false; objContact.modified_date = DateTime.Now; objContact.modified_by = UserSession.CurrentUser.UserId; objBrightPlatformEntity.SaveChanges(); }
public static void Delete(int pEventId) { using (BrightPlatformEntities _eftDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) { event_followup_log _eftEvent = _eftDbContext.event_followup_log.FirstOrDefault(i => i.id == pEventId); if (_eftEvent != null) { _eftDbContext.event_followup_log.DeleteObject(_eftEvent); _eftDbContext.SaveChanges(); _eftDbContext.Detach(_eftEvent); } } }
public static int SaveLanguage(language pLanguage) { using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) { //_efDbContext.ExecuteStoreQuery //_efDbContext.FIGetCallLists(0,0).encrypt; _efDbContext.languages.AddObject(pLanguage); _efDbContext.SaveChanges(); return pLanguage.id; } }
/// <sumamary> /// Save languages /// </sumamary> public static void SaveUpdatedLanguages(List<LanguageInstance> objList) { BrightPlatformEntities objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection); foreach (LanguageInstance Item in objList) { var objItem = objBrightPlatformEntity.languages.Where(element => element.id == Item.id).FirstOrDefault(); objItem.code = Item.code; objItem.name = Item.description; objBrightPlatformEntity.SaveChanges(); } }
/// <sumamary> /// Save titles /// </sumamary> public static void SaveUpdatedTitles(List<TitleInstance> objList) { BrightPlatformEntities objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection); foreach (TitleInstance Item in objList) { var objItem = objBrightPlatformEntity.titles.Where(element => element.id == Item.id).FirstOrDefault(); objItem.language_id = Item.language_id; objItem.ssyk = Item.ssyk; objItem.date_created = Item.datecreated; objBrightPlatformEntity.SaveChanges(); } }
public static void SaveUpdatedLanguages(List<LanguageInstance> pList) { using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) { foreach (LanguageInstance Item in pList) { language _eftLanguage = _efDbContext.languages.Where(element => element.id == Item.id).FirstOrDefault(); _eftLanguage.code = Item.code; _eftLanguage.name = Item.description; _efDbContext.SaveChanges(); _efDbContext.Detach(_eftLanguage); } } }
public static void DeleteUser(int UserId) { BrightPlatformEntities m_objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection); var objEntityUser = m_objBrightPlatformEntity.users.Where(objField => objField.id == UserId).SingleOrDefault(); var objEntityUserComment = m_objBrightPlatformEntity.users_comments.Where(i => i.user_id == UserId).SingleOrDefault(); m_objBrightPlatformEntity.users.DeleteObject(objEntityUser); if (objEntityUserComment != null) m_objBrightPlatformEntity.users_comments.DeleteObject(objEntityUserComment); m_objBrightPlatformEntity.SaveChanges(); }
/// <summary> /// De-activate a company /// </summary> public static void DeActivateCompany(int AccountId, string Reason) { BrightPlatformEntities objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection); var objCompany = objBrightPlatformEntity.accounts.FirstOrDefault(i => i.id == AccountId) as account; if (objCompany != null) { //objCompany.active = false; objCompany.de_activate_reason = Reason; objCompany.modified_by = UserSession.CurrentUser.UserId; objCompany.modified_date = DateTime.Now; objCompany.de_activate_by = UserSession.CurrentUser.UserId; ; objCompany.de_activate_date = DateTime.Now; objBrightPlatformEntity.SaveChanges(); } }
private void btnSave_Click(object sender, EventArgs e) { //DialogResult _dlg = MessageBox.Show("Are you sure to re-assign selected follow-up?", "Bright Manager", MessageBoxButtons.YesNo, MessageBoxIcon.Question); //if (_dlg == DialogResult.No) // return; using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) { event_followup_log _item = _efDbContext.event_followup_log.FirstOrDefault(i => i.id == m_EventFollowUpLogId); _item.assigned_user = Convert.ToInt32(cboSubCampaignUsers.EditValue); _efDbContext.event_followup_log.ApplyCurrentValues(_item); _efDbContext.SaveChanges(); } if (AfterSave != null) AfterSave(new AfterSaveArgs() { UserId = Convert.ToInt32(cboSubCampaignUsers.EditValue), UserName = cboSubCampaignUsers.Text }); this.ParentForm.Close(); }
public static long? SaveMail(string pXml, serverside_report_requests _eftRequest) { string _Connection = ConfigurationManager.ConnectionStrings["DefaultEntityConnection"].ToString(); using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(_Connection)) { int? requested_by = _eftRequest.requested_by; string[] _ids = _eftRequest.sub_campaign_ids.Split(','); string _SubCampaignIds = _ids[0]; message_log _eftMessageLog = new message_log() { message_type = (int)SendMail.eMailType.Send_Mail_To_Prospect, sub_campaign_id = int.Parse(_SubCampaignIds), company_id = _eftRequest.account_id, user_id = _eftRequest.requested_by, XML = pXml, created_date = DateTime.Now }; _efDbContext.message_log.AddObject(_eftMessageLog); _efDbContext.SaveChanges(); _efDbContext.Detach(_eftMessageLog); return _eftMessageLog.id; } }
private void btnSave_Click(object sender, EventArgs e) { if (tbxReportTemplateName.Text.Length < 1) return; using (BrightPlatformEntities _efDbModel = new BrightPlatformEntities(UserSession.EntityConnection)) { if (_efDbModel.additional_data_report_templates.FirstOrDefault(i => i.template_name.Equals(tbxReportTemplateName.Text)) != null) { MessageBox.Show("Report template name already exists.", "Bright Manager", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } var defaultTemplate = _efDbModel.additional_data_report_templates.FirstOrDefault(i => i.is_default); if (defaultTemplate == null) { defaultTemplate = new additional_data_report_templates(); defaultTemplate.layout_config = string.Empty; defaultTemplate.data_config = string.Empty; } WaitDialog.Show("Saving new data."); additional_data_report_templates _item = new additional_data_report_templates() { template_name = tbxReportTemplateName.Text, created_on = DateTime.Now, created_by = UserSession.CurrentUser.UserId, layout_config = defaultTemplate.layout_config }; _efDbModel.additional_data_report_templates.AddObject(_item); _efDbModel.SaveChanges(); if (AfterSave != null) AfterSave(this, new AddReportTemplateArgs() { ReportTemplateId = _item.id }); if (_item != null) _efDbModel.Detach(_item); } WaitDialog.Close(); this.ParentForm.Close(); }
public ActionResult PlayAudio(string pData) { /** * connection info. */ #region Code Logic string _Connection = ConfigurationManager.ConnectionStrings["DefaultEntityConnection"].ToString(); if (string.IsNullOrEmpty(_Connection)) Response.Redirect(Url.RouteUrl(new { action = "DisplayError", pExceptionMessage = "No available connection. Please kindly contact your administrator." })); #endregion /** * user and request infos. */ #region Code Logic serverside_report_requests _eftRequest = null; using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(_Connection)) { try { Guid _id = new Guid(pData); _eftRequest = _efDbContext.serverside_report_requests.FirstOrDefault(i => i.id == _id); if (_eftRequest == null) Response.Redirect(Url.RouteUrl(new { action = "DisplayError", pExceptionMessage = "Invalid web service request. Please kindly contact your administrator." })); _eftRequest.processed = true; _efDbContext.SaveChanges(); _efDbContext.Detach(_eftRequest); } catch { Response.Redirect(Url.RouteUrl(new { action = "DisplayError", pExceptionMessage = "Invalid web service request. Please kindly contact your administrator." })); } } #endregion Stream stream = WebRequest.Create("https://lii.blob.core.windows.net/old/0a4b23f7-eab8-4043-ad84-36b4b5d23f1e_.mp3").GetResponse().GetResponseStream(); return new FileStreamResult(stream, "audio/mpeg"); }
public static void SaveUserStatus(int UserId, bool IsActivated) { BrightPlatformEntities m_objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection); var objEntityUser = m_objBrightPlatformEntity.users.Where(i => i.id == UserId).SingleOrDefault(); //objEntityUser.disabled = Convert.ToByte(IsActivated); objEntityUser.disabled = IsActivated == true ? (byte)0 : (byte)1; objEntityUser.modified_date = DateTime.Now; objEntityUser.modified_by = UserSession.CurrentUser.UserId; m_objBrightPlatformEntity.SaveChanges(); }
public static void SaveUserRole(int UserId, int RoleId, bool IsEnabled) { BrightPlatformEntities m_objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection); var objEntityUserRole = m_objBrightPlatformEntity.roles_users.Where(i => i.role_id == RoleId && i.user_id == UserId).SingleOrDefault(); switch (IsEnabled) { case true: { if (objEntityUserRole == null) { objEntityUserRole = m_objBrightPlatformEntity.roles_users.CreateObject(); objEntityUserRole.role_id = RoleId; objEntityUserRole.user_id = UserId; m_objBrightPlatformEntity.roles_users.AddObject(objEntityUserRole); } break; } case false: { if (objEntityUserRole != null) m_objBrightPlatformEntity.roles_users.DeleteObject(objEntityUserRole); break; } } m_objBrightPlatformEntity.SaveChanges(); }
public static bool SaveUserPassword(string pEmail, string pNewPassword, ref string pOldPassword) { var _Connection = UserSession.DefaultEntityConnection; if (_Connection == null) return false; using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(_Connection)) { user _eftUser = _efDbContext.users.FirstOrDefault(i => i.email == pEmail && i.internal_user == true); if (_eftUser == null) { BrightVision.Common.UI.NotificationDialog.Error("Error", "No match found for the user.\nPlease contact system administrator."); return false; } if (Convert.ToBoolean(_eftUser.disabled)) { _efDbContext.Detach(_eftUser); return false; } if (_eftUser != null) { _efDbContext.change_password_logs.AddObject(new change_password_logs() { user_id = _eftUser.id, old_password = _eftUser.password, new_password = pNewPassword, updated_by = _eftUser.id, updated_on = DateTime.Now, machine_name = UserSession.CurrentUser.ComputerName, machine_ip = UserSession.CurrentUser.ComputerIP }); pOldPassword = _eftUser.password; _eftUser.password = HashUtility.GetHashPassword(pNewPassword); _efDbContext.SaveChanges(); _efDbContext.Detach(_eftUser); } else return false; } return true; }
public static bool SaveUserPassword(string pEmail, string pNewPassword) { var _Connection = UserSession.DefaultEntityConnection; if (_Connection == null) return false; using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(_Connection)) { user _eftUser = _efDbContext.users.FirstOrDefault(i => i.email == pEmail && i.internal_user == true); if (Convert.ToBoolean(_eftUser.disabled)) { _efDbContext.Detach(_eftUser); return false; } if (_eftUser != null) { _efDbContext.change_password_logs.AddObject(new change_password_logs() { user_id = _eftUser.id, old_password = _eftUser.password, new_password = pNewPassword, updated_by = _eftUser.id, updated_on = DateTime.Now }); _eftUser.password = HashUtility.GetHashPassword(pNewPassword); _efDbContext.SaveChanges(); _efDbContext.Detach(_eftUser); } else return false; } return true; }
public static void SaveUserCustomer(int UserId, int CustomerId) { BrightPlatformEntities m_objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection); var objEntityUserCustomer = m_objBrightPlatformEntity.user_customers.Where(i => i.user_id == UserId).SingleOrDefault(); if (objEntityUserCustomer != null) { m_objBrightPlatformEntity.user_customers.DeleteObject(objEntityUserCustomer); m_objBrightPlatformEntity.SaveChanges(); } user_customers objUserCustomer = new user_customers(); objUserCustomer.user_id = UserId; objUserCustomer.customer_id = CustomerId; m_objBrightPlatformEntity.user_customers.AddObject(objUserCustomer); m_objBrightPlatformEntity.SaveChanges(); }
public static void SaveUserComment(int UserId, string UserComment) { BrightPlatformEntities m_objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection); bool isNewRecord = false; var objEntityUserComment = m_objBrightPlatformEntity.users_comments.Where(i => i.user_id == UserId).SingleOrDefault(); if (objEntityUserComment == null) { objEntityUserComment = m_objBrightPlatformEntity.users_comments.CreateObject(); objEntityUserComment.user_id = UserId; isNewRecord = true; } objEntityUserComment.comments = UserComment; if (isNewRecord) m_objBrightPlatformEntity.users_comments.AddObject(objEntityUserComment); m_objBrightPlatformEntity.SaveChanges(); }
private void SaveEventLog(EventLog.EventTypes pType) { BrightPlatformEntities m_efDbContext = new BrightPlatformEntities(UserSession.EntityConnection); int? _ContactId = null; int? _SubCampaignId = null; int? _AccountId = null; if (ContactPerson != null) { if (ContactPerson.id > 0) _ContactId = ContactPerson.id; } if (SubCampaignId > 0) _SubCampaignId = SubCampaignId; if (AccountId > 0) _AccountId = AccountId; m_efDbContext.event_log.AddObject( new event_log() { event_id = (int)pType, user_id = UserSession.CurrentUser.UserId, subcampaign_id = _SubCampaignId, account_id = _AccountId, contact_id = _ContactId, local_datetime = DateTime.Now, computer_name = UserSession.CurrentUser.ComputerName, param1 = null, param2 = null, param3 = null, param4 = null, param5 = null, param6 = null } ); m_efDbContext.SaveChanges(); m_EventBus.Notify(new CallViewBarEvents.PhoneCallAttempt()); //if (CallAttemptMade != null) // CallAttemptMade(this, new EventArgs()); }
private void tbxPassword_Leave(object sender, EventArgs e) { TextEdit _control = sender as TextEdit; if (gridViewUsers.RowCount < 1 || _control.Text.Length < 1) return; WaitDialog.Show("Saving data ..."); using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) { ObjectUser.UserInstance _item = gridViewUsers.GetFocusedRow() as ObjectUser.UserInstance; user _efoUser = _efDbContext.users.FirstOrDefault(i => i.id == _item.id); _efoUser.password = HashUtility.GetHashPassword(_control.Text); _efoUser.modified_by = UserSession.CurrentUser.UserId; _efoUser.modified_date = DateTime.Now; _efDbContext.users.ApplyCurrentValues(_efoUser); _efDbContext.SaveChanges(); _efDbContext.Detach(_efoUser); } gridViewUsers.SetRowCellValue(gridViewUsers.FocusedRowHandle, "password", _control.Text); WaitDialog.Close(); }
public static void SaveUserType(int UserId, bool IsInternal) { BrightPlatformEntities m_objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection); var objEntityUser = m_objBrightPlatformEntity.users.Where(i => i.id == UserId).SingleOrDefault(); objEntityUser.internal_user = IsInternal; objEntityUser.modified_date = DateTime.Now; objEntityUser.modified_by = UserSession.CurrentUser.UserId; m_objBrightPlatformEntity.SaveChanges(); }
private void btnSaveToContact_Click(object sender, EventArgs e) { try { bool _editable = true; using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) { sub_campaign_account_lists _eftCurrentCompany = _efDbContext.sub_campaign_account_lists.FirstOrDefault(i => i.final_list_id == m_BrightSalesProperty.CommonProperty.FinalListId && i.account_id == m_BrightSalesProperty.CommonProperty.AccountId); if (_eftCurrentCompany != null) { if (_eftCurrentCompany.locked_by != null && _eftCurrentCompany.locked_by != UserSession.CurrentUser.UserId) _editable = false; _efDbContext.Detach(_eftCurrentCompany); } } if (!_editable) { NotificationDialog.Error("Bright Sales", "Currently worked by another user."); return; } if (txtAddressBar.Text.Trim() == "" && BrightVision.Common.Utilities.ValidationUtility.IFNullString(wbLinkedIn.Url, "").Contains("/profile/view?id=")) txtAddressBar.Text = wbLinkedIn.Url.ToString(); if (!CheckValidURL(txtAddressBar.Text)) { NotificationDialog.Error("Error", "Invalid URL"); return; } using (BrightPlatformEntities _efDbCOntext = new BrightPlatformEntities(UserSession.EntityConnection)) { contact _eftContacts = _efDbCOntext.contacts.FirstOrDefault(i => i.id == m_contactId); if (_eftContacts != null) { _eftContacts.linkedin_url = txtAddressBar.Text; } _efDbCOntext.SaveChanges(); _efDbCOntext.Detach(_eftContacts); m_linkedin = txtAddressBar.Text; btnLoadContact.Enabled = true; if (m_BrightSalesProperty.CommonProperty.CurrentTab == SelectionProperty.CurrentTab.CampaignBooking) { m_EventBus.Notify(new LinkedInEvents.OnSave.ManageCampaignBooking() { OnSaveArgs = new LinkedInEvents.LinkedInArgs() { LinkedInUrl = txtAddressBar.Text } }); } } NotificationDialog.Information("Bright Sales", "Successfully updated LinkedIn url."); } catch(Exception ex) { NotificationDialog.Error("Bright Sales", "An error has been encountered while trying to save LinkedIn url.\nPlease consult system administrator."); } }
/// <summary> /// Function to save user data /// </summary> public static int SaveUser(bool isNew, UserInstance objParams, bool hasChangedPassword) { user objEntityUser = null; using (BrightPlatformEntities m_objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection)) { objEntityUser = m_objBrightPlatformEntity.users.CreateObject(); if (!isNew) { objEntityUser = null; objEntityUser = m_objBrightPlatformEntity.users.Where(i => i.id == objParams.id).FirstOrDefault(); } else { objEntityUser.created_by = UserSession.CurrentUser.UserId; objEntityUser.created_date = DateTime.Now; } string _OldPassword = objEntityUser.password; objEntityUser.fullname = objParams.full_name; //objEntityUser.last_name = objParams.last_name; objEntityUser.title = objParams.title; objEntityUser.reports_to = Convert.ToInt16(objParams.reports_to); objEntityUser.site = objParams.site; objEntityUser.disabled = Convert.ToInt16(objParams.active == true ? 0 : 1); objEntityUser.sip_id = objParams.sip_id; objEntityUser.phone1 = objParams.phone; objEntityUser.mobile_no = objParams.mobile; objEntityUser.email = objParams.email; objEntityUser.username = objParams.username; objEntityUser.internal_user = objParams.internal_user; objEntityUser.modified_by = UserSession.CurrentUser.UserId; objEntityUser.modified_date = DateTime.Now; if (hasChangedPassword) objEntityUser.password = HashUtility.GetHashPassword(objParams.password); if (isNew) m_objBrightPlatformEntity.users.AddObject(objEntityUser); m_objBrightPlatformEntity.change_password_logs.AddObject(new change_password_logs() { user_id = objParams.id, new_password = objParams.password, old_password = _OldPassword, updated_by = UserSession.CurrentUser.UserId, updated_on = DateTime.Now }); m_objBrightPlatformEntity.SaveChanges(); m_objBrightPlatformEntity.Detach(objEntityUser); } return objEntityUser.id; }