public static void GetTrips()
{
Trips = new List <Trip>();
//created a command
Command = new SqlCommand("SELECT * FROM Trip", Connection);
//excuted the command
Reader = Command.ExecuteReader();
//Reading Data
while (Reader.Read())
{
String TripId = (string)Reader["TripId"];
String TourGuideId = (string)Reader["TripId"];
String Type = (string)Reader["TripId"];
String Depature = (string)Reader["TripId"];
String Destination = (string)Reader["TripId"];
Double Discount = (Double)Reader["Discount"];
DateTime Start = (DateTime)Reader["Start"];
DateTime End = (DateTime)Reader["End"];
Byte[] TripImage = (Byte[])Reader["TripImage"];
TourGuide CurrentTourGuide = SelectTourGuide(TourGuideId);
Trip Obj = new Trip(TripId, CurrentTourGuide, Type, Depature, Destination, Discount, Start, End);
Obj.TripImage = new CustomImage(TripImage);
Trips.Add(Obj);
}
Reader.Close();
return;
}
public static void GetTourGuides()
{
TourGuides = new List <TourGuide>();
//created a command
Command = new SqlCommand("SELECT * from TourGuide", Connection);
Reader = Command.ExecuteReader();
//Reading Data
while (Reader.Read())
{
string Id = (string)Reader["Id"];
string Name = (string)Reader["Name"];
string Nationality = (string)Reader["Nationality"];
string Gender = (string)Reader["Gender"];
string Email = (string)Reader["Email"];
string PhoneNumber = (string)Reader["PhoneNumber"];
byte[] TourGuideImage = (byte[])Reader["TourGuideImage"];
TourGuide Obj = new TourGuide(Id, Name, Nationality, Gender, Email, PhoneNumber);
Obj.UserImage.SetImage(TourGuideImage);
TourGuides.Add(Obj);
}
Reader.Close();
return;
}
private static void GetTrips()
{
Trips = new List <Trip>();
//created a command
Command.CommandText = "SELECT * FROM Trip";
//excuted the command
Reader = Command.ExecuteReader();
//Reading Data
while (Reader.Read())
{
String TripId = (string)Reader["TripId"];
String TourGuideId = (string)Reader["TourGuideId"];
String Depature = (string)Reader["Depature"];
String Destination = (string)Reader["Destination"];
Double Discount = (Double)Reader["Discount"];
DateTime Start = (DateTime)Reader["TripStartDate"];
DateTime End = (DateTime)Reader["TripEndDate"];
Byte[] TripImage = (Byte[])Reader["Image"];
TourGuide CurrentTourGuide = SelectTourGuide(TourGuideId);
if (CurrentTourGuide == null)
{
continue;
}
Trip Obj = new Trip(TripId, CurrentTourGuide, Depature, Destination, Discount, Start, End);
Obj.TripImage = new CustomImage(TripImage);
Trips.Add(Obj);
CurrentTourGuide.Trips.Add(Obj);
}
Reader.Close();
return;
}
private void AddTourGuide(TourGuide t)
{
string name = t.Name, nationality = t.Nationality, phone_number = t.PhoneNumber,
language = t.Languages[0], gender = t.Gender, email = t.Email;
if (AddTourGuideFullData_Name.Text != "")
{
name = AddTourGuideFullData_Name.Text;
}
if (AddTourGuideFullData_Nationality.Text != "")
{
nationality = AddTourGuideFullData_Nationality.Text;
}
if (AddTourGuideFullData_PhoneNumber.Text != "")
{
phone_number = AddTourGuideFullData_PhoneNumber.Text;
}
if (AddTourGuideFullData_language.Text != "")
{
language = AddTourGuideFullData_language.Text;
}
if (AddTourGuideGender_ComboBox.Text != "")
{
gender = AddTourGuideGender_ComboBox.Text;
}
if (AddTourGuideFullData_Email.Text != "")
{
email = AddTourGuideFullData_Email.Text;
}
}
private static void GetTourGuides()
{
TourGuides = new List <TourGuide>();
//created a command
Command.CommandText = "SELECT * from TourGuide";
Reader = Command.ExecuteReader();
//Reading Data
while (Reader.Read())
{
string Id = (string)Reader["Id"];
string Name = (string)Reader["Name"];
string Nationality = (string)Reader["Nationality"];
string Language = (string)Reader["Language"];
string Gender = (string)Reader["Gender"];
string Email = (string)Reader["Email"];
string PhoneNumber = (string)Reader["PhoneNumber"];
byte[] TourGuideImage = (byte[])Reader["Image"];
TourGuide Obj = new TourGuide(Id, Name, Nationality, Language, Gender, Email, PhoneNumber);
Obj.UserImage = new CustomImage(TourGuideImage);
TourGuides.Add(Obj);
}
Reader.Close();
return;
}
public static void InsertTourGuide(TourGuide CurrentTourGuide)
{
Command = new SqlCommand($"INSERT INTO TourGuide values('{ CurrentTourGuide.Id }','{CurrentTourGuide.Name }' ," +
$" '{CurrentTourGuide.Nationality}','{ CurrentTourGuide.Gender}','{CurrentTourGuide.Email}'," +
$"'{CurrentTourGuide.PhoneNumber}', {CurrentTourGuide.UserImage.GetByteImage()})", Connection);
TourGuides.Add(CurrentTourGuide);
Command.ExecuteNonQuery();
return;
}
public static void InsertTourGuide(TourGuide CurrentTourGuide)
{
Command.CommandText = $"INSERT INTO TourGuide values('{ CurrentTourGuide.Id }','{CurrentTourGuide.Name }' ," +
$" '{CurrentTourGuide.Nationality}', '{CurrentTourGuide.Language}', '{ CurrentTourGuide.Gender}','{CurrentTourGuide.Email}'," +
$"'{CurrentTourGuide.PhoneNumber}', @image)";
Command.Parameters.AddWithValue("@image", CurrentTourGuide.UserImage.GetByteImage());
Command.ExecuteNonQuery();
Command.Parameters.Clear();
TourGuides.Add(CurrentTourGuide);
return;
}
private void ShowTourGuideFullData(TourGuide t)
{
CurrentPanelName_Label.Content = "TourGuide Full Data";
CurrentCanvas.Visibility = Visibility.Hidden;
CurrentCanvas = TourGuideFullData_Canvas;
CurrentCanvas.Visibility = Visibility.Visible;
TourGuideFullData_Name.Content = t.Name;
TourGuideFullData_Nationality.Content = t.Nationality;
TourGuideFullData_Id.Content = t.Id;
TourGuideFullData_Email.Content = t.Email;
TourGuideFullData_Gender.Content = t.Gender;
// TourGuideFullData_Language.Content = t.Languages[0].ToString();
TourGuideFullData_IMG.Source = t.UserImage.GetImage().Source;
TourGuideFullData_PhoneNumber.Content = t.PhoneNumber;
}
public MainWindow()
{
InitializeComponent();
DataBase.Intialize();
List <string> x = new List <string>();
x.Add("Arabic");
CurrentCanvas = Main_Canvas;
cus = new Customer("1", "Ali Ahmed", "Egyptian", x, "Male", "*****@*****.**", "01125567777");
cus.UserImage = new CustomImage("C:/Users/Hadil/Desktop/mejor-guia-natural_LPRIMA20180218_0060_27.jpg");
//Trip NewTrip = new Trip("2", DataBase.TourGuides[0], "General", "Alex", "Cairo", 0, new DateTime(2018, 5, 1), new DateTime(2018, 5, 10));
//NewTrip.TripImage = new CustomImage("D:/test.png");
//DataBase.InsertTrip(NewTrip);
t = new TourGuide("1", "Ahmed Gamal", "Egyptian", "Male", "*****@*****.**", "01145888");
t.UserImage = new CustomImage("C:/Users/Hadil/Desktop/mejor-guia-natural_LPRIMA20180218_0060_27.jpg");
int today = DateTime.Today.Day;
if (DataBase.Trips.Count != 0)
{
TripOfTheDay = DataBase.Trips[today % DataBase.Trips.Count]; //generate trip based on today's date
}
if (DataBase.TourGuides.Count != 0)
{
TourGuideOfTheMonth = TourGuide.GetBestTourGuide(DateTime.Today.Month - 1); //returns tour guide with maximum salary in the past month
}
if (TripOfTheDay != null)
{
TripOfTheDay_IMG.Source = TripOfTheDay.TripImage.GetImage().Source;
TripOfTheDay_Label.Content = TripOfTheDay.Departure + " - " + TripOfTheDay.Destination;
ActiveTrip = TripOfTheDay;
}
if (TourGuideOfTheMonth == null)
{
;
}
//Todo: add message
//There is no tour guides or max existing haas 0 salary in the past month
}
public static bool UpdateTourGuide(TourGuide CurrentTourGuide, string Id, string Name, string Nationality, string Gender, string Email, string PhoneNumber, CustomImage TourGuideImage)
{
if (CheckUniqueTourGuideId(Id) || CurrentTourGuide.Id == Id)
{
Command = new SqlCommand($"UPDATE Customer set Id = '{Id}', set Name = '{Name}', set Nationality = '{Nationality}', " +
$"set Gender = '{Gender}', set Email = '{Email}', set PhoneNumber = '{PhoneNumber}', " +
$"set TourGuideImage = {TourGuideImage.GetByteImage()} where Id = '{CurrentTourGuide.Id}'",
Connection);
CurrentTourGuide.Id = Id;
CurrentTourGuide.Name = Name;
CurrentTourGuide.Nationality = Nationality;
CurrentTourGuide.Gender = Gender;
CurrentTourGuide.Email = Email;
CurrentTourGuide.PhoneNumber = PhoneNumber;
CurrentTourGuide.UserImage = TourGuideImage;
return(true);
}
return(false);
}
public static void UpdateTourGuide(TourGuide CurrentTourGuide, string Id, string Name, string Nationality, string Language, string Gender, string Email, string PhoneNumber, CustomImage TourGuideImage)
{
//update databae
Command.CommandText = $"UPDATE TourGuide set Id = '{Id}', Name = '{Name}', Nationality = '{Nationality}', " +
$"Language = '{Language}', Gender = '{Gender}', Email = '{Email}', PhoneNumber = '{PhoneNumber}', " +
$"Image = @image where Id = '{CurrentTourGuide.Id}'";
Command.Parameters.AddWithValue("@image", TourGuideImage.GetByteImage());
Command.ExecuteNonQuery();
Command.Parameters.Clear();
//update object
CurrentTourGuide.Id = Id;
CurrentTourGuide.Name = Name;
CurrentTourGuide.Nationality = Nationality;
CurrentTourGuide.Gender = Gender;
CurrentTourGuide.Email = Email;
CurrentTourGuide.PhoneNumber = PhoneNumber;
CurrentTourGuide.UserImage = TourGuideImage;
}
/// <summary>
/// updates old TourGuide in database first then updates the object
/// </summary>
public static void UpdateTourGuide(TourGuide CurrentTourGuide, TourGuide NewTourGuide)
{
//update databae
Command.CommandText = $"UPDATE TourGuide set Id = '{NewTourGuide.Id}', Name = '{NewTourGuide.Name}', Nationality = '{NewTourGuide.Nationality}', " +
$"Language = '{NewTourGuide.Language}', Gender = '{NewTourGuide.Gender}', Email = '{NewTourGuide.Email}', PhoneNumber = '{NewTourGuide.PhoneNumber}', " +
$"Image = @image where Id = '{CurrentTourGuide.Id}'";
Command.Parameters.AddWithValue("@image", NewTourGuide.UserImage.GetByteImage());
Command.ExecuteNonQuery();
Command.Parameters.Clear();
//update object
CurrentTourGuide.Id = NewTourGuide.Id;
CurrentTourGuide.Name = NewTourGuide.Name;
CurrentTourGuide.Nationality = NewTourGuide.Nationality;
CurrentTourGuide.Language = NewTourGuide.Language;
CurrentTourGuide.Gender = NewTourGuide.Gender;
CurrentTourGuide.Email = NewTourGuide.Email;
CurrentTourGuide.PhoneNumber = NewTourGuide.PhoneNumber;
CurrentTourGuide.UserImage = NewTourGuide.UserImage;
}
public static void UpdateTrip(Trip CurrentTrip, string TripId, string TourGuideId, string Type, string Depature, string Destination, double Discount, DateTime Start, DateTime End, CustomImage TripImage)
{
//update database
//update Trip table
Command.CommandText = $"UPDATE Trips set TripId = '{TripId}', set TourGuideId = '{TourGuideId}', set Type = '{Type}', " +
$"set Depature = '{Depature}', set Destination = '{Destination}', set Discont = {Discount}, set Start = '{Start}'," +
$"set End = '{End}', set Image = @Image where TripId = '{CurrentTrip.TripId}'";
Command.Parameters.AddWithValue("@image", TripImage.GetByteImage());
Command.ExecuteNonQuery();
Command.Parameters.Clear();
//update TripsTickets Table
Command.CommandText = $"UPDATE TripsTickets set TripId = '{TripId}' where TripId = '{CurrentTrip.TripId}'";
Command.ExecuteNonQuery();
//update Transactions Table
Command.CommandText = $"UPDATE Transactions set TripId = '{TripId}' where TripId = '{CurrentTrip.TripId}'";
Command.ExecuteNonQuery();
//update objects
CurrentTrip.TripId = TripId;
//remove the trip from the previous TourGuide and add it to the new selected tourguide
CurrentTrip.Tour.Trips.Remove(CurrentTrip);
TourGuide NewTour = SelectTourGuide(TourGuideId);
CurrentTrip.Tour = NewTour;
NewTour.Trips.Add(CurrentTrip);
CurrentTrip.Type = Type;
CurrentTrip.Departure = Depature;
CurrentTrip.Destination = Destination;
CurrentTrip.Discount = Discount;
CurrentTrip.Start = Start;
CurrentTrip.End = End;
CurrentTrip.TripImage = TripImage;
}
public static bool UpdateTrip(Trip CurrentTrip, string TripId, string TourGuideId, string Type, string Depature, string Destination, double Discount, DateTime Start, DateTime End, CustomImage TripImage)
{
if (CheckUniqueTripId(TripId) || TripId == CurrentTrip.TripId)
{
Command = new SqlCommand($"UPDATE Trips set TripId = '{TripId}', set TourGuideId = '{TourGuideId}', set Type = '{Type}', " +
$"set Depature = '{Depature}', set Destination = '{Destination}', set Discont = {Discount}, set Start = '{Start}'," +
$"set End = '{End}', set Image = {TripImage.GetByteImage()} where TripId = '{CurrentTrip.TripId}'", Connection);
Command = new SqlCommand($"UPDATE TripsTickets set TripId = '{TripId}' where TripId = '{CurrentTrip.TripId}'");
Command = new SqlCommand($"UPDATE Transactions set TripId = '{TripId}' where TripId = '{CurrentTrip.TripId}'");
CurrentTrip.TripId = TripId;
TourGuide T = SelectTourGuide(TourGuideId);
CurrentTrip.Tour = T;
CurrentTrip.Type = Type;
CurrentTrip.Departure = Depature;
CurrentTrip.Destination = Destination;
CurrentTrip.Discount = Discount;
CurrentTrip.Start = Start;
CurrentTrip.End = End;
CurrentTrip.TripImage = TripImage;
Command.ExecuteNonQuery();
return(true);
}
return(false);
}
public MainWindow()
{
InitializeComponent();
DataBase.Intialize();
CurrentCanvas = CustomerFullDetails_Canvas;
List <string> l = new List <string>();
l.Add("Arabic");
cus = new Customer("1", "Ali Ahmed", "Egyption", l, "Male", "*****@*****.**", "0114849551");
cus.UserImage = new CustomImage("E:/test.JPG");
DataBase.Customers.Add(cus);
CurrentCanvas = Main_Canvas;
TourGuide t = new TourGuide("1", "ahmed", "egy", "male", "asa", "011");
t.UserImage = new CustomImage("E:/test.JPG");
DataBase.TourGuides.Add(t);
Trip trip = new Trip("2", t, "family", "Cairo", "Alex", 0, new DateTime(2017, 5, 4), new DateTime(2017, 6, 4));
trip.TripImage = new CustomImage("E:/test.JPG"); //Put a valid image just to test
DataBase.Trips.Add(trip);
Trip trip2 = new Trip("3", t, "test", "Rome", "Paris", 0, new DateTime(2017, 5, 4), new DateTime(2017, 6, 4));
trip2.TripImage = new CustomImage("E:/test.JPG"); //Put a valid image just to test
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
//DataBase.Trips.Add(trip2);
int today = DateTime.Today.Day;
if (DataBase.Trips.Count != 0)
{
TripOfTheDay = DataBase.Trips[today % DataBase.Trips.Count]; //generate trip based on today's date
}
if (DataBase.TourGuides.Count != 0)
{
TourGuideOfTheMonth = TourGuide.GetBestTourGuide(DateTime.Today.Month - 1); //returns tour guide with maximum salary in the past month
}
if (TripOfTheDay != null)
{
TripOfTheDay_IMG.Source = TripOfTheDay.TripImage.GetImage().Source;
TripOfTheDay_Label.Content = TripOfTheDay.Departure + " - " + TripOfTheDay.Destination;
}
if (TourGuideOfTheMonth == null)
{
;
}
//Todo: add message
//There is no tour guides or max existing haas 0 salary in the past month
}
public static void DeleteTourGuide(TourGuide CurrentTourGuide)
{
Command.CommandText = $"Delete From TourGuide where Id = '{CurrentTourGuide.Id}'";
Command.ExecuteNonQuery();
TourGuides.Remove(CurrentTourGuide);
}
private void EditTourGuideData(TourGuide t)
{
string name = t.Name, nationality = t.Nationality, phone_number = t.PhoneNumber,
gender = t.Gender, email = t.Email;
bool tourErrorFound = false;
// if (DataBase.CheckUniqueTourGuideId(t.Id) == true)
//{
// AddTourGuide_Error_ID.Content = "This id is already found!";
//tourErrorFound = true;
//}
//else AddTourGuide_Error_ID.Content = "";
//todo check unique id
if (EditTourGuideFullData_Name.Text == "")
{
EditTourGuide_Name_ErrorLabel.Content = "This field can't be empty!";
tourErrorFound = true;
}
else
{
EditTourGuide_Name_ErrorLabel.Content = "";
}
if (EditTourGuideFullData_Nationality.Text.Trim() == "")
{
EditTourGuide_Nationality_ErrorLabel.Content = "This field can't be empty!";
tourErrorFound = true;
}
else
{
EditTourGuide_Nationality_ErrorLabel.Content = "";
}
if (EditTourGuideFullData_Email.Text.Trim() == "")
{
EditTourGuide_Email_ErrorLabel.Content = "This field can't be empty!";
tourErrorFound = true;
}
else
{
EditTourGuide_Email_ErrorLabel.Content = "";
}
/* if (EditTourGuideFullData_Language.Text.Trim() == "")
* {
* EditTourGuide_Language_ErrorLabel.Content = "This field can't be empty!";
* tourErrorFound = true;
* }
* else EditTourGuide_Language_ErrorLabel.Content = "";
*/if (TourGuideGender_ComboBox.Text == "")
{
EditTourGuide_Gender_ErrorLabel.Content = "This field can't be empty!";
tourErrorFound = true;
}
else
{
EditTourGuide_Gender_ErrorLabel.Content = "";
}
if (EditTourGuideFullData_PhoneNumber.Text == "")
{
EditTourGuide_PhoneNumber_ErrorLabel.Content = "This field can't be empty!";
tourErrorFound = true;
}
else
{
EditTourGuide_PhoneNumber_ErrorLabel.Content = "";
}
if (SelectedPath == "")
{
EditTourGuide_Photo_ErrorLabel.Content = "This field can't be empty!";
tourErrorFound = true;
}
else
{
EditTourGuide_Photo_ErrorLabel.Content = "";
}
if (tourErrorFound == true)
{
return;
}
//TourGuide temp = new TourGuide(AddTourGuideFullData_Id.Text, AddTourGuideFullData_Name.Text, AddTourGuideFullData_Nationality.Text
// , AddTourGuideGender_ComboBox.Text, AddTourGuideFullData_Email.Text, AddTourGuideFullData_PhoneNumber.Text);
// temp.UserImage = new CustomImage(SelectedPath);
EditTourGuide_Name_ErrorLabel.Content = "";
EditTourGuide_Email_ErrorLabel.Content = "";
EditTourGuide_PhoneNumber_ErrorLabel.Content = "";
// EditTourGuide_Language_ErrorLabel.Content = "";
EditTourGuide_Gender_ErrorLabel.Content = "";
EditTourGuide_Nationality_ErrorLabel.Content = "";
name = EditTourGuideFullData_Name.Text;
nationality = EditTourGuideFullData_Nationality.Text;
phone_number = EditTourGuideFullData_PhoneNumber.Text;
// language = EditTourGuideFullData_Language.Text;
gender = TourGuideGender_ComboBox.Text;
email = EditTourGuideFullData_Email.Text;
// DataBase.UpdateTourGuide(t, t.Id, name, nationality, gender, email, phone_number, t.UserImage);
//Todo 7war el language
}