public static List<Object> PassengerToList(PAUPassenger pass)
{
List<Object> objs = new List<object>();
objs.Add(pass.No);
objs.Add(pass.FirstName);
objs.Add(pass.LastName);
objs.Add(ConvertDateToString(pass.FlightDate));
objs.Add(pass.FlightNo);
objs.Add(ConvertDateToString(pass.Date));
objs.Add(pass.PNR);
objs.Add(pass.FareClass);
objs.Add(pass.SEQNo);
objs.Add(pass.SeatNo);
objs.Add(pass.Passport);
objs.Add(pass.Gender);
objs.Add(ConvertDateToString(pass.BirthDate));
objs.Add(pass.Nationality);
objs.Add(pass.Notes);
return objs;
}
public static List<int> PassengerColWidth(PAUPassenger pass)
{
List<int> objs = new List<int>();
objs.Add(5);
objs.Add(100);
objs.Add(100);
objs.Add(50);
objs.Add(10);
objs.Add(20);
objs.Add(10);
objs.Add(10);
objs.Add(10);
objs.Add(10);
objs.Add(30);
objs.Add(10);
objs.Add(20);
objs.Add(10);
objs.Add(100);
return objs;
}
private void UpdatePassenger(PAUPassenger passenger)
{
BeaCukai cukai = new BeaCukai();
if (passenger != null)
{
try
{
var existing = (from p in cukai.PAUPassenger
where
p.ID == passenger.ID
select p).First();
existing.Name = passenger.Name;
existing.BirthDate = passenger.BirthDate;
existing.CDst = passenger.CDst;
existing.Date = passenger.Date;
existing.FareClass = passenger.FareClass;
existing.FirstName = passenger.FirstName;
existing.FlightDate = passenger.FlightDate;
existing.FlightNo = passenger.FlightNo;
existing.Gender = passenger.Gender;
existing.LastName = passenger.LastName;
existing.Nationality = passenger.Nationality;
existing.Passport = passenger.Passport;
existing.PNR = passenger.PNR;
existing.SeatNo = passenger.SeatNo;
existing.SEQNo = passenger.SEQNo;
existing.Notes = passenger.Notes;
existing.Picture = passenger.Picture;
}
catch (Exception)
{
return;
}
cukai.SubmitChanges();
}
}
private void ReadAirAsia(BackgroundWorker worker, string filename, out DateTime flightDate, out string flightNo, out List<PAUPassenger> passengers)
{
flightDate = DateTime.Now;
flightNo = "";
passengers = new List<PAUPassenger>();
using (StreamReader reader = new StreamReader(filename))
{
char[] separator = { ',', '/' };
string line;
bool parse = false;
bool isNoShow = false;
int lineNo = 1;
while ((line = reader.ReadLine()) != null)
{
if (worker != null)
{
worker.ReportProgress(lineNo, line);
}
lineNo++;
if (line.Contains("Checked-in/Boarded:") || line.Contains("No Shows"))
{
parse = true;
if (line.Contains("No Shows"))
{
isNoShow = true;
}
else
{
isNoShow = false;
}
continue;
}
if (line.Trim() == "")
{
parse = false;
}
if (line.Contains("Flight:") && line.Contains("Date:"))
{
int flightPos = line.IndexOf("Flight:") + 7;
int datePos = line.IndexOf("Date:") + 5;
string fNo = line.Substring(flightPos, 6).Trim();
string date = line.Substring(datePos, 14).Trim();
string[] dates = date.Split(separator);
ConvertPAXStringToDate(dates[0], out flightDate);
flightNo = fNo;
continue;
}
if (parse && line.Length >= 79)
{
string num = line.Substring(0, 3).Trim();
bool acc = true;
try
{
int testNum = Int32.Parse(num);
}
catch (Exception)
{
acc = false;
}
if (acc)
{
string name = line.Substring(4, 26).Trim();
string[] names = name.Split(separator, 26);
string pnr = line.Substring(35, 6).Trim();
string fare_class = line.Substring(42, 7).Trim();
string seq_no = line.Substring(52, 3).Trim();
string date = line.Substring(55, 7).Trim();
string seat_no = line.Substring(64, 6).Trim();
string flight_no = line.Substring(75, 4).Trim();
//MessageBox.Show(num + "." + names[1] + "."+ names[0]+"."+pnr+"." + fare_class+"."+seq_no+"."+date+"."+seat_no+"."+flight_no);
DateTime dt;
ConvertPAXStringToDate(date, out dt);
PAUPassenger passenger = new PAUPassenger();
passenger.Date = dt;
passenger.FareClass = fare_class;
passenger.FlightNo = flight_no;
passenger.Gender = "-";
passenger.Name = name;
passenger.FirstName = names[1];
passenger.LastName = names[0];
passenger.Passport = "";
passenger.PNR = pnr;
passenger.SeatNo = seat_no;
passenger.SEQNo = seq_no;
passenger.FlightDate = flightDate;
passenger.Notes = isNoShow ? "No Show" : "";
passenger.CDst = "";
passengers.Add(passenger);
}
}
}
}
}
private int UpdateRecord(PAUPassenger passenger)
{
int rowsAffected = 0;
try
{
// 0 = pnr, 1 = gender, 2 = nationality
// 4 = first_name, 5 = last_name, 6 = flight_date, 7 = flight_no
string sql = string.Format("UPDATE pau_passenger SET pnr='{0}', gender='{1}', nationality='{2}', birth_date='{3}' " +
"WHERE first_name='{4}' && last_name='{5}' && flight_date='{6}' && flight_no='{7}'",
passenger.PNR, passenger.Gender, passenger.Nationality, ConvertDateToMySql(passenger.BirthDate.Value),
passenger.FirstName, passenger.LastName, ConvertDateToMySql(passenger.FlightDate.Value), passenger.FlightNo);
//MessageBox.Show(passenger.Gender+"\n"+sql);
MySqlConnection con = new MySqlConnection(MySqlSettings.Instance.ConnectionString());
MySqlCommand cmd = new MySqlCommand(sql, con);
con.Open();
rowsAffected = cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
return rowsAffected;
}
