private void LoadGrid(bool SelectRow)
{
using (new WaitCursor())
{
try
{
DataTable dt = Dispensation_TypeData.SelectAll();
Grid.ItemsSource = dt.DefaultView;
Grid.CanUserAddRows = false;
Grid.CanUserDeleteRows = false;
Grid.IsReadOnly = true;
if (Grid.Items.Count > 0 & SelectRow == true)
{
Grid.SelectedItem = Grid.Items[0];
Grid.ScrollIntoView(Grid.SelectedItem);
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
finally
{
}
}
}
private void butSearch_Click(object sender, RoutedEventArgs e)
{
using (new WaitCursor())
{
try
{
DataTable dt = Dispensation_TypeData.Search(cmbFields.Text, cmbCondition.Text, txtSearch.Text);
Grid.ItemsSource = dt.DefaultView;
Grid.CanUserAddRows = false;
Grid.CanUserDeleteRows = false;
Grid.IsReadOnly = true;
if (Grid.Items.Count > 0)
{
Grid.SelectedItem = Grid.Items[0];
Grid.ScrollIntoView(Grid.SelectedItem);
}
}
catch
{
MessageBox.Show("An error occurred in butSearch_Click...", "Error");
}
finally
{
}
}
}
private void UpdateRecord()
{
using (new WaitCursor())
{
Dispensation_Type oclsDispensation_Type = new Dispensation_Type();
Dispensation_Type clsDispensation_Type = new Dispensation_Type();
oclsDispensation_Type.Dispensation_Type_ID = System.Convert.ToInt16((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text);
oclsDispensation_Type = Dispensation_TypeData.Select_Record(oclsDispensation_Type);
if (VerifyData() == true)
{
SetData(clsDispensation_Type);
Boolean bSucess = new Boolean();
bSucess = Dispensation_TypeData.Update(oclsDispensation_Type, clsDispensation_Type);
if (bSucess == true)
{
GoBack_To_Grid();
}
else
{
MessageBox.Show("Update failed.", "Error");
}
}
}
}
private void InsertRecord()
{
using (new WaitCursor())
{
Dispensation_Type clsDispensation_Type = new Dispensation_Type();
if (VerifyData() == true)
{
SetData(clsDispensation_Type);
Boolean bSucess = new Boolean();
bSucess = Dispensation_TypeData.Add(clsDispensation_Type);
if (bSucess == true)
{
GoBack_To_Grid();
}
else
{
MessageBox.Show("Insert failed.", "Error");
}
}
}
}
private void DeleteRecord()
{
using (new WaitCursor())
{
Dispensation_Type clsDispensation_Type = new Dispensation_Type();
clsDispensation_Type.Dispensation_Type_ID = System.Convert.ToInt16((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text);
if (MessageBox.Show("Are you sure? Delete this record?", "Delete", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
SetData(clsDispensation_Type);
Boolean bSucess = new Boolean();
bSucess = Dispensation_TypeData.Delete(clsDispensation_Type);
if (bSucess == true)
{
GoBack_To_Grid();
}
else
{
MessageBox.Show("Delete failed.", "Error");
}
}
}
}
private void GetData()
{
using (new WaitCursor())
{
ClearRecord();
Dispensation_Type clsDispensation_Type = new Dispensation_Type();
clsDispensation_Type.Dispensation_Type_ID = System.Convert.ToInt16((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text);
clsDispensation_Type = Dispensation_TypeData.Select_Record(clsDispensation_Type);
if ((clsDispensation_Type != null))
{
try
{
nudDispensation_Type_ID.Text = System.Convert.ToInt16(clsDispensation_Type.Dispensation_Type_ID).ToString();
tbDispensation_Type_Name.Text = Convert.ToString(clsDispensation_Type.Dispensation_Type_Name);
}
catch
{
}
}
}
}
