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