protected void Button1_Click(object sender, EventArgs e) { try { ValidateForceSaleValue(); try { ValidateIssurance(); RobotTableAdapters.CollateralType_PropertyTableAdapter robot = new RobotTableAdapters.CollateralType_PropertyTableAdapter(); RobotTableAdapters.InsuranceTableAdapter robotInsuranceTable = new RobotTableAdapters.InsuranceTableAdapter(); //initialize values int collateralId = Convert.ToInt32(Request.QueryString["collateralId"]); int CollateralTypeId = Convert.ToInt32(Request.QueryString["CollateralTypeId"]); double varForceSaleValue = 0; double varOpenMarketValue = 0; varForceSaleValue = Convert.ToDouble(ForceSaleValue.Text); varOpenMarketValue = Convert.ToDouble(OpenMarketValue.Text); //insert values into CollateralType_Property and retrieve max id as collateralDetailsId int collateralDetailsId = Convert.ToInt32(robot.Proc_insert_property(OwnershipLink.Text, Location.Text, Convert.ToInt32(state_id.SelectedValue), Name_ColDocument.Text, RefNo_ColDocument.Text, AddressWithLandMark.Text, Convert.ToInt32(PropertyType_id.SelectedValue), varForceSaleValue, varOpenMarketValue, "NULL", Convert.ToDateTime(DateOfValuation.Value), Convert.ToInt32(PropertyDevelopmentStatus.SelectedValue), OccupancyStatus_id.SelectedValue, collateralId, -1, Convert.ToInt32(NameOfValuer.SelectedValue), -1, property_desc.Text, "NULL")); hiddenDetailsId.Text = collateralDetailsId.ToString(); //see if he filled the insurance form, then run the block of code that will do the insrt into insurance table if (insuranceStatusId.SelectedValue == "1") { int varPeriodOfInsuranceCover = 0; double varAmountInsured = 0; varPeriodOfInsuranceCover = Convert.ToInt32(PeriodOfInsuranceCover.Text); varAmountInsured = Convert.ToDouble(AmountInsured.Text); robotInsuranceTable.Insert(Convert.ToInt32(insuranceStatusId.SelectedValue), Convert.ToInt32(InsuranceCover_id.SelectedValue), collateralDetailsId, CollateralTypeId, InsuranceCompany.Text, Convert.ToDateTime(DateOfInsurance.Value), varPeriodOfInsuranceCover, varAmountInsured, keyClause.Text, -1, Convert.ToInt32(InsuranceCompany.SelectedValue)); } else { robotInsuranceTable.Insert(Convert.ToInt32(insuranceStatusId.SelectedValue), null, collateralDetailsId, CollateralTypeId, null, DateTime.Now, null, null, null, Smart.GetEmployeeID(), null); } //enable and move focus to next tab, disable current tab ASPxPageControl1.TabPages[1].Enabled = true; //documenttype_id.SelectedIndex = 2; ASPxPageControl1.ActiveTabIndex = 1; } catch (Exception ex) { _errorMessageProperty.Text = ex.Message; } } catch (Exception _ex) { _errorMessageProperty_1.Text = _ex.Message; } }
protected void Button1_Click(object sender, EventArgs e) { try { ValidateIssurance(); // new RobotTableAdapters.InsuranceCompanyTableAdapter().Insert(); RobotTableAdapters.CollateralType_SalaryContractTableAdapter robot = new RobotTableAdapters.CollateralType_SalaryContractTableAdapter(); RobotTableAdapters.InsuranceTableAdapter robotInsuranceTable = new RobotTableAdapters.InsuranceTableAdapter(); //initialize values int collateralId = Convert.ToInt32(Request.QueryString["collateralId"]); int CollateralTypeId = Convert.ToInt32(Request.QueryString["CollateralTypeId"]); double varValueOfContract = 0; double varAPG = 0; varValueOfContract = Convert.ToDouble(ValueOfContract.Text); varAPG = Convert.ToDouble(APG.Text); //insert values into CollateralType_Cash and retrieve max id as collateralDetailsId int collateralDetailsId = Convert.ToInt32(robot.proc_insert_contract(NameOfInsuringBody.Text, OriginalContractor.Text, Convert.ToDateTime(ContractAwardDate.Value), PurposeOfContract.Text, RefNo.Text, varValueOfContract, varAPG, TenureOfContract.Text, Convert.ToDateTime(MaturityDate.Value), collateralId, Smart.GetEmployeeID(), thirdparty.Text, "NULL",2)); hiddenDetailsId.Text = collateralDetailsId.ToString(); //see if he filled the insurance form, then run the block of code that will do the insrt into insurance table if (FinInsuranceStatus_id.SelectedValue == "1" || FinInsuranceStatus_id.SelectedValue == "3") { int varPeriodOfInsuranceCover = 0; double varAmountInsured = 0; varPeriodOfInsuranceCover = Convert.ToInt32(FinPeriodofInsuranceCover.Text); varAmountInsured = Convert.ToDouble(FinAmountInsured.Text); robotInsuranceTable.Insert(Convert.ToInt32(FinInsuranceStatus_id.SelectedValue), Convert.ToInt32(InsuranceCover.SelectedValue), collateralDetailsId, CollateralTypeId, FinInsuranceCompany.Text, Convert.ToDateTime(FinDateOfInsurance.Value), varPeriodOfInsuranceCover, varAmountInsured, FinKeyClause.Text, Smart.GetEmployeeID(), Convert.ToInt32(FinInsuranceCompany.SelectedValue)); } else { robotInsuranceTable.Insert(Convert.ToInt32(FinInsuranceStatus_id.SelectedValue), null, collateralDetailsId, CollateralTypeId, null, null, null, null, null, Smart.GetEmployeeID(), null); } //enable and move focus to next tab, disable current tab ASPxPageControl1.TabPages[1].Enabled = true; ASPxPageControl1.ActiveTabIndex = 1; } catch (Exception ex) { _errorMessageSalary.Text = ex.Message; } }
protected void Button1_Click(object sender, EventArgs e) { // new RobotTableAdapters.InsuranceCompanyTableAdapter().Insert(); try { ValidateIssurance(); RobotTableAdapters.CollateralType_StockHypoTableAdapter robot = new RobotTableAdapters.CollateralType_StockHypoTableAdapter(); RobotTableAdapters.InsuranceTableAdapter robotInsuranceTable = new RobotTableAdapters.InsuranceTableAdapter(); //initialize values int collateralId = Convert.ToInt32(Request.QueryString["collateralId"]); int CollateralTypeId = Convert.ToInt32(Request.QueryString["CollateralTypeId"]); int varTypeOfStock = 0; int varInsuranceCover_id = 0; double varValueOfStock = 0; int varFrequencyOfValuation = 0; varTypeOfStock = Convert.ToInt32(TypeOfStock_id.SelectedValue); varValueOfStock = Convert.ToDouble(ValueOfStock_total.Text); varFrequencyOfValuation = Convert.ToInt32(FrequencyOfValuation.SelectedValue); varInsuranceCover_id = Convert.ToInt32(InsuranceCover_id.SelectedValue); //insert values into CollateralType_Cash and retrieve max id as collateralDetailsId int collateralDetailsId = Convert.ToInt32(robot.proc_insert_stockHypo(varTypeOfStock, ListOfStock.Text, InvoiceNo.Text, -1, varValueOfStock, NameOfStockValuer.Text, DateTime.Now, MethodOfValuation.Text, varFrequencyOfValuation, varInsuranceCover_id, collateralId, Smart.GetEmployeeID(), varFrequencyOfValuation, "NULL")); hiddenDetailsId.Text = collateralDetailsId.ToString(); //see if he filled the insurance form, then run the block of code that will do the insrt into insurance table if (insuranceStatusId.SelectedValue == "1") { int varPeriodOfInsuranceCover = 0; double varAmountInsured = 0; varPeriodOfInsuranceCover = Convert.ToInt32(StockPeriodOfInsuranceCover.Text); varAmountInsured = Convert.ToDouble(StockAmountInsured.Text); robotInsuranceTable.Insert(Convert.ToInt32(insuranceStatusId.SelectedValue), Convert.ToInt32(InsuranceCover_id.SelectedValue), collateralDetailsId, CollateralTypeId, InsuranceCompany.Text, DateTime.Now, varPeriodOfInsuranceCover, varAmountInsured, StockKeyClause.Text, Smart.GetEmployeeID(), Convert.ToInt32(InsuranceCompany.SelectedValue)); } else { robotInsuranceTable.Insert(Convert.ToInt32(insuranceStatusId.SelectedValue), null, collateralDetailsId, CollateralTypeId, null, DateTime.Now, null, null, null, Smart.GetEmployeeID(), null); } //enable and move focus to next tab, disable current tab ASPxPageControl1.TabPages[1].Enabled = true; ASPxPageControl1.ActiveTabIndex = 1; } catch (Exception ex) { _errorMessageStock.Text = ex.Message; } }
protected void Button1_Click(object sender, EventArgs e) { // new RobotTableAdapters.InsuranceCompanyTableAdapter().Insert(); try { ValidateIssurance(); RobotTableAdapters.CollateralType_CarEquipTableAdapter robot = new RobotTableAdapters.CollateralType_CarEquipTableAdapter(); RobotTableAdapters.InsuranceTableAdapter robotInsuranceTable = new RobotTableAdapters.InsuranceTableAdapter(); //initialize values int collateralId = Convert.ToInt32(Request.QueryString["collateralId"]); int CollateralTypeId = Convert.ToInt32(Request.QueryString["CollateralTypeId"]); double varValueAsAtDate = 0; varValueAsAtDate = Convert.ToDouble(ValueAsAtDate.Text); //insert values into CollateralType_CarEquipTableAdapter and retrieve max id as collateralDetailsId int collateralDetailsId = Convert.ToInt32(robot.proc_insert_car(TypeOfCarEquip.Text, Make.Text, YearOfManufacture.SelectedItem.Text, varValueAsAtDate, ChassisNo.Text, -1, collateralId, Smart.GetEmployeeID(), "NULL")); hiddenDetailsId.Text = collateralDetailsId.ToString(); //see if he filled the insurance form, then run the block of code that will do the insrt into insurance table if (insuranceStatusId.SelectedValue == "1") { int varPeriodOfInsuranceCover = 0; double varAmountInsured = 0; varPeriodOfInsuranceCover = Convert.ToInt32(PeriodOfInsuranceCover.Text); varAmountInsured = Convert.ToDouble(AmountInsured.Text); robotInsuranceTable.Insert(Convert.ToInt32(insuranceStatusId.SelectedValue), Convert.ToInt32(InsuranceCover_id.SelectedValue), collateralDetailsId, CollateralTypeId, InsuranceCompany.Text, Convert.ToDateTime(DateOfInsurance.Value), varPeriodOfInsuranceCover, varAmountInsured, keyClause.Text, Smart.GetEmployeeID(), Convert.ToInt32(InsuranceCompany.SelectedValue)); } else { robotInsuranceTable.Insert(Convert.ToInt32(insuranceStatusId.SelectedValue), -1, collateralDetailsId, CollateralTypeId, "", null, -1, 0, null, Smart.GetEmployeeID(), -1); } //enable and move focus to next tab, disable current tab ASPxPageControl1.TabPages[1].Enabled = true; ASPxPageControl1.ActiveTabIndex = 1; } catch (Exception ex) { _errorMessageCar.Text = ex.Message; } }