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