private void buttonDelete_Click(object sender, EventArgs e) //DELETE Button in Update Info Panel
{
MemberTableDataContext mi = new MemberTableDataContext(strCon);
try
{
var x = from a in mi.Members
where a.Id == int.Parse(textBox_Up_Id.Text)
select a;
//Lamda Expression
foreach (Member m in x)
{
mi.Members.DeleteOnSubmit(m);
}
mi.SubmitChanges();
//UpdateGridView();
MessageBox.Show("Success!");
}
catch
{
MessageBox.Show("Unsuccessful!");
}
}
private void buttonUpdate_Click(object sender, EventArgs e) //Update Button in Update Info Panel
{
MemberTableDataContext mi = new MemberTableDataContext(strCon);
if (textBox_Up_Id.Text != "")
{
try
{
var x = from a in mi.Members
where a.Id == int.Parse(textBox_Up_Id.Text)
select a;
x.First().Id = int.Parse(textBox_Up_Id.Text);
x.First().Name = textBox_Up_name.Text;
x.First().Gender = comboBox_Up_Gen.Text;
x.First().Age = textBox_Up_Age.Text;
x.First().Height = textBox_Up_Height.Text;
x.First().Weight = textBox_Up_Weight.Text;
x.First().Contact = textBox_Up_Contact.Text;
x.First().Batch = comboBox_Up_batch.Text;
x.First().Member_Type = comboBox_Up_Mem.Text;
x.First().Fees_Mode = comboBox_Up_Fees.Text;
mi.SubmitChanges();
dataGrid_Update_List.DataSource = x.ToList();
}
catch
{
MessageBox.Show("Invalid Entry!");
}
}
else
{
MessageBox.Show("Input ID First!");
}
}
private void buttonSubmit_Click(object sender, EventArgs e)
{
MemberTableDataContext mi = new MemberTableDataContext(strCon);
try
{
Member mt = new Member
{
Id = int.Parse(textBox_Id.Text),
Name = textName.Text,
Age = textBox_Age.Text,
Gender = comboBox_Gender.Text,
Height = textHeight.Text,
Weight = textWeight.Text,
Contact = textContact.Text,
Batch = comboBatch.Text,
Member_Type = comboMember.Text,
Fees_Mode = comboFees.Text
};
if (int.Parse(textBox_Age.Text) < 100 && int.Parse(textBox_Age.Text) > 0)
{
mi.Members.InsertOnSubmit(mt);
mi.SubmitChanges();
MessageBox.Show("Success!");
}
else
{
MessageBox.Show("Please input a valid age!");
}
}
catch
{
MessageBox.Show("Error!");
}
}
private void buttonDelete_Click(object sender, EventArgs e) //DELETE Button in Update Info Panel
{
MemberTableDataContext mi = new MemberTableDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\Study\Sem 8\OOP2 (C#)\Final\Project\FinalTermProject v2.0\FinalTermProject\FinalTermProject\Admindata.mdf;Integrated Security=True;Connect Timeout=30");
try
{
var x = from a in mi.Members
where a.Id == int.Parse(textBox_Up_Id.Text)
select a;
//Lamda Expression
foreach (Member m in x)
{
mi.Members.DeleteOnSubmit(m);
}
mi.SubmitChanges();
//UpdateGridView();
MessageBox.Show("Success!");
}
catch
{
MessageBox.Show("Unsuccessful!");
}
}
private void buttonUpdate_Click(object sender, EventArgs e) //Update Button in Update Info Panel
{
MemberTableDataContext mi = new MemberTableDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\Study\Sem 8\OOP2 (C#)\Final\Project\FinalTermProject v2.0\FinalTermProject\FinalTermProject\Admindata.mdf;Integrated Security=True;Connect Timeout=30");
if (textBox_Up_Id.Text != "")
{
try
{
var x = from a in mi.Members
where a.Id == int.Parse(textBox_Up_Id.Text)
select a;
x.First().Id = int.Parse(textBox_Up_Id.Text);
x.First().Name = textBox_Up_name.Text;
x.First().Gender = comboBox_Up_Gen.Text;
x.First().Age = textBox_Up_Age.Text;
x.First().Height = textBox_Up_Height.Text;
x.First().Weight = textBox_Up_Weight.Text;
x.First().Contact = textBox_Up_Contact.Text;
x.First().Batch = comboBox_Up_batch.Text;
x.First().Member_Type = comboBox_Up_Mem.Text;
x.First().Fees_Mode = comboBox_Up_Fees.Text;
mi.SubmitChanges();
dataGrid_Update_List.DataSource = x.ToList();
}
catch
{
MessageBox.Show("Invalid Entry!");
}
}
else
{
MessageBox.Show("Input ID First!");
}
}
private void buttonSubmit_Click(object sender, EventArgs e)
{
MemberTableDataContext mi = new MemberTableDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\Study\Sem 8\OOP2 (C#)\Final\Project\FinalTermProject\FinalTermProject\Admindata.mdf;Integrated Security=True;Connect Timeout=30");
try
{
Member mt = new Member
{
Id = int.Parse(textBox_Id.Text),
Name = textName.Text,
Age = textBox_Age.Text,
Gender = comboBox_Gender.Text,
Height = textHeight.Text,
Weight = textWeight.Text,
Contact = textContact.Text,
Batch = comboBatch.Text,
Member_Type = comboMember.Text,
Fees_Mode = comboFees.Text
};
if (int.Parse(textBox_Age.Text) < 100 && int.Parse(textBox_Age.Text) > 0)
{
mi.Members.InsertOnSubmit(mt);
mi.SubmitChanges();
MessageBox.Show("Success!");
}
else
{
MessageBox.Show("Please input a valid age!");
}
}
catch
{
MessageBox.Show("Error!");
}
}
