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);
}
}
}
/// <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();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
var atts = m_oSchedule.ContactAttendies;
int[] rowHandles = gridView1.GetSelectedRows();
if (rowHandles.Length > 0) {
if (atts == null)
atts = new List<ContactAttendie>();
for (int x = 0; x < rowHandles.Length; ++x) {
ContactAttendie att = gridView1.GetRow(rowHandles[x]) as ContactAttendie;
if (att != null) {
using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
contact _eftContact = _efDbContext.contacts.FirstOrDefault(i => i.id == att.ContactID);
if (_eftContact != null) {
att.Email = _eftContact.email;
att.Address = string.Format("{0}{1}{2}{3}",
string.IsNullOrEmpty(_eftContact.address_1) ? "" : _eftContact.address_1,
string.IsNullOrEmpty(_eftContact.address_2) ? "" : " " + _eftContact.address_2,
string.IsNullOrEmpty(_eftContact.city) ? "" : ", " + _eftContact.city,
string.IsNullOrEmpty(_eftContact.country) ? "" : ", " + _eftContact.country
);
att.Telephone = _eftContact.direct_phone;
_efDbContext.Detach(_eftContact);
}
}
att.Attending = true;
atts.Add(att);
}
}
}
}
public AddQuestion(GridView oQuestionGrid, int question_id)
{
InitializeComponent();
BPContext = new BrightPlatformEntities(UserSession.EntityConnection);
QuestionID = question_id;
QuestionGrid = oQuestionGrid;
}
private void LoadSIPAccount()
{
objDbModel = new BrightPlatformEntities(UserSession.EntityConnection);
gcSIPAccount.DataSource = null;
var sipaccount = objDbModel.sip_accounts.AsQueryable();
gcSIPAccount.DataSource = sipaccount;
}
public AddAnswerForm(int questionid, GridView sender)
{
InitializeComponent();
question_id = questionid;
gridviewSender = sender;
BPContext = new BrightPlatformEntities(UserSession.EntityConnection);
}
/// <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;
}
public static bool CanDoCall()
{
BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection);
int _UserId = UserSession.CurrentUser.UserId;
var userAudio = _efDbContext.audio_settings.FirstOrDefault(i => i.user_id == _UserId);
if(userAudio == null)
return false;
int _CallMode = userAudio.mode;
if (_CallMode == 0) {
user _item = _efDbContext.users.FirstOrDefault(i => i.id == UserSession.CurrentUser.UserId);
if (_item.sip_id == null || Convert.ToInt32(_item.sip_id) < 1)
return false;
else
return true;
}
return true;
//int _UserId = UserSession.CurrentUser.UserId;
//BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection);
//user _efeUser = _efDbContext.users.Where(i => i.id == _UserId).FirstOrDefault();
//if (_efeUser != null && _efeUser.sip_id != null && _efeUser.sip_id > 0) {
// var sipAccount = _efDbContext.sip_accounts.Where(e => e.id == _efeUser.sip_id).FirstOrDefault();
// if (sipAccount != null)
// return true;
//}
//return false;
}
private void FrmMain_Load(object sender, EventArgs e)
{
//dummy values for question_id
//int dropboxId = 1, textboxId = 2, multipleChoiceId = 3;
BPContext = new BrightPlatformEntities(UserSession.EntityConnection);
//var resourceList = BPContext.FIGetResources(3).ToList();
//List<int?> resourceids = new List<int?>();
//resourceList.ForEach(delegate(CTResources r) {
// resourceids.Add(r.resource_id);
//});
//var schedList = BPContext.schedules.Where(x => resourceids.Contains(x.resource_id)).ToList();
this.layoutControlGroupQuestionnaire.BeginUpdate();
////add dropbox
//Dropbox oDropbox = new Dropbox(this.layoutControlQuestionnaire);
//oDropbox.ToolTipController = defaultToolTipController1;
//oDropbox.Questionnaire = CampaignQuestionnaire.Instanciate(QuestionTypeConstants.Dropbox);
////oDropbox.Questionnaire = Business.BusinessAnswer.BindAnswer(oDropbox.Questionnaire, BPContext, dropboxId);
//oDropbox.BindControls();
//this.layoutControlGroupQuestionnaire.Add(oDropbox.ControlGroup);
////add textbox
//Textbox oTextbox = new Textbox(this.layoutControlQuestionnaire);
//oTextbox.Questionnaire = CampaignQuestionnaire.Instanciate(QuestionTypeConstants.Textbox);
////oTextbox.Questionnaire = Business.BusinessAnswer.BindAnswer(oTextbox.Questionnaire, BPContext, textboxId);
//oTextbox.BindControls();
//this.layoutControlGroupQuestionnaire.Add(oTextbox.ControlGroup);
////add multiplechoice
Multiplechoice oMultipleChoice = new Multiplechoice(this.layoutControlQuestionnaire);
oMultipleChoice.Questionnaire = CampaignQuestionnaire.Instanciate(QuestionTypeConstants.MultipleChoice);
//oMultipleChoice.Questionnaire = Business.BusinessAnswer.BindAnswer(oMultipleChoice.Questionnaire, BPContext, multipleChoiceId);
oMultipleChoice.BindControls();
this.layoutControlGroupQuestionnaire.Add(oMultipleChoice.ControlGroup);
//add schedule
Schedule oSchedule = new Schedule(this.layoutControlQuestionnaire);
oSchedule.Questionnaire = CampaignQuestionnaire.Instanciate(QuestionTypeConstants.Schedule);
oSchedule.Questionnaire.Form.Settings.DataBindings.account_id = "1";
//contact callerContact = BPContext.contacts.FirstOrDefault(x=>x.id == 35758);
//if (callerContact != null)
// oSchedule.SetCurrentCaller(callerContact, 1);
//oSchedule.ShowCalendarBookingClick += new EventHandler(oSchedule_ShowCalendarBookingClick);
//oSchedule.Questionnaire = Business.BusinessAnswer.BindAnswer(oSchedule.Questionnaire, BPContext, multipleChoiceId);
oSchedule.BindControls();
this.layoutControlGroupQuestionnaire.Add(oSchedule.ControlGroup);
//add seminar
//Seminar oSeminar = new Seminar(this.layoutControlQuestionnaire);
//oSeminar.Questionnaire = CampaignQuestionnaire.Instanciate(QuestionTypeConstants.Seminar);
//oSeminar.Questionnaire.Form.Settings.DataBindings.account_id = "1";
////oSeminar.Questionnaire = Business.BusinessAnswer.BindAnswer(oSchedule.Questionnaire, BPContext, multipleChoiceId);
//oSeminar.BindControls();
//this.layoutControlGroupQuestionnaire.Add(oSeminar.ControlGroup);
//add bottom spacer
this.layoutControlGroupQuestionnaire.AddItem(emptySpaceItem1);
this.layoutControlGroupQuestionnaire.EndUpdate();
}
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();
}
}
public static void Save(event_followup_log pData, bool pSaveExistingFollowUpCallsAsDone = false)
{
using (BrightPlatformEntities _eftDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
if (pSaveExistingFollowUpCallsAsDone) {
List<event_followup_log> _ToUpdateList = _eftDbContext.event_followup_log.Where(
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")
).ToList();
if (_ToUpdateList.Count > 0) {
foreach (event_followup_log _item in _ToUpdateList) {
event_followup_log _handler = _eftDbContext.event_followup_log.FirstOrDefault(x => x.id == _item.id);
_item.done = true;
_eftDbContext.event_followup_log.ApplyCurrentValues(_item);
_eftDbContext.Detach(_handler);
}
}
}
_eftDbContext.event_followup_log.AddObject(pData);
_eftDbContext.SaveChanges();
_eftDbContext.Detach(pData);
}
}
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 IList<IdName> GetUsers(int FinalListId, bool pAddTeamEntry = false)
{
List<IdName> _lstData = new List<IdName>();
using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
var objUsers = (
from objFinalList in _efDbContext.final_lists
join objSubCampaignUser in _efDbContext.subcampaign_users on objFinalList.sub_campaign_id equals objSubCampaignUser.subcampaign_id
join objUser in _efDbContext.users on objSubCampaignUser.user_id equals objUser.id
orderby objUser.fullname
select new IdName {
id = objUser.id,
name = objUser.fullname
}
).Distinct();
var listResult = objUsers.ToList();
IdName[] array = new IdName[listResult.Count];
listResult.CopyTo(array);
_lstData = array.ToList();
}
if (pAddTeamEntry)
_lstData.Add(new IdName() {
id = 0,
name = "Team"
});
return _lstData;
}
/// <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 (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 FrmSchedulingPopup()
{
m_DoneLoadingBookings = false; // flag as not done loading yet
InitializeComponent();
this.KeyPreview = true;
BPContext = new BrightPlatformEntities(UserSession.EntityConnection);
}
public ManageReportTemplate(int viewid)
{
InitializeComponent();
BPContext = new BrightPlatformEntities(UserSession.EntityConnection);
reportDesign = new ReportUserDesigner();
//BindSubcampaignLookup();
}
private void GetData(int pCustomerId, int pCampaignId, int pSubCampaignId)
{
m_SubCampaignId = pSubCampaignId;
using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
gcNurtureSubCampaign.DataSource = null;
gcNurtureSubCampaign.DataSource = _efDbContext.FIGetSubCampaignNurtureList(pCustomerId, pCampaignId, pSubCampaignId).ToList();
}
}
public static List<CTAdditionalDataReportTemplate> GetAdditionalDataReportTemplates()
{
List<CTAdditionalDataReportTemplate> list = new List<CTAdditionalDataReportTemplate>();
using (BrightPlatformEntities _efDbModel = new BrightPlatformEntities(UserSession.EntityConnection) { CommandTimeout = 0 }) {
list = _efDbModel.FIGetAdditionalDataReportTemplates().ToList();
}
return list;
}
public TemplateDialog()
{
this.Visible = false;
InitializeComponent();
BPContext = new BrightPlatformEntities(UserSession.EntityConnection);
BindLookupEdit();
this.Visible = true;
}
/// <summary>
/// Returns the customer id
/// </summary>
public static int GetCustomerId(string CustomerName)
{
BrightPlatformEntities m_objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection);
var objCustomer = m_objBrightPlatformEntity.customers.CreateObject();
objCustomer = m_objBrightPlatformEntity.customers.Where(objField => objField.customer_name == CustomerName).SingleOrDefault();
return objCustomer.id;
}
public AddAnswerForm(int questionid, GridView sender, SimpleButton btnSchedule)
{
InitializeComponent();
question_id = questionid;
gridviewSender = sender;
createSchedule = btnSchedule;
BPContext = new BrightPlatformEntities(UserSession.EntityConnection);
}
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;
}
/// <summary>
/// Check if already exists, must implement 1 dialog = 1 sub campaign relationship
/// </summary>
/// <param name="DialogName"></param>
/// <param name="SubCampaignId"></param>
/// <returns></returns>
public static bool Exists(string DialogName, int SubCampaignId)
{
BrightPlatformEntities objDbModel = new BrightPlatformEntities(UserSession.EntityConnection);
var Item = objDbModel.dialogs.FirstOrDefault(i => i.name.Equals(DialogName.Trim()) && i.subcampaign_id == SubCampaignId && i.is_active == true);
if (Item == null)
return false;
else
return true;
}
public static bool CanAddDialog(int SubCampaignId)
{
BrightPlatformEntities objDbModel = new BrightPlatformEntities(UserSession.EntityConnection);
var Item = objDbModel.dialogs.FirstOrDefault(i => i.subcampaign_id == SubCampaignId && i.is_active == true);
if (Item == null)
return true;
else
return false;
}
public static List<CTScEventAndFollowUpLog> GetEventFollowUpLogs(int pSubCampaignId, int pAccountId)
{
List<CTScEventAndFollowUpLog> _lstData = new List<CTScEventAndFollowUpLog>();
using (BrightPlatformEntities _eftDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) {
_lstData = _eftDbContext.FIScGetEventAndFollowUpLogs(pSubCampaignId, pAccountId, UserSession.CurrentUser.UserId).ToList();
}
return _lstData;
}
/// <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();
}
/// <summary>
/// Gets campaign records returns an object query result set
/// </summary>
public static ObjectQuery GetCampaigns(eViewtype ViewType, int CustomerId)
{
BrightPlatformEntities m_objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection);
ObjectQuery objCampaigns = null;
switch (ViewType)
{
//case eViewtype.SubCampaignsView:
//{
// var objEntityCampaigns =
// from objCampaign in m_objBrightPlatformEntity.campaigns
// join objEntityCustomer in m_objBrightPlatformEntity.customers on objCampaign.customer_nr equals objEntityCustomer.customer_nr into objEntityCustomer
// from objCustomer in objEntityCustomer.DefaultIfEmpty()
// select new
// {
// ids = SqlFunctions.StringConvert((double) objCampaign.id).Trim() + ";" + objCustomer.customer_name,
// name = objCampaign.campaign_name
// };
// objCampaigns = (ObjectQuery) objEntityCampaigns;
// break;
//}
case eViewtype.ComboListView:
{
var objEntityCampaigns =
from objCampaign in m_objBrightPlatformEntity.campaigns
orderby objCampaign.campaign_name
select new
{
id = objCampaign.id,
name = objCampaign.campaign_name
};
objCampaigns = (ObjectQuery) objEntityCampaigns;
break;
}
case eViewtype.ComboListViewByCustomerId:
{
var objEntityCampaigns =
from objCampaign in m_objBrightPlatformEntity.campaigns
where objCampaign.customer_id == CustomerId
orderby objCampaign.campaign_name
select new
{
id = objCampaign.id,
name = objCampaign.campaign_name
};
objCampaigns = (ObjectQuery)objEntityCampaigns;
break;
}
}
return objCampaigns;
}
/// <summary>
/// Logic to save customer record
/// </summary>
private void SaveCompany()
{
var BPContext = new BrightPlatformEntities(UserSession.EntityConnection);
BPContext.CommandTimeout = 0;
var objAccount = new account {
company_name = !string.IsNullOrEmpty(txtName.Text.Trim()) ? txtName.Text.Trim() : null,
org_no = !string.IsNullOrEmpty(txtOrgNo.Text.Trim()) ? txtOrgNo.Text.Trim() : null,
box_address = !string.IsNullOrEmpty(txtBoxAddress.Text.Trim()) ? txtBoxAddress.Text.Trim() : null,
street_address = !string.IsNullOrEmpty(txtStreetAddress.Text.Trim()) ? txtStreetAddress.Text.Trim() : null,
zipcode = !string.IsNullOrEmpty(txtZipcode.Text.Trim()) ? txtZipcode.Text.Trim() : null,
country = !string.IsNullOrEmpty(txtCountry.Text.Trim()) ? txtCountry.Text.Trim() : null,
county = !string.IsNullOrEmpty(txtCounty.Text.Trim()) ? txtCounty.Text.Trim() : null,
municipality = !string.IsNullOrEmpty(txtMunicipality.Text.Trim()) ? txtMunicipality.Text.Trim() : null,
city = !string.IsNullOrEmpty(txtCity.Text.Trim()) ? txtCity.Text.Trim() : null,
telephone = !string.IsNullOrEmpty(txtTelephone.Text.Trim()) ? txtTelephone.Text.Trim() : null,
telefax = !string.IsNullOrEmpty(txtTelefax.Text.Trim()) ? txtTelefax.Text.Trim() : null,
www = !string.IsNullOrEmpty(txtSite.Text.Trim()) ? txtSite.Text.Trim() : null,
parent_company = !string.IsNullOrEmpty(txtParentCompany.Text.Trim()) ? txtParentCompany.Text.Trim() : null,
year_established = !string.IsNullOrEmpty(txtYearEstablished.Text.Trim()) ? txtYearEstablished.Text.Trim() : null,
activity_code = !string.IsNullOrEmpty(txtActivityCode.Text.Trim()) ? txtActivityCode.Text.Trim() : null,
activity_code_2 = !string.IsNullOrEmpty(txtActivityCode2.Text.Trim()) ? txtActivityCode2.Text.Trim() : null,
currency = !string.IsNullOrEmpty(txtCurrency.Text.Trim()) ? txtCurrency.Text.Trim() : null,
fiscal = !string.IsNullOrEmpty(txtFiscal1.Text.Trim()) ? txtFiscal1.Text.Trim() : null,
turnover = !string.IsNullOrEmpty(txtTurnover1.Text.Trim()) ? decimal.Parse(txtTurnover1.Text.Trim()) : (decimal?) null,
export = !string.IsNullOrEmpty(txtExport1.Text.Trim()) ? decimal.Parse(txtExport1.Text.Trim()) : (decimal?) null,
result = !string.IsNullOrEmpty(txtResult1.Text.Trim()) ? decimal.Parse(txtResult1.Text.Trim()) : (decimal?) null,
sales_abroad = !string.IsNullOrEmpty(txtSalesAbroad1.Text.Trim()) ? decimal.Parse(txtSalesAbroad1.Text.Trim()) : (decimal?)null,
employees_total = !string.IsNullOrEmpty(txtEmpTotal1.Text.Trim()) ? int.Parse(txtEmpTotal1.Text.Trim()) : (int?)null,
employees_abroad = !string.IsNullOrEmpty(txtEmpAbroad1.Text.Trim()) ? int.Parse(txtEmpAbroad1.Text.Trim()) : (int?)null,
fiscal_2 = !string.IsNullOrEmpty(txtFiscal2.Text.Trim()) ? txtFiscal2.Text.Trim() : null,
turnover_2 = !string.IsNullOrEmpty(txtTurnover2.Text.Trim()) ? decimal.Parse(txtTurnover2.Text.Trim()) : (decimal?)null,
export_2 = !string.IsNullOrEmpty(txtExport2.Text.Trim()) ? decimal.Parse(txtExport2.Text.Trim()) : (decimal?)null,
result_2 = !string.IsNullOrEmpty(txtResult2.Text.Trim()) ? decimal.Parse(txtResult2.Text.Trim()) : (decimal?)null,
sales_abroad_2 = !string.IsNullOrEmpty(txtSalesAbroad2.Text.Trim()) ? decimal.Parse(txtSalesAbroad2.Text.Trim()) : (decimal?)null,
employees_total_2 = !string.IsNullOrEmpty(txtEmpTotal2.Text.Trim()) ? int.Parse(txtEmpTotal2.Text.Trim()) : (int?)null,
employees_abroad_2 = !string.IsNullOrEmpty(txtEmpAbroad2.Text.Trim()) ? int.Parse(txtEmpAbroad2.Text.Trim()) : (int?)null,
fiscal_3 = !string.IsNullOrEmpty(txtFiscal3.Text.Trim()) ? txtFiscal3.Text.Trim() : null,
turnover_3 = !string.IsNullOrEmpty(txtTurnover3.Text.Trim()) ? decimal.Parse(txtTurnover3.Text.Trim()) : (decimal?)null,
export_3 = !string.IsNullOrEmpty(txtExport3.Text.Trim()) ? decimal.Parse(txtExport3.Text.Trim()) : (decimal?)null,
result_3 = !string.IsNullOrEmpty(txtResult3.Text.Trim()) ? decimal.Parse(txtResult3.Text.Trim()) : (decimal?)null,
sales_abroad_3 = !string.IsNullOrEmpty(txtSalesAbroad3.Text.Trim()) ? decimal.Parse(txtSalesAbroad3.Text.Trim()) : (decimal?)null,
employees_total_3 = !string.IsNullOrEmpty(txtEmpTotal3.Text.Trim()) ? int.Parse(txtEmpTotal3.Text.Trim()) : (int?)null,
employees_abroad_3 = !string.IsNullOrEmpty(txtEmpAbroad3.Text.Trim()) ? int.Parse(txtEmpAbroad3.Text.Trim()) : (int?)null,
created_date = DateTime.Now,
created_by = UserSession.CurrentUser.UserId,
modified_date = DateTime.Now,
active = true,
last_modified_machine = UserSession.CurrentUser.ComputerName,
last_modified_source = BrightVision.EventLog.Business.FacadeEventLog.Source_Bright_Manager_Add_Company
};
BPContext.accounts.AddObject(objAccount);
BPContext.SaveChanges();
//m_objParentControl.PopulateCompanyView(null, 1);
m_objParentControl.PopulateCompanyView(objAccount.company_name, 1, true);
this.ParentForm.Close();
}
public static string GetServerUrl(Guid audioID)
{
var objDbModel = new BrightPlatformEntities(UserSession.EntityConnection);
var followup = objDbModel.event_followup_log.Where(param => param.audio_id == audioID).FirstOrDefault();
string salesAudioUri = ConfigManager.AppSettings["SalesAudioUri"];
string audioUrl = String.Format("{0}/{1}/{2}/{3}/{4}_.mp3", salesAudioUri, followup.date_created.Value.Year, followup.date_created.Value.Month, followup.date_created.Value.Day, audioID);
return audioUrl;
}
