public void LoadPayeeRepresentative()
{
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
gd.Clear();
db = new ImusCityHallEntities();
var representative = db.PayeeRepresentativeViews.Where(m => m.PayeeID == null).OrderBy(m => m.PayeeRepresentativeName).ToList();
foreach (var dr in representative)
{
PayeeRepresentativeClass i = new PayeeRepresentativeClass()
{
Name = dr.PayeeRepresentativeName.ToString(),
Id = dr.PayeeRepID
};
gd.Add(i);
}
represetativelb.ItemsSource = gd;
represetativelb.SelectedValuePath = "Id";
represetativelb.Items.Refresh();
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void MetroWindow_Loaded(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
ImusCityGovernmentSystem.Model.Payee payee = db.Payees.Find(PayeeID);
payeenotb.Text = payee.PayeeNo;
companynametb.Text = payee.CompanyName;
companyaddresstb.Text = payee.CompanyAddress;
tinnotb.Text = payee.TIN;
contactnotb.Text = payee.LandlineNo;
gd.Clear();
db = new ImusCityHallEntities();
if (db.PayeeRepresentatives.Where(m => m.PayeeID == PayeeID).Count() == 0)
{
var representative = db.PayeeRepresentativeViews.OrderBy(m => m.PayeeRepresentativeName).ToList();
foreach (var dr in representative)
{
PayeeRepresentativeClass i = new PayeeRepresentativeClass()
{
Name = dr.PayeeRepresentativeName.ToString(),
Id = dr.PayeeRepID
};
gd.Add(i);
}
}
else
{
var representative = db.PayeeRepresentativeViews.OrderBy(m => m.PayeeRepresentativeName).ToList();
foreach (var dr in representative)
{
PayeeRepresentativeClass i = new PayeeRepresentativeClass()
{
Name = dr.PayeeRepresentativeName.ToString(),
Id = dr.PayeeRepID,
IsSelected = dr.PayeeID == null || dr.PayeeID != PayeeID ? false : true
};
gd.Add(i);
}
}
represetativelb.ItemsSource = gd;
represetativelb.Items.Refresh();
}
else
{
Mouse.OverrideCursor = null;
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
