private List <DepotStockistModel> loadDepotClientStockist(string strClientType)
{
conDB = new ConnectionDB();
DepotStockistModel dpotStockist = new DepotStockistModel();
List <DepotStockistModel> lstDepotStockist = new List <DepotStockistModel>();
string queryString = "SELECT ID, firstname, lastname, phonenumber, address, clienttype FROM dbpackage.tblclients where " +
"isDeleted = 0 AND clienttype = ? ORDER BY lastname asc";
List <string> parameters = new List <string>();
parameters.Add(strClientType);
MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters);
while (reader.Read())
{
dpotStockist.ID = reader["ID"].ToString();
dpotStockist.FirstName = reader["firstname"].ToString();
dpotStockist.LastName = reader["lastname"].ToString();
dpotStockist.ContactNo = reader["phonenumber"].ToString();
dpotStockist.Address = reader["address"].ToString();
dpotStockist.Fullname = dpotStockist.LastName + ", " + dpotStockist.FirstName;
lstDepotStockist.Add(dpotStockist);
dpotStockist = new DepotStockistModel();
}
conDB.closeConnection();
return(lstDepotStockist);
}
public AddPaymentWindow(OrderWindow ow, DepotStockistModel dsm, OrderHistoryModel ohm)
{
orderWin = ow;
depotStockModel = dsm;
orderHistory = ohm;
InitializeComponent();
}
private List <DepotStockistModel> searchStockist()
{
conDB = new ConnectionDB();
DepotStockistModel depotStockist = new DepotStockistModel();
List <DepotStockistModel> lstDepotStockist = new List <DepotStockistModel>();
queryString = "SELECT ID, firstname, lastname, phonenumber, address, clienttype FROM dbpackage.tblclients where " +
"(isDeleted = 0) AND (clienttype = 3)";
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 DepotStockistModel();
}
conDB.closeConnection();
return(lstDepotStockist);
}
private void btnEditClient_Click(object sender, RoutedEventArgs e)
{
DepotStockistModel depotStck = dgvclientmega.SelectedItem as DepotStockistModel;
AddClientWindow acw = new AddClientWindow(this, depotStck);
acw.ShowDialog();
}
private void btnViewDR_Click(object sender, RoutedEventArgs e)
{
viewDepotStockist = dgvclientmega.SelectedItem as DepotStockistModel;
if (viewDepotStockist != null)
{
dgvdr.ItemsSource = loadOrdersHistory(viewDepotStockist.ID);
lblCientNameDisplay.Content = "D.R. records for " + viewDepotStockist.Fullname;
disableEnableControls(false);
btnDRDetails.IsEnabled = true;
btnAddDR.IsEnabled = true;
btnEditDR.IsEnabled = true;
btnDeleteDR.IsEnabled = true;
}
}
private async void btnDelete_Click(object sender, RoutedEventArgs e)
{
DepotStockistModel dept = dgvclientmega.SelectedItem as DepotStockistModel;
if (dept != 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: " + dept.Fullname, MessageDialogStyle.AffirmativeAndNegative);
if (result == MessageDialogResult.Affirmative)
{
deleteDepotStockist(dept.ID);
dgvclientmega.ItemsSource = loadClientDepotStockist();
dgvclientmega.Items.Refresh();
}
}
}
public OrderWindow(DepotStockistModel dsm, OrderHistoryModel ohm)
{
orderHistory = ohm;
depotStockistMod = dsm;
InitializeComponent();
}
public OrderWindow(DepotStockistModel dsm)
{
depotStockistMod = dsm;
InitializeComponent();
}
public AddClientWindow(SPMSUN_DepotStockist ds, DepotStockistModel dsm)
{
spmsun_depot = ds;
depotStockist = dsm;
InitializeComponent();
}