private void btnDelete_Click(object sender, RoutedEventArgs e)
{
System.Windows.Forms.DialogResult dialogResult = System.Windows.Forms.MessageBox.Show("Are you sure you want to Delete record?", "Delete Record", System.Windows.Forms.MessageBoxButtons.YesNo);
if (dialogResult == System.Windows.Forms.DialogResult.Yes)
{
CommissionView cm = dgvCommission.SelectedItem as CommissionView;
if (cm != null)
{
int id = Convert.ToInt32(cm.ID);
if (id != 0)
{
deleteClientRecord(id);
getDatagridDetails();
System.Windows.MessageBox.Show("Record deleted successfuly!");
}
}
else
{
System.Windows.MessageBox.Show("No record selected!");
}
}
}
public void getDatagridDetails()
{
List <CommissionView> lstCommissions = new List <CommissionView>();
CommissionView commissionView = new CommissionView();
try
{
queryString = "SELECT dbspa.tblcommissions.ID, dbspa.tblservicetype.description as 'SERVICE TYPE', " +
"dbspa.tblcommissions.commission as 'COMMISSION' FROM (dbspa.tblcommissions INNER JOIN dbspa.tblservicetype ON " +
"dbspa.tblcommissions.serviceTypeID = dbspa.tblservicetype.ID) WHERE (dbspa.tblcommissions.isDeleted = 0)";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
commissionView.ID = reader["ID"].ToString();
commissionView.ServiceType = reader["SERVICE TYPE"].ToString();
commissionView.Commission = reader["COMMISSION"].ToString();
lstCommissions.Add(commissionView);
commissionView = new CommissionView();
}
conDB.closeConnection();
dgvCommission.ItemsSource = lstCommissions;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnEdit_Click(object sender, RoutedEventArgs e)
{
CommissionView comView = dgvCommission.SelectedItem as CommissionView;
if (comView != null)
{
int id = Convert.ToInt32(comView.ID);
if (id != 0)
{
CommissionModel com = getCommissionModel(id);
com.ServiceTypeModel = getServiceTypeModel(Convert.ToInt32(com.ServiceTypeID));
com.IfEditDetails = true;
CommissionDetails cd = new CommissionDetails(this, com);
cd.ShowDialog();
}
}
else
{
MessageBox.Show("No record selected!");
}
}
