private void deleteUButton_Click(object sender, EventArgs e) { try { libraryDataContext lb = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\LibraryManagementSystem\library.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in lb.Informations where a.Id == Convert.ToInt32(textBox1.Text) select a; if (x.Any()) { foreach (Information p in x) { lb.Informations.DeleteOnSubmit(p); } lb.SubmitChanges(); MessageBox.Show("Member Deleted"); //libraryDataContext lb = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\LibraryManagementSystem\library.mdf;Integrated Security=True;Connect Timeout=30"); dataGridView3.DataSource = lb.Informations; } else { MessageBox.Show("Fill up the id first"); } } catch (Exception) { MessageBox.Show("Fill Up the id first"); } }
private void updateButton_Click(object sender, EventArgs e) { try { libraryDataContext ld = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\LibraryManagementSystem\library.mdf;Integrated Security=True;Connect Timeout=30"); var t = from s in ld.Informations where s.Id == Convert.ToInt32(idTF.Text) select s; //libraryDataContext le = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); //var zz = from q in le.Borrows // where q.userId == idTF.Text // select q; t.First().Name = nameTF.Text; //zz.First().name = nameTF.Text; t.First().Address = addTF.Text; t.First().Email = emailTF.Text; t.First().MobileNo = phoneTF.Text; t.First().Gender = genderTF.Text; ld.SubmitChanges(); //le.SubmitChanges(); dataGridView8.DataSource = t.ToList(); } catch (Exception) { MessageBox.Show("Please Enter ID"); } }
private void searchButton_Click(object sender, EventArgs e) { try { libraryDataContext ld = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\LibraryManagementSystem\library.mdf;Integrated Security=True;Connect Timeout=30"); var c = from h in ld.Informations where h.Id == Convert.ToInt32(idTF.Text) select h; if (c.Any()) { nameTF.Text = c.FirstOrDefault().Name; addTF.Text = c.FirstOrDefault().Address; emailTF.Text = c.FirstOrDefault().Email; phoneTF.Text = c.FirstOrDefault().MobileNo; genderTF.Text = c.FirstOrDefault().Gender; dataGridView8.DataSource = c.ToList(); if (nameTF.Text != "" || addTF.Text != "" || emailTF.Text != "" || phoneTF.Text != "" || genderTF.Text != "") { nameTF.Enabled = true; addTF.Enabled = true; emailTF.Enabled = true; phoneTF.Enabled = true; genderTF.Enabled = true; } } else { MessageBox.Show("Nothing Found"); } } catch (Exception) { MessageBox.Show("Please Enter ID"); } }
private void addButton_Click(object sender, EventArgs e) { try { libraryDataContext lb = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); Table t = new Table(); //string tid = bookIdText.Text; //string tname = bookNameText.Text; //string tauthore = bookAuthoreTF.Text; //string type = btTf.Text; //string tcopy = cpyTF.Text; if (bookIdText.Text == "" || bookNameText.Text == "" || bookAuthoreTF.Text == "" || btTf.Text == "" || cpyTF.Text == "") { MessageBox.Show("Please Check The Fields"); } else { t.bookId = bookIdText.Text; t.bookName = bookNameText.Text; t.authorName = bookAuthoreTF.Text; t.bookType = btTf.Text; t.bookCopy = cpyTF.Text; lb.Tables.InsertOnSubmit(t); lb.SubmitChanges(); dataGridView6.DataSource = lb.Tables; MessageBox.Show("Book Added Successfully"); } } catch (Exception) { MessageBox.Show("Please CHeck The Fields Again"); } }
// search books for borrowing private void btnSrc_Click(object sender, EventArgs e) { try { // btnSelectBook.Enabled = true; libraryDataContext src = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in src.Tables where a.bookId == searchTF.Text select a; BookIdTF.Text = x.FirstOrDefault().bookId; bookNameTF.Text = x.FirstOrDefault().bookName; authorNameTF.Text = x.FirstOrDefault().authorName; bookTypeTF.Text = x.FirstOrDefault().bookType; bookCopyTF.Text = x.FirstOrDefault().bookCopy; // priceTF.Text = x.FirstOrDefault().price; dataGridView1.DataSource = x.ToList(); } catch (Exception) { MessageBox.Show("Not Found"); } }
private void Form4_Load(object sender, EventArgs e) { libraryDataContext lb = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\LibraryManagementSystem\library.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in lb.Informations where a.Id == Convert.ToInt32(id) select a; adLabel.Text = x.FirstOrDefault().Name; }
private void sButton_Click(object sender, EventArgs e) { libraryDataContext ll = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); var f = from l in ll.Tables where l.bookId == bidTF.Text select l; if (f.Any()) { dataGridView2.DataSource = f.ToList(); } else { MessageBox.Show("Nothing Found"); } }
//------------------------Search Book------------------------------ //enable search and load private void btnSearch_Click(object sender, EventArgs e) { try { searchTF.Enabled = true; dataGridView(); // btnSelectBook.Enabled = true; btnSrc.Enabled = true; libraryDataContext lib = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); // Borrow b = new Borrow(); var abc = from g in lib.Borrows where g.userId == getUserIdLbl.Text select g; if (abc.FirstOrDefault().userId == null) { btnConfirm.Enabled = true; } else if (abc.FirstOrDefault().userId != null) { btnConfirm.Enabled = false; } } catch (Exception) { } //btnConfirm.Enabled = true; //libraryDataContext lib = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); //Borrow br = new Borrow(); //var abc = from g in lib.Borrows // where br.userId == getUserIdLbl.Text // select g; //if (abc.Any()) //{ // btnConfirm.Enabled = false; //} //else //{ // btnConfirm.Enabled = true; //} }
private void button1_Click(object sender, EventArgs e) { libraryDataContext lb = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); //string bId = delBookIdTF.Text; var x = from a in lb.Tables where a.bookId == delBookIdTF.Text select a; if (x.Any()) { dataGridView1.DataSource = x.ToList(); } else { MessageBox.Show("Nothing Found"); } }
// insert data of borrower for admin to monitor the borrowe return the book or not private void InsertBorrowerInfoToDatabase() { borrowD = borrowDate.Value.ToString("dd-mm-yyyy"); returnD = returnDate.Value.ToString("dd-mm-yyyy"); libraryDataContext borrowBook = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); Borrow borrowInfo = new Borrow { name = getNameLbl.Text, userId = getUserIdLbl.Text, bookId = BookIdTF.Text, borrowDate = borrowD, returnDate = returnD, totalDays = dateDiffTF.Text }; //borrowInfo.BookBorrowInfos.InsertOnSubmit(); borrowBook.Borrows.InsertOnSubmit(borrowInfo); borrowBook.SubmitChanges(); }
private void seButton_Click(object sender, EventArgs e) { try { libraryDataContext lr = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); var f = from k in lr.Borrows where k.userId == textBox2.Text select k; var h = from l in lr.Tables where f.FirstOrDefault().bookId == l.bookId select l; textBox3.Text = f.FirstOrDefault().bookId; textBox4.Text = f.FirstOrDefault().name; textBox5.Text = h.FirstOrDefault().bookName; } catch (Exception) { MessageBox.Show("Check ID"); } }
private void uupdateButton_Click(object sender, EventArgs e) { try { libraryDataContext ll = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); var f = from l in ll.Tables where l.bookId == bidTF.Text select l; int x = Convert.ToInt32(f.FirstOrDefault().bookCopy); x += Convert.ToInt32(cpTF.Text); f.First().bookCopy = Convert.ToString(x); ll.SubmitChanges(); MessageBox.Show("Book Copy Added Successfully"); dataGridView2.DataSource = f.ToList(); cpTF.Text = ""; bidTF.Text = ""; } catch (Exception) { MessageBox.Show("Check ID"); } }
private void button2_Click(object sender, EventArgs e) { libraryDataContext lb = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in lb.Tables where a.bookId == delBookIdTF.Text select a; if (x.Any()) { foreach (Table p in x) { lb.Tables.DeleteOnSubmit(p); } lb.SubmitChanges(); MessageBox.Show("Book Deleted"); UpdateGridView(); } else { MessageBox.Show("Fill up the id first"); } }
private void button3_Click(object sender, EventArgs e) { libraryDataContext lr = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in lr.Tables where a.bookId == textBox3.Text select a; int g = Convert.ToInt32(x.FirstOrDefault().bookCopy); g += 1; x.First().bookCopy = Convert.ToString(g); lr.SubmitChanges(); var v = from f in lr.Borrows where f.userId == textBox2.Text select f; foreach (Borrow oo in v) { lr.Borrows.DeleteOnSubmit(oo); } lr.SubmitChanges(); //UpdateGridView(); }
private void searchUButton_Click(object sender, EventArgs e) { libraryDataContext lb = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\LibraryManagementSystem\library.mdf;Integrated Security=True;Connect Timeout=30"); //string bId = delBookIdTF.Text; try { var z = from a in lb.Informations where a.Id == Convert.ToInt32(textBox1.Text) && a.Id != 1 select a; if (z.Any()) { dataGridView3.DataSource = z.ToList(); } else { MessageBox.Show("Nothing Found"); } } catch (Exception) { MessageBox.Show("Please Check the ID"); } }
private void btnSend_Click(object sender, EventArgs e) { try { if (ReportTF.Text != "") { libraryDataContext dc = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); Review r = new Review(); r.Id = Convert.ToInt32(userTF.Text); r.Rev = ReportTF.Text; dc.Reviews.InsertOnSubmit(r); dc.SubmitChanges(); ReportTF.Enabled = false; //userTF.Text = userId; //string getMessage = ReportTF.Text; userTF.Text = ""; ReportTF.Text = ""; //getMess.Text = getMessage; btnSend.Enabled = false; MessageBox.Show("Message sent successfully"); } else { MessageBox.Show("Message sent failed"); } } catch (Exception) { MessageBox.Show("You are already give your review "); } }
private void loginButton_Click(object sender, EventArgs e) { string type = cbSearch.Text;; string tid = userIdTF.Text; string tpass = passTF.Text; if (tid == "" || tpass == "" || type == "") { warnLabel.Text = "Please Enter All The Values"; } else { try { libraryDataContext lb = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\LibraryManagementSystem\library.mdf;Integrated Security=True;Connect Timeout=30"); Information i = new Information(); warnLabel.Text = ""; var x = from a in lb.Informations where a.Id == Convert.ToInt32(tid) && a.Type == type && a.Password == tpass select a; if (x.Any()) { if (type == "Admin") { //MessageBox.Show("Admin Found"); this.Hide(); Form4 f4 = new Form4(userIdTF.Text); f4.Show(); } else if (type == "User") { libraryDataContext log = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\LibraryManagementSystem\library.mdf;Integrated Security=True;Connect Timeout=30"); var r = from a in log.Informations where a.Id == Convert.ToInt32(userIdTF.Text) && a.Password == passTF.Text select a; // get values from database userId = r.FirstOrDefault().Id.ToString(); password = r.FirstOrDefault().Password; Address = r.FirstOrDefault().Address; userName = r.FirstOrDefault().Name; mobileNumebr = r.FirstOrDefault().MobileNo; //Library_management_software.UserDashboard u1 = new Library_management_software.UserDashboard(); //MessageBox.Show("User Found"); // Library_management_software.UserDashboard u1 = new Library_management_software.UserDashboard(userName, userId, password, Address, mobileNumebr); Form5 f5 = new Form5(userName, userId, password, Address, mobileNumebr); this.Hide(); f5.Show(); } } else { MessageBox.Show("Wrong id and password"); } } catch (Exception) { MessageBox.Show("wrong id and password"); } //MessageBox.Show(tid + tpass+type); } }
private void ustatusButton_Click(object sender, EventArgs e) { libraryDataContext lb = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\LibraryManagementSystem\library.mdf;Integrated Security=True;Connect Timeout=30"); dataGridView4.DataSource = lb.Informations; }
//confirm button private void btnConfirm_Click(object sender, EventArgs e) { //count++; //try //{ // int totalBook = int.Parse(bookCopyTF.Text); // int totalCopy = 0; // totalCopy = totalBook; // if (totalCopy <= 0) // { // MessageBox.Show("Book is not avaliable"); // } // else // { // //update // bookCopyTF.Text = totalCopy.ToString(); // libraryDataContext update = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); // var x = from a in update.Tables // where a.bookId == BookIdTF.Text // select a; // x.First().bookId = BookIdTF.Text; // x.First().bookName = bookNameTF.Text; // x.First().authorName = authorNameTF.Text; // x.First().bookType = bookTypeTF.Text; // x.First().bookCopy = bookCopyTF.Text; // update.SubmitChanges(); // dataGridView1.DataSource = x.ToList(); // int days = int.Parse(dateDiffTF.Text); // //days = days +1; // dateDiffTF.Text = days.ToString(); // if (day > 7 || day <= 0) // {//|| count == 2 || userName == getNameLbl.Text // totalCopy = totalCopy - 1; // MessageBox.Show("sorry ... order can't be processed"); // } // else // { // if (searchTF.Text == "" || BookIdTF.Text == "" || bookNameTF.Text == "" || bookTypeTF.Text == "" || bookCopyTF.Text == "") // { // MessageBox.Show(" Sorry your request is Not confirmed yet :)"); // } // else // { // MessageBox.Show("Welcome sir you borrowed this book for " + dateDiffTF.Text + " days"); // InsertBorrowerInfoToDatabase(); // } // } // } //} //catch (Exception) //{ // if (searchTF.Text == "" || BookIdTF.Text == "" || bookNameTF.Text == "" || bookTypeTF.Text == "" || bookCopyTF.Text == "") // { // MessageBox.Show(" Sorry your request is Not confirmed yet :)"); // } try { int totalBook = Convert.ToInt32(bookCopyTF.Text); if (searchTF.Text == "" || BookIdTF.Text == "" || bookNameTF.Text == "" || bookTypeTF.Text == "" || bookCopyTF.Text == "") { MessageBox.Show(" Sorry your request is Not confirmed yet :)"); } else { if (totalBook <= 0) { MessageBox.Show("Book is not avaliable"); } else if (totalBook > 0) { day = Convert.ToInt32(dateDiffTF.Text); if (day > 7 || day <= 0) { MessageBox.Show("process can't be possible"); } else { totalBook = totalBook - 1; bookCopyTF.Text = totalBook.ToString(); libraryDataContext update = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in update.Tables where a.bookId == BookIdTF.Text select a; x.First().bookId = BookIdTF.Text; x.First().bookName = bookNameTF.Text; x.First().authorName = authorNameTF.Text; x.First().bookType = bookTypeTF.Text; x.First().bookCopy = bookCopyTF.Text; update.SubmitChanges(); dataGridView1.DataSource = x.ToList(); MessageBox.Show("Welcome " + userId + " your confermation done"); InsertBorrowerInfoToDatabase(); btnConfirm.Enabled = false; } } } } catch (Exception) { MessageBox.Show("Operation not done "); } }
void UpdateGridView() { libraryDataContext lb = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\LibraryManagementSystem\library.mdf;Integrated Security=True;Connect Timeout=30"); dataGridView1.DataSource = lb.Tables; }
private void bookStatus_Click(object sender, EventArgs e) { libraryDataContext lb = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); dataGridView2.DataSource = lb.Tables; }
//load the data public void dataGridView() { libraryDataContext grid = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); dataGridView1.DataSource = grid.Tables; }
private void submitButton_Click(object sender, EventArgs e) { // Check if the point entered is numeric or not //if () //{ // // Do what you want to do if numeric //} //else //{ // // Do what you want to do if not numeric //} ld = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\LibraryManagementSystem\library.mdf;Integrated Security=True;Connect Timeout=30"); Information i = new Information(); //tid=Convert.ToInt32(idTextBox.Text); /*this.tname=nameTextBox.Text; * this.tpass=passwordTextBox.Text; * this.tmbl=mobileTextBox.Text; * this.tgen=gender; * this.tmail=emailTextBox.Text; * this.tut=this.table;*/ /*if(tname.Equals(null)||tpass.Equals(null)||tmbl.Equals(null)||tgen.Equals(null)||tmail.Equals(null)||tut.Equals(null)) * { * label8.Text="Please enter all the values"; * }*/ if (idTextBox.Text == "" || nameTextBox.Text == "" || passwordTextBox.Text == "" || mobileTextBox.Text == "" || g == "" || emailTextBox.Text == "" || comboBox1.Text == "" || addressTf.Text == "") { label8.Text = "Please enter all the values Correctly"; } else { try { i.Id = Convert.ToInt32(idTextBox.Text); i.Name = nameTextBox.Text; i.Password = passwordTextBox.Text; i.MobileNo = mobileTextBox.Text; i.Gender = this.g; i.Email = emailTextBox.Text; i.Type = this.table; i.Address = addressTf.Text; if (this.table == "Admin") { var x = from a in ld.Informations where a.Type == "Admin" select a.Type; //var y = from b in ld.Informations // where b.Type == "User" // select b.Type; if (x.Any()) { MessageBox.Show("Already"); } else { ld.Informations.InsertOnSubmit(i); ld.SubmitChanges(); this.Hide(); MessageBox.Show("Registration Successfull.."); Form2 f2 = new Form2(); f2.Show(); } } else { ld.Informations.InsertOnSubmit(i); ld.SubmitChanges(); this.Hide(); MessageBox.Show("Registration Successfull.."); Form2 f2 = new Form2(); f2.Show(); } } catch (Exception) { MessageBox.Show("Check Again"); } //try //{ // i.Id = Convert.ToInt32(idTextBox.Text); // i.Name = nameTextBox.Text; // i.Password = passwordTextBox.Text; // i.MobileNo = mobileTextBox.Text; // i.Gender = this.g; // i.Email = emailTextBox.Text; // i.Type = this.table; // i.Address = addressTf.Text; // var x = from a in ld.Informations // where a.Type == "Admin" // select a.Type; // var y = from b in ld.Informations // where b.Type == "User" // select b.Type; // if (x != null) // { // ld.Informations.InsertOnSubmit(i); // ld.SubmitChanges(); // this.Hide(); // MessageBox.Show("Registration Successfull.."); // Form2 f2 = new Form2(); // f2.Show(); // } // else // { // if (y.Any() || y != null) // { // ld.Informations.InsertOnSubmit(i); // ld.SubmitChanges(); // this.Hide(); // MessageBox.Show("Registration Successfull.."); // Form2 f2 = new Form2(); // f2.Show(); // } // else // { // MessageBox.Show("Already"); // } // } // } //catch (Exception) //{ // MessageBox.Show("Please enter another id"); //} } /*if (this.table == "Admin") * { * ld = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\LibraryManagementSystem\library.mdf;Integrated Security=True;Connect Timeout=30"); * admin ad = new admin(); * * try * { * ad.aid = idTextBox.Text; * ad.name = nameTextBox.Text; * ad.password = passwordTextBox.Text; * ad.mobileno = mobileTextBox.Text; * ad.emailid = emailTextBox.Text; * ad.gender = gender; * ld.admins.InsertOnSubmit(ad); * ld.SubmitChanges(); * } * catch (DBConcurrencyException) * { * MessageBox.Show("Please Check Your Mobile No.", "Message"); * } * catch (NullReferenceException) * { * MessageBox.Show("Please insert all the values", "Message"); * } * * //MessageBox.Show(idTextBox.Text+nameTextBox.Text+passwordTextBox.Text+mobileTextBox.Text+emailTextBox.Text+gender); * * * } * else if (this.table == "User") * { * ld = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\LibraryManagementSystem\library.mdf;Integrated Security=True;Connect Timeout=30"); * user us = new user(); * try * { * us.pid = idTextBox.Text; * us.name = nameTextBox.Text; * us.password = passwordTextBox.Text; * us.mobileno = mobileTextBox.Text; * us.emailid = emailTextBox.Text; * us.gender = gender; * ld.users.InsertOnSubmit(us); * ld.SubmitChanges(); * } * catch (DataException) * { * MessageBox.Show("Please Check Your Mobile No.", "Message"); * } * catch (NullReferenceException) * { * MessageBox.Show("Please insert all the values", "Message"); * } * * } * else * { * MessageBox.Show("Please insert the values"); * }*/ }