//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);
}
