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");
}
}
}
partial void UpdateFlight_Detail(Flight_Detail instance);
partial void DeleteFlight_Detail(Flight_Detail instance);
partial void InsertFlight_Detail(Flight_Detail instance);