private List <MegaStockistModel> searchStockist()
{
conDB = new ConnectionDB();
MegaStockistModel depotStockist = new MegaStockistModel();
List <MegaStockistModel> lstDepotStockist = new List <MegaStockistModel>();
queryString = "SELECT ID, firstname, lastname, phonenumber, address, clienttype FROM dbpackage.tblclients where " +
"(isDeleted = 0) AND (clienttype = 1)";
queryString += " AND (dbpackage.tblclients.lastname like '%" + searchName.Text + "%' OR dbpackage.tblclients.firstname " +
"like '%" + searchName.Text + "%')";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
depotStockist.ID = reader["ID"].ToString();
depotStockist.FirstName = reader["firstname"].ToString();
depotStockist.LastName = reader["lastname"].ToString();
depotStockist.ContactNo = reader["phonenumber"].ToString();
depotStockist.Address = reader["address"].ToString();
depotStockist.Fullname = depotStockist.LastName + ", " + depotStockist.FirstName;
lstDepotStockist.Add(depotStockist);
depotStockist = new MegaStockistModel();
}
conDB.closeConnection();
return(lstDepotStockist);
}
public AddPaymentWindow(OrderWindow ow, MegaStockistModel msm, OrderHistoryModel ohm)
{
orderWin = ow;
megaStockModel = msm;
orderHistory = ohm;
InitializeComponent();
}
private List <MegaStockistModel> loadClientMegaStockist()
{
conDB = new ConnectionDB();
MegaStockistModel megaStockist = new MegaStockistModel();
List <MegaStockistModel> lstMegaStockist = new List <MegaStockistModel>();
queryString = "SELECT ID, firstname, lastname, phonenumber, address, clienttype FROM dbpackage.tblclients where " +
"isDeleted = 0 AND clienttype = 1 ORDER BY lastname asc";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
megaStockist.ID = reader["ID"].ToString();
megaStockist.FirstName = reader["firstname"].ToString();
megaStockist.LastName = reader["lastname"].ToString();
megaStockist.ContactNo = reader["phonenumber"].ToString();
megaStockist.Address = reader["address"].ToString();
megaStockist.Fullname = megaStockist.LastName + ", " + megaStockist.FirstName;
lstMegaStockist.Add(megaStockist);
megaStockist = new MegaStockistModel();
}
conDB.closeConnection();
return(lstMegaStockist);
}
private void btnEditClient_Click(object sender, RoutedEventArgs e)
{
MegaStockistModel megaStck = dgvclientmega.SelectedItem as MegaStockistModel;
AddClientWindow acw = new AddClientWindow(this, megaStck);
acw.ShowDialog();
}
private void btnViewDR_Click(object sender, RoutedEventArgs e)
{
viewMegaStockist = dgvclientmega.SelectedItem as MegaStockistModel;
if (viewMegaStockist != null)
{
dgvdr.ItemsSource = loadOrdersHistory(viewMegaStockist.ID);
lblCientNameDisplay.Content = "D.R. records for " + viewMegaStockist.Fullname;
disableEnableControls(false);
btnDRDetails.IsEnabled = true;
btnAddDR.IsEnabled = true;
btnEditDR.IsEnabled = true;
btnDeleteDR.IsEnabled = true;
}
}
private async void btnDelete_Click(object sender, RoutedEventArgs e)
{
MegaStockistModel hme = dgvclientmega.SelectedItem as MegaStockistModel;
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);
dgvclientmega.ItemsSource = loadClientMegaStockist();
dgvclientmega.Items.Refresh();
}
}
}
public OrderWindow(MegaStockistModel msm, OrderHistoryModel ohm)
{
orderHistory = ohm;
megaStockistMod = msm;
InitializeComponent();
}
public OrderWindow(MegaStockistModel msm)
{
megaStockistMod = msm;
InitializeComponent();
}
public AddClientWindow(SPMSUN_MegaStockist ms, MegaStockistModel msm)
{
megaStockist = msm;
spmsun_mega = ms;;
InitializeComponent();
}