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(); }