private void resdel_Click(object sender, RoutedEventArgs e)
{
// delete customer details code
try
{
if (r2.Text == "0" || r2.Text == "")
{
MessageBox.Show("Search Customer Details By their Mobile Numbers & then Delete .");
}
else
{
airlinqDataContext dc = new airlinqDataContext();
var c = new reservationdb();
var q = from a in dc.reservationdbs
where a.mobile == r2.Text
select a;
foreach (var cust in q)
{
dc.reservationdbs.DeleteOnSubmit(cust);
}
dc.SubmitChanges();
r1.Text = ""; r5.Text = "";
r2.Text = "0"; r3.Text = "0"; r6.Text = "0"; r7.Text = "0";
} // else closing
}
catch
{
MessageBox.Show("Search Customer by means of their mobile numbers & then Delete!");
}
}
private void adminbin_Click(object sender, RoutedEventArgs e)
{
// delete details code
try
{
if (mobilet.Text == "0" || mobilet.Text == "")
{
MessageBox.Show("Search Delete Details By their Mobile Numbers & then Delete .");
}
else
{
airlinqDataContext dc = new airlinqDataContext();
var c = new reservationdb();
var q = from a in dc.admindbs
where a.mobile == mobilet.Text
select a;
foreach (var cust in q)
{
dc.admindbs.DeleteOnSubmit(cust);
}
dc.SubmitChanges();
namet.Text = ""; mobilet.Text = "0"; nict.Text = "0"; passt.Password = ""; cpasst.Password = "";
} // else closing
}
catch
{
MessageBox.Show("Search Delete by means of their mobile numbers & then Delete!");
}
}
private void empbin_Click(object sender, RoutedEventArgs e)
{
// delete details code
try
{
if (mobilet.Text == "0" || mobilet.Text == "")
{
MessageBox.Show("Search Employee Details By their Mobile Numbers & then Delete .");
}
else
{
airlinqDataContext dc = new airlinqDataContext();
var c = new reservationdb();
var q = from a in dc.employeedbs
where a.mobile == mobilet.Text
select a;
foreach (var cust in q)
{
dc.employeedbs.DeleteOnSubmit(cust);
}
dc.SubmitChanges();
firstt.Text = ""; lastt.Text = ""; nationalityt.Text = ""; addresst.Text = ""; emailt.Text = ""; departt.Text = ""; positiont.Text = ""; feildt.Text = "";
mobilet.Text = "0";
} // else closing
}
catch
{
MessageBox.Show("Search Employee by means of their mobile numbers & then Delete!");
}
}
private void routebin_Click(object sender, RoutedEventArgs e)
{
// delete details code
try
{
if (modelt.Text == "0" || modelt.Text == "")
{
MessageBox.Show("Search route Details By flight model Numbers & then Delete .");
}
else
{
airlinqDataContext dc = new airlinqDataContext();
var c = new reservationdb();
var q = from a in dc.routesdbs
where a.model == modelt.Text
select a;
foreach (var cust in q)
{
dc.routesdbs.DeleteOnSubmit(cust);
}
dc.SubmitChanges();
fromt.Text = ""; tot.Text = ""; takeofft.Text = ""; landt.Text = "";
modelt.Text = "0";
} // else closing
}
catch
{
MessageBox.Show("Search route Details By flight model Numbers & then Delete!");
}
}
private void flightbin_Click(object sender, RoutedEventArgs e)
{
// delete customer details code
try
{
if (modelt.Text == "0" || modelt.Text == "")
{
MessageBox.Show("Search flight by means of their model numbers & then Delete .");
}
else
{
airlinqDataContext dc = new airlinqDataContext();
var q = from a in dc.flightdbs
where a.model == modelt.Text
select a;
foreach (var cust in q)
{
dc.flightdbs.DeleteOnSubmit(cust);
}
dc.SubmitChanges();
namet.Text = ""; typet.Text = ""; takeofft.Text = ""; landingt.Text = "";
modelt.Text = "0"; seatt.Text = "0"; cabint.Text = "0";
} // else closing
}
catch
{
MessageBox.Show("Search flight by means of their model numbers & then Delete!");
}
}
private void empmod_Click(object sender, RoutedEventArgs e)
{
// update details code
try
{
if (mobilet.Text == "0" || mobilet.Text == "")
{
MessageBox.Show("Search Employee Details By their Mobile Numbers & then Update .");
}
else
{
airlinqDataContext dc = new airlinqDataContext();
var query = from person in dc.employeedbs
where person.mobile == mobilet.Text
select person;
foreach (var c in query)
{
c.first = firstt.Text;
c.last = lastt.Text;
c.gender = gendercombo.SelectedValue.ToString();
c.nationality = nationalityt.Text;
c.joining = datet.SelectedDate;
c.mobile = mobilet.Text;
c.address = addresst.Text;
c.email = emailt.Text;
c.department = departt.Text;
c.position = positiont.Text;
c.field = feildt.Text;
}
dc.SubmitChanges();
firstt.Text = ""; lastt.Text = ""; nationalityt.Text = ""; addresst.Text = ""; emailt.Text = ""; departt.Text = ""; positiont.Text = ""; feildt.Text = "";
mobilet.Text = "0";
} // else closing
}
catch
{
MessageBox.Show("Search Employee by means of their mobile numbers & then Update Their Details .");
}
}
private void empsave_Click(object sender, RoutedEventArgs e)
{
// INSERT : CODE
try
{
if (firstt.Text == "" || lastt.Text == "" || nationalityt.Text == "" || addresst.Text == "" || emailt.Text == "" || departt.Text == "" || positiont.Text == "" || feildt.Text == "" || mobilet.Text == "0")
{
MessageBox.Show("Don't Leave Any TextBox Empty !");
}
else
{
var d = new airlinqDataContext();
var c = new employeedb();
c.first = firstt.Text;
c.last = lastt.Text;
c.gender = gendercombo.SelectedValue.ToString();
c.nationality = nationalityt.Text;
c.joining = datet.SelectedDate;
c.mobile = mobilet.Text;
c.address = addresst.Text;
c.email = emailt.Text;
c.department = departt.Text;
c.position = positiont.Text;
c.field = feildt.Text;
d.employeedbs.InsertOnSubmit(c);
d.SubmitChanges();
firstt.Text = ""; lastt.Text = ""; nationalityt.Text = ""; addresst.Text = ""; emailt.Text = ""; departt.Text = ""; positiont.Text = ""; feildt.Text = "";
mobilet.Text = "0";
MessageBox.Show("Inserted Successfully");
} // else closing
}
catch
{
MessageBox.Show("Issue With Database Handling ! Contact Database Administrator");
}
}
private void resmod_Click(object sender, RoutedEventArgs e)
{
// update customer details code
try
{
if (r2.Text == "0" || r2.Text == "")
{
MessageBox.Show("Search Customer Details By their Mobile Numbers & then Update .");
}
else
{
airlinqDataContext dc = new airlinqDataContext();
var query = from person in dc.reservationdbs
where person.mobile == r2.Text
select person;
foreach (var cust in query)
{
cust.name = r1.Text;
cust.mobile = r2.Text;
cust.passengers = r3.Text;
cust.flight = r4combo.Text;
cust.route = r5.Text;
cust.seats = r6.Text;
cust.payment = r7.Text;
}
dc.SubmitChanges();
r1.Text = ""; r5.Text = "";
r2.Text = "0"; r3.Text = "0"; r6.Text = "0"; r7.Text = "0";
} // else closing
}
catch
{
MessageBox.Show("Search Customer by means of their mobile numbers & then Update Their Details .");
}
}
private void flightmod_Click(object sender, RoutedEventArgs e)
{
// update customer details code
try
{
if (modelt.Text == "0" || modelt.Text == "")
{
MessageBox.Show("Search flight by means of their model numbers & then Update .");
}
else
{
airlinqDataContext dc = new airlinqDataContext();
var query = from person in dc.flightdbs
where person.model == modelt.Text
select person;
foreach (var c in query)
{
c.name = namet.Text;
c.type = typet.Text;
c.model = modelt.Text;
c.seats = seatt.Text;
c.cabins = cabint.Text;
c.takoff = takeofft.Text;
c.landing = landingt.Text;
}
dc.SubmitChanges();
namet.Text = ""; typet.Text = ""; takeofft.Text = ""; landingt.Text = "";
modelt.Text = "0"; seatt.Text = "0"; cabint.Text = "0";
} // else closing
}
catch
{
MessageBox.Show("Search flight by means of their model numbers & then Update Their Details .");
}
}
private void ressaveb_Click(object sender, RoutedEventArgs e)
{
// INSERT CUSTOMER : CODE
try
{
if (r1.Text == "" || r2.Text == "" || r3.Text == "" || r5.Text == "" || r6.Text == "" || r7.Text == "")
{
MessageBox.Show("Don't Leave Any TextBox Empty !");
}
else
{
var d = new airlinqDataContext();
var c = new reservationdb();
c.name = r1.Text;
c.mobile = r2.Text;
c.passengers = r3.Text;
c.flight = r4combo.Text;
c.route = r5.Text;
c.seats = r6.Text;
c.payment = r7.Text;
d.reservationdbs.InsertOnSubmit(c);
d.SubmitChanges();
r1.Text = ""; r5.Text = "";
r2.Text = "0"; r3.Text = "0"; r6.Text = "0"; r7.Text = "0";
MessageBox.Show("Inserted Successfully");
} // else closing
}
catch
{
MessageBox.Show("Issue With Database Handling ! Contact Database Administrator");
}
}
private void routemod_Click(object sender, RoutedEventArgs e)
{
// update details code
try
{
if (modelt.Text == "0" || modelt.Text == "")
{
MessageBox.Show("Search route Details By flight model Numbers & then Update .");
}
else
{
airlinqDataContext dc = new airlinqDataContext();
var query = from person in dc.routesdbs
where person.model == modelt.Text
select person;
foreach (var c in query)
{
c.name = namet.SelectedValue.ToString();
c.model = modelt.Text;
c.startdest = fromt.Text;
c.enddest = tot.Text;
c.takeoff = takeofft.Text;
c.landing = landt.Text;
}
dc.SubmitChanges();
fromt.Text = ""; tot.Text = ""; takeofft.Text = ""; landt.Text = "";
modelt.Text = "0";
} // else closing
}
catch
{
MessageBox.Show("Search route Details By flight model Numbers & then Update Their Details .");
}
}
private void adminmod_Click(object sender, RoutedEventArgs e)
{
// update details code
try
{
if (mobilet.Text == "0" || mobilet.Text == "")
{
MessageBox.Show("Search Admin Details By their Mobile Numbers & then Update .");
}
else
{
airlinqDataContext dc = new airlinqDataContext();
var query = from person in dc.admindbs
where person.mobile == mobilet.Text
select person;
foreach (var c in query)
{
c.name = namet.Text;
c.mobile = mobilet.Text;
c.nic = nict.Text;
c.pass = passt.Password;
c.cpass = cpasst.Password;
}
dc.SubmitChanges();
namet.Text = ""; mobilet.Text = "0"; nict.Text = "0"; passt.Password = ""; cpasst.Password = "";
} // else closing
}
catch
{
MessageBox.Show("Search Admin by means of their mobile numbers & then Update Their Details .");
}
}
private void flightsaveb_Click(object sender, RoutedEventArgs e)
{
// INSERT : CODE
try
{
if (namet.Text == "" || typet.Text == "" || takeofft.Text == "" || landingt.Text == "" || modelt.Text == "0" || seatt.Text == "0" || cabint.Text == "0")
{
MessageBox.Show("Don't Leave Any TextBox Empty !");
}
else
{
var d = new airlinqDataContext();
var c = new flightdb();
c.name = namet.Text;
c.type = typet.Text;
c.model = modelt.Text;
c.seats = seatt.Text;
c.cabins = cabint.Text;
c.takoff = takeofft.Text;
c.landing = landingt.Text;
d.flightdbs.InsertOnSubmit(c);
d.SubmitChanges();
namet.Text = ""; typet.Text = ""; takeofft.Text = ""; landingt.Text = "";
modelt.Text = "0"; seatt.Text = "0"; cabint.Text = "0";
MessageBox.Show("Inserted Successfully");
} // else closing
}
catch
{
MessageBox.Show("Issue With Database Handling ! Contact Database Administrator");
}
}
private void adminsave_Click(object sender, RoutedEventArgs e)
{
// INSERT : CODE
try
{
if (namet.Text == "" || mobilet.Text == "" || nict.Text == "" || passt.Password == "" || cpasst.Password == "")
{
MessageBox.Show("Don't Leave Any TextBox Empty !");
}
else
{
var d = new airlinqDataContext();
var c = new admindb();
c.name = namet.Text;
c.mobile = mobilet.Text;
c.nic = nict.Text;
c.pass = passt.Password;
c.cpass = cpasst.Password;
d.admindbs.InsertOnSubmit(c);
d.SubmitChanges();
namet.Text = ""; mobilet.Text = "0"; nict.Text = "0"; passt.Password = ""; cpasst.Password = "";
MessageBox.Show("Inserted Successfully");
} // else closing
}
catch
{
MessageBox.Show("Issue With Database Handling ! Contact Database Administrator");
}
}
private void routesave_Click(object sender, RoutedEventArgs e)
{
// INSERT : CODE
try
{
if (fromt.Text == "" || tot.Text == "" || takeofft.Text == "" || landt.Text == "" || modelt.Text == "0")
{
MessageBox.Show("Don't Leave Any TextBox Empty !");
}
else
{
var d = new airlinqDataContext();
var c = new routesdb();
c.name = namet.SelectedValue.ToString();
c.model = modelt.Text;
c.startdest = fromt.Text;
c.enddest = tot.Text;
c.takeoff = takeofft.Text;
c.landing = landt.Text;
d.routesdbs.InsertOnSubmit(c);
d.SubmitChanges();
fromt.Text = ""; tot.Text = ""; takeofft.Text = ""; landt.Text = "";
modelt.Text = "0";
MessageBox.Show("Inserted Successfully");
} // else closing
}
catch
{
MessageBox.Show("Issue With Database Handling ! Contact Database Administrator");
}
}