private void SearchlistBox1_Click(object sender, EventArgs e)
{
NamebunifuMaterialTextbox1.DataBindings.Clear();
RelationbunifuMaterialTextbox1.DataBindings.Clear();
parametercomboBox1.DataBindings.Clear();
PhonebunifuMaterialTextbox1.DataBindings.Clear();
AddressbunifuMaterialTextbox1.DataBindings.Clear();
AgenumericUpDown1.DataBindings.Clear();
CVUploadlabel7.DataBindings.Clear();
phbContext ph = new phbContext();
selectedPerson = (person)SearchlistBox1.SelectedItem;
selectedPersonPhone = ph.phopersonPhones.Where(w => w.personDataId == selectedPerson.Id).FirstOrDefault();
selectedPersonDetail = ph.personDetails.Where(w => w.personDataId == selectedPerson.Id).FirstOrDefault();
NamebunifuMaterialTextbox1.DataBindings.Add("Text", selectedPerson, "fullName");
AgenumericUpDown1.DataBindings.Add("Text", selectedPerson, "age");
parametercomboBox1.DataBindings.Add("Text", selectedPerson, "relation");
RelationbunifuMaterialTextbox1.DataBindings.Add("Text", selectedPersonDetail, "parameter");
PhonebunifuMaterialTextbox1.DataBindings.Add("Text", selectedPersonPhone, "phoneNumber");
AddressbunifuMaterialTextbox1.DataBindings.Add("Text", selectedPersonDetail, "address");
}
void register(person p, personDetail pd, personPhone pp)
{
phbContext db1 = new phbContext();
if (p.Age >= 18 && search(p) != true)
{
db1.persons.Add(new person {
fullName = p.fullName, relation = p.relation, Age = p.Age, Image = path
});
db1.personDetails.Add(new personDetail {
parameter = pd.parameter, Address = pd.Address
});
db1.phopersonPhones.Add(new personPhone {
phoneNumber = pp.phoneNumber
});
db1.SaveChanges();
MessageBox.Show("ثبت نام شما موفقیت آمیز بود");
}
else
{
MessageBox.Show("امکان ثبت نام وجود ندارد");
}
}
private void SearchlistBox_Click(object sender, EventArgs e)
{
phbContext ph = new phbContext();
selectedPerson = (person)SearchlistBox.SelectedItem;
selectedPersonPhone = ph.phopersonPhones.Where(w => w.personDataId == selectedPerson.Id).FirstOrDefault();
selectedPersonDetail = ph.personDetails.Where(w => w.personDataId == selectedPerson.Id).FirstOrDefault();
bunifuMaterialTextbox1.DataBindings.Clear();
bunifuMaterialTextbox2.DataBindings.Clear();
bunifuMaterialTextbox3.DataBindings.Clear();
bunifuMaterialTextbox4.DataBindings.Clear();
numericUpDown1.DataBindings.Clear();
comboBox1.DataBindings.Clear();
bunifuMaterialTextbox1.DataBindings.Add("Text", selectedPerson, "fullName", false, DataSourceUpdateMode.OnPropertyChanged);
bunifuMaterialTextbox2.DataBindings.Add("Text", selectedPerson, "relation");
bunifuMaterialTextbox3.DataBindings.Add("Text", selectedPersonPhone, "phoneNumber");
bunifuMaterialTextbox4.DataBindings.Add("Text", selectedPersonDetail, "address");
numericUpDown1.DataBindings.Add("Text", selectedPerson, "age");
comboBox1.DataBindings.Add("Text", selectedPersonDetail, "parameter", false, DataSourceUpdateMode.OnPropertyChanged);
if (!string.IsNullOrEmpty(selectedPerson.Image))
{
pictureBox1.Image = Image.FromFile(selectedPerson.Image);
}
if (selectedPersonDetail != null)
{
comboBox1.Text = selectedPersonDetail.parameter;
}
}
private void MakeGroupUserControl_Load(object sender, EventArgs e)
{
// p100 = new person_Bll().ReadAll();
List <person> pList = new List <person>();
phbContext db = new phbContext();
pList = db.persons.ToList();
}
private void SearchbunifuMaterialTextbox1_OnValueChanged(object sender, EventArgs e)
{
List <person> searchList = new List <person>();
phbContext db1 = new phbContext();
var q = from item in db1.persons where item.fullName.Contains(SearchbunifuMaterialTextbox1.Text) select item;
SearchlistBox.DataSource = q.ToList();
}
private void GroupslistBox1_Click(object sender, EventArgs e)
{
selectedGroup = (group)GroupslistBox1.SelectedItem;
List <int> ids = selectedGroup.persons.Split(',').Select(s => Convert.ToInt32(s)).ToList();
phbContext phb1 = new phbContext();
selectedGroupPersons = phb1.persons.Where(w => ids.Contains(w.Id)).ToList();
GroupMemberslistBox2.DataSource = selectedGroupPersons;
}
private void fillChart1()
{
phbContext pcd = new phbContext();
chart1.DataSource = pcd.persons.ToList();
//set the member of the chart data source used to data bind to the X-values of the series
chart1.Series["Age of Members"].XValueMember = "fullName";
//set the member columns of the chart data source used to data bind to the X-values of the series
chart1.Series["Age of Members"].YValueMembers = "Age";
chart1.ChartAreas.FirstOrDefault().AxisX.Interval = 1;
chart1.Titles.Add("جدول سن کارکنان شرکت مانا");
}
private void SaveEditbutton2_Click(object sender, EventArgs e)
{
phbContext phb = new phbContext();
phb.persons.Attach(selectedPerson);
phb.Entry(selectedPerson).State = System.Data.Entity.EntityState.Modified;
var result = phb.SaveChanges();
if (result > 0)
{
MessageBox.Show("تغییرات اعمال شد");
}
else
{
MessageBox.Show("ثبت تغییرات با مشکل مواجه شد");
}
}
void register(group g)
{
phbContext db1 = new phbContext();
if (g.groupName.Length >= 2 && search(g) != true)
{
db1.groups.Add(new group {
groupName = g.groupName, persons = g.persons
});
db1.SaveChanges();
MessageBox.Show("ثبت شد" + GroupNamebunifuMaterialTextbox1.Text + "گروه");
NewGroupMemberlistBox1.ClearSelected();
}
else
{
MessageBox.Show("امکان ثبت وجود ندارد");
}
}
public bool register(person p, personDetail pd, personPhone pp)
{
CRUD_Person cp = new CRUD_Person();
CRUD_PersonDetail cpd = new CRUD_PersonDetail();
CRUD_personPhone cpp = new CRUD_personPhone();
phbContext db1 = new phbContext();
if (p.Age >= 18 && search(p) != true)
{
var person = new person {
fullName = p.fullName, relation = p.relation, Age = p.Age, Image = savedPath
};
var prsn = cp.Create(person);
// db1.persons.Add(new person { fullName = p.fullName, relation = p.relation, Age = p.Age, Image = savedPath });
// db1.personDetails.Add(new personDetail { parameter = pd.parameter, Address = pd.Address });
var prsnD = cpd.Create(new personDetail {
parameter = pd.parameter, Address = pd.Address, personDataId = prsn?.Id ?? 0
});
// db1.phopersonPhones.Add(new personPhone { phoneNumber = pp.phoneNumber });
var prsnP = cpp.Create(new personPhone {
phoneNumber = pp.phoneNumber, personDataId = prsn?.Id ?? 0
});
RegisterSubmitForm rsf = new RegisterSubmitForm();
rsf.Show();
if (prsnD != null && prsnP != null)
{
return(true);
}
// return false;
}
else
{
FailedRegisterSubmitForm frsf = new FailedRegisterSubmitForm();
frsf.Show();
}
return(false);
}
bool search(group g)
{
phbContext phb = new phbContext();
return(phb.groups.Any(i => i.groupName.Contains(g.groupName)));
}
public bool search(groups g)
{
phbContext db2 = new phbContext();
return(db2.groups.Any(i => i.groupName.Contains(g.groupName)));
}
bool search(person p)
{
phbContext phb = new phbContext();
return(phb.persons.Any(i => i.fullName.Contains(p.fullName)));
}
void register()
{
phbContext phb = new phbContext();
}
