private void btnSubmit_Click(object sender, EventArgs e) { MatrixLinQDataContext con = new MatrixLinQDataContext(); Student s = con.Students.SingleOrDefault(x => x.sName == txtName.Text); if (s != null) { s.sName = txtName.Text; s.sFatherName = txtFather.Text; s.sMotherName = txtMother.Text; s.sContactNo = txtContact.Text; s.sAdress = txtAddress.Text; s.sSchool = txtSchools.Text; s.sClass = txtClass.Text; s.sSection = txtsection.Text; s.sFees = int.Parse(txtFees.Text); con.SubmitChanges(); MessageBox.Show("Success"); } else { MessageBox.Show("Not Update"); } }
private void btnSubmit_Click(object sender, EventArgs e) { MatrixLinQDataContext con = new MatrixLinQDataContext(); teacher t = con.teachers.SingleOrDefault(x => x.teacherName == txtName.Text); if (t != null) { t.teacherName = txtName.Text; t.teacherEmail = txtMail.Text; t.teacherContactNo = txtContactNo.Text; t.teacherAddress = txtAddress.Text; t.teacherDesignation = txtDesignation.Text; t.teacherPayPerClass = int.Parse(txtPayment.Text); con.SubmitChanges(); MessageBox.Show("Success"); } else { MessageBox.Show("Not Update"); } }
private void FormStudent_Load(object sender, EventArgs e) { MatrixLinQDataContext con = new MatrixLinQDataContext(); var ob = con.Students.Where(x => x.sName.StartsWith(searchBox.Text)); searchBox.DataSource = ob.ToList(); searchBox.DisplayMember = "sName"; }
private void FormAddStudent_Load(object sender, EventArgs e) { MatrixLinQDataContext con = new MatrixLinQDataContext(); var ob = from f in con.sections select f; if (ob.Any()) { SectionBox.DataSource = ob.ToList(); SectionBox.DisplayMember = "sectionName"; } }
//connect with linQ private bool isUserValid() { MatrixLinQDataContext con = new MatrixLinQDataContext(); var ob = from f in con.user_logins where f.uName == UserID.Text && f.uPassword == Password.Text select f; if (ob.Any()) { return(true); } return(false); }
private void btnDelete_Click(object sender, EventArgs e) { MatrixLinQDataContext con = new MatrixLinQDataContext(); Student s = con.Students.SingleOrDefault(x => x.sName == txtName.Text); if (s != null) { con.Students.DeleteOnSubmit(s); con.SubmitChanges(); MessageBox.Show(" Deleted"); } else { MessageBox.Show(" Not Found"); } }
private void button1_Click(object sender, EventArgs e) { MatrixLinQDataContext con = new MatrixLinQDataContext(); teacher t = con.teachers.SingleOrDefault(x => x.teacherName == txtName.Text); if (t != null) { con.teachers.DeleteOnSubmit(t); con.SubmitChanges(); MessageBox.Show(" Deleted"); } else { MessageBox.Show(" Not Found"); } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { MatrixLinQDataContext con = new MatrixLinQDataContext(); string temp = searchBox.GetItemText(searchBox.SelectedItem); teacher t = con.teachers.SingleOrDefault(x => x.teacherName == temp); if (t != null) { txtName.Text = t.teacherName; txtMail.Text = t.teacherEmail; txtContactNo.Text = t.teacherContactNo; txtAddress.Text = t.teacherAddress; txtDesignation.Text = t.teacherDesignation; txtPayment.Text = t.teacherPayPerClass.ToString(); } }
private void searchBox_SelectedIndexChanged(object sender, EventArgs e) { MatrixLinQDataContext con = new MatrixLinQDataContext(); string temp = searchBox.GetItemText(searchBox.SelectedItem); Student s = con.Students.SingleOrDefault(x => x.sName == temp); if (s != null) { txtName.Text = s.sName; txtFather.Text = s.sFatherName; txtMother.Text = s.sMotherName; txtContact.Text = s.sContactNo; txtAddress.Text = s.sAdress; txtSchools.Text = s.sSchool; txtClass.Text = s.sClass; txtsection.Text = s.sSection; txtFees.Text = s.sFees.ToString(); } }
private void btnAdd_Click(object sender, EventArgs e) { if (txtCourse.Text.Length != 0) { MatrixLinQDataContext con = new MatrixLinQDataContext(); section s = new section(); s.sectionName = this.txtCourse.Text; con.sections.InsertOnSubmit(s); con.SubmitChanges(); MessageBox.Show("New Section Added"); txtCourse.Text = ""; } else { MessageBox.Show("Error"); } }
private void btnSubmit_Click(object sender, EventArgs e) { if (!isFieldEmpty()) { MatrixLinQDataContext con = new MatrixLinQDataContext(); teacher t = new teacher(); t.teacherName = txtName.Text; t.teacherEmail = txtMail.Text; t.teacherContactNo = txtContactNo.Text; t.teacherBloodGroup = bloodGroup.SelectedItem.ToString(); t.teacherReligion = religion.SelectedItem.ToString(); t.teacherAddress = txtAddress.Text; t.teacherJoinDate = joinDate.Value.ToString("dd/MM/yyyy"); t.teacherDesignation = txtDesignation.Text; t.teacherPayPerClass = Convert.ToInt32(txtPayment.Text); con.teachers.InsertOnSubmit(t); con.SubmitChanges(); MessageBox.Show("New User Added"); } }
private void btnUpdate_Click(object sender, EventArgs e) { MatrixLinQDataContext con = new MatrixLinQDataContext(); user_login uc = con.user_logins.SingleOrDefault(x => x.uName == Utility.UserName && x.uPassword == this.txtCurrentPassword.Text); if (uc != null) { uc.uPassword = newPass.Text; con.SubmitChanges(); this.Dispose(); MessageBox.Show("Password Changed"); } else { MessageBox.Show("Error"); txtCurrentPassword.Text = ""; newPass.Text = ""; rePass.Text = ""; } }
private void btnSubmit_Click(object sender, EventArgs e) { if (!isFieldEmpty()) { MatrixLinQDataContext con = new MatrixLinQDataContext(); Student s = new Student(); s.sName = txtName.Text; s.sFatherName = txtFather.Text; s.sMotherName = txtMother.Text; s.sContactNo = txtContact.Text; s.sGender = gender.SelectedItem.ToString(); s.sAdress = txtAddress.Text; s.sDateOfBirth = DoB.Value.ToString("dd/MM/yyyy"); s.sJoiningDate = JoiningDate.Value.ToString("dd/MM/yyyy"); s.sSchool = txtSchools.Text; s.sClass = ClassBox.SelectedItem.ToString(); s.sSection = SectionBox.GetItemText(SectionBox.SelectedItem); s.sFees = int.Parse(txtFees.Text); con.Students.InsertOnSubmit(s); con.SubmitChanges(); MessageBox.Show("New Student Added"); } }