private void changeButton_Click(object sender, RoutedEventArgs e)
{
if (dtgtourist.SelectedIndex >= 0)
{
TouristInfo tourist = new TouristInfo();
int index = dtgtourist.SelectedIndex;
tourist.Id = (dtgtourist.Items[index] as TouristInfo).Id;
tourist.FirstName = (dtgtourist.Items[index] as TouristInfo).FirstName;
tourist.LastName = (dtgtourist.Items[index] as TouristInfo).LastName;
tourist.Serial = (dtgtourist.Items[index] as TouristInfo).Serial;
tourist.Number = (dtgtourist.Items[index] as TouristInfo).Number;
tourist.TourId = (dtgtourist.Items[index] as TouristInfo).TourId;
tourist.PhoneNumber = (dtgtourist.Items[index] as TouristInfo).PhoneNumber;
tourist.DiscountId = (dtgtourist.Items[index] as TouristInfo).DiscountId;
tourist.TotalSum = dBforUsers.TourPrice(tourist.TourId) * (100 - dBforUsers.SelectDiscount(tourist.DiscountId)) / 100;
if (tourist.TotalSum == 0)
{
tourist.TotalSum = dBforUsers.TourPrice(tourist.TourId);
}
dBforUsers.UpdateTourist(tourist);
UpdateDatabase();
}
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
if (dtgtourist.SelectedIndex >= 0)
{
TouristInfo tourist = new TouristInfo();
int index = dtgtourist.SelectedIndex;
try
{
tourist.FirstName = (dtgtourist.Items[index] as TouristInfo).FirstName;
tourist.LastName = (dtgtourist.Items[index] as TouristInfo).LastName;
tourist.Serial = (dtgtourist.Items[index] as TouristInfo).Serial;
tourist.Number = (dtgtourist.Items[index] as TouristInfo).Number;
tourist.TourId = (dtgtourist.Items[index] as TouristInfo).TourId;
tourist.PhoneNumber = (dtgtourist.Items[index] as TouristInfo).PhoneNumber;
tourist.DiscountId = (dtgtourist.Items[index] as TouristInfo).DiscountId;
tourist.TotalSum = dBforUsers.TourPrice(tourist.TourId) * (100 - dBforUsers.SelectDiscount(tourist.DiscountId)) / 100;
if (tourist.TotalSum == 0)
{
tourist.TotalSum = dBforUsers.TourPrice(tourist.TourId);
}
dBforUsers.AddTourist(tourist);
dBforUsers.tourists.Add(tourist);
UpdateDatabase();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void deleteButton_Click(object sender, RoutedEventArgs e)
{
if (dtgtourist.SelectedIndex >= 0)
{
if (MessageBox.Show("Are you sure you want to delete", "Check", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
try
{
TouristInfo tourist = new TouristInfo();
int index = dtgtourist.SelectedIndex;
tourist.Id = (dtgtourist.Items[index] as TouristInfo).Id;
dBforUsers.tourists.Remove(dtgtourist.Items[index] as TouristInfo);
// dBStore.students.RemoveAt(index);
dBforUsers.DeleteTourist(tourist.Id);
UpdateDatabase();
}
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);
}
}
public void UpdateTourist(TouristInfo tourist)
{
try
{
using (SqlConnection sqlConnection = new SqlConnection(connectDB))
{
SqlCommand sqlCommand = new SqlCommand
{
CommandText = "sp_UpdateTourist",
CommandType = CommandType.StoredProcedure,
Connection = sqlConnection
};
SqlParameter sqlParameter = new SqlParameter
{
ParameterName = "@Lastname",
Value = tourist.LastName,
SqlDbType = System.Data.SqlDbType.NVarChar,
Size = 50
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "@FirstName",
Value = tourist.FirstName,
SqlDbType = SqlDbType.NVarChar,
Size = 50
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "@TourId",
Value = tourist.TourId,
SqlDbType = SqlDbType.Int
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "@DiscountId",
Value = tourist.DiscountId,
SqlDbType = SqlDbType.Int,
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "@Id",
Value = tourist.Id,
SqlDbType = SqlDbType.Int,
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "@TotalSum",
Value = tourist.TotalSum,
SqlDbType = SqlDbType.Float,
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "@Serial",
Value = tourist.Serial,
SqlDbType = SqlDbType.NVarChar,
Size = 50
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "@Number",
Value = tourist.Number,
SqlDbType = SqlDbType.NVarChar,
Size = 50
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "@PhoneNumber",
Value = tourist.PhoneNumber,
SqlDbType = SqlDbType.NVarChar,
Size = 50
};
sqlCommand.Parameters.Add(sqlParameter);
sqlConnection.Open();
if (sqlCommand.ExecuteNonQuery() > 0)
{
MessageBox.Show("Task completed succesfully");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
