private List <HomeStockistModel> searchStockist() { conDB = new ConnectionDB(); HomeStockistModel homeDepot = new HomeStockistModel(); List <HomeStockistModel> lstHomeStockist = new List <HomeStockistModel>(); queryString = "SELECT ID, firstname, lastname, phonenumber, address, clienttype FROM dbpackage.tblclients where " + "(isDeleted = 0) AND (clienttype = 2)"; queryString += " AND (dbpackage.tblclients.lastname like '%" + searchName.Text + "%' OR dbpackage.tblclients.firstname " + "like '%" + searchName.Text + "%')"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); while (reader.Read()) { homeDepot.ID = reader["ID"].ToString(); homeDepot.FirstName = reader["firstname"].ToString(); homeDepot.LastName = reader["lastname"].ToString(); homeDepot.ContactNo = reader["phonenumber"].ToString(); homeDepot.Address = reader["address"].ToString(); homeDepot.Fullname = homeDepot.LastName + ", " + homeDepot.FirstName; lstHomeStockist.Add(homeDepot); homeDepot = new HomeStockistModel(); } conDB.closeConnection(); return(lstHomeStockist); }
public AddPaymentWindow(OrderWindow ow, HomeStockistModel hsm, OrderHistoryModel ohm) { orderWin = ow; homeStockModel = hsm; orderHistory = ohm; InitializeComponent(); }
private List <HomeStockistModel> loadClientHOmeStockist() { conDB = new ConnectionDB(); HomeStockistModel homeStockist = new HomeStockistModel(); List <HomeStockistModel> lstHomeStockist = new List <HomeStockistModel>(); queryString = "SELECT ID, firstname, lastname, phonenumber, address, clienttype FROM dbpackage.tblclients where " + "isDeleted = 0 AND clienttype = 2 ORDER BY lastname asc"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); while (reader.Read()) { homeStockist.ID = reader["ID"].ToString(); homeStockist.FirstName = reader["firstname"].ToString(); homeStockist.LastName = reader["lastname"].ToString(); homeStockist.ContactNo = reader["phonenumber"].ToString(); homeStockist.Address = reader["address"].ToString(); homeStockist.Fullname = homeStockist.LastName + ", " + homeStockist.FirstName; lstHomeStockist.Add(homeStockist); homeStockist = new HomeStockistModel(); } conDB.closeConnection(); return(lstHomeStockist); }
private void btnEditClient_Click(object sender, RoutedEventArgs e) { HomeStockistModel hs = dgvclient.SelectedItem as HomeStockistModel; if (hs != null) { AddClientWindow acw = new AddClientWindow(this, hs); acw.ShowDialog(); } }
private void btnViewDR_Click(object sender, RoutedEventArgs e) { viewHomeStockist = dgvclient.SelectedItem as HomeStockistModel; if (viewHomeStockist != null) { dgvdr.ItemsSource = loadOrdersHistory(viewHomeStockist.ID); lblCientNameDisplay.Content = "D.R. records for " + viewHomeStockist.Fullname; disableEnableControls(false); btnDRDetails.IsEnabled = true; btnAddDR.IsEnabled = true; btnEditDR.IsEnabled = true; btnDeleteDR.IsEnabled = true; } }
private async void btnDelete_Click(object sender, RoutedEventArgs e) { HomeStockistModel hme = dgvclient.SelectedItem as HomeStockistModel; if (hme != null) { MahApps.Metro.Controls.MetroWindow window = Window.GetWindow(this) as MahApps.Metro.Controls.MetroWindow; MessageDialogResult result = await window.ShowMessageAsync("Delete Client", "Are you sure you want to delete client: " + hme.Fullname, MessageDialogStyle.AffirmativeAndNegative); if (result == MessageDialogResult.Affirmative) { deleteHomeStockist(hme.ID); dgvclient.ItemsSource = loadClientHOmeStockist(); dgvclient.Items.Refresh(); } } }
public OrderWindow(HomeStockistModel hsm, OrderHistoryModel ohm) { orderHistory = ohm; homeStockistMod = hsm; InitializeComponent(); }
public OrderWindow(HomeStockistModel hsm) { homeStockistMod = hsm; InitializeComponent(); }
public AddClientWindow(SPMSUN_Stockist ss, HomeStockistModel hsm) { homeStockist = hsm; spmsun_home = ss; InitializeComponent(); }