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 "); }
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 "); }
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}'"); }
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}'"); }