private void Addbtn_Click_1(object sender, RoutedEventArgs e)
{
if (dtgadmtour.SelectedIndex >= 0)
{
TourInfo tour = new TourInfo();
int index = dtgadmtour.SelectedIndex;
try
{
tour.TourCountry = (dtgadmtour.Items[index] as TourInfo).TourCountry;
tour.TourCity = (dtgadmtour.Items[index] as TourInfo).TourCity;
tour.TourBegin = (dtgadmtour.Items[index] as TourInfo).TourBegin;
tour.TourEnd = (dtgadmtour.Items[index] as TourInfo).TourEnd;
tour.MaxSeats = (dtgadmtour.Items[index] as TourInfo).MaxSeats;
tour.CurrentSeats = (dtgadmtour.Items[index] as TourInfo).CurrentSeats;
tour.DiscountId = (dtgadmtour.Items[index] as TourInfo).DiscountId;
tour.Price = (dtgadmtour.Items[index] as TourInfo).Price;
dBForAdmin.AddTour(tour);
dBForAdmin.tours.Add(tour);
AdminUpdateDatabase();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void Chgbtn_Click_1(object sender, RoutedEventArgs e)
{
if (dtgadmtour.SelectedIndex >= 0)
{
TourInfo tour = new TourInfo();
int index = dtgadmtour.SelectedIndex;;
tour.TourCountry = (dtgadmtour.Items[index] as TourInfo).TourCountry;
tour.TourCity = (dtgadmtour.Items[index] as TourInfo).TourCity;
tour.Id = (dtgadmtour.Items[index] as TourInfo).Id;
tour.TourBegin = (dtgadmtour.Items[index] as TourInfo).TourBegin;
tour.TourEnd = (dtgadmtour.Items[index] as TourInfo).TourEnd;
tour.MaxSeats = (dtgadmtour.Items[index] as TourInfo).MaxSeats;
tour.CurrentSeats = (dtgadmtour.Items[index] as TourInfo).CurrentSeats;
tour.DiscountId = (dtgadmtour.Items[index] as TourInfo).DiscountId;
tour.Price = (dtgadmtour.Items[index] as TourInfo).Price;
dBForAdmin.UpdateTour(tour);
AdminUpdateDatabase();
}
}
private void Dltbtn_Click_1(object sender, RoutedEventArgs e)
{
if (dtgadmtour.SelectedIndex >= 0)
{
if (MessageBox.Show("Are you sure you want to delete", "Check", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
try
{
TourInfo tour = new TourInfo();
int index = dtgadmtour.SelectedIndex;
tour.Id = (dtgadmtour.Items[index] as TourInfo).Id;
//dBTravelAgency.tours.Remove(dtgadmtour.Items[index] as TourInfo);
// dBStore.students.RemoveAt(index);
dBForAdmin.DeleteTour(tour.Id);
AdminUpdateDatabase();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
public void AddTour(TourInfo tour)
{
try
{
using (SqlConnection sqlConnection = new SqlConnection(connectDB))
{
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand
{
CommandText = "sp_addtour",
CommandType = CommandType.StoredProcedure,
Connection = sqlConnection
};
SqlParameter sqlParameter = new SqlParameter
{
ParameterName = "@TourCountry",
Value = tour.TourCountry,
SqlDbType = System.Data.SqlDbType.NVarChar,
Size = 50
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "@TourCity",
Value = tour.TourCity,
SqlDbType = SqlDbType.NVarChar,
Size = 50
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "@TourBegin",
Value = tour.TourBegin,
SqlDbType = SqlDbType.Date
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "@TourEnd",
Value = tour.TourEnd,
SqlDbType = SqlDbType.Date,
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "@MaxSeats",
Value = tour.MaxSeats,
SqlDbType = SqlDbType.Int,
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "@CurrentSeats",
Value = tour.CurrentSeats,
SqlDbType = SqlDbType.Int,
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "@Price",
Value = tour.Price,
SqlDbType = SqlDbType.Money,
};
sqlCommand.Parameters.Add(sqlParameter);
if (sqlCommand.ExecuteNonQuery() > 0)
{
MessageBox.Show("Task completed succesfully");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void SelectAdminAll()
{
try
{
using (SqlConnection sqlConnection = new SqlConnection(connectDB))
{
string zapros = "select T.TourCountry,T.TourTown,Tim.TourBegin,Tim.TourEnd,T.MaxSeats,Tim.CurrentSeats,S.DiscountId,T.Price,T.id from dbo.Tour T join dbo.TourTime Tim on T.TourTimeId = Tim.Id join dbo.Seasons S on S.Id = T.SeasonId";
string zapros1 = "select u.LastName,u.FirstName,u.BirthDate,u.UserLogin,u.UserPassword,u.Id from dbo.UserPeson u where u.RoleName='User'";
sqlConnection.Open();
SqlCommand sqlComand = new SqlCommand
{
CommandText = zapros,
Connection = sqlConnection
};
SqlCommand sqlComand1 = new SqlCommand
{
CommandText = zapros1,
Connection = sqlConnection
};
using (SqlDataReader sqlDataReader1 = sqlComand1.ExecuteReader())
{
while (sqlDataReader1.Read())
{
User user = new User();
user.LastName = sqlDataReader1[0].ToString();
user.FirstName = sqlDataReader1[1].ToString();
user.BirthDate = Convert.ToDateTime(sqlDataReader1[2]);
user.Userlogin = sqlDataReader1[3].ToString();
user.UserPassword = sqlDataReader1[4].ToString();
user.Id = (int)sqlDataReader1[5];
users.Add(user);
}
}
using (SqlDataReader sqlDataReader = sqlComand.ExecuteReader())
{
while (sqlDataReader.Read())
{
TourInfo tour = new TourInfo();
tour.TourCountry = sqlDataReader[0].ToString();
tour.TourCity = sqlDataReader[1].ToString();
tour.TourBegin = Convert.ToDateTime(sqlDataReader[2]);
tour.TourEnd = Convert.ToDateTime(sqlDataReader[3]);
tour.MaxSeats = (int)sqlDataReader[4];
tour.CurrentSeats = (int)sqlDataReader[5];
tour.DiscountId = (int)sqlDataReader[6];
tour.Price = Convert.ToDouble(sqlDataReader[7]);
tour.Id = (int)sqlDataReader[8];
tours.Add(tour);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void SelectAll()
{
try
{
using (SqlConnection sqlConnection = new SqlConnection(connectDB))
{
string zapros = "select T.FirstName,T.LastName, doc.Serial,doc.Number,ph.PhoneNumber,pay.TourId[TourId],pay.DiscountId, pay.TotalSum,T.Id from dbo.Tourists T join dbo.Documents Doc on T.Id = Doc.TouristId join dbo.TouristsPhones ph on t.Id = ph.TouristId Join dbo.Payment pay on pay.TouristId = t.Id";
string zapros1 = "select T.TourCountry,T.TourTown,Tim.TourBegin,Tim.TourEnd,T.MaxSeats,Tim.CurrentSeats,S.DiscountId,T.Price,T.id from dbo.Tour T join dbo.TourTime Tim on T.TourTimeId = Tim.Id join dbo.Seasons S on S.Id = T.SeasonId";
string zapros2 = "select d.DiscountType,d.Number,d.Id from dbo.Discounts d ";
sqlConnection.Open();
SqlCommand sqlComand = new SqlCommand
{
CommandText = zapros,
Connection = sqlConnection
};
SqlCommand sqlComand1 = new SqlCommand
{
CommandText = zapros1,
Connection = sqlConnection
};
SqlCommand sqlComand2 = new SqlCommand
{
CommandText = zapros2,
Connection = sqlConnection
};
using (SqlDataReader sqlDataReader = sqlComand.ExecuteReader())
{
while (sqlDataReader.Read())
{
TouristInfo tourist = new TouristInfo();
tourist.FirstName = sqlDataReader[0].ToString();
tourist.LastName = sqlDataReader[1].ToString();
tourist.Serial = sqlDataReader[2].ToString();
if (string.IsNullOrWhiteSpace(tourist.Serial))
{
tourist.Serial = "-";
}
tourist.Number = sqlDataReader[3].ToString();
tourist.PhoneNumber = sqlDataReader[4].ToString();
tourist.TourId = (int)sqlDataReader[5];
tourist.DiscountId = (int)sqlDataReader[6];
tourist.TotalSum = Convert.ToDouble(sqlDataReader[7]);
tourist.Id = (int)sqlDataReader[8];
tourists.Add(tourist);
}
}
using (SqlDataReader sqlDataReader = sqlComand1.ExecuteReader())
{
while (sqlDataReader.Read())
{
TourInfo tour = new TourInfo();
tour.TourCountry = sqlDataReader[0].ToString();
tour.TourCity = sqlDataReader[1].ToString();
tour.TourBegin = Convert.ToDateTime(sqlDataReader[2]);
tour.TourEnd = Convert.ToDateTime(sqlDataReader[3]);
tour.MaxSeats = (int)sqlDataReader[4];
tour.CurrentSeats = (int)sqlDataReader[5];
tour.DiscountId = (int)sqlDataReader[6];
tour.Price = Convert.ToDouble(sqlDataReader[7]);
tour.Id = (int)sqlDataReader[8];
tours.Add(tour);
}
}
using (SqlDataReader sqlDataReader = sqlComand2.ExecuteReader())
{
while (sqlDataReader.Read())
{
Discount discount = new Discount();
discount.Type = sqlDataReader[0].ToString();
discount.Number = (int)sqlDataReader[1];
discount.Id = (int)sqlDataReader[2];
discounts.Add(discount);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}