public void LoadLinkedIn(int accountid, int contactId)
{
ResetValues();
m_contactId = contactId;
this.Cursor = Cursors.WaitCursor;
this.Enabled = false;
try
{
if (accountid > 0 && contactId > 0)
{
using (BrightPlatformEntities _efDbCOntext = new BrightPlatformEntities(UserSession.EntityConnection))
{
string companyname = "";
string contactname = "";
account _eftCompany = _efDbCOntext.accounts.FirstOrDefault(i => i.id == accountid);
if (_eftCompany != null)
{
companyname = _eftCompany.company_name;
_efDbCOntext.Detach(_eftCompany);
//_Url = _eftCompany.www;
}
contact _eftContacts = _efDbCOntext.contacts.FirstOrDefault(i => i.id == contactId);
if (_eftContacts != null)
{
contactname = _eftContacts.first_name + " " + _eftContacts.last_name;
m_linkedin = _eftContacts.linkedin_url;
_efDbCOntext.Detach(_eftContacts);
//_Url = _eftCompany.www;
}
string searchString = contactname + " " + companyname;
if (BrightVision.Common.Utilities.ValidationUtility.IFNullString(m_linkedin,"").Trim() != "")
wbLinkedIn.Url = new Uri(m_linkedin);
else
wbLinkedIn.Url = new Uri("http://www.linkedin.com/search/fpsearch?type=people&keywords=" + searchString + "&pplSearchOrigin=GLHD&pageKey=fps_results");
}
}
else
{
wbLinkedIn.DocumentText =
"<div style=\"padding:40px 40px 40px 40px;\">" +
"<div style=\"background-color:#d9e2b3;border:1px solid #ccc;padding:40px 40px 40px 40px;font-family:arial;" +
"font-size:12px;font-weight:bold;\"><center>No LinkedIn to be search for.</center>" +
"<br/><center><span style=\"font-weight:normal;font-style:italic;margin-top:20px;font-size:9px;\">" +
"Brightvision - We accelerate your sales.</span></center></div></div></div>";
}
}
catch { }
this.Enabled = true;
this.Cursor = Cursors.Default;
}
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 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);
}
}
}
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();
}
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 CallLogPlayer(string pAudioFileUrl, bool pFromStream = false)
{
InitializeComponent();
int _volume = 50;
audio_settings _item = null;
using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
_item = _efDbContext.audio_settings.FirstOrDefault(i => i.user_id == UserSession.CurrentUser.UserId);
if (_item != null)
_efDbContext.Detach(_item);
}
if (_item != null && _item.speaker_volume > 0)
_volume = Convert.ToInt32(_item.speaker_volume * 10);
if (pFromStream)
m_MediaType = eMediaType.Stream;
else if (Path.GetExtension(pAudioFileUrl) == ".wav")
m_MediaType = eMediaType.WavFile;
else if (Path.GetExtension(pAudioFileUrl) == ".mp3")
m_MediaType = eMediaType.Mp3File;
m_MediaFile = pAudioFileUrl;
trackBarControl.Properties.Minimum = 0;
if (!pFromStream) {
FileInfo info = new FileInfo(pAudioFileUrl);
if (info.Length == 0) {
NotificationDialog.Information("Player", "Audio file don't have any content.");
m_CanBePlayed = false;
return;
}
}
if (pFromStream) {
//checking for m_MediaFile
}
if (!this.IsMediaValidated()) {
m_CanBePlayed = false;
return;
}
if (m_MediaType == eMediaType.Mp3File)
this.InitializeMp3Audio();
else if (m_MediaType == eMediaType.WavFile)
this.InitializeWavAudio();
else if (m_MediaType == eMediaType.Stream)
if (!this.InitializeStreamAudio())
return;
m_CanBePlayed = true;
if (!this.IsDisposed)
this.btnPlay_Click(null, null);
}
private void InitiateLockScreen()
{
user _efoUser = null;
using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
m_UserId = UserSession.CurrentUser.UserId;
_efoUser = _efDbContext.users.FirstOrDefault(i => i.id == UserSession.CurrentUser.UserId);
_efDbContext.Detach(_efoUser);
}
tbxUser.Text = _efoUser.fullname;
tbxPassword.Focus();
}
public static bool CanAddDialog(int pSubCampaignId)
{
dialog _eftDialog = null;
using (BrightPlatformEntities _eftDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
_eftDialog = _eftDbContext.dialogs.FirstOrDefault(i => i.subcampaign_id == pSubCampaignId && i.is_active == true);
if (_eftDialog != null) {
_eftDbContext.Detach(_eftDialog);
return true;
}
}
return false;
}
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 bool Exists(string pDialogName, int pSubCampaignId)
{
dialog _eftDialog = null;
using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
_eftDialog = _efDbContext.dialogs.FirstOrDefault(i => i.name.Equals(pDialogName.Trim()) && i.subcampaign_id == pSubCampaignId && i.is_active == true);
if (_eftDialog != null) {
_efDbContext.Detach(_eftDialog);
return true;
}
}
return false;
}
public static int GetDocument(int FinalListId, int UserId)
{
sub_campaign_user_sales_scripts _eftUserDocument = null;
using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
_eftUserDocument = _efDbContext.sub_campaign_user_sales_scripts.FirstOrDefault(i => i.final_list_id == FinalListId && i.user_id == UserId);
if (_eftUserDocument != null)
_efDbContext.Detach(_eftUserDocument);
}
if (_eftUserDocument == null)
return 0;
return (int)_eftUserDocument.id;
}
public void LoadCompanyWebsite(string pCompanyWebsite = null)
{
string _Url = string.Empty;
if (string.IsNullOrEmpty(pCompanyWebsite)) {
using (BrightPlatformEntities _efDbCOntext = new BrightPlatformEntities(UserSession.EntityConnection)) {
account _eftCompany = _efDbCOntext.accounts.FirstOrDefault(i => i.id == m_AccountId);
if (_eftCompany != null) {
_efDbCOntext.Detach(_eftCompany);
_Url = _eftCompany.www;
}
}
}
else
_Url = pCompanyWebsite;
theUri = null;
if (_Url != null)
{
try
{
if (!_Url.Contains("http://"))
_Url = "http://" + _Url; //"aa";
if (Uri.IsWellFormedUriString(_Url, UriKind.Absolute))
{
if (Uri.TryCreate(_Url, UriKind.Absolute, out theUri))
{
wbCompanyWebsite.Url = theUri;
}
else
{
theUri = null;
}
}
}
catch
{
}
}
if (theUri == null) {
wbCompanyWebsite.DocumentText =
"<div style=\"padding:40px 40px 40px 40px;\">" +
"<div style=\"background-color:#d9e2b3;border:1px solid #ccc;padding:40px 40px 40px 40px;font-family:arial;" +
"font-size:12px;font-weight:bold;\"><center>No website is currently registered for the selected company.</center>" +
"<br/><center><span style=\"font-weight:normal;font-style:italic;margin-top:20px;font-size:9px;\">" +
"Brightvision - We accelerate your sales.</span></center></div></div></div>";
}
}
private void AddSipAccount_Load(object sender, EventArgs e)
{
using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
if (m_SipId != 0) {
sip_accounts _eftSipAccount = _efDbContext.sip_accounts.FirstOrDefault(i => i.id == m_SipId);
_efDbContext.Detach(_eftSipAccount);
textEditSIPUrl.EditValue = _eftSipAccount.sip_url;
textEditDisplayName.EditValue = _eftSipAccount.display_name;
textEditUsername.EditValue = _eftSipAccount.username;
textEditPassword.EditValue = _eftSipAccount.password;
textEditOperator.EditValue = _eftSipAccount.@operator;
memoEditComment.EditValue = _eftSipAccount.comment;
}
}
}
public static bool FollowUpCallExists(event_followup_log pData)
{
using (BrightPlatformEntities _eftDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
event_followup_log _item = _eftDbContext.event_followup_log.FirstOrDefault(
i => i.contact_id == pData.contact_id
&& i.subcampaign_id == pData.subcampaign_id
&& i.account_id == pData.account_id
&& i.done == false
&& pData.event_status.Equals("Follow-Up Call")
);
if (_item != null) {
_eftDbContext.Detach(_item);
return true;
}
return false;
}
}
public void AutoLoadReport()
{
subcampaign _efoSubCampaign = null;
using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
m_efoViewConfig = _efDbContext.view_configuration.FirstOrDefault(i => i.id == m_ViewConfigId);
_efoSubCampaign = _efDbContext.subcampaigns.FirstOrDefault(i => i.id == m_efoViewConfig.subcampaign_id);
_efDbContext.Detach(m_efoViewConfig);
}
lookUpEditCustomerCampaign.EditValue = _efoSubCampaign.campaign_id;
for (int i = 0; i < ccbeSubcampaign.Properties.Items.Count; i++) {
if (ccbeSubcampaign.Properties.Items[i].Description.Equals(_efoSubCampaign.title)) {
ccbeSubcampaign.Properties.Items[i].CheckState = CheckState.Checked;
break;
}
}
cboDisplayMode.SelectedIndex = 0;
this.btnLoad.PerformClick();
m_ViewConfigId = 0;
}
private void btnUnlock_Click(object sender, EventArgs e)
{
if (tbxPassword.Text.Length < 1) {
this.InvalidLogin();
return;
}
user _efoUser = null;
using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
string _Password = BrightVision.Common.Utilities.HashUtility.GetHashPassword(tbxPassword.Text);
_efoUser = _efDbContext.users.FirstOrDefault(i => i.id == m_UserId && i.password == _Password);
if (_efoUser != null) {
_efDbContext.Detach(_efoUser);
this.Close();
}
else {
tbxPassword.Text = string.Empty;
this.InvalidLogin();
}
}
}
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");
}
private void cbxActive_EditValueChanging(object sender, ChangingEventArgs e)
{
if (m_BrightSalesProperty.CampaignBooking.Mode == SelectionProperty.CampaignBookingMode.Browse) {
e.Cancel = true;
return;
}
m_ContactForUpdateRowHandle = gvContact.FocusedRowHandle;
CheckEdit _objCheckBox = sender as CheckEdit;
if (!_objCheckBox.Checked)
return;
bool _editable = true;
using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
final_lists _item = _efDbContext.final_lists.FirstOrDefault(i => i.sub_campaign_id == m_BrightSalesProperty.CommonProperty.SubCampaignId);
if (_item == null)
_editable = false;
else {
_efDbContext.Detach(_item);
sub_campaign_account_lists _eftCurrentCompany = _efDbContext.sub_campaign_account_lists.FirstOrDefault(
i => i.final_list_id == _item.id && i.account_id == m_BrightSalesProperty.CommonProperty.CurrentWorkedAccountId
);
if (_eftCurrentCompany != null) {
if (_eftCurrentCompany.locked_by != UserSession.CurrentUser.UserId)
_editable = false;
_efDbContext.Detach(_eftCurrentCompany);
}
}
}
if (!_editable) {
NotificationDialog.Information("Bright Sales", "Currently worked by another user.");
return;
}
string Message = String.Format("This is a global deletion from all campaigns.{0}Are you sure you want to de-activate this contact?", Environment.NewLine);
DialogResult _dlg = MessageBox.Show(Message, "Bright Sales", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (_dlg == DialogResult.No)
e.Cancel = true;
else
e.Cancel = false;
}
/// <summary>
///It initializes a softphone object with a SIP BPX, and it is for requisiting a SIP account that is nedded for a SIP PBX service. It registers this SIP
///account to the SIP PBX through an ’IphoneLine’ object which represents the telephoneline.
///If the telephone registration is successful we have a call ready softphone. In this example the softphone can be reached by dialing the number 891.
/// </summary>
private void InitializeSoftPhone()
{
try
{
if (Ozeki.VoIP.SDK.Protection.LicenseManager.Instance.LicenseType != Ozeki.VoIP.SDK.Protection.LicenseType.Activated)
Ozeki.VoIP.SDK.Protection.LicenseManager.Instance.SetLicense(m_OzekiLicenseId, m_OzekiLicenseKey);
using (BrightPlatformEntities objDbModel = new BrightPlatformEntities(UserSession.EntityConnection)) {
int? _SipAcctId = objDbModel.users.FirstOrDefault(i => i.id == UserSession.CurrentUser.UserId).sip_id;
if (!_SipAcctId.HasValue) {
//MessageBox.Show(
// string.Format("Your account is not yet configured for calling.{0}Please contact your administrator.", Environment.NewLine),
// "Bright Sales",
// MessageBoxButtons.OK,
// MessageBoxIcon.Information
//);
BrightVision.Common.UI.NotificationDialog.Error(
"Bright Sales",
string.Format("Your account is not yet configured for calling.{0}Please contact your administrator.", Environment.NewLine)
);
return;
}
sip_accounts sip = objDbModel.sip_accounts.FirstOrDefault(i => i.id == _SipAcctId);
if (sip != null)
objDbModel.Detach(sip);
if (m_UserAudioSetting == null)
m_UserAudioSetting = AudioSettingUtility.GetUserAudioSetting();
m_UserMicrophone = AudioSettingUtility.GetDefaultDeviceMicrophone();
m_UserSpeaker = AudioSettingUtility.GetDefaultDeviceSpeaker();
m_UserMicrophone.Volume = (float)m_UserAudioSetting.mic_volume / 10;
m_UserSpeaker.Volume = (float)m_UserAudioSetting.speaker_volume / 10;
try {
softPhone = SoftPhoneFactory.CreateSoftPhone(SoftPhoneFactory.GetLocalIP(), 5700, 5750, 5780);
}
catch {
}
this.DisableUnwantedCodec();
softPhone.IncomingCall -= new EventHandler<VoIPEventArgs<IPhoneCall>>(softPhone_IncomingCall);
softPhone.IncomingCall += new EventHandler<VoIPEventArgs<IPhoneCall>>(softPhone_IncomingCall);
SIPAccount acc = new SIPAccount(
true,
sip.display_name.Trim(),
sip.username.Trim(),
sip.username.Trim(),
sip.password,
sip.sip_url.Trim(),
5060,
""
);
// var acc = new SIPAccount(true, sip.display_name, sip.username, sip.username, sip.password, sip.sip_url, 5060,"");
// NatConfiguration newNatConfiguration = new NatConfiguration(NatTraversalMethod.Auto, new NatRemoteServer("stun.ozekiphone.com", "", ""));
phoneLine = softPhone.CreatePhoneLine(acc, Ozeki.Network.TransportType.Udp, SRTPMode.None);
phoneLine.PhoneLineStateChanged -= new EventHandler<VoIPEventArgs<PhoneLineState>>(phoneLine_PhoneLineInformation);
phoneLine.PhoneLineStateChanged += new EventHandler<VoIPEventArgs<PhoneLineState>>(phoneLine_PhoneLineInformation);
softPhone.RegisterPhoneLine(phoneLine);
objDbModel.Dispose();
}
}
catch (Exception ex) {
}
}
private void btnEditFollowUpDetails_Click(object sender, EventArgs e)
{
if (EventId < 1)
{
NotificationDialog.Error("Bright Sales", "No editable data is available.");
return;
}
m_EventBus.Notify(new FollowUpBarEvents.GetCampaignBookingArgs() {
ForWorkModePurpose = false
});
//CampaignBookingProperty.CampaignBoookingArguments _args = GetCampaignBookingArgs(false);
if (m_BrightSalesProperty.EventsProperty.CampaignBookingArgs == null || m_BrightSalesProperty.EventsProperty.CampaignBookingArgs.oAppointment == null)
return;
WaitDialog.Show("Loading Data ...");
#region Initialize Editor
m_Editor = new FollowUpEditor() {
Dock = DockStyle.Fill,
IsNurtureEvent = false
};
m_Editor.btnSave_OnClick += new FollowUpEditor.btnSaveOnClickEventHandler(m_Editor_btnSave_OnClick);
m_dlgEditor = new PopupDialog() {
FormBorderStyle = FormBorderStyle.FixedSingle,
MinimizeBox = false,
MaximizeBox = false,
StartPosition = FormStartPosition.CenterScreen,
Text = "Edit Current Follow Up",
ClientSize = new Size(m_Editor.Width + 2, m_Editor.Height + 2),
CloseBox = false
};
m_dlgEditor.Controls.Add(m_Editor);
#endregion
CampaignBookingProperty.CampaignBoookingArguments _args = m_BrightSalesProperty.EventsProperty.CampaignBookingArgs;
//bool IsDeActivated = false;
int _FinalListId;
event_followup_log _data;
using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
_data = _efDbContext.event_followup_log.FirstOrDefault(i => i.id == _args.Id);
_FinalListId = (int)_efDbContext.final_lists.FirstOrDefault(i => i.sub_campaign_id == _data.subcampaign_id).id;
_efDbContext.Detach(_data);
/*
* https://brightvision.jira.com/browse/PLATFORM-3070
* DAN: Inrelated to fixing the issue as must not be able to edit when account is already deactivated.
*/
sub_campaign_account_lists _eftSubCampaignAccount = _efDbContext.sub_campaign_account_lists.FirstOrDefault(p =>
p.account_id == _data.account_id &&
p.final_list_id == _FinalListId &&
p.active == true
);
if (_eftSubCampaignAccount == null) {
NotificationDialog.Warning("Bright Sales", "This account has been de-activated");
WaitDialog.Close();
return;
}
_efDbContext.Detach(_eftSubCampaignAccount);
//if (_eftSubCampaignAccount != null)
// _efDbContext.Detach(_eftSubCampaignAccount);
//else
// IsDeActivated = true;
}
//if (IsDeActivated)
//{
// NotificationDialog.Warning("Bright Sales", "This account has been de-activated");
// //return;
//}
if (_data.event_type.Equals("Nurture Event"))
m_Editor.IsNurtureEvent = true;
m_Editor.SubCampaignId = _args.oAppointment.SubCampaignId;
m_Editor.AccountId = _args.oAppointment.AccountId;
m_Editor.Prepare();
if (!_data.event_type.Equals("Nurture Event")) {
m_Editor.GetEventTypes(0, _data.event_type);
m_Editor.LoadSalesUsers((int)_data.subcampaign_id, (int)((_data.assigned_user != null)?_data.assigned_user:0));
m_Editor.SetCampaignInfo(_args);
m_ContactList = ObjectSubCampaign.GetSubCampaignContacts(_args.oAppointment.SubCampaignId, _args.oAppointment.AccountId, _args.oAppointment.FinalListId);
}
else {
m_Editor.GetEventTypes((int)_data.source_sub_campaign_id);
m_Editor.SetSelectedEventType((int)_data.subcampaign_id);
m_Editor.LoadSalesUsers((int)_data.subcampaign_id, (int)_data.assigned_user);
m_Editor.SetCampaignInfo(_data);
m_ContactList = ObjectSubCampaign.GetSubCampaignContacts((int)_data.subcampaign_id, (int)_data.account_id, _FinalListId);
}
if (m_ContactList.Count > 0) {
m_Editor.LoadContactPersons(m_ContactList);
CTScSubCampaignContactList _contact = m_ContactList.Find(i => i.id == (int)_data.contact_id);
if (_contact != null) {
m_Editor.ContactPerson = _contact;
m_Editor.LoadSelectedContact(false);
}
}
WaitDialog.Close();
m_dlgEditor.ShowDialog(this);
}
//public static bool ValidateUserLogin(int UserId, string Password)
public static bool ValidateUserLogin(string pEmail, string pPassword, ref user efoUser)
{
user _efoUser;
using (BrightPlatformEntities m_objBrightPlatformEntity = new BrightPlatformEntities(UserSession.DefaultEntityConnection)) {
pPassword = HashUtility.GetHashPassword(pPassword);
_efoUser = m_objBrightPlatformEntity.users.FirstOrDefault(i => i.email == pEmail && i.password.Equals(pPassword) && i.internal_user == true);
if (_efoUser != null) {
efoUser = _efoUser;
m_objBrightPlatformEntity.Detach(_efoUser);
}
}
if (_efoUser != null)
return true;
else
return false;
}
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;
}
/// <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;
}
/// <summary>
/// Determines if the user is a brightvision customer user
/// </summary>
/// <param name="UserId"></param>
/// <param name="SubcampaignId"></param>
/// <returns></returns>
public static bool IsCustomerUser(int UserId, int SubcampaignId)
{
//3 = Sub Campaign Sales
BrightPlatformEntities objDbModel = new BrightPlatformEntities(UserSession.EntityConnection);
var iUser =
(
from objUserRole in objDbModel.sub_campaign_user_roles
join objSubCampaignUser in objDbModel.subcampaign_users on objUserRole.sub_campaign_user_id equals objSubCampaignUser.id
where objSubCampaignUser.user_id == UserId && objUserRole.sub_campaign_role_id == 4 && objSubCampaignUser.subcampaign_id == SubcampaignId
select objUserRole
).FirstOrDefault();
if (iUser != null)
{
objDbModel.Detach(iUser);
return true;
}
else
{
return false;
}
}
private void GetDefaultConfig()
{
using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
subcampaign _eftSubCampaign = _efDbContext.subcampaigns.FirstOrDefault(i => i.id == m_SubCampaignId);
if (_eftSubCampaign != null) {
//if (!string.IsNullOrEmpty(_eftSubCampaign.send_email_config)) {
// string[] _data = _eftSubCampaign.send_email_config.Split(new string[] { "[sep]" }, StringSplitOptions.None);
// tbxSubject.Text = _data[0];
// tbxMessage.Text = _data[1];
//}
_efDbContext.Detach(_eftSubCampaign);
}
}
}
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.");
}
}
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 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;
}