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; } }
public string Delete(int id) { personPhone pp = Read(id); db1.phopersonPhones.Remove(pp); db1.SaveChanges(); return("حذف اطلاعات با موفقیت انجام شد"); }
public int Update(int id, personPhone p) { personPhone pp = new personPhone(); pp = Read(id); pp.Id = p.Id; return(db1.SaveChanges()); // return "ویرایش اطلاعات با موفقیت انجام شد"; }
public personPhone Create(personPhone p) {//ایجاد شی در بانک اطلاعاتی if (p == null || p.personDataId == 0) { return(null); } db1.phopersonPhones.Add(p); var result = db1.SaveChanges(); if (result > 0) { return(p); } return(null); }
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); }
public bool Exist(personPhone pp) { return(db1.phopersonPhones.Any(i => i.phoneNumber == pp.phoneNumber)); }