private void RefreshDataGridView(FrmMaster _frmMaster, EGOEntities _egoEntities)
{
Cursor.Current = Cursors.WaitCursor;
_frmMaster.dataGridView.Columns.Clear();
switch (typeof(T).Name)
{
case "FAMILY":
string lastNameFamily = _frmMaster.textBox1.Text;
FamilySearchView familySearchView = new FamilySearchView(_egoEntities.FAMILY.Where(x => x.LASTNAME.Contains(lastNameFamily)).ToList().OrderBy(x => x.LASTNAME).ToList());
_frmMaster.dataGridView.DataSource = familySearchView.FamilySearchViews;
_frmMaster.dataGridView.Columns["FAMILYID"].Visible = false;
AddColumnEditDeleteToDataGridView(_frmMaster, false);
DataGridViewControl.SetHeaderName(_frmMaster.dataGridView);
SetAutoCompletion(_frmMaster.textBox1, familySearchView.FamilySearchViews.Select(x => x.LASTNAME).ToList());
_frmMaster.label3.Text = "Famille(" + familySearchView.FamilySearchViews.Count + ")";
break;
case "PERSON":
string lastNamePerson = _frmMaster.textBox1.Text;
PersonMasterSearchView personSearchView = new PersonMasterSearchView(_egoEntities.PERSON.Where(x => x.LASTNAME.Contains(lastNamePerson)).ToList().OrderBy(x => x.LASTNAME).ToList());
_frmMaster.dataGridView.DataSource = personSearchView.PersonSearchViews;
_frmMaster.dataGridView.Columns["PERSONID"].Visible = false;
AddColumnEditDeleteToDataGridView(_frmMaster, false);
DataGridViewControl.SetHeaderName(_frmMaster.dataGridView);
SetAutoCompletion(_frmMaster.textBox1, personSearchView.PersonSearchViews.Select(x => x.LASTNAME).ToList());
_frmMaster.label3.Text = "Adhérent(" + personSearchView.PersonSearchViews.Count + ")";
break;
case "GYMGROUP":
string gymGroupName = _frmMaster.textBox1.Text;
GymGroupSearchView gymGroupSearchView = new GymGroupSearchView(_egoEntities.GYMGROUP.Where(x => x.GYMGROUPNAME.Contains(gymGroupName) && x.GYMGROUPYEAR == _frmMaster.numericUpDown1.Value).ToList());
_frmMaster.dataGridView.DataSource = gymGroupSearchView.GymGroupSearchViews;
_frmMaster.dataGridView.Columns["GYMGROUPID"].Visible = false;
AddColumnEditDeleteToDataGridView(_frmMaster, false);
DataGridViewControl.SetHeaderName(_frmMaster.dataGridView);
SetAutoCompletion(_frmMaster.textBox1, gymGroupSearchView.GymGroupSearchViews.Select(x => x.GYMGROUPNAME).ToList());
_frmMaster.label3.Text = "Groupe - " + _frmMaster.numericUpDown1.Value + "(" + gymGroupSearchView.GymGroupSearchViews.Count + ")";
break;
}
Cursor.Current = Cursors.Default;
}
private void RefreshDataGridView(FrmSlave _frmSlave, int _currentStartYear)
{
_frmSlave.dataGridView.Columns.Clear();
string masterObjectTypeName = GetObjectTypeName(masterObj);
if (typeof(T).Name == "PERSON")
{
if (masterObjectTypeName == "FAMILY")
{
int _familyId = Convert.ToInt32(Reflection.GetValue(masterObj, "FAMILYID"));
PersonSlaveSearchView _personSlaveSearchView = new PersonSlaveSearchView(egoEntities.PERSON.Where(x => x.FAMILYID == _familyId).ToList(), _currentStartYear);
_frmSlave.dataGridView.DataSource = _personSlaveSearchView.PersonSlaveSearchViews;
_frmSlave.dataGridView.Columns["PERSONID"].Visible = false;
AddColumnEditDeleteToDataGridView(_frmSlave, false);
DataGridViewControl.SetHeaderName(_frmSlave.dataGridView);
frmSlave.label1.Text = Translation.GetByKey(typeof(T).Name) + "(" + _personSlaveSearchView.PersonSlaveSearchViews.Count + ")";
}
if (masterObjectTypeName == "GYMGROUP")
{
int _gymGroupId = Convert.ToInt32(Reflection.GetValue(masterObj, masterObjectTypeName + "ID"));
if (_gymGroupId == 0)
{
return;
}
GymGroupPersonSearchView _gymGroupPersonSearchView = new GymGroupPersonSearchView(egoEntities.PERSON_GYMGROUP.Where(x => x.GYMGROUPID == _gymGroupId).ToList());
_frmSlave.dataGridView.DataSource = _gymGroupPersonSearchView.GymGroupPersonSearchViews;
_frmSlave.dataGridView.Columns["PERSON_GYMGROUP_ID"].Visible = false;
AddColumnEditDeleteToDataGridView(_frmSlave, true);
DataGridViewControl.SetHeaderName(_frmSlave.dataGridView);
frmSlave.label1.Text = Translation.GetByKey(typeof(T).Name) + "(" + _gymGroupPersonSearchView.GymGroupPersonSearchViews.Count + ")";
}
}
else if (typeof(T).Name == "PHONE")
{
if (masterObjectTypeName == "FAMILY")
{
int _familyId = Convert.ToInt32(Reflection.GetValue(masterObj, "FAMILYID"));
PhoneSearchView _phoneSearchView = new PhoneSearchView(egoEntities.PHONE.Where(x => x.FAMILYID == _familyId).ToList());
_frmSlave.dataGridView.DataSource = _phoneSearchView.PhoneSearchViews;
_frmSlave.dataGridView.Columns["PHONEID"].Visible = false;
AddColumnEditDeleteToDataGridView(_frmSlave, false);
DataGridViewControl.SetHeaderName(_frmSlave.dataGridView);
frmSlave.label1.Text = Translation.GetByKey(typeof(T).Name) + "(" + _phoneSearchView.PhoneSearchViews.Count + ")";
}
}
else if (typeof(T).Name == "DISCOUNT")
{
if (masterObjectTypeName == "FAMILY")
{
int _familyId = Convert.ToInt32(Reflection.GetValue(masterObj, "FAMILYID"));
DiscountSearchView _discountSearchView = new DiscountSearchView(egoEntities.DISCOUNT.Where(x => x.FAMILYID == _familyId).ToList());
_frmSlave.dataGridView.DataSource = _discountSearchView.DiscountSearchViews;
_frmSlave.dataGridView.Columns["DISCOUNTID"].Visible = false;
AddColumnEditDeleteToDataGridView(_frmSlave, false);
DataGridViewControl.SetHeaderName(_frmSlave.dataGridView);
frmSlave.label1.Text = Translation.GetByKey(typeof(T).Name) + "(" + _discountSearchView.DiscountSearchViews.Count + ")";
}
}
else if (typeof(T).Name == "PAYMENT")
{
if (masterObjectTypeName == "FAMILY")
{
int _familyId = Convert.ToInt32(Reflection.GetValue(masterObj, "FAMILYID"));
PaymentSearchView _paymentSearchView = new PaymentSearchView(egoEntities.PAYMENT.Where(x => x.FAMILYID == _familyId).ToList());
_frmSlave.dataGridView.DataSource = _paymentSearchView.PaymentSearchViews;
_frmSlave.dataGridView.Columns["PAYMENTID"].Visible = false;
AddColumnEditDeleteToDataGridView(_frmSlave, false);
DataGridViewControl.SetHeaderName(_frmSlave.dataGridView);
frmSlave.label1.Text = Translation.GetByKey(typeof(T).Name) + "(" + _paymentSearchView.PaymentSearchViews.Count + ")";
}
}
else if (typeof(T).Name == "DOCUMENT")
{
if (masterObjectTypeName == "PERSON")
{
int _personId = Convert.ToInt32(Reflection.GetValue(masterObj, "PERSONID"));
DocumentSearchView _documentSearchView = new DocumentSearchView(egoEntities.DOCUMENT.Where(x => x.PERSONID == _personId).ToList());
_frmSlave.dataGridView.DataSource = _documentSearchView.DocumentSearchViews;
_frmSlave.dataGridView.Columns["DOCUMENTID"].Visible = false;
AddColumnEditDeleteToDataGridView(_frmSlave, false);
DataGridViewControl.SetHeaderName(_frmSlave.dataGridView);
frmSlave.label1.Text = Translation.GetByKey(typeof(T).Name) + "(" + _documentSearchView.DocumentSearchViews.Count + ")";
}
}
else if (typeof(T).Name == "GYMGROUP")
{
if (masterObjectTypeName == "PERSON")
{
int _personId = Convert.ToInt32(Reflection.GetValue(masterObj, "PERSONID"));
PersonGymGroupSearchView _personGymGroupSearchView = new PersonGymGroupSearchView(egoEntities.PERSON_GYMGROUP.Where(x => x.PERSONID == _personId).ToList());
_frmSlave.dataGridView.DataSource = _personGymGroupSearchView.PersonGymGroupSearchViews;
_frmSlave.dataGridView.Columns["PERSON_GYMGROUP_ID"].Visible = false;
AddColumnEditDeleteToDataGridView(_frmSlave, true);
DataGridViewControl.SetHeaderName(_frmSlave.dataGridView);
frmSlave.label1.Text = Translation.GetByKey(typeof(T).Name) + "(" + _personGymGroupSearchView.PersonGymGroupSearchViews.Count + ")";
}
}
}