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