private void SaveButton_Click(object sender, EventArgs e)
{
if (updateAppId == 0)
{
string query = "insert into FullApplication(AppDate, AppNumContract, AppFullName, AppNameOrgOrPF, AppCountry, AppWay, AppStartTour, AppNumDays, AppNumNights, AppNumPeople,AppNumOldPeople, AppNumChildren, AppChildrensAge, AppCategory, AppNotes, AppNumDaysHealth, ArFood, ArBase, ArCost, ArCostWithoutProcent, ArSumPay, ArDateSumPay, ArDebt, ArOtherMoney, ArPhone, ArRoute, ArTransfer, ArTourProgram, ArVise, ArTicket, ArInsurance, AppTipe, AppAgentProcent) values (\'" +
inputAppDate.Text + "\', \'" +
inputNumContract.Text + "\', \'" +
inputAppFullName.Text + "\',\'" +
inputAppNameOrgOrPF.Text + "\',\'" +
inputAppCountry.Text + "\',\'" +
inputAppWay.Text + "\',\'" +
inputAppStartTour.Text + "\',\'" +
inputNumDays.Text + "\',\'" +
inputNumNights.Text + "\',\'" +
inputAppNumPeople.Text + "\',\'" +
inputAppOldPeople.Text + "\',\'" +
inputAppNumChildren.Text + "\',\'" +
inputAppChildAge.Text + "\',\'" +
inputAppNumberAndCategory.Text + "\',\'" +
inputAppNotes.Text + "\',\'" +
inputNumDaysHealth.Text + "\', \'" +
inputFood.Text + "\',\'" +
inputArBase.Text + "\',\'" +
inputAppCost.Text + "\',\'" +
inputAppCostWithoutProcent.Text + "\',\'" +
inputAppSumPay.Text + "\' , \'" +
inputAppDateSumPay.Text + "\',\'" +
inputAppDebt.Text + "\',\'" +
inputAppOtherMoney.Text + "\',\'" +
inputAppPhone.Text + "\',\'" +
inputRoute.Text + "\',\'" +
inputTransfer.Text + "\',\'" +
inputTourProgram.Text + "\',\'" +
inputVisa.Text + "\',\'" +
inputTick.Text + "\',\'" +
inputIns.Text + "\',\'" +
inputTipeApp.Text + "\',\'" +
inputAgentsProcent.Text + "\')";
string query2 = "insert into TouristsPayment(tourNumContract, tourDateAcc, tourSumAcc, tourPayAcc, tourOrderAcc, tourDateRec, tourSumRec, tourPayRec, tourOrderRec, tourDateDebt, tourSumDebt, tourPayDebt, tourOrderDebt, forTourJurTick, forTourDateTick, forTourSumTick, forTourPayTick, forTourOrderTick, forTourJurWay, forTourDateWay, forTourSumWay, forTourPayWay, forTourOrderWay, forTourJurIns, forTourDateIns, forTourSumIns, forTourPayIns, forTourOrderIns, forTourDocTick, forTourDocIns, forTourDocWay) values (\'" +
inputNumContract.Text + "\', \'" +
dateAcc.Text + "\', \'" +
sumAcc.Text + "\', \'" +
payAcc.Text + "\', \'" +
orderAcc.Text + "\', \'" +
dateRec.Text + "\', \'" +
sumRec.Text + "\', \'" +
payRec.Text + "\', \'" +
orderRec.Text + "\', \'" +
DateDeb.Text + "\', \'" +
sumDeb.Text + "\', \'" +
payDeb.Text + "\', \'" +
orderDeb.Text + "\', \'" +
jurTick.Text + "\', \'" +
dateTick.Text + "\', \'" +
sumTick.Text + "\', \'" +
payTick.Text + "\', \'" +
orderTick.Text + "\', \'" +
jurWay.Text + "\', \'" +
dateWay.Text + "\', \'" +
sumWay.Text + "\', \'" +
payWay.Text + "\', \'" +
orderWay.Text + "\', \'" +
jurIns.Text + "\', \'" +
dateIns.Text + "\', \'" +
sumIns.Text + "\', \'" +
payIns.Text + "\', \'" +
orderIns.Text + "\', \'" +
docTick.Text + "\', \'" +
docIns.Text + "\', \'" +
docWay.Text + "\')";
Database.executeQuery(query).Close();
Database.executeQuery(query2).Close();
ApplicationTableForm appTableForm = new ApplicationTableForm();
appTableForm.Show();
this.Close();
this.Close();
}
else {
string query3 = "update FullApplication set AppDate = \'" + inputAppDate.Text + "\', AppNumContract = \'" + inputNumContract.Text + "\', AppFullName = \'" + inputAppFullName.Text + "\', AppNameOrgOrPF = \'" + inputAppNameOrgOrPF.Text + "\', AppCountry = \'" + inputAppCountry.Text + "\', AppWay = \'" + inputAppWay.Text + "\', AppStartTour = \'" + inputAppStartTour.Text + "\', AppNumDays = \'" + inputNumDays.Text + "\', AppNumNights = \'" + inputNumNights.Text + "\', AppNumPeople = \'" + inputAppNumPeople.Text + "\', AppNumOldPeople = \'" + inputAppOldPeople.Text + "\', AppNumChildren = \'" + inputAppNumChildren.Text + "\', AppChildrensAge = \'" + inputAppChildAge.Text + "\', AppCategory = \'" + inputAppNumberAndCategory.Text + "\', AppNotes = \'" + inputAppNotes.Text + "\', AppNumDaysHealth = \'" + inputNumDaysHealth.Text + "\', ArFood = \'" + inputFood.Text + "\', ArBase = \'" + inputArBase.Text + "\', ArCost = \'" + inputAppCost.Text + "\', ArCostWithoutProcent = \'" + inputAppCostWithoutProcent.Text + "\', ArSumPay = \'" + inputAppSumPay.Text + "\', ArDateSumPay = \'" + inputAppDateSumPay.Text + "\', ArDebt = \'" + inputAppDebt.Text + "\', ArOtherMoney = \'" + inputAppOtherMoney.Text + "\', ArPhone = \'" + inputAppPhone.Text + "\', ArRoute = \'" + inputRoute.Text + "\', ArTransfer = \'" + inputTransfer.Text + "\', ArTourProgram = \'" + inputTourProgram.Text + "\', ArVise = \'" + inputVisa.Text + "\', ArTicket = \'" + inputTick.Text + "\', ArInsurance = \'" + inputIns.Text + "\', AppTipe = \'" + inputTipeApp.Text + "\', AppAgentProcent = \'" + inputAgentsProcent.Text + "\' where (AppId = " + updateAppId + ")";
string query4 = "update TouristsPayment set tourDateAcc = \'" + dateAcc.Text + "\', tourSumAcc = \'" + sumAcc.Text + "\', tourPayAcc = \'" + payAcc.Text + "\', tourOrderAcc = \'" + orderAcc.Text + "\', tourDateRec = \'" + dateRec.Text + "\', tourSumRec = \'" + sumRec.Text + "\', tourPayRec = \'" + payRec.Text + "\', tourOrderRec = \'" + orderRec.Text + "\', tourDateDebt = \'" + DateDeb.Text + "\', tourSumDebt = \'" + sumDeb.Text + "\', tourPayDebt = \'" + payDeb.Text + "\', tourOrderDebt = \'" + orderDeb.Text + "\', forTourJurTick = \'" + jurTick.Text + "\', forTourDateTick = \'" + dateTick.Text + "\', forTourSumTick = \'" + sumTick.Text + "\', forTourPayTick = \'" + payTick.Text + "\', forTourOrderTick = \'" + orderTick.Text + "\', forTourJurWay = \'" + jurWay.Text + "\', forTourDateWay = \'" + dateWay.Text + "\', forTourSumWay = \'" + sumWay.Text + "\', forTourPayWay = \'" + payWay.Text + "\', forTourOrderWay = \'" + orderWay.Text + "\', forTourJurIns = \'" + jurIns.Text + "\', forTourDateIns = \'" + dateIns.Text + "\', forTourSumIns = \'" + sumIns.Text + "\', forTourPayIns = \'" + payIns.Text + "\', forTourOrderIns = \'" + orderIns.Text + "\', forTourDocTick = \'" + docTick.Text + "\', forTourDocIns = \'" + docIns.Text + "\', forTourDocWay = \'" + docWay.Text + "\' where (tourNumContract = " + inputNumContract.Text + ")";
Database.executeQuery(query3).Close();
Database.executeQuery(query4).Close();
this.Close();
}
}
private void SaveButton_Click(object sender, EventArgs e)
{
if (updateAppId == 0)
{
string query = "insert into FullApplication(AppDate, AppNumContract, AppFullName, AppNameOrgOrPF, AppCountry, AppWay, AppStartTour, AppNumDays, AppNumNights, AppNumPeople,AppNumOldPeople, AppNumChildren, AppChildrensAge, AppCategory, AppNotes, AppNumDaysHealth, ArFood, ArBase, ArCost, ArCostWithoutProcent, ArSumPay, ArDateSumPay, ArDebt, ArOtherMoney, ArPhone, ArRoute, ArTransfer, ArTourProgram, ArVise, ArTicket, ArInsurance, AppTipe, AppAgentProcent) values (\'" +
inputAppDate.Text + "\', \'" +
inputNumContract.Text + "\', \'" +
inputAppFullName.Text + "\',\'" +
inputAppNameOrgOrPF.Text + "\',\'" +
inputAppCountry.Text + "\',\'" +
inputAppWay.Text + "\',\'" +
inputAppStartTour.Text + "\',\'" +
inputNumDays.Text + "\',\'" +
inputNumNights.Text + "\',\'" +
inputAppNumPeople.Text + "\',\'" +
inputAppOldPeople.Text + "\',\'" +
inputAppNumChildren.Text + "\',\'" +
inputAppChildAge.Text + "\',\'" +
inputAppNumberAndCategory.Text + "\',\'" +
inputAppNotes.Text + "\',\'" +
inputNumDaysHealth.Text + "\', \'" +
inputFood.Text + "\',\'" +
inputArBase.Text + "\',\'" +
inputAppCost.Text + "\',\'" +
inputAppCostWithoutProcent.Text + "\',\'" +
inputAppSumPay.Text + "\' , \'" +
inputAppDateSumPay.Text + "\',\'" +
inputAppDebt.Text + "\',\'" +
inputAppOtherMoney.Text + "\',\'" +
inputAppPhone.Text + "\',\'" +
inputRoute.Text + "\',\'" +
inputTransfer.Text + "\',\'" +
inputTourProgram.Text + "\',\'" +
inputVisa.Text + "\',\'" +
inputTick.Text + "\',\'" +
inputIns.Text + "\',\'" +
inputTipeApp.Text + "\',\'" +
inputAgentsProcent.Text + "\')";
string query2 = "insert into TouristsPayment(tourNumContract, tourDateAcc, tourSumAcc, tourPayAcc, tourOrderAcc, tourDateRec, tourSumRec, tourPayRec, tourOrderRec, tourDateDebt, tourSumDebt, tourPayDebt, tourOrderDebt, forTourJurTick, forTourDateTick, forTourSumTick, forTourPayTick, forTourOrderTick, forTourJurWay, forTourDateWay, forTourSumWay, forTourPayWay, forTourOrderWay, forTourJurIns, forTourDateIns, forTourSumIns, forTourPayIns, forTourOrderIns, forTourDocTick, forTourDocIns, forTourDocWay) values (\'" +
inputNumContract.Text + "\', \'" +
dateAcc.Text + "\', \'" +
sumAcc.Text + "\', \'" +
payAcc.Text + "\', \'" +
orderAcc.Text + "\', \'" +
dateRec.Text + "\', \'" +
sumRec.Text + "\', \'" +
payRec.Text + "\', \'" +
orderRec.Text + "\', \'" +
DateDeb.Text + "\', \'" +
sumDeb.Text + "\', \'" +
payDeb.Text + "\', \'" +
orderDeb.Text + "\', \'" +
jurTick.Text + "\', \'" +
dateTick.Text + "\', \'" +
sumTick.Text + "\', \'" +
payTick.Text + "\', \'" +
orderTick.Text + "\', \'" +
jurWay.Text + "\', \'" +
dateWay.Text + "\', \'" +
sumWay.Text + "\', \'" +
payWay.Text + "\', \'" +
orderWay.Text + "\', \'" +
jurIns.Text + "\', \'" +
dateIns.Text + "\', \'" +
sumIns.Text + "\', \'" +
payIns.Text + "\', \'" +
orderIns.Text + "\', \'" +
docTick.Text + "\', \'" +
docIns.Text + "\', \'" +
docWay.Text + "\')";
Database.executeQuery(query).Close();
Database.executeQuery(query2).Close();
ApplicationTableForm appTableForm = new ApplicationTableForm();
appTableForm.Show();
this.Close();
this.Close();
}
else
{
string query3 = "update FullApplication set AppDate = \'" + inputAppDate.Text + "\', AppNumContract = \'" + inputNumContract.Text + "\', AppFullName = \'" + inputAppFullName.Text + "\', AppNameOrgOrPF = \'" + inputAppNameOrgOrPF.Text + "\', AppCountry = \'" + inputAppCountry.Text + "\', AppWay = \'" + inputAppWay.Text + "\', AppStartTour = \'" + inputAppStartTour.Text + "\', AppNumDays = \'" + inputNumDays.Text + "\', AppNumNights = \'" + inputNumNights.Text + "\', AppNumPeople = \'" + inputAppNumPeople.Text + "\', AppNumOldPeople = \'" + inputAppOldPeople.Text + "\', AppNumChildren = \'" + inputAppNumChildren.Text + "\', AppChildrensAge = \'" + inputAppChildAge.Text + "\', AppCategory = \'" + inputAppNumberAndCategory.Text + "\', AppNotes = \'" + inputAppNotes.Text + "\', AppNumDaysHealth = \'" + inputNumDaysHealth.Text + "\', ArFood = \'" + inputFood.Text + "\', ArBase = \'" + inputArBase.Text + "\', ArCost = \'" + inputAppCost.Text + "\', ArCostWithoutProcent = \'" + inputAppCostWithoutProcent.Text + "\', ArSumPay = \'" + inputAppSumPay.Text + "\', ArDateSumPay = \'" + inputAppDateSumPay.Text + "\', ArDebt = \'" + inputAppDebt.Text + "\', ArOtherMoney = \'" + inputAppOtherMoney.Text + "\', ArPhone = \'" + inputAppPhone.Text + "\', ArRoute = \'" + inputRoute.Text + "\', ArTransfer = \'" + inputTransfer.Text + "\', ArTourProgram = \'" + inputTourProgram.Text + "\', ArVise = \'" + inputVisa.Text + "\', ArTicket = \'" + inputTick.Text + "\', ArInsurance = \'" + inputIns.Text + "\', AppTipe = \'" + inputTipeApp.Text + "\', AppAgentProcent = \'" + inputAgentsProcent.Text + "\' where (AppId = " + updateAppId + ")";
string query4 = "update TouristsPayment set tourDateAcc = \'" + dateAcc.Text + "\', tourSumAcc = \'" + sumAcc.Text + "\', tourPayAcc = \'" + payAcc.Text + "\', tourOrderAcc = \'" + orderAcc.Text + "\', tourDateRec = \'" + dateRec.Text + "\', tourSumRec = \'" + sumRec.Text + "\', tourPayRec = \'" + payRec.Text + "\', tourOrderRec = \'" + orderRec.Text + "\', tourDateDebt = \'" + DateDeb.Text + "\', tourSumDebt = \'" + sumDeb.Text + "\', tourPayDebt = \'" + payDeb.Text + "\', tourOrderDebt = \'" + orderDeb.Text + "\', forTourJurTick = \'" + jurTick.Text + "\', forTourDateTick = \'" + dateTick.Text + "\', forTourSumTick = \'" + sumTick.Text + "\', forTourPayTick = \'" + payTick.Text + "\', forTourOrderTick = \'" + orderTick.Text + "\', forTourJurWay = \'" + jurWay.Text + "\', forTourDateWay = \'" + dateWay.Text + "\', forTourSumWay = \'" + sumWay.Text + "\', forTourPayWay = \'" + payWay.Text + "\', forTourOrderWay = \'" + orderWay.Text + "\', forTourJurIns = \'" + jurIns.Text + "\', forTourDateIns = \'" + dateIns.Text + "\', forTourSumIns = \'" + sumIns.Text + "\', forTourPayIns = \'" + payIns.Text + "\', forTourOrderIns = \'" + orderIns.Text + "\', forTourDocTick = \'" + docTick.Text + "\', forTourDocIns = \'" + docIns.Text + "\', forTourDocWay = \'" + docWay.Text + "\' where (tourNumContract = " + inputNumContract.Text + ")";
Database.executeQuery(query3).Close();
Database.executeQuery(query4).Close();
this.Close();
}
}
private void LookAtApplications_Click(object sender, EventArgs e)
{
ApplicationTableForm appTableForm = new ApplicationTableForm();
appTableForm.ShowDialog();
}
private void LookAtApplications_Click(object sender, EventArgs e)
{
ApplicationTableForm appTableForm = new ApplicationTableForm();
appTableForm.ShowDialog();
}