public void initialData()
{
Admin newAdmin = new Admin
{
ID = "AD001",
name = "admin",
email = "*****@*****.**",
password = "******"
};
DB.conn.Store(newAdmin);
//Blue Bird
BlueBird car1 = new BlueBird
{
ID = "VH001",
type = "Limo",
seats = 4,
baseFee = 6500,
rate = 4000
};
BlueBird car2 = new BlueBird
{
ID = "VH002",
type = "Mobilio",
seats = 7,
baseFee = 7500,
rate = 5000
};
BlueBird car3 = new BlueBird
{
ID = "VH003",
type = "Transmover",
seats = 7,
baseFee = 7500,
rate = 5000
};
BlueBird car4 = new BlueBird
{
ID = "VH004",
type = "Serena",
seats = 6,
baseFee = 7000,
rate = 4500
};
DB.conn.Store(car1);
DB.conn.Store(car2);
DB.conn.Store(car3);
DB.conn.Store(car4);
//Silver Bird
SilverBird car5 = new SilverBird
{
ID = "VH005",
type = "Mercedes C200",
seats = 4,
baseFee = 13000,
rate = 7000
};
SilverBird car6 = new SilverBird
{
ID = "VH006",
type = "Alphard",
seats = 7,
baseFee = 17000,
rate = 9000
};
DB.conn.Store(car5);
DB.conn.Store(car6);
// Big Bird
BigBird car7 = new BigBird
{
ID = "VH007",
type = "Delta Long Chasis",
seats = 11,
baseFee = 1170000,
rate = 1500000
};
BigBird car8 = new BigBird
{
ID = "VH008",
type = "Delta Bus",
seats = 10,
baseFee = 1170000,
rate = 1500000
};
BigBird car9 = new BigBird
{
ID = "VH009",
type = "Commuter Bus",
seats = 14,
baseFee = 1530000,
rate = 2000000
};
BigBird car10 = new BigBird
{
ID = "VH010",
type = "Charlie Premium",
seats = 10,
baseFee = 1530000,
rate = 2000000
};
BigBird car11 = new BigBird
{
ID = "VH011",
type = "Bravo Bus",
seats = 25,
baseFee = 1920000,
rate = 2500000
};
BigBird car12 = new BigBird
{
ID = "VH012",
type = "Bravo Premium",
seats = 12,
baseFee = 2720000,
rate = 3700000
};
BigBird car13 = new BigBird
{
ID = "VH013",
type = "Alpha Bus 37",
seats = 37,
baseFee = 2670000,
rate = 3500000
};
BigBird car14 = new BigBird
{
ID = "VH014",
type = "Alpha Bus 44",
seats = 44,
baseFee = 2670000,
rate = 3500000
};
BigBird car15 = new BigBird
{
ID = "VH015",
type = "Alpha Bus 54",
seats = 54,
baseFee = 2670000,
rate = 3500000
};
BigBird car16 = new BigBird
{
ID = "VH016",
type = "Alpha Premium",
seats = 12,
baseFee = 6100000,
rate = 8500000
};
DB.conn.Store(car7);
DB.conn.Store(car8);
DB.conn.Store(car9);
DB.conn.Store(car10);
DB.conn.Store(car11);
DB.conn.Store(car12);
DB.conn.Store(car13);
DB.conn.Store(car14);
DB.conn.Store(car15);
DB.conn.Store(car16);
}
private void BtnSave_Click(object sender, EventArgs e)
{
var ID = txtID.Text;
var serviceType = cbService.SelectedIndex;
var vehicleType = txtType.Text;
var seats = Int32.Parse(nudSeats.Value.ToString());
var baseFee = txtBaseFee.Text;
var rate = txtRate.Text;
if (serviceType == 0)
{
MessageBox.Show("Service Type must be selected!");
}
else if (vehicleType.Equals(""))
{
MessageBox.Show("Vehicle Type can't be empty!");
}
else if (seats <= 0)
{
MessageBox.Show("Seats must be greater than 0!");
}
else if (baseFee.Equals(""))
{
MessageBox.Show("Base Fee can't be empty!");
}
else if (checkDigit(baseFee) != 0)
{
MessageBox.Show("Base Fee must be numeric!");
}
else if (Int32.Parse(baseFee) <= 0)
{
MessageBox.Show("Base Fee must be greater than 0!");
}
else if (rate.Equals(""))
{
MessageBox.Show("Rate can't be empty!");
}
else if (checkDigit(rate) != 0)
{
MessageBox.Show("Rate must be numeric!");
}
else if (Int32.Parse(rate) <= 0)
{
MessageBox.Show("Rate must be greater than 0!");
}
else
{
if (selectedButton == 1)
{
if (serviceType == 1)
{
var checkType = (from BlueBird x in DB.conn
where x.type == vehicleType
select x).ToList();
if (checkType.Count != 0)
{
MessageBox.Show("Vehicle type already exists for this service type!");
}
else
{
BlueBird newVehicle = new BlueBird
{
ID = ID,
type = vehicleType,
seats = seats,
baseFee = Int32.Parse(baseFee),
rate = Int32.Parse(rate)
};
DB.conn.Store(newVehicle);
MessageBox.Show("Success");
resetInitial();
}
}
else if (serviceType == 2)
{
var checkType = (from SilverBird x in DB.conn
where x.type == vehicleType
select x).ToList();
if (checkType.Count != 0)
{
MessageBox.Show("Vehicle type already exists for this service type!");
}
else
{
SilverBird newVehicle = new SilverBird
{
ID = ID,
type = vehicleType,
seats = seats,
baseFee = Int32.Parse(baseFee),
rate = Int32.Parse(rate)
};
DB.conn.Store(newVehicle);
MessageBox.Show("Success");
resetInitial();
}
}
else if (serviceType == 3)
{
var checkType = (from BigBird x in DB.conn
where x.type == vehicleType
select x).ToList();
if (checkType.Count != 0)
{
MessageBox.Show("Vehicle type already exists for this service type!");
}
else
{
BigBird newVehicle = new BigBird
{
ID = ID,
type = vehicleType,
seats = seats,
baseFee = Int32.Parse(baseFee),
rate = Int32.Parse(rate)
};
DB.conn.Store(newVehicle);
MessageBox.Show("Success");
resetInitial();
}
}
}
else if (selectedButton == 2)
{
var updateVehicle = (from Vehicle x in DB.conn
where x.ID == ID
select x).FirstOrDefault();
updateVehicle.type = vehicleType;
updateVehicle.seats = seats;
updateVehicle.baseFee = Int32.Parse(baseFee);
updateVehicle.rate = Int32.Parse(rate);
DB.conn.Store(updateVehicle);
MessageBox.Show("Success!");
resetInitial();
}
}
}
