private void AP_Cancel_FS_Click(object sender, EventArgs e) { //Air_Reservation_DBDataContext aPD = new Air_Reservation_DBDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Mzs Munna\documents\visual studio 2013\Projects\Air_Reservation_System\Air_Reservation_System\Air_Reservation.mdf;Integrated Security=True;Connect Timeout=30"); Airline_Reservation_SystemDBCDataContext aPD = new Airline_Reservation_SystemDBCDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Mzs Munna\Documents\Visual Studio 2013\Projects\Air_Reservation_System\Air_Reservation_System\Airline_Reservation_System.mdf;Integrated Security=True;Connect Timeout=30"); if (currentGridView == "Flight Details") { var x = from a in aPD.Flight_Details where a.Flight_ID == flightListNo select a; foreach (Flight_Detail p in x) { aPD.Flight_Details.DeleteOnSubmit(p); } aPD.SubmitChanges(); AP_Gridview_Display.DataSource = aPD.Flight_Details; AP_Gridview_Display.SelectionMode = DataGridViewSelectionMode.FullRowSelect; } else { MessageBox.Show("Currently Displaying " + currentGridView + " Table!!"); } }
private void UI_Cancel_Reservation_Click(object sender, EventArgs e) { Airline_Reservation_SystemDBCDataContext uHCD = new Airline_Reservation_SystemDBCDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Mzs Munna\Documents\Visual Studio 2013\Projects\Air_Reservation_System\Air_Reservation_System\Airline_Reservation_System.mdf;Integrated Security=True;Connect Timeout=30"); var y = from b in uHCD.TicketBooked_Infos where b.CID == userID select b; //y.First().Flight_ID foreach (TicketBooked_Info p in y) { uHCD.TicketBooked_Infos.DeleteOnSubmit(p); } uHCD.SubmitChanges(); MessageBox.Show("Reservation Canceled"); var z = from c in uHCD.Flight_Details where c.Flight_ID == fID select c; z.First().Available_Seat_E_ = addES + esT; z.First().Available_Seat_B_ = addBS + bsT; uHCD.SubmitChanges(); UH_Flight_Name_TB.Text = ""; UH_Flight_Name_TB.Enabled = false; EconomySeatBox.Text = ""; EconomySeatBox.Enabled = false; Business_SeatBox.Text = ""; Business_SeatBox.Enabled = false; UH_Destination_TB.Text = ""; UH_Destination_TB.Enabled = false; UH_Departure_TB.Text = ""; UH_Departure_TB.Enabled = false; Time_Schedule_Box.Text = ""; Time_Schedule_Box.Enabled = false; Date_Schedule_Box.Text = ""; Date_Schedule_Box.Enabled = false; UI_Cancel_Reservation.Visible = false; }
private void AP_CancelReservation_Click(object sender, EventArgs e) { Airline_Reservation_SystemDBCDataContext aPD = new Airline_Reservation_SystemDBCDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Mzs Munna\Documents\Visual Studio 2013\Projects\Air_Reservation_System\Air_Reservation_System\Airline_Reservation_System.mdf;Integrated Security=True;Connect Timeout=30"); if (currentGridView == "Ticket Booking Details") { var x = from a in aPD.TicketBooked_Infos where a.CID == flightListNo select a; foreach (TicketBooked_Info p in x) { aPD.TicketBooked_Infos.DeleteOnSubmit(p); } aPD.SubmitChanges(); AP_Gridview_Display.DataSource = aPD.TicketBooked_Infos; AP_Gridview_Display.SelectionMode = DataGridViewSelectionMode.FullRowSelect; } }
private void CCI_Pay_Click(object sender, EventArgs e) { int warning = 0; cHName = CardHolderNameTB.Text; cCNo = CreditCardNoTB.Text; cCPc = CardPinNoTB.Text; cCEd = CCIEXD.Value.ToString("dd-MM-yyyy"); bool allDigitCCN = cCNo.All(char.IsDigit); bool allDigitCPC = cCPc.All(char.IsDigit); if ((cHName == "") || (cCNo == "") || (cCPc == "") || (cCEd == "")) { MessageBox.Show("Can't skip any field!!! Fill up all to proceed!"); } else { if (allDigitCCN == false) { MessageBox.Show("Invalid Credit Card Number"); warning = 3; } if (allDigitCPC == false) { MessageBox.Show("Invalid Pin Code Number"); warning = 2; } if (Regex.IsMatch(cHName, @"^[a-zA-Z ]{2,30}$") == true) { //MessageBox.Show("valid name no number upto 30!"); //nameV = 1; } else { MessageBox.Show("Invalid Card Holder name"); warning = 1; } if (warning == 0) { int cusID = Convert.ToInt32(cID); //string path=Path.GetRandomFileName(); //path=path.Replace(".",""); //cCount++; string path = "12345" + cName; Customer_Info ciT = new Customer_Info { CID = cusID, CName = cName, CGender = cGender, CDOB = cDOB, CPhone_Num = cPN, CEmail = cEID, CPassport_No = cPPNo, CNationality = cNationality, Card_Holder_Name = cHName, Credit_Card_No = Convert.ToInt32(cCNo), Card_Expire_Date = cCEd, CPassword = path }; ciD.Customer_Infos.InsertOnSubmit(ciT); ciD.SubmitChanges(); var x = from a in ciD.Flight_Details where a.Flight_ID == flightListNo select a; string fN = x.First().Flight_Name; x.First().Available_Seat_E_ = sEAvail; x.First().Available_Seat_B_ = sBAvail; ciD.SubmitChanges(); var y = from b in ciD.Flight_Details //where a.Flight_Name == APSearchBox.Text where b.Available_Seat_B_ == 0 && b.Available_Seat_E_ == 0 select b; foreach (Flight_Detail p in y) { ciD.Flight_Details.DeleteOnSubmit(p); } ciD.SubmitChanges(); TicketBooked_Info tbT = new TicketBooked_Info { CID = cusID, CName = cName, Flight_ID = flightListNo, Flight_Name = fN, Business_Seat_Taken = intoB, Economy_Seat_Taken = intoE }; ciD.TicketBooked_Infos.InsertOnSubmit(tbT); ciD.SubmitChanges(); MessageBox.Show("Ticket Confirmation is Successfull!! :)\n\nYour User Password is : " + path + "\n\nyou can login with your user name using this password from login panel! "); this.Hide(); AIRRMainFrame mF = new AIRRMainFrame(); mF.Show(); } } }
private void AFP_Add_Flight_Button_Click(object sender, EventArgs e) { int warning = 0; int nameV = 0; string fids = ""; fids = AFP_FIDTB.Text; fName = AFP_Flight_Name_Box.Text; des = AFP_DestinationBox.Text; dep = AFP_DepertureBox.Text; date = AFP_Date.Value.ToString("dd-MM-yyyy"); time = AFP_Time.Value.ToString("H:mm"); availES = AFP_AvailESB.Text; availBS = AFP_AvailBSB.Text; ecoCost = AFP_EcoCostBox.Text; bsnsCost = AFP_BsnsCostBox.Text; bool allDigitAES = availES.All(char.IsDigit); bool allDigitABS = availBS.All(char.IsDigit); bool allDigitEC = ecoCost.All(char.IsDigit); bool allDigitBC = bsnsCost.All(char.IsDigit); bool allDigitFID = fids.All(char.IsDigit); int availES2I = 0; int availBS2I = 0; int ecoCost2I = 0; int bsnsCost2I = 0; if ((fName == "") || (des == "") || (dep == "") || (date == "") || (time == "") || (availES == "") || (availBS == "") || (ecoCost == "") || (bsnsCost == "") || (fids == "")) { MessageBox.Show("Can't skip any field!!! Fill up all to proceed!"); } else { if (allDigitAES == false) { MessageBox.Show("Number of Economy seat is invalid"); warning = 1; } else { availES2I = Convert.ToInt32(availES); } if (allDigitFID == false) { MessageBox.Show("Number of Economy seat is invalid"); warning = 1; } else { fID = Convert.ToInt32(fids); } if (allDigitABS == false) { MessageBox.Show("Number of Business seat is invalid"); warning = 2; } else { availBS2I = Convert.ToInt32(availBS); } if (allDigitEC == false) { MessageBox.Show("Economy Seeat Amount is invalid"); warning = 3; } else { ecoCost2I = Convert.ToInt32(ecoCost); } if (allDigitBC == false) { MessageBox.Show("Business Seat Amount is invalid"); warning = 4; } else { bsnsCost2I = Convert.ToInt32(bsnsCost); } if (Regex.IsMatch(des, @"^[a-zA-Z]+$") == true) //all character { //MessageBox.Show("All are letters"); } else { MessageBox.Show("Not a valid Destination!"); warning = 5; } if (Regex.IsMatch(dep, @"^[a-zA-Z]+$") == true) //all character { //MessageBox.Show("All are letters"); } else { MessageBox.Show("Not a valid Departure!"); warning = 6; } if (Regex.IsMatch(fName, @"^[a-zA-Z ]{2,30}$") == true) { //MessageBox.Show("valid name no number upto 30!"); nameV = 1; } else { //MessageBox.Show("Invalid name"); warning = 1; } if (nameV == 0) { if (Regex.IsMatch(fName, @"^[a-zA-Z ]{2,26}[0-9]{1,4}$") == true) { //MessageBox.Show("at first letter then number up to 5"); warning = 0; } else { MessageBox.Show("Invalid name"); warning = 1; } } } if (status == "Add") { if (warning == 0) { Flight_Detail fdT = new Flight_Detail { Flight_ID = fID, Flight_Name = fName, Destination = des, Departure = dep, Date = date, Time = time, Available_Seat_E_ = availES2I, Available_Seat_B_ = availBS2I, Economy_Cost_BDT_ = ecoCost2I, Business_Cost_BDT_ = bsnsCost2I }; aFPD.Flight_Details.InsertOnSubmit(fdT); aFPD.SubmitChanges(); this.Hide(); apDGV.DataSource = aFPD.Flight_Details; MessageBox.Show("Flight Added Successfully"); } } else if (status == "Update") { var x = from a in aFPD.Flight_Details where a.Flight_ID == flightListNo select a; if (warning == 0) { x.First().Flight_Name = fName; x.First().Destination = des; x.First().Departure = dep; x.First().Date = date; x.First().Time = time; x.First().Available_Seat_E_ = availES2I; x.First().Available_Seat_B_ = availBS2I; x.First().Economy_Cost_BDT_ = ecoCost2I; x.First().Business_Cost_BDT_ = bsnsCost2I; aFPD.SubmitChanges(); apDGV.DataSource = aFPD.Flight_Details; MessageBox.Show("Flight Updated Successfully"); this.Hide(); } else { MessageBox.Show("Something wnt wrong"); } } }
private void Cash_Payment_Click(object sender, EventArgs e) { int warning = 0; amount = Cash_Amount_TB.Text; bool allDigitCSH = amount.All(char.IsDigit); if (amount == "") { MessageBox.Show("Please Enter the Amount"); } else { if (allDigitCSH == false) { MessageBox.Show("Invalid Amount!!!"); warning = 3; } else { payment = Convert.ToInt32(amount); } if (warning == 0) { if (payment >= totalAmount) { int cusID = Convert.ToInt32(cID); //string path=Path.GetRandomFileName(); //path=path.Replace(".",""); //cCount++; string path = "12345" + cName; Customer_Info ciT = new Customer_Info { CID = cusID, CName = cName, CGender = cGender, CDOB = cDOB, CPhone_Num = cPN, CEmail = cEID, CPassport_No = cPPNo, CNationality = cNationality, //Card_Holder_Name=cHName, //Credit_Card_No=Convert.ToInt32(cCNo), //Card_Expire_Date=cCEd, CPassword = path }; cpD.Customer_Infos.InsertOnSubmit(ciT); cpD.SubmitChanges(); var x = from a in cpD.Flight_Details where a.Flight_ID == flightListNo select a; string fN = x.First().Flight_Name; x.First().Available_Seat_E_ = sEAvail; x.First().Available_Seat_B_ = sBAvail; cpD.SubmitChanges(); var y = from b in cpD.Flight_Details //where a.Flight_Name == APSearchBox.Text where b.Available_Seat_B_ == 0 && b.Available_Seat_E_ == 0 select b; foreach (Flight_Detail p in y) { cpD.Flight_Details.DeleteOnSubmit(p); } cpD.SubmitChanges(); TicketBooked_Info tbT = new TicketBooked_Info { CID = cusID, CName = cName, Flight_ID = flightListNo, Flight_Name = fN, Business_Seat_Taken = intoB, Economy_Seat_Taken = intoE }; cpD.TicketBooked_Infos.InsertOnSubmit(tbT); cpD.SubmitChanges(); if (payment > totalAmount) { payment = payment - totalAmount; MessageBox.Show("Your return back amount is : " + payment + " BDT"); } MessageBox.Show("Ticket Confirmation is Successfull!! :)\n\nYour User Password is : " + path + "\n\nyou can login with your user name using this password from login panel! "); this.Hide(); AIRRMainFrame mF = new AIRRMainFrame(); mF.Show(); } else if (payment < totalAmount) { MessageBox.Show("Your amount is Insufficient!!"); } } } }
private void UI_Update_IB_Click(object sender, EventArgs e) { Airline_Reservation_SystemDBCDataContext uHLD = new Airline_Reservation_SystemDBCDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Mzs Munna\Documents\Visual Studio 2013\Projects\Air_Reservation_System\Air_Reservation_System\Airline_Reservation_System.mdf;Integrated Security=True;Connect Timeout=30"); //string cID = ""; string cName = ""; string cGender = ""; string cDOB = ""; string cPN = ""; string cEID = ""; string cPPNo = ""; string cNationality = ""; string cHName = ""; string cCrdN = ""; string cPass = ""; //x.First().CID = Convert.ToInt32(CIDTB.Text); cName = CustomerName.Text; cGender = CustomerGender.SelectedItem.ToString(); cDOB = CustomerDOB.Text; cPN = CustomerPN.Text; cEID = CustomerEID.Text; cPPNo = CustomerPassportNo.Text; cNationality = CustomerNationality.Text; cHName = CardHolderNameTB.Text; cCrdN = CreditCardNoTB.Text; cPass = User_Pass_TB.Text; bool allDigitPP = cPPNo.All(char.IsDigit); bool allDigitPN = cPN.All(char.IsDigit); bool allDigitCCNo = cCrdN.All(char.IsDigit); int warning = 0; int nameV = 0; if ((cName == "") || (cGender == "") || (cDOB == "") || (cPN == "") || (cEID == "") || (cNationality == "") || (cPPNo == "")) { MessageBox.Show("Can't keep any field blank!!! Fill up all to proceed!"); } else { if (allDigitPP == false) { MessageBox.Show("Invalid Passport Number"); warning = 3; } if (allDigitPN == false) { MessageBox.Show("Invalid Phone Number"); warning = 4; } if (allDigitCCNo == false) { MessageBox.Show("Invalid ID Number"); warning = 5; } if (Regex.IsMatch(cNationality, @"^[a-zA-Z]+$") == true) //all character { //MessageBox.Show("All are letters"); } else { MessageBox.Show("Not a valid Nation!"); warning = 6; } if (Regex.IsMatch(cHName, @"^[a-zA-Z]+$") == true) //all character { //MessageBox.Show("All are letters"); } else { MessageBox.Show("Not a valid Card Holder Name!"); warning = 7; } if (Regex.IsMatch(cName, @"^[a-zA-Z ]{2,30}$") == true) { //MessageBox.Show("valid name no number upto 30!"); nameV = 1; } else { //MessageBox.Show("Invalid name"); warning = 1; } if (nameV == 0) { if (Regex.IsMatch(cName, @"^[a-zA-Z ]{2,26}[0-9]{1,4}$") == true) { //MessageBox.Show("at first letter then number up to 5"); warning = 0; } else { MessageBox.Show("Invalid name"); warning = 1; } } if (Regex.IsMatch(cEID, @"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,3})+)$") == true) { //MessageBox.Show("VALID EMAIL ID"); //warning = 0; } else { MessageBox.Show("Invalid email id"); warning = 2; } if (warning == 0) { //MessageBox.Show("Go to next form! :) "+warning); //PaymentMethodPanel pMF=new PaymentMethodPanel(this, flightListNo, totalAmount, cID, cName, cGender, cDOB, cPN, cEID, cPPNo, cNationality,intoE,intoB,sEAvail,sBAvail); //pMF.Show(); //this.Hide(); var x = from a in uHLD.Customer_Infos where a.CID == userID select a; x.First().CID = Convert.ToInt32(CIDTB.Text); x.First().CName = CustomerName.Text; x.First().CGender = CustomerGender.Text; x.First().CDOB = CustomerDOB.Text; x.First().CPhone_Num = CustomerPN.Text; x.First().CEmail = CustomerEID.Text; x.First().CPassport_No = CustomerPassportNo.Text; x.First().CNationality = CustomerNationality.Text; x.First().Card_Holder_Name = CardHolderNameTB.Text; x.First().Credit_Card_No = Convert.ToInt32(CreditCardNoTB.Text); x.First().CPassword = User_Pass_TB.Text; uHLD.SubmitChanges(); MessageBox.Show("Update Successfull!"); UserHome uH2 = new UserHome(cLF, userID); this.Hide(); uH2.Show(); } } }