コード例 #1
0
 private void BtnDelete_Click(object sender, RoutedEventArgs e)
 {
     classEdit.Edit("Update LeadsAndCalls set Status='Удален' " +
                    $"Where IdLeadAndCalls='{classDG.SelectId()}'");
     classDG.LoadDB("Select * from dbo.ViewListCall " +
                    $"Where Login='******' " +
                    $"and NameStatus='Активный' and Status='Активен' " +
                    $"Order by LeadCallDateTime DESC ");
 }
コード例 #2
0
 private void BtnDelete_Click(object sender, RoutedEventArgs e)
 {
     classEdit.Edit("Update Lead set IdStatus='2' " +
                    $"Where IdLead='{classDG.SelectId()}'");
     classDG.LoadDB("Select * from dbo.ViewListLead " +
                    $"Where Login='******' " +
                    $"and NameStatus='Активный' " +
                    $"Order by DateTimeLeadCreated DESC ");
 }
コード例 #3
0
 private void btnSave_Click(object sender, RoutedEventArgs e)
 {
     classEdit.Edit("Update LeadsAndCalls " +
                    $"set LeadCallDateTime='{DpDateCall.Text}', " +
                    $"CallDuration='{TbDurationCall.Text}', " +
                    $"Comment='{TbCommentCall.Text}' " +
                    $"Where IdLeadAndCalls='" +
                    $"{FolderClass.ClassLeadAndCall.IdLeadAndCalls}'");
 }
コード例 #4
0
        private void BtnSave_Click(object sender, RoutedEventArgs e)
        {
            FolderClass.ClassStatusLead.IdStatus = Int32.Parse(CbStatus.SelectedValue.ToString());

            classEdit.Edit("Update dbo.Lead " +
                           $"set NumberPhoneLead='{TbNumberPhone.Text}', " +
                           $"WorkingWithObjections='{TbWorkingWithObjections.Text}', " +
                           $"KnowledgeOfCompanysProducts='{TbKnowledgeOfCompanysProducts.Text}', " +
                           $"MasteringSalesSkills='{TbMasteringSalesSkills.Text}', " +
                           $"DateTimeLeadCreated='{DpDateTimeLeadCreated.Text}', " +
                           $"Comment='{TbComment.Text}', " +
                           $"IdStatus='{FolderClass.ClassStatusLead.IdStatus}' " +
                           $"Where IdLead='{FolderClass.ClassLead.IdLead}'");
        }