//Mehod to check do hava any booking in hall in same data public bool check_Booking(int ID_HALL, string DATE_BOOKING) { bool succes = false; DataSet1TableAdapters.BOOKINGTableAdapter UDA = new DataSet1TableAdapters.BOOKINGTableAdapter(); DataSet1.BOOKINGDataTable UTable; DataSet1.BOOKINGRow URow; UTable = UDA.GetDataBooking(); if (UTable.Rows.Count > 0) // we hava account { for (int i = 0; i <= UTable.Rows.Count - 1; i++) { URow = UTable.Rows[0] as DataSet1.BOOKINGRow; if (URow.ID_HALL == ID_HALL) { succes = true; } else { succes = false; } } } return(succes); }
public string addBooking(Booking booking) { DataSet1TableAdapters.BOOKINGTableAdapter UDA = new DataSet1TableAdapters.BOOKINGTableAdapter(); int IsAdd = 0; String Message = ""; bool IsBooking = check_Booking(booking.ID_HALL, booking.DATE_BOOKING); if (IsBooking == false) { Boolean sucess = InsertNewBooking(booking); if (sucess == true) { Message = "تم تسجيل حجزكم بنجاح"; IsAdd = 1; } else { //"cannot add your infromation" IsAdd = 0; Message = "can not add your Booking "; } } else { Message = "يوجد لديكم حجز سابق !!!!"; } var jsonData = new { IsAdd = IsAdd, Message = Message }; return(ser.Serialize(jsonData)); }
//--------------------------------------------------------------------- //Methoed to insert New booking public Boolean InsertNewBooking(Booking booking) { DataSet1TableAdapters.BOOKINGTableAdapter UDA = new DataSet1TableAdapters.BOOKINGTableAdapter(); int STATUE_BOOKING = 1; bool sucess = false; try { UDA.InsertBooking(booking.ID_Email, booking.ID_HALL, booking.DATE_BOOKING, STATUE_BOOKING, booking.NOTE_BOOKING); sucess = true; } catch (Exception ex) { sucess = false; //"cannot add your infromation" } return(sucess); }