public Boolean DeleteBookingToDatabase(TrainingSession session, GymMember member)
{
SqlCommand myCommand = new SqlCommand();
session.StartTime.AddMilliseconds(000);
long memberId = Convert.ToInt64(member.MemberID);
long sessionId = Convert.ToInt64(session.SessionId);
string commandText = $"delete from Booking where mId= '{memberId}' and tId = '{sessionId}';";
using (sqlCon = new SqlConnection(conString))
{
try
{
sqlCon.Open();
myCommand.CommandText = commandText;
myCommand.Connection = sqlCon;
int nbrOfRows = myCommand.ExecuteNonQuery();
if (nbrOfRows == 0)
{
return(false);
}
else
{
return(true);
}
}
catch (SqlException ex)
{
return(false);
}
}
}
private void GymMemberCombobox_SelectedIndexChanged(object sender, EventArgs e)
{
DataRowView rowView = BookGymMemberComboBox.SelectedItem as DataRowView;
GymMember temp = new GymMember();
temp.MemberID = (rowView[0]) as string;
BookTrainingGridView.DataSource = controller.DisplayBookingForObject(temp);
//BookTrainingGridView.Columns["startTime"].DefaultCellStyle.Format = "yyyy-MM-dd hh:mm";
}
public Boolean DeleteBooking(TrainingSession session, GymMember member)
{
if (dal.DeleteBookingToDatabase(session, member) == true)
{
return(true);
}
else
{
return(false);
}
}
//tar in värden från interface & skapar en ny member m.h.a. AddObjectToDatabase i dal
public GymMember CreateMember(string memberId, string memberName, string memberPhoneNumber, string memberAddress, string memberEmail)
{
GymMember newMember = new GymMember();
newMember.MemberID = memberId;
newMember.Name = memberName;
newMember.PhoneNumber = memberPhoneNumber;
newMember.Address = memberAddress;
newMember.Email = memberEmail;
return(dal.AddObjectToDatabase(newMember) as GymMember);
}
public Boolean CreateBooking(TrainingSession session, GymMember member)
{
Booking booking = new Booking();
booking.GymMember = member;
booking.TrainingSession = session;
booking.BookingId = CreateBookingId().ToString();
if (dal.AddBookingToDatabase(booking.BookingId, session, member) == true)
{
return(true);
}
else
{
return(false);
}
}
private void CreateBooking_Click(object sender, EventArgs e)
{
DataRowView memberRow = BookGymMemberComboBox.SelectedItem as DataRowView;
DataRowView sessionRow = BookTrainingSessionCombobox.SelectedItem as DataRowView;
GymMember member = new GymMember(memberRow[0].ToString());
TrainingSession session = new TrainingSession();
session.SessionId = sessionRow[0].ToString();
if (controller.CreateBooking(session, member) == true)
{
long memberId = Convert.ToInt64(member.MemberID);
long sessionId = Convert.ToInt64(session.SessionId);
BookingMessageTextBox.Text = $"booking for member = {memberId} added for Trainingsession = {sessionId}";
BookTrainingGridView.DataSource = controller.DisplayBookingForObject(member);
}
else
{
BookingMessageTextBox.Text = "booking already exists";
}
}
private void DeleteBooking_Click(object sender, EventArgs e)
{
DataRowView memberRow = BookGymMemberComboBox.SelectedItem as DataRowView;
DataRowView sessionRow = BookTrainingSessionCombobox.SelectedItem as DataRowView;
GymMember member = new GymMember();
member.MemberID = (memberRow[0].ToString());
TrainingSession session = new TrainingSession();
session.SessionId = sessionRow[0].ToString();
if (controller.DeleteBooking(session, member) == true)
{
BookingMessageTextBox.Text = $"booking for member = {member.MemberID} deleted for Trainingsession = {session.SessionId}";
BookTrainingGridView.DataSource = controller.DisplayBookingForObject(member);
}
else
{
BookingMessageTextBox.Text = "booking doesnt exist";
}
}
private void UpdateMemberButton_Click(object sender, EventArgs e)
{
if (MemberIDCombobox.SelectedItem != null)
{
DataRowView rowView = MemberIDCombobox.SelectedItem as DataRowView;
String memberId = (rowView[0]).ToString();
string name = MemberNameTextBox.Text;
string phoneNumber = MemberPhoneNumberTextBox.Text;
string address = MemberAddressTextBox.Text;
string email = MemberEmailTextBox.Text;
GymMember newMember = new GymMember(memberId, name, email, phoneNumber, address);
Console.WriteLine(newMember.Address + newMember.Name + newMember.Email + newMember.PhoneNumber);
controller.UpdateObject(newMember);
Console.WriteLine($"member {memberId} updated!");
this.Populate();
}
else
{
MemberResponseTextBox.Text = "select member to update";
}
}
private void DeleteMemberButton_Click(object sender, EventArgs e)
{
if (MemberIDCombobox.SelectedItem != null)
{
DataRowView rowView = MemberIDCombobox.SelectedItem as DataRowView;
GymMember newMember = new GymMember();
newMember.MemberID = (rowView[0]).ToString();
if (controller.DeleteObject(newMember) == true)
{
MemberResponseTextBox.Text = $"member {newMember.MemberID} deleted!";
this.Populate();
}
else
{
MemberResponseTextBox.Text = "cannot delete member that has made bookings on trainingsessions";
}
}
else
{
MemberResponseTextBox.Text = "select member to delete";
}
}
public Boolean AddBookingToDatabase(String bookingId, TrainingSession session, GymMember member)
{
SqlCommand myCommand = new SqlCommand();
long memberId = Convert.ToInt64(member.MemberID);
long sessionId = Convert.ToInt64(session.SessionId);
string commandText1 = $"select * from Booking b where b.tId='{sessionId}' and b.mId='{memberId}';";
string commandText2 = $"insert into Booking (bookingId,tId,mId) values('{bookingId}','{session.SessionId}','{member.MemberID}');";
using (sqlCon = new SqlConnection(conString))
{
try
{
sqlCon.Open();
SqlDataReader dr;
myCommand.CommandText = commandText1;
myCommand.Connection = sqlCon;
dr = myCommand.ExecuteReader();
if (!dr.HasRows)
{
dr.Close();
myCommand.CommandText = commandText2;
myCommand.Connection = sqlCon;
int nbrOfRows = myCommand.ExecuteNonQuery();
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
return(false);
}
}
}
