private bool action(string act)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
ottp = act == "insert" ? new OtobusTicketTypeRoute() : dc.OtobusTicketTypeRoutes.FirstOrDefault(id => id.Id == Convert.ToInt32(lbIdValue.Text));
ottp.IdOtobus = Convert.ToInt32(tbOtobus.Text.Trim());
ottp.IdTicketType = Convert.ToInt32(tbTicketType.Text.Trim());
ottp.IdRoute = Convert.ToInt32(tbRoute.Text.Trim());
string formatprice = tbPrice.Text.Trim().Replace(".", "");
ottp.Price = Convert.ToDecimal(formatprice);
if (act == "insert")
dc.OtobusTicketTypeRoutes.InsertOnSubmit(ottp);
dc.SubmitChanges();
ts.Complete();
if (act != "insert")
{
lbIdValue.Text = "";
lbIdValue.Visible = false;
lbID.Visible = false;
bCancel.Visible = false;
}
tbOtobus.ResetText();
tbOtobusName.ResetText();
tbTicketType.ResetText();
tbTicketTypeName.ResetText();
tbRoute.ResetText();
tbRouteDeparture.ResetText();
tbRouteDestination.ResetText();
tbPrice.ResetText();
return true;
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return false;
}
}
private void detach_OtobusTicketTypeRoutes(OtobusTicketTypeRoute entity)
{
this.SendPropertyChanging();
entity.Route = null;
}
partial void DeleteOtobusTicketTypeRoute(OtobusTicketTypeRoute instance);
partial void UpdateOtobusTicketTypeRoute(OtobusTicketTypeRoute instance);
partial void InsertOtobusTicketTypeRoute(OtobusTicketTypeRoute instance);
private void attach_OtobusTicketTypeRoutes(OtobusTicketTypeRoute entity)
{
this.SendPropertyChanging();
entity.TicketType = this;
}
private bool DeletePricing()
{
DialogResult dr = MessageBox.Show("Are you sure to delete this Ticket Type ?", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
try
{
ottp = dc.OtobusTicketTypeRoutes.FirstOrDefault(x => x.Id == Convert.ToInt32(dgPrice.CurrentRow.Cells[0].Value));
using (TransactionScope ts = new TransactionScope())
{
if (ottp != null)
{
dc.OtobusTicketTypeRoutes.DeleteOnSubmit(ottp);
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;
}
}
