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();
     }
 }
Exemple #2
0
 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();
     }
 }
Exemple #3
0
 private void LookAtApplications_Click(object sender, EventArgs e)
 {
     ApplicationTableForm appTableForm = new ApplicationTableForm();
     appTableForm.ShowDialog();
 }
Exemple #4
0
        private void LookAtApplications_Click(object sender, EventArgs e)
        {
            ApplicationTableForm appTableForm = new ApplicationTableForm();

            appTableForm.ShowDialog();
        }