private bool action(string act)
{
try
{
if (act != "insert")
{
string currentNik = dc.Passengers.First(i => i.Id == Convert.ToInt32(lbIdValue.Text)).NIK;
string Nik = tbNik.Text.Trim();
if (currentNik != Nik)
{
if (dc.Passengers.First(i => i.NIK == Nik) != null)
{
MessageBox.Show("NIK already taken", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
return false;
}
}
}
using (TransactionScope ts = new TransactionScope())
{
psngr = act == "insert" ? new Passenger() : dc.Passengers.FirstOrDefault(id => id.Id == Convert.ToInt32(lbIdValue.Text));
psngr.NIK = tbNik.Text.Trim();
psngr.FirstName = tbFirstName.Text.Trim();
psngr.LastName = tbLastName.Text.Trim();
psngr.Birthday = DateTime.ParseExact(dtpBirthday.Value.ToString("yyyy-MM-dd"), "yyyy-MM-dd", CultureInfo.InvariantCulture);
psngr.IdGender = Convert.ToInt32(cbGender.SelectedValue);
psngr.Address = rtbAddress.Text.Trim();
psngr.Town = tbTown.Text.Trim();
psngr.PostCode = String.IsNullOrEmpty(tbPostCode.Text.Trim()) ? null : tbPostCode.Text.Trim();
psngr.Phone = String.IsNullOrEmpty(tbPhone.Text.Trim()) ? null : tbPostCode.Text.Trim();
if (act == "insert")
dc.Passengers.InsertOnSubmit(psngr);
dc.SubmitChanges();
ts.Complete();
if (act != "insert")
{
lbIdValue.Text = "";
lbIdValue.Visible = false;
lbID.Visible = false;
bCancel.Visible = false;
}
tbNik.ResetText();
tbFirstName.ResetText();
tbLastName.ResetText();
cbGender.SelectedIndex = -1;
dtpBirthday.Value = DateTime.Parse(DateTime.Now.ToString("yyyy/MM/dd"));
rtbAddress.ResetText();
tbTown.ResetText();
tbPostCode.ResetText();
tbPhone.ResetText();
return true;
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return false;
}
}
private bool DeletePassenger()
{
DialogResult dr = MessageBox.Show("Are you sure to delete this Ticket Type ?", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
try
{
psngr = dc.Passengers.FirstOrDefault(x => x.Id == Convert.ToInt32(dgPassenger.CurrentRow.Cells[0].Value));
using (TransactionScope ts = new TransactionScope())
{
if (psngr != null)
{
dc.Passengers.DeleteOnSubmit(psngr);
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 DeletePassenger(Passenger instance);
partial void UpdatePassenger(Passenger instance);
partial void InsertPassenger(Passenger instance);
private void detach_Passengers(Passenger entity)
{
this.SendPropertyChanging();
entity.GenderList = null;
}
