private void pubadd_Click(object sender, EventArgs e) { try{ bool flag = false; PUBLISHER p = new PUBLISHER(); p.Publisher_ID = Convert.ToInt32(pubid.Text); p.Publisher_Name = pubname.Text; p.Publisher_Address = pubaddress.Text; using (DataClasses1DataContext context = new DataClasses1DataContext()) { foreach (PUBLISHER p1 in context.PUBLISHERs) { if (p1.Publisher_ID == p.Publisher_ID || p1.Publisher_Name.ToLower() == p.Publisher_Name.ToLower()) { flag = true; } } if (flag == false) { context.PUBLISHERs.InsertOnSubmit(p); context.SubmitChanges(); MessageBox.Show("Publisher added succesfully."); } else { MessageBox.Show("Same Id/Name found."); } } } catch (FormatException) { MessageBox.Show("Input Error."); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
partial void DeletePUBLISHER(PUBLISHER instance);
partial void UpdatePUBLISHER(PUBLISHER instance);
partial void InsertPUBLISHER(PUBLISHER instance);