private void button2_Click(object sender, EventArgs e)
{
string roomID = textBox1.Text;
string SQL = "UPDATE Room SET CheckedIn = '" + false + "' WHERE RoomID='" + roomID + "'";
Main.databaseCon(SQL);
Main.updateRooms();
}
private void button1_Click(object sender, EventArgs e)
{
string roomID = textBox1.Text;
string SQL = "UPDATE Room SET Availability='Vacant', StartDate=NULL, EndDate=NULL, ID=NULL WHERE RoomID='" + roomID + "'";
Main.databaseCon(SQL);
Main.updateRooms();
}
private void button1_Click(object sender, EventArgs e)
{
if (goodPrice && CB1 && CB2)
{
string SQL = "UPDATE Room SET Price='" + newPrice + "' WHERE OceanView='" + OVorNOV + "' AND Beds ='1 " + QorK + "'";
Main.databaseCon(SQL);
Main.updateRooms();
}
}
public void updateVacantRooms()
{
int[] indexForRoomArrayList = new int[2];
indexForRoomArrayList[0] = 0;
indexForRoomArrayList[1] = 3;
String sql = "SELECT * FROM ROOM";
NTRoomArrayList = Main.databaseCon(sql, indexForRoomArrayList);
NTRoomList = NTRoomArrayList.Cast <String>().ToList();
this.listBox1.DataSource = NTRoomList;
}
public static void updateRooms()
{
int[] indexForRoomList = new int[4];
indexForRoomList[0] = 0;
indexForRoomList[1] = 4;
indexForRoomList[2] = 5;
indexForRoomList[3] = 3;
String command = "SELECT * FROM ROOM";
roomArrayList = Main.databaseCon(command, indexForRoomList);
roomList = roomArrayList.Cast <string>().ToList();
Main.listBox1.DataSource = roomList;
}
public void refreshPrice()
{
string sql = "SELECT Price FROM ROOM WHERE RoomID = '" + customerInfo[16] + "';";
int[] priceIndex = new int[1];
priceIndex[0] = 0;
ArrayList priceArrayList = new ArrayList();
priceArrayList = Main.databaseCon(sql, priceIndex);
price = double.Parse((string)priceArrayList[0]);
totalPrice = price * (dateTimePicker2.Value - dateTimePicker1.Value).Days;
totalPrice += price;
maskedTextBox8.Text = totalPrice.ToString();
}
private void button1_Click(object sender, EventArgs e)
{
NewTransactionReview transactionReview = new NewTransactionReview();
transactionReview.setCustomerInfo(customerInfo);
transactionReview.Show();
string SQL = "INSERT INTO AspNetUsers (UserName, ID, Email, EmailConfirmed, PhoneNumber, FirstName, LastName, Address, City, State, Zip, PhoneNumberConfirmed, TwoFactorEnabled, LockoutEnabled, AccessFailedCount) VALUES ('" + customerInfo[0] + customerInfo[1] + "','" + customerInfo[0] + customerInfo[1] + customerInfo[5] + "','" + customerInfo[7] + "','" + false + "','" + customerInfo[6] + "','" + customerInfo[0] + "','" + customerInfo[1] + "','" + customerInfo[2] + "','" + customerInfo[3] + "','" + customerInfo[4] + "','" + customerInfo[5] + "','" + false + "','" + false + "','" + false + "','" + 0 + "');";
string SQL2 = "UPDATE Room SET Availability='Occupied', StartDate='" + customerInfo[8] + "', EndDate='" + customerInfo[9] + "', ID='" + customerInfo[0] + customerInfo[1] + customerInfo[5] + "' WHERE RoomID='" + customerInfo[16] + "'";
string SQL3 = "INSERT INTO Transaction (Id, Amount) VALUES ('" + customerInfo[0] + customerInfo[1] + customerInfo[5] + "','" + maskedTextBox8.Text + "');";
string SQL4 = "INSERT INTO Account (id,PaymentType, CreditCardNumber) VALUES ('" + customerInfo[0] + customerInfo[1] + customerInfo[5] + "','" + customerInfo[10] + "','" + maskedTextBox7.Text + "');";
Console.WriteLine(SQL2);
Console.WriteLine(SQL3);
Console.WriteLine(SQL4);
Main.databaseCon(SQL);
Main.databaseCon(SQL2);
//Main.databaseCon(SQL4);
Main.databaseCon(SQL3);
Main.updateRooms();
}
