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);
