private void DeleteClientGridButton_Click(object sender, RoutedEventArgs e) { if (mangaclientgrid.SelectedItems.Count != 1) { MessageBox.Show("Please select 1 client to delete", "Error"); return; } if (MessageBox.Show("Are you sure you want to delete this client?", "Confirm", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { Client client = (Client)mangaclientgrid.SelectedItem; client = db.Clients.SingleOrDefault(x => x.CLCODE == client.CLCODE); if (client == null) { MessageBox.Show("This client does not exists.", "Error"); return; } if (client.CLCODE == "<NONE>" || client.CLCODE == "<DTDC>") { MessageBox.Show("This client cannot be deleted"); return; } db.Clients.DeleteOnSubmit(client); try { db.SubmitChanges(); MessageBox.Show("Client deleted.", "Success"); } catch (Exception ex) { MessageBox.Show("Deletion failed with error : " + ex.Message, "Failure"); } DataSources.refreshClientList(); ReloadClientGridButton_Click(null, null); } }
private void ReloadClientGridButton_Click(object sender, RoutedEventArgs e) { DataSources.refreshClientList(); clients = DataSources.ClientCopy; viewsource = (CollectionViewSource)FindResource("ClienTable"); viewsource.Source = clients; }
public void add() { string errorMsg = validate(); if (errorMsg == "") { client = new Client(); client.CLNAME = ClientName.Text; client.Status = 'A'; client.ADDRESS = ClientAddress.Text; client.CONTACTNO = ClientPhoneNo.Text; client.EMAILID = CLientEmailAddress.Text; client.CLCODE = ClientCode.Text; client.FUEL = float.Parse(ClientFuel.Text); client.INTRODATE = DateTime.Now; client.STAX = float.Parse(ServiceTax.Text); client.AMTDISC = float.Parse(DiscountBox.Text); db.Clients.InsertOnSubmit(client); try { db.SubmitChanges(); DataSources.refreshClientList(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } this.Close(); } else { MessageBox.Show("Please correct following errors: " + errorMsg); } }
public void setDataSource(Filter filterObj, IEnumerable <string> ConnNo) { InitializeComponent(); this.filterObj = filterObj; BillingDataDataContext db = new BillingDataDataContext(); StartConnNoList = (CollectionViewSource)FindResource("StartConnNoList"); List <String> ConnNoList = ConnNo.OrderBy(x => x).ToList(); StartConnNoList.Source = ConnNoList; EndConnoList = (CollectionViewSource)FindResource("EndConnoList"); EndConnoList.Source = ConnNoList; DataSources.refreshClientList(); List <Client> fClientList = DataSources.ClientCopy; SelectClientBox.AllListSource = fClientList.Where(x => !filterObj.selectedClientList.Select(y => y.CLCODE).Contains(x.CLCODE)).ToList(); SelectClientBox.SelectedListSource = filterObj.selectedClientList; SelectClientBox.DisplayValuePath = "NameAndCode"; switch (filterObj.showBilled) { case true: { BilledRadio.IsChecked = true; break; } case false: { UnBilledRadio.IsChecked = true; break; } case null: { AllRadio.IsChecked = true; break; } } if (filterObj.startConnNo != "" && ConnNo.Contains(filterObj.startConnNo)) { StartConnNo.Text = filterObj.startConnNo; } else { StartConnNo.Text = ConnNo.FirstOrDefault() ?? ""; } if (filterObj.endConnNo != "" && ConnNo.Contains(filterObj.endConnNo)) { EndConnNo.Text = filterObj.endConnNo; } else { EndConnNo.Text = ConnNo.LastOrDefault() ?? ""; } ToDate.SelectedDate = filterObj.toDate; FromDate.SelectedDate = filterObj.fromDate; StartPriceValue.Text = filterObj.startPrice.ToString(); EndPriceValue.Text = filterObj.endPrice.ToString(); StartWeightValue.Text = filterObj.startWeight.ToString(); EndWeightValue.Text = filterObj.endWeight.ToString(); }
private void AddClient_close(object sender, EventArgs e) { DataSources.refreshClientList(); clientViewSource.Source = DataSources.ClientCopy; ClientCombo.Items.Refresh(); }