public FrmBind(object _masterObj, Type _type, EGOEntities _egoEntities)
{
InitializeComponent();
type = _type;
masterObj = _masterObj;
egoEntities = _egoEntities;
CreateStructure(_masterObj, _type, _egoEntities);
}
public FrmAddEdit(EGOEntities _egoEntities, Type _type, object _objSlave = null, object _objMaster = null)
{
InitializeComponent();
type = _type;
objSlave = _objSlave;
objMaster = _objMaster;
egoEntities = _egoEntities;
CreateEditForm(objSlave, objMaster);
}
private List <ReportDocument> GetReportDocuments()
{
List <ReportDocument> ReportDocuments = new List <ReportDocument>();
EGOEntities egoEntities = new EGOEntities();
List <PERSON> persons = egoEntities.PERSON.ToList();
List <DOCUMENTTYPE> documentTypes = egoEntities.DOCUMENTTYPE.ToList();
List <GYMGROUP> gymGroups = egoEntities.GYMGROUP.ToList();
int GYMGROUPYEAR = Common.Common.CurrentStartYear();
foreach (var person in persons)
{
if (!person.DOCUMENT.Any(x => x.DOCUMENTTYPEID == 1))
{
ReportDocument ReportDocument = new ReportDocument();
ReportDocument.DOCUMENTNAME = documentTypes.First(x => x.DOCUMENTTYPEID == 1).DOCUMENTNAME;
ReportDocument.GYMGROUPNAME = person.PERSON_GYMGROUP.Select(x => x.GYMGROUP).First(x => x.GYMGROUPYEAR == GYMGROUPYEAR).GYMGROUPNAME;
ReportDocument.PERSONFIRSTNAME = person.FIRSTNAME;
ReportDocument.PERSONLASTNAME = person.LASTNAME;
ReportDocuments.Add(ReportDocument);
}
if (!person.DOCUMENT.Any(x => x.DOCUMENTTYPEID == 2))
{
ReportDocument ReportDocument = new ReportDocument();
ReportDocument.DOCUMENTNAME = documentTypes.First(x => x.DOCUMENTTYPEID == 2).DOCUMENTNAME;
ReportDocument.GYMGROUPNAME = person.PERSON_GYMGROUP.Select(x => x.GYMGROUP).First(x => x.GYMGROUPYEAR == GYMGROUPYEAR).GYMGROUPNAME;
ReportDocument.PERSONFIRSTNAME = person.FIRSTNAME;
ReportDocument.PERSONLASTNAME = person.LASTNAME;
ReportDocuments.Add(ReportDocument);
}
if (!person.DOCUMENT.Any(x => x.DOCUMENTTYPEID == 3))
{
ReportDocument ReportDocument = new ReportDocument();
ReportDocument.DOCUMENTNAME = documentTypes.First(x => x.DOCUMENTTYPEID == 3).DOCUMENTNAME;
ReportDocument.GYMGROUPNAME = person.PERSON_GYMGROUP.Select(x => x.GYMGROUP).First(x => x.GYMGROUPYEAR == GYMGROUPYEAR).GYMGROUPNAME;
ReportDocument.PERSONFIRSTNAME = person.FIRSTNAME;
ReportDocument.PERSONLASTNAME = person.LASTNAME;
ReportDocuments.Add(ReportDocument);
}
if (!person.DOCUMENT.Any(x => x.DOCUMENTTYPEID == 4))
{
ReportDocument ReportDocument = new ReportDocument();
ReportDocument.DOCUMENTNAME = documentTypes.First(x => x.DOCUMENTTYPEID == 4).DOCUMENTNAME;
ReportDocument.GYMGROUPNAME = person.PERSON_GYMGROUP.Select(x => x.GYMGROUP).First(x => x.GYMGROUPYEAR == GYMGROUPYEAR).GYMGROUPNAME;
ReportDocument.PERSONFIRSTNAME = person.FIRSTNAME;
ReportDocument.PERSONLASTNAME = person.LASTNAME;
ReportDocuments.Add(ReportDocument);
}
}
return(ReportDocuments);
}
private static GYMGROUP CreateGymGroup(ExcelModel _ExcelModel, EGOEntities _EGOEntities)
{
GYMGROUP GymGroup = new GYMGROUP();
GymGroup.GYMGROUPNAME = _ExcelModel.GROUPE;
GymGroup.NUMBEROFHOURS = 0;
GymGroup.GYMGROUPYEAR = Common.CurrentStartYear();
GymGroup.YEARPRICE = _ExcelModel.RGLTDUTT;
_EGOEntities.GYMGROUP.Add(GymGroup);
return(GymGroup);
}
public static void ImportExcel(FrmSetting _FrmSetting, string fileName)
{
EGOEntities EGOEntities = new EGOEntities();
_FrmSetting.label1.Text = "Suppression des tables";
Database.Drop();
_FrmSetting.label1.Text = "Création des tables";
Database.Create();
List <ExcelModel> ExcelModels = CreateExcelObject(_FrmSetting, fileName);
_FrmSetting.label1.Text = "Insertion des données";
CreatePerson(ExcelModels, EGOEntities, _FrmSetting);
}
static public string GetByKey(string key)
{
EGOEntities egoEntities = new EGOEntities();
if (egoEntities.TRANSLATION.Any(x => x.TRANSLATIONKEY == key))
{
return(egoEntities.TRANSLATION.First(x => x.TRANSLATIONKEY == key).WORDS);
}
else
{
return(key);
}
}
private static FAMILY CreateFamily(ExcelModel _ExcelModel, EGOEntities _EGOEntities)
{
FAMILY Family = new FAMILY();
Family.LASTNAME = _ExcelModel.NOM.ToUpper();
Family.ADDRESS = _ExcelModel.ADRESSE;
Family.ZIPCODE = _ExcelModel.CP;
Family.CITY = _ExcelModel.VILLE;
Family.EMAIL = _ExcelModel.EMAIL;
_EGOEntities.FAMILY.Add(Family);
return(Family);
}
public SlaveObject(FrmMain _frmMain, string _masterTypeName, int _currentStartYear)
{
egoEntities = new EGOEntities();
currentStartYear = _currentStartYear;
frmSlave = new FrmSlave()
{
Dock = DockStyle.Fill, TopLevel = false, TopMost = true, FormBorderStyle = FormBorderStyle.None
};
CreateBinding();
SetEvent(frmSlave, _masterTypeName);
GetFreePanel(_frmMain).Controls.Add(frmSlave);
frmSlave.label1.Text = Translation.GetByKey(typeof(T).Name);
frmSlave.Show();
}
private static void CreateFamilyDiscount(EGOEntities _EGOEntities)
{
List <FAMILY> Familys = _EGOEntities.FAMILY.ToList();
foreach (var Family in Familys)
{
if (Family.PERSON.Count > 1)
{
DISCOUNT Discount = new DISCOUNT();
Discount.FAMILYID = Family.FAMILYID;
Discount.DISCOUNTYEAR = Common.CurrentStartYear();
Discount.DESCRIPTION = "Réduction familiale";
Discount.AMOUNT = 10;
_EGOEntities.DISCOUNT.Add(Discount);
}
}
}
private List <ReportDateOfPayment> GetReportDateOfPayments()
{
List <ReportDateOfPayment> reportDateOfPayments = new List <ReportDateOfPayment>();
EGOEntities egoEntities = new EGOEntities();
List <PAYMENT> payments = egoEntities.PAYMENT.Where(x => x.PAYMENTTYPEID == 2).OrderBy(x => x.PAYMENTDATE).ThenBy(x => x.CHECKNUMBER).ThenBy(x => x.AMOUNT).ToList();
foreach (var payment in payments)
{
ReportDateOfPayment reportDateOfPayment = new ReportDateOfPayment();
reportDateOfPayment.AMOUNT = payment.AMOUNT;
reportDateOfPayment.CHECKNUMBER = payment.CHECKNUMBER;
reportDateOfPayment.GYMYEAR = payment.GYMYEAR;
reportDateOfPayment.LASTNAME = payment.FAMILY.LASTNAME;
reportDateOfPayment.PAYMENTDATE = payment.PAYMENTDATE;
reportDateOfPayments.Add(reportDateOfPayment);
}
return(reportDateOfPayments);
}
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;
}
public MasterObject(FrmMain _frmMain)
{
Cursor.Current = Cursors.WaitCursor;
egoEntities = new EGOEntities();
FrmMaster _frmMaster = new FrmMaster()
{
Dock = DockStyle.Fill, TopLevel = false, TopMost = true, FormBorderStyle = FormBorderStyle.None
};
SetConrols(_frmMaster);
SetEvent(_frmMaster);
_frmMain.panel1.Controls.Add(_frmMaster);
RefreshDataGridView(_frmMaster, egoEntities);
SetChild(_frmMain, _frmMaster);
PositionPanel(_frmMain);
SimulateClickOneFirstDataGridViewRow(_frmMaster);
_frmMaster.Show();
Cursor.Current = Cursors.Default;
}
private List <ReportPayment> GetReportPayments()
{
List <ReportPayment> reportPayments = new List <ReportPayment>();
EGOEntities egoEntities = new EGOEntities();
List <FAMILY> familys = egoEntities.FAMILY.ToList().OrderBy(x => x.LASTNAME).ToList();
int year = Common.Common.CurrentStartYear();
float contribution = 0;
if (egoEntities.CONTRIBUTION.Any(x => x.GYMYEAR == year))
{
contribution = egoEntities.CONTRIBUTION.First(x => x.GYMYEAR == year).AMOUNT;
}
foreach (var family in familys)
{
ReportPayment reportPayment = new ReportPayment();
int numberOfSubscriber = family.PERSON.SelectMany(x => x.PERSON_GYMGROUP).Select(x => x.GYMGROUP).Where(x => x.GYMGROUPYEAR == year).ToList().Count;
float PAID = family.PAYMENT.Where(x => x.GYMYEAR == year).Sum(x => x.AMOUNT);
float RECEIVABLE = (family.PERSON.SelectMany(x => x.PERSON_GYMGROUP).Select(x => x.GYMGROUP).Where(x => x.GYMGROUPYEAR == year).Sum(x => x.YEARPRICE) + (contribution * numberOfSubscriber));
float DISCOUNT = family.DISCOUNT.Sum(x => x.AMOUNT);
float REMAININGBALANCE = RECEIVABLE - PAID - DISCOUNT;
if (REMAININGBALANCE != 0)
{
reportPayment.LASTNAME = family.LASTNAME;
reportPayment.ZIPCODE = family.ZIPCODE;
reportPayment.ADDRESS = family.ADDRESS;
reportPayment.RECEIVABLE = RECEIVABLE;
reportPayment.PAID = PAID;
reportPayment.REMAININGBALANCE = REMAININGBALANCE;
reportPayments.Add(reportPayment);
}
}
return(reportPayments);
}
private static void CreatePerson(List <ExcelModel> _ExcelModel, EGOEntities _EGOEntities, FrmSetting _FrmSetting)
{
_FrmSetting.progressBar.Value = 0;
_FrmSetting.progressBar.Maximum = _ExcelModel.Count;
int i = 0;
try
{
foreach (var ExcelModel in _ExcelModel)
{
i++;
_FrmSetting.label1.Text = "Création de l'adhérent:" + ExcelModel.NOM + " " + ExcelModel.PRENOM + i + "/" + _ExcelModel.Count;
_FrmSetting.label1.Refresh();
_FrmSetting.progressBar.Value = i;
_FrmSetting.progressBar.Refresh();
FAMILY Family;
if (!_EGOEntities.FAMILY.Any(x => x.LASTNAME == ExcelModel.NOM && x.ZIPCODE == ExcelModel.CP))
{
Family = CreateFamily(ExcelModel, _EGOEntities);
}
else
{
Family = _EGOEntities.FAMILY.First(x => x.LASTNAME == ExcelModel.NOM && x.ZIPCODE == ExcelModel.CP);
}
PERSON Person = new PERSON();
Person.FAMILYID = Family.FAMILYID;
Person.LASTNAME = ExcelModel.NOM.ToUpper();
Person.FIRSTNAME = ExcelModel.PRENOM.ToUpper();
Person.BIRTHDATE = ExcelModel.NEELE;
Person.HOURLYRATE = 0;
_EGOEntities.PERSON.Add(Person);
GYMGROUP GymGroup;
if (!_EGOEntities.GYMGROUP.Any(x => x.GYMGROUPNAME == ExcelModel.GROUPE))
{
GymGroup = CreateGymGroup(ExcelModel, _EGOEntities);
}
else
{
GymGroup = _EGOEntities.GYMGROUP.First(x => x.GYMGROUPNAME == ExcelModel.GROUPE);
}
PERSON_GYMGROUP Person_GymGroup = new PERSON_GYMGROUP();
Person_GymGroup.GYMGROUPID = GymGroup.GYMGROUPID;
Person_GymGroup.PERSONID = Person.PERSONID;
Person_GymGroup.KINDID = 1;
_EGOEntities.PERSON_GYMGROUP.Add(Person_GymGroup);
if (!_EGOEntities.PHONE.Any(x => x.FAMILYID == Family.FAMILYID && x.PHONENUMBER == ExcelModel.TELEPHONE))
{
PHONE Phone = new PHONE();
Phone.FAMILYID = Family.FAMILYID;
Phone.PHONENUMBER = ExcelModel.TELEPHONE;
_EGOEntities.PHONE.Add(Phone);
}
if (!_EGOEntities.PHONE.Any(x => x.FAMILYID == Family.FAMILYID && x.PHONENUMBER == ExcelModel.PORTABLE))
{
PHONE Phone = new PHONE();
Phone.FAMILYID = Family.FAMILYID;
Phone.PHONENUMBER = ExcelModel.PORTABLE;
_EGOEntities.PHONE.Add(Phone);
}
DOCUMENT Document;
if (ExcelModel.FICHE)
{
Document = new DOCUMENT();
Document.DOCUMENTTYPEID = 1;
Document.PERSONID = Person.PERSONID;
Document.DOCUMENTYEAR = Common.CurrentStartYear();
_EGOEntities.DOCUMENT.Add(Document);
}
if (ExcelModel.AUTPAR)
{
Document = new DOCUMENT();
Document.DOCUMENTTYPEID = 2;
Document.PERSONID = Person.PERSONID;
Document.DOCUMENTYEAR = Common.CurrentStartYear();
_EGOEntities.DOCUMENT.Add(Document);
}
if (ExcelModel.PHOTO)
{
Document = new DOCUMENT();
Document.DOCUMENTTYPEID = 3;
Document.PERSONID = Person.PERSONID;
Document.DOCUMENTYEAR = Common.CurrentStartYear();
_EGOEntities.DOCUMENT.Add(Document);
}
if (ExcelModel.CM)
{
Document = new DOCUMENT();
Document.DOCUMENTTYPEID = 4;
Document.PERSONID = Person.PERSONID;
Document.DOCUMENTYEAR = Common.CurrentStartYear();
_EGOEntities.DOCUMENT.Add(Document);
}
PAYMENT Payment;
if (ExcelModel.ECH1MONTANT != 0)
{
Payment = new PAYMENT();
if (ExcelModel.ECH1NUMCHEQUE != 0)
{
Payment.PAYMENTTYPEID = 2;
}
else
{
Payment.PAYMENTTYPEID = 1;
}
Payment.FAMILYID = Family.FAMILYID;
Payment.GYMYEAR = Common.CurrentStartYear();
Payment.PAYMENTDATE = DateTime.ParseExact("30/09/2020", "dd/MM/yyyy", CultureInfo.InvariantCulture);
Payment.CHECKNUMBER = ExcelModel.ECH1NUMCHEQUE;
Payment.AMOUNT = ExcelModel.ECH1MONTANT;
_EGOEntities.PAYMENT.Add(Payment);
}
if (ExcelModel.ECH2MONTANT != 0)
{
Payment = new PAYMENT();
if (ExcelModel.ECH2NUMCHEQUE != 0)
{
Payment.PAYMENTTYPEID = 2;
}
else
{
Payment.PAYMENTTYPEID = 1;
}
Payment.FAMILYID = Family.FAMILYID;
Payment.GYMYEAR = Common.CurrentStartYear();
Payment.PAYMENTDATE = DateTime.ParseExact("30/11/2020", "dd/MM/yyyy", CultureInfo.InvariantCulture);
Payment.CHECKNUMBER = ExcelModel.ECH2NUMCHEQUE;
Payment.AMOUNT = ExcelModel.ECH2MONTANT;
_EGOEntities.PAYMENT.Add(Payment);
}
if (ExcelModel.ECH3MONTANT != 0)
{
Payment = new PAYMENT();
if (ExcelModel.ECH3NUMCHEQUE != 0)
{
Payment.PAYMENTTYPEID = 2;
}
else
{
Payment.PAYMENTTYPEID = 1;
}
Payment.FAMILYID = Family.FAMILYID;
Payment.GYMYEAR = Common.CurrentStartYear();
Payment.PAYMENTDATE = DateTime.ParseExact("28/02/2021", "dd/MM/yyyy", CultureInfo.InvariantCulture);
Payment.CHECKNUMBER = ExcelModel.ECH3NUMCHEQUE;
Payment.AMOUNT = ExcelModel.ECH3MONTANT;
_EGOEntities.PAYMENT.Add(Payment);
}
if (ExcelModel.ECH4MONTANT != 0)
{
Payment = new PAYMENT();
if (ExcelModel.ECH4NUMCHEQUE != 0)
{
Payment.PAYMENTTYPEID = 2;
}
else
{
Payment.PAYMENTTYPEID = 1;
}
Payment.FAMILYID = Family.FAMILYID;
Payment.GYMYEAR = Common.CurrentStartYear();
Payment.PAYMENTDATE = DateTime.ParseExact("30/04/2021", "dd/MM/yyyy", CultureInfo.InvariantCulture);
Payment.CHECKNUMBER = ExcelModel.ECH4NUMCHEQUE;
Payment.AMOUNT = ExcelModel.ECH4MONTANT;
_EGOEntities.PAYMENT.Add(Payment);
}
if (ExcelModel.COTISLICENCE != 0)
{
Payment = new PAYMENT();
Payment.PAYMENTTYPEID = 2;
Payment.FAMILYID = Family.FAMILYID;
Payment.GYMYEAR = Common.CurrentStartYear();
Payment.PAYMENTDATE = DateTime.ParseExact("28/09/2020", "dd/MM/yyyy", CultureInfo.InvariantCulture);
Payment.CHECKNUMBER = ExcelModel.ECH4NUMCHEQUE;
Payment.AMOUNT = ExcelModel.COTISLICENCE;
_EGOEntities.PAYMENT.Add(Payment);
}
if (!ExcelModel.Nouvelle)
{
DISCOUNT Discount = new DISCOUNT();
Discount.FAMILYID = Family.FAMILYID;
Discount.DISCOUNTYEAR = Common.CurrentStartYear();
Discount.DESCRIPTION = "Cotisation";
Discount.AMOUNT = 35;
_EGOEntities.DISCOUNT.Add(Discount);
Discount = new DISCOUNT();
Discount.FAMILYID = Family.FAMILYID;
Discount.DISCOUNTYEAR = Common.CurrentStartYear();
Discount.DESCRIPTION = "Ancienneté";
Discount.AMOUNT = ExcelModel.REDUCANCIEN;
_EGOEntities.DISCOUNT.Add(Discount);
}
_EGOEntities.SaveChanges();
}
_FrmSetting.label1.Text = "Création des réductions familiales";
CreateFamilyDiscount(_EGOEntities);
_EGOEntities.SaveChanges();
_FrmSetting.label1.Text = "Fin";
_FrmSetting.progressBar.Value = 0;
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
private void CreateStructure(object _masterObj, Type _type, EGOEntities _egoEntities)
{
var dataGridViewButtonColumn = new DataGridViewButtonColumn();
List <KIND> Kinds;
switch (_type.Name)
{
case "GYMGROUP":
textBoxParent.Text = Reflection.GetValue(_masterObj, "LASTNAME").ToString() + " " + Reflection.GetValue(_masterObj, "FIRSTNAME").ToString();
GymGroupSearchView _gymGroupSearchView = new GymGroupSearchView(_egoEntities.GYMGROUP.ToList());
dataGridView.DataSource = _gymGroupSearchView.GymGroupSearchViews;
dataGridView.Columns["GYMGROUPID"].Visible = false;
dataGridViewButtonColumn.Name = "Select";
dataGridViewButtonColumn.HeaderText = "Choix";
dataGridViewButtonColumn.Text = "Choisir";
dataGridViewButtonColumn.UseColumnTextForButtonValue = true;
dataGridView.Columns.Add(dataGridViewButtonColumn);
Kinds = _egoEntities.KIND.ToList();
foreach (var kind in Kinds)
{
ComboboxItem item = new ComboboxItem();
item.Text = kind.KINDNAME;
item.Value = kind.KINDID;
comboBoxKind.Items.Add(item);
}
comboBoxKind.Visible = true;
break;
case "PERSON":
textBoxParent.Text = Reflection.GetValue(_masterObj, "GYMGROUPYEAR").ToString() + " " + Reflection.GetValue(_masterObj, "GYMGROUPNAME").ToString();
PersonMasterSearchView _personSearchView = new PersonMasterSearchView(_egoEntities.PERSON.ToList());
dataGridView.DataSource = _personSearchView.PersonSearchViews;
dataGridView.Columns["PERSONID"].Visible = false;
dataGridViewButtonColumn.Name = "Select";
dataGridViewButtonColumn.HeaderText = "Choix";
dataGridViewButtonColumn.Text = "Choisir";
dataGridViewButtonColumn.UseColumnTextForButtonValue = true;
dataGridView.Columns.Add(dataGridViewButtonColumn);
Kinds = _egoEntities.KIND.ToList();
foreach (var kind in Kinds)
{
ComboboxItem item = new ComboboxItem();
item.Text = kind.KINDNAME;
item.Value = kind.KINDID;
comboBoxKind.Items.Add(item);
}
comboBoxKind.Visible = true;
break;
default:
break;
}
}
