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 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 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 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!"); } }
//-----------------------------------END OF MEMBER INFO----------------------------------------- //--------------------------------------UPDATE MEMBER------------------------------------------- private void b3_Click(object sender, EventArgs e)//Update Frame button { MemberTableDataContext m = new MemberTableDataContext(strCon); dataGrid_Update_List.DataSource = m.Members; panel_Mem_Info.Visible = false; panel_Purchase_Product.Visible = false; panel_Home.Visible = false; panel_AddMem.Visible = false; panel_Update_Member.Visible = true; panel_Admin.Visible = false; }
//-----------------------------------END OF ADD MEMBER----------------------------------------- //--------------------------------------MEMBER INFO--------------------------------------------- private void b1_Click(object sender, EventArgs e) { panel_Mem_Info.Visible = true; panel_Home.Visible = false; panel_Purchase_Product.Visible = false; panel_AddMem.Visible = false; panel_Update_Member.Visible = false; panel_Admin.Visible = false; MemberTableDataContext m = new MemberTableDataContext(strCon); dataGridView1.DataSource = m.Members; }
//-----------------------------------END OF MEMBER INFO----------------------------------------- //--------------------------------------UPDATE MEMBER------------------------------------------- private void b3_Click(object sender, EventArgs e)//Update Frame button { MemberTableDataContext m = 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"); dataGrid_Update_List.DataSource = m.Members; panel_Mem_Info.Visible = false; panel_Purchase_Product.Visible = false; panel_Home.Visible = false; panel_AddMem.Visible = false; panel_Update_Member.Visible = true; panel_Admin.Visible = false; }
private void buttonLoad_Click(object sender, EventArgs e) //REFRESH Button in Update info Panel { MemberTableDataContext mi = new MemberTableDataContext(strCon); dataGrid_Update_List.DataSource = mi.Members; textBox_Up_Id.Text = textBox_Up_name.Text = comboBox_Up_Gen.Text = textBox_Up_Age.Text = textBox_Up_Height.Text = textBox_Up_Weight.Text = textBox_Up_Contact.Text = comboBox_Up_batch.Text = comboBox_Up_Mem.Text = comboBox_Up_Fees.Text = string.Empty; }
private void buttonLoad_Click(object sender, EventArgs e) //REFRESH 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"); dataGrid_Update_List.DataSource = mi.Members; textBox_Up_Id.Text = textBox_Up_name.Text = comboBox_Up_Gen.Text = textBox_Up_Age.Text = textBox_Up_Height.Text = textBox_Up_Weight.Text = textBox_Up_Contact.Text = comboBox_Up_batch.Text = comboBox_Up_Mem.Text = comboBox_Up_Fees.Text = string.Empty; }
private void buttonMemSearch_Click(object sender, EventArgs e)//SEARCH button in Update info Panel { MemberTableDataContext mi = new MemberTableDataContext(strCon); try { if (int.Parse(textBox_Up_Id.Text) >= 0) { var x = from a in mi.Members where a.Id == int.Parse(textBox_Up_Id.Text) select a; { textBox_Up_name.Text = x.FirstOrDefault().Name; comboBox_Up_Gen.Text = x.First().Gender; textBox_Up_Age.Text = x.First().Age; textBox_Up_Height.Text = x.First().Height; textBox_Up_Weight.Text = x.First().Weight; textBox_Up_Contact.Text = x.First().Contact; comboBox_Up_batch.Text = x.First().Batch; comboBox_Up_Mem.Text = x.First().Member_Type; comboBox_Up_Fees.Text = x.First().Fees_Mode; dataGrid_Update_List.DataSource = x.ToList(); } } else { MessageBox.Show("ID must be positive integer!"); } } catch { MessageBox.Show("Invalid ID!"); } }
private void buttonMemSearch_Click(object sender, EventArgs e)//SEARCH 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 { if (int.Parse(textBox_Up_Id.Text) >= 0) { var x = from a in mi.Members where a.Id == int.Parse(textBox_Up_Id.Text) select a; { textBox_Up_name.Text = x.FirstOrDefault().Name; comboBox_Up_Gen.Text = x.First().Gender; textBox_Up_Age.Text = x.First().Age; textBox_Up_Height.Text = x.First().Height; textBox_Up_Weight.Text = x.First().Weight; textBox_Up_Contact.Text = x.First().Contact; comboBox_Up_batch.Text = x.First().Batch; comboBox_Up_Mem.Text = x.First().Member_Type; comboBox_Up_Fees.Text = x.First().Fees_Mode; dataGrid_Update_List.DataSource = x.ToList(); } } else { MessageBox.Show("ID must be positive integer!"); } } catch { MessageBox.Show("Invalid ID!"); } }
private void buttonRefresh_Click(object sender, EventArgs e) { MemberTableDataContext mi = new MemberTableDataContext(strCon); dataGridView1.DataSource = mi.Members; }
private void buttonRefresh_Click(object sender, EventArgs e) { 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"); dataGridView1.DataSource = mi.Members; }