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