private void ListViewLastContracts_DoubleClick(object sender, EventArgs e)
{
int id = Convert.ToInt32(listViewLastContracts.SelectedItems[0].Text);
PageController.DisplayContract(id);
this.Hide();
this.Dispose();
}
private void ListViewContracts_DoubleClick(object sender, EventArgs e)
{
//Open Contract with specified ID
int contractID = Convert.ToInt32(listViewContracts.SelectedItems[0].Text);
PageController.DisplayContract(contractID);
this.Hide();
this.Dispose();
}
private void PictureBoxSave_Click(object sender, EventArgs e)
{
int passengersNumber;
if (textBoxPassengersNumber.Text == "")
{
passengersNumber = 1;
}
else
{
passengersNumber = Convert.ToInt32(textBoxPassengersNumber.Text.Trim());
}
getNextContractID();
if (checkCapacityAvailable(passengersNumber))
{
string clientName = labelFirstName.Text + " " + labelLastName.Text;
string clientJMBG = labelJMBG.Text;
string clientPassport = labelPassportNumber.Text;
string clientAge = labelAge.Text;
string clientPhone = labelPhone.Text;
string clientEmail = labelEmail.Text;
string daysP = OfferDays.ToString();
string dateDeparture = date_departure.ToString("dd-MM-yyyy");
string dateReturn = date_return.ToString("dd-MM-yyyy");
string numOfPassengers = passengersNumber.ToString();
string fullPrice = labelFullPrice.Text;
string discount = labelDiscount.Text;
string sumPrice = labelSumPrice.Text;
string paidNowP = paidNow.ToString();
string leftToPay = (Convert.ToDecimal(labelSumPrice.Text) - paidNow).ToString();
string numOfPayments = textBoxNumPayments.Text.Trim();
string priceEachPayment = labelAmountPerPayment.Text;
string dateFirstPayment = dateTimePickerFirstPayment.Value.ToString("dd.MM.yyyy");
string dateLastPayment = dateTimePickerLastPayment.Value.ToString("dd.MM.yyyy");
string note = textBoxNote.Text.Trim();
if (radioButtonComplete.Checked == true)
{
//Insert new contract when paid now is complete
if (labelFirstName.Text != "" && OfferId != 0 && Data.id != 0 && User.UserID != 0 && textBoxPassengersNumber.Text != "0" && labelFullPrice.Text != "" && labelDiscount.Text != "" && labelSumPrice.Text != "")
{
SqlCommand cmd = conn.Command("INSERT INTO Contracts (contract_id,offer_id,client_id,employee_id, number_of_passengers, transport, full_price, discount, paid_now, sum_price, note) "
+ "VALUES(@ContractID, @OfferID, @ClientID, @EmployeeId, @NumOfPassenger, @Transport, @FullPrice, @Discount, @PaidNow, @SumPrice, @Note)");
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ContractID", contractID);
cmd.Parameters.AddWithValue("@OfferID", OfferId);
cmd.Parameters.AddWithValue("@ClientID", Data.id);
cmd.Parameters.AddWithValue("@EmployeeId", User.UserID);
cmd.Parameters.AddWithValue("@NumOfPassenger", passengersNumber);
cmd.Parameters.AddWithValue("@Transport", transport);
cmd.Parameters.AddWithValue("@FullPrice", Convert.ToDecimal(labelFullPrice.Text));
cmd.Parameters.AddWithValue("@Discount", Convert.ToDecimal(labelDiscount.Text));
cmd.Parameters.AddWithValue("@PaidNow", paidNow);
cmd.Parameters.AddWithValue("@SumPrice", Convert.ToDecimal(labelSumPrice.Text));
cmd.Parameters.AddWithValue("@Note", note);
try
{
conn.OpenConnection();
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
//create PDF file
new CreatePDF(contractID, touristGuideName, touristGuidePhone, touristGuideEmail, clientName, clientJMBG, clientPassport,
clientAge, clientPhone, clientEmail, OfferCountry, OfferCity, daysP, room, meals, dateDeparture, dateReturn, hotelName,
hotelAddress, hotelPhone, numOfPassengers, fullPrice, discount, sumPrice, paidNowP, leftToPay, numOfPayments, priceEachPayment,
dateFirstPayment, dateLastPayment);
MessageBox.Show("Contract is successfully saved.");
changeCapacityAvailable(passengersNumber, OfferId);
int IdOfContract = Convert.ToInt32(contractID.Remove(contractID.Length - 5));
PageController.DisplayContract(IdOfContract);
this.Hide();
this.Dispose();
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.CloseConnection();
}
}
else
{
MessageBox.Show("All fields are required. Please try again.");
}
}
else
{
//Insert new contract when paid now is none or half
if (labelFirstName.Text != "" && OfferId != 0 && Data.id != 0 && User.UserID != 0 && textBoxPassengersNumber.Text != "0" && labelFullPrice.Text != "" && labelDiscount.Text != "" && labelSumPrice.Text != "" && textBoxNumPayments.Text != "0" && textBoxNumPayments.Text != "" && labelAmountPerPayment.Text != "0")
{
SqlCommand cmd = conn.Command("INSERT INTO Contracts (contract_id,offer_id,client_id,employee_id, number_of_passengers, transport, full_price, discount, paid_now, sum_price, number_of_payments, price_each_payment, date_first_payment,date_last_payment, note) "
+ "VALUES(@ContractID, @OfferID, @ClientID, @EmployeeId, @NumOfPassenger, @Transport, @FullPrice, @Discount, @PaidNow, @SumPrice, @NumberOfPayments, @PriceOfEachPayment, @DateFirstPayment, @DateLastPayment, @Note)");
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ContractID", contractID);
cmd.Parameters.AddWithValue("@OfferID", OfferId);
cmd.Parameters.AddWithValue("@ClientID", Data.id);
cmd.Parameters.AddWithValue("@EmployeeId", User.UserID);
cmd.Parameters.AddWithValue("@NumOfPassenger", passengersNumber);
cmd.Parameters.AddWithValue("@Transport", transport);
cmd.Parameters.AddWithValue("@FullPrice", Convert.ToDecimal(labelFullPrice.Text));
cmd.Parameters.AddWithValue("@Discount", Convert.ToDecimal(labelDiscount.Text));
cmd.Parameters.AddWithValue("@PaidNow", paidNow);
cmd.Parameters.AddWithValue("@SumPrice", Convert.ToDecimal(labelSumPrice.Text));
cmd.Parameters.AddWithValue("@NumberOfPayments", Convert.ToInt32(textBoxNumPayments.Text));
cmd.Parameters.AddWithValue("@PriceOfEachPayment", Convert.ToDecimal(labelAmountPerPayment.Text));
cmd.Parameters.AddWithValue("@DateFirstPayment", dateTimePickerFirstPayment.Value);
cmd.Parameters.AddWithValue("@DateLastPayment", dateTimePickerLastPayment.Value);
cmd.Parameters.AddWithValue("@Note", note);
try
{
conn.OpenConnection();
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
//create PDF file
new CreatePDF(contractID, touristGuideName, touristGuidePhone, touristGuideEmail, clientName, clientJMBG, clientPassport,
clientAge, clientPhone, clientEmail, OfferCountry, OfferCity, daysP, room, meals, dateDeparture, dateReturn, hotelName,
hotelAddress, hotelPhone, numOfPassengers, fullPrice, discount, sumPrice, paidNowP, leftToPay, numOfPayments, priceEachPayment,
dateFirstPayment, dateLastPayment);
MessageBox.Show("Contract is successfully saved.");
changeCapacityAvailable(passengersNumber, OfferId);
int IdOfContract = Convert.ToInt32(contractID.Remove(contractID.Length - 5));
PageController.DisplayContract(IdOfContract);
this.Hide();
this.Dispose();
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.CloseConnection();
}
}
else
{
MessageBox.Show("All fields are required. Please try again.");
}
}
}
else
{
MessageBox.Show("There is no enough capacity available.");
}
}
private void PictureBoxViewContract_Click(object sender, EventArgs e)
{
PageController.DisplayContract(contractID);
this.Hide();
this.Dispose();
}