private bool action(String act) { try { using(TransactionScope ts = new TransactionScope()) { tt = act == "insert" ? new TicketType() : dc.TicketTypes.Single(i => i.Id == Convert.ToInt32(lbIdValue.Text)); tt.TicketName = tbTicket.Text.Trim(); if (act == "insert") dc.TicketTypes.InsertOnSubmit(tt); dc.SubmitChanges(); ts.Complete(); if (act != "insert") { lbIdValue.Text = "0"; lbIdValue.Visible = false; lbID.Visible = false; bCancel.Visible = false; } tbTicket.ResetText(); return true; } } catch (Exception e) { MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return false; } }
private bool DeleteTicketType() { DialogResult dr = MessageBox.Show("Are you sure to delete this Ticket Type ?", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.Yes) { try { tt = dc.TicketTypes.FirstOrDefault(x => x.Id == Convert.ToInt32(dgTicket.CurrentRow.Cells[0].Value)); using (TransactionScope ts = new TransactionScope()) { if (tt != null) { dc.TicketTypes.DeleteOnSubmit(tt); dc.SubmitChanges(); ts.Complete(); return true; } else { return false; } } } catch (Exception e) { MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return false; } } else { return false; } }
partial void UpdateTicketType(TicketType instance);
partial void DeleteTicketType(TicketType instance);
partial void InsertTicketType(TicketType instance);