private void button3_Click(object sender, EventArgs e)
{
//se sterge membrul cand apesi delete
entities.Members.Remove(memberToBeDeletedInCase);
entities.SaveChanges();
MessageBox.Show("Member's Registration has been deleted", "Success", MessageBoxButtons.OK);
}
//adaugare dietplan la membri
private void Btn_Add_Click(object sender, EventArgs e)
{
//setarea numelor dietplan dupa butoane
string DietPlan = " ";
if (rdplan1.Checked == true)
{
DietPlan = "Diet Plan 1";
}
else if (rdPlan2.Checked == true)
{
DietPlan = "Diet Plan 2";
}
else if (rdplan3.Checked == true)
{
DietPlan = "Diet Plan 3";
}
//ia id-ul de la diet plan dupa selectarea facuta
string dietPlan = (from plan in entites.Diet_Plans
where plan.PlanName == DietPlan
select plan.PlanID).FirstOrDefault();
//retine numele ales in combobox
string MemberName = comboBox1.Text;
//se alege un membru existent in baza de date
var selectedMember = (from member in entites.Members
where member.Member_Name == MemberName
select member).FirstOrDefault();
//Seteaza alegerea facuta
selectedMember.DietPlanID = dietPlan;
//Salvare
entites.SaveChanges();
MessageBox.Show("Diet Plan Updated", "Success", MessageBoxButtons.OK);
}
//Adaugare antrenor
private void Btn_Add_Click(object sender, EventArgs e)
{
//se creeaza o noua instanta in tabelul antrenori
Trainer trainer = new Trainer()
{
Trainer_ID = new Random().Next(1, 100000).ToString(),
Trainer_Address = txbx_address.Text,
Trainer_Name = txbx_name.Text,
Trainer_PhoneNumber = txbx_contact.Text
};
//Se adauga in baza de date
entities.Trainers.Add(trainer);
//Salvare
entities.SaveChanges();
MessageBox.Show("Trainer has been Added", "Success", MessageBoxButtons.OK);
//Refresh formular
Form1 form = new Form1();
((Form1)this.TopLevelControl).Close();
form.Show();
}
//Adaugarea membrului
private void Btn_Add_Click(object sender, EventArgs e)
{
//retine abonamentul selectat
string comboxBoxPackagesText = cmbx_package.Text;
// Atribuirea codurilor conform bazei de date prin utilizarea structurilor de control
if (cmbx_package.Text == "Monthly")
{
comboxBoxPackagesText = "1";
}
else if (cmbx_package.Text == "3 Months")
{
comboxBoxPackagesText = "3";
}
else if (cmbx_package.Text == "6 Months")
{
comboxBoxPackagesText = "6";
}
else if (cmbx_package.Text == "1 Year")
{
comboxBoxPackagesText = "12";
}
//Se ia cheia primară din packages cu interogare in baza de date
var getPackagesID = (from package in entities.Packages
where package.Package_Time == comboxBoxPackagesText
select new { package.Package_ID, package.Package_Time }).FirstOrDefault();
//selecteaza genul
string gender = " ";
if (malerb.Checked == true)
{
gender = "Male";
}
else if (femalrb.Checked == true)
{
gender = "Female";
}
string getTrainerID = " ";
//Retine numele antrenorului
string trainerSelected = cmbx_Trainer.Text;
//Se ia id-ul din tabelul Trainer, după numele selectat
getTrainerID = (from trainer in entities.Trainers
where trainer.Trainer_Name == trainerSelected
select trainer.Trainer_ID).FirstOrDefault();
//se creeaza o noua instanta membru si se atribuie valori
Member member = new Member()
{
Member_ID = new Random().Next(1, 100000000).ToString(),
Member_Date = dateTimePicker2.Value.Date.ToShortDateString(),
Member_Name = namebox.Text.Trim(),
Member_sex = gender,
Package_ID = getPackagesID.Package_ID,
Member_PackageExpiry = dateTimePicker1.Value.Date.AddMonths(int.Parse(getPackagesID.Package_Time)),
Member_Email = emailbox.Text.Trim(),
AddedBy = loginform.AddedBy,
Trainer_ID = getTrainerID
};
//Se adauga in baza de date
entities.Members.Add(member);
//Call la save changes pentru a da update la database
entities.SaveChanges();
MessageBox.Show("Member has been Added Successfully", "Added", MessageBoxButtons.OK);
//Refresh la form pentru a vedea updateul
Form1 form = new Form1();
((Form1)this.TopLevelControl).Close();
form.Show();
}