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