C# BrightPlatformEntities类代码示例

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

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

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