protected void Page_Load(object sender, EventArgs e) { String collateraldetails_id = Request.QueryString["collateraldetails_id"]; int insureID = 0; if (!IsPostBack) { // insuranceStatusId.SelectedIndex = 1; ASPxPageControl1.TabPages[0].Enabled = true; ASPxPageControl1.TabPages[1].Enabled = true; ASPxPageControl1.TabPages[2].Enabled = false; ASPxPageControl1.TabPages[3].Enabled = false; ASPxPageControl1.ActiveTabIndex = 0; int collateraldetailsid = Convert.ToInt32(Request.QueryString["collateraldetails_id"]); //this code is for population of fields when update mode is set RobotTableAdapters.CollateralType_PropertyTableAdapter propertyEngine = new RobotTableAdapters.CollateralType_PropertyTableAdapter(); DataTable propertyData = propertyEngine.getPropertyById(Convert.ToInt32(collateraldetails_id)); OwnershipLink.Text = propertyData.Rows[0]["OwnershipLink"].ToString(); Name_ColDocument.Text = propertyData.Rows[0]["Name_ColDocument"].ToString(); RefNo_ColDocument.Text = propertyData.Rows[0]["RefNo_ColDocument"].ToString(); OpenMarketValue.Text = propertyData.Rows[0]["OpenMarketValue"].ToString(); DateTime dt ; dt= Convert.ToDateTime(propertyData.Rows[0]["DateOfValuation"].ToString()); DateOfValuation.Value = ((DateTime)dt).ToString("MM/dd/yyyy"); AddressWithLandMark.Text = propertyData.Rows[0]["AddressWithLandMark"].ToString(); ForceSaleValue.Text = propertyData.Rows[0]["ForceSaleValue"].ToString(); property_desc.Text = propertyData.Rows[0]["property_desc"].ToString(); Location.Text = propertyData.Rows[0]["Location"].ToString(); //DROPDOWN if (propertyData.Rows[0]["documenttype_id"].ToString() != "-1") documenttype_id.SelectedValue = propertyData.Rows[0]["documenttype_id"].ToString(); OccupancyStatus_id.SelectedIndex = Convert.ToInt32(propertyData.Rows[0]["OccupancyStatus_id"].ToString()); PropertyDevelopmentStatus.SelectedValue = propertyData.Rows[0]["PropertyDevelopmentStatus_id"].ToString(); NameOfValuer.SelectedValue = propertyData.Rows[0]["valuer_id"].ToString(); state_id.SelectedValue = propertyData.Rows[0]["state_id"].ToString(); PropertyType_id.SelectedValue = propertyData.Rows[0]["PropertyType_id"].ToString(); // OwnershipLink.Text = propertyData.Rows[0]["OwnershipLink"].ToString(); try { RobotTableAdapters.InsuranceTableAdapter InsuranceEngine = new RobotTableAdapters.InsuranceTableAdapter(); DataTable InsuranceData = InsuranceEngine.proc_getInsuranceById(Convert.ToInt32(collateraldetails_id), 1); //TEXTBOXES InsuranceID.Value = InsuranceData.Rows[0]["Insurance_id"].ToString(); insuranceStatusId.SelectedValue = InsuranceData.Rows[0]["InsuranceStatus_id"].ToString(); if (InsuranceData.Rows[0]["InsuranceStatus_id"].ToString() == "1" || InsuranceData.Rows[0]["InsuranceStatus_id"].ToString() == "3") { PeriodOfInsuranceCover.Text = InsuranceData.Rows[0]["PeriodOfInsuranceCover"].ToString(); keyClause.Text = InsuranceData.Rows[0]["KeyClause"].ToString(); AmountInsured.Text = InsuranceData.Rows[0]["AmountInsured"].ToString(); DateTime dt1; dt1 = Convert.ToDateTime(InsuranceData.Rows[0]["DateOfInsurance"].ToString()); DateOfInsurance.Value = ((DateTime)dt1).ToString("MM/dd/yyyy"); //DROPDOWNS InsuranceCompany.SelectedValue = InsuranceData.Rows[0]["insuranceCompany_id"].ToString(); InsuranceCover_id.SelectedValue = InsuranceData.Rows[0]["InsuranceCover_id"].ToString(); } } catch (Exception) { } } CheckBoxList1_Load(); }
protected void Page_Load(object sender, EventArgs e) { String collateraldetails_id = Request.QueryString["collateraldetails_id"]; if (!IsPostBack) { // insuranceStatusId.SelectedIndex = 1; ASPxPageControl1.TabPages[0].Enabled = true; ASPxPageControl1.TabPages[1].Enabled = false; ASPxPageControl1.TabPages[2].Enabled = false; ASPxPageControl1.TabPages[3].Enabled = false; int years = DateTime.Now.Year; for (int i = 0; i < 30; i++) { years--; YearOfManufacture.Items.Add(new ListItem(years.ToString(), years.ToString())); } ASPxPageControl1.ActiveTabIndex = 2; int collateraldetailsid = Convert.ToInt32(Request.QueryString["collateraldetails_id"]); //this code is for population of fields when update mode is set RobotTableAdapters.CollateralType_CarEquipTableAdapter Engine = new RobotTableAdapters.CollateralType_CarEquipTableAdapter(); DataTable returnedData = Engine.getCarEquipById(Convert.ToInt32(collateraldetails_id)); //TEXTBOXES TypeOfCarEquip.Text = returnedData.Rows[0]["TypeOfCarEquip"].ToString(); ChassisNo.Text = returnedData.Rows[0]["ChassisNo"].ToString(); Make.Text = returnedData.Rows[0]["Make"].ToString(); ValueAsAtDate.Text = returnedData.Rows[0]["ValueAsAtDate"].ToString(); if(returnedData.Rows[0]["documenttype_id"].ToString() !="-1") documenttype_id.SelectedValue = returnedData.Rows[0]["documenttype_id"].ToString(); //DROPDOWN YearOfManufacture.SelectedValue = returnedData.Rows[0]["YearOfManufacture"].ToString(); //this code takes care of the population of insurance controls try { RobotTableAdapters.InsuranceTableAdapter InsuranceEngine = new RobotTableAdapters.InsuranceTableAdapter(); DataTable InsuranceData = InsuranceEngine.proc_getInsuranceById(Convert.ToInt32(collateraldetails_id), 4); //TEXTBOXES insuranceStatusId.SelectedValue = InsuranceData.Rows[0]["InsuranceStatus_id"].ToString(); InsuranceID.Value = InsuranceData.Rows[0]["Insurance_id"].ToString(); if (InsuranceData.Rows[0]["InsuranceStatus_id"].ToString() == "1" || InsuranceData.Rows[0]["InsuranceStatus_id"].ToString() == "3") { PeriodInsured.Text = InsuranceData.Rows[0]["PeriodOfInsuranceCover"].ToString(); keyClause.Text = InsuranceData.Rows[0]["KeyClause"].ToString(); AmountInsured.Text = InsuranceData.Rows[0]["AmountInsured"].ToString(); DateTime dt; dt = Convert.ToDateTime(InsuranceData.Rows[0]["DateOfInsurance"].ToString()); DateOfInsurance.Value = ((DateTime)dt).ToString("MM/dd/yyyy"); //DROPDOWNS InsuranceCompany.SelectedValue = InsuranceData.Rows[0]["InsuranceCompany"].ToString(); InsuranceCover_id.SelectedValue = InsuranceData.Rows[0]["InsuranceCover_id"].ToString(); } } catch (Exception) { } } CheckBoxList1_Load(); }
protected void Page_Load(object sender, EventArgs e) { String collateraldetails_id = Request.QueryString["collateraldetails_id"]; if (!IsPostBack) { // FinInsuranceStatus_id.SelectedIndex = 1; ASPxPageControl1.TabPages[0].Enabled = true; ASPxPageControl1.TabPages[1].Enabled = true; ASPxPageControl1.TabPages[2].Enabled = false; ASPxPageControl1.TabPages[3].Enabled = false; ASPxPageControl1.ActiveTabIndex = 0; int collateraldetailsid = Convert.ToInt32(Request.QueryString["collateraldetails_id"]); //this code is for population of fields when update mode is set RobotTableAdapters.CollateralType_SalaryContractTableAdapter Engine = new RobotTableAdapters.CollateralType_SalaryContractTableAdapter(); DataTable returnedData = Engine.getSalaryContractById(Convert.ToInt32(collateraldetails_id)); //TEXTBOXES NameOfInsuringBody.Text = returnedData.Rows[0]["NameOfInsuringBody"].ToString(); thirdparty.Text = returnedData.Rows[0]["thirdparty"].ToString(); DateTime dt; dt = Convert.ToDateTime(returnedData.Rows[0]["ContractAwardDate"].ToString()); ContractAwardDate.Value = ((DateTime)dt).ToString("MM/dd/yyyy"); RefNo.Text = returnedData.Rows[0]["RefNo"].ToString(); APG.Text = returnedData.Rows[0]["APG"].ToString(); OriginalContractor.Text = returnedData.Rows[0]["OriginalContractor"].ToString(); PurposeOfContract.Text = returnedData.Rows[0]["PurposeOfContract"].ToString(); ValueOfContract.Text = returnedData.Rows[0]["ValueOfContract"].ToString(); TenureOfContract.Text = returnedData.Rows[0]["TenorOfContract"].ToString(); //documenttype_id.SelectedValue = "";//(returnedData.Rows[0]["documenttype_id"].ToString()=="-1") ? "-1" : returnedData.Rows[0]["documenttype_id"].ToString() ; //documenttype_id.SelectedValue = returnedData.Rows[0]["documenttype_id"].ToString(); if(returnedData.Rows[0]["documenttype_id"].ToString() != "-1") documenttype_id.SelectedValue = returnedData.Rows[0]["documenttype_id"].ToString(); //DROPDOWN contratType.SelectedValue = returnedData.Rows[0]["contractTypeID"].ToString(); try { RobotTableAdapters.InsuranceTableAdapter InsuranceEngine = new RobotTableAdapters.InsuranceTableAdapter(); DataTable InsuranceData = InsuranceEngine.proc_getInsuranceById(Convert.ToInt32(collateraldetails_id), 5); //TEXTBOXES FinInsuranceStatus_id.SelectedValue = InsuranceData.Rows[0]["InsuranceStatus_id"].ToString(); InsuranceID.Value = InsuranceData.Rows[0]["Insurance_id"].ToString(); if (InsuranceData.Rows[0]["InsuranceStatus_id"].ToString() == "1" || InsuranceData.Rows[0]["InsuranceStatus_id"].ToString() == "3") { FinPeriodofInsuranceCover.Text = InsuranceData.Rows[0]["PeriodOfInsuranceCover"].ToString(); FinKeyClause.Text = InsuranceData.Rows[0]["KeyClause"].ToString(); FinAmountInsured.Text = InsuranceData.Rows[0]["AmountInsured"].ToString(); // FinDateOfInsurance.Value = InsuranceData.Rows[0]["DateOfInsurance"].ToString(); DateTime dt1; dt1 = Convert.ToDateTime(InsuranceData.Rows[0]["DateOfInsurance"].ToString()); FinDateOfInsurance.Value = ((DateTime)dt1).ToString("MM/dd/yyyy"); //DROPDOWNS FinInsuranceCompany.SelectedValue = InsuranceData.Rows[0]["InsuranceCompany"].ToString(); InsuranceCover.SelectedValue = InsuranceData.Rows[0]["InsuranceCover_id"].ToString(); } } catch (Exception) { } } CheckBoxList1_Load(); }
protected void Page_Load(object sender, EventArgs e) { String collateraldetails_id = Request.QueryString["collateraldetails_id"]; int collateralId = Convert.ToInt32(Request.QueryString["collateralId"]); int collateraldetailsid = Convert.ToInt32(Request.QueryString["collateraldetails_id"]); int CollateralTypeId = Convert.ToInt32(Request.QueryString["CollateralTypeId"]); //this code is for population of fields when update mode is set RobotTableAdapters.CollateralType_StockHypoTableAdapter Engine = new RobotTableAdapters.CollateralType_StockHypoTableAdapter(); DataTable returnedData = Engine.getStockHypoById(Convert.ToInt32(collateraldetails_id)); if (!IsPostBack) { //insuranceStatusId.SelectedIndex = 1; ASPxPageControl1.TabPages[0].Enabled = true; ASPxPageControl1.TabPages[1].Enabled = true; ASPxPageControl1.TabPages[2].Enabled = false; ASPxPageControl1.TabPages[3].Enabled = false; ASPxPageControl1.ActiveTabIndex = 0; hiddenDetailsId.Text = collateraldetailsid.ToString(); //TextBOXES InvoiceNo.Text = returnedData.Rows[0]["InvoiceNo"].ToString(); ValueOfStock_total.Text = returnedData.Rows[0]["ValueOfStock_total"].ToString(); // DateOfValuation.Text = returnedData.Rows[0]["DateOfValuation"].ToString(); DateTime dt; dt = Convert.ToDateTime(returnedData.Rows[0]["DateOfValuation"].ToString()); DateOfValuation.Value = ((DateTime)dt).ToString("MM/dd/yyyy"); ListOfStock.Text = returnedData.Rows[0]["ListOfStock"].ToString(); NameOfStockValuer.Text = returnedData.Rows[0]["NameOfStockValuer"].ToString(); MethodOfValuation.Text = returnedData.Rows[0]["MethodOfValuation"].ToString(); FrequencyOfValuation.SelectedValue = returnedData.Rows[0]["ValuationID"].ToString(); //DROPDOWN TypeOfStock_id.SelectedValue = returnedData.Rows[0]["TypeOfStock_id"].ToString(); // TypeOfStock_id.SelectedValue = returnedData.Rows[0]["TypeOfStock_id"].ToString(); if (returnedData.Rows[0]["documenttype_id"].ToString() != "-1") { documenttype_id.SelectedValue = returnedData.Rows[0]["documenttype_id"].ToString(); } try { RobotTableAdapters.InsuranceTableAdapter InsuranceEngine = new RobotTableAdapters.InsuranceTableAdapter(); DataTable InsuranceData = InsuranceEngine.proc_getInsuranceById(Convert.ToInt32(collateraldetails_id), 3); //TextBOXES insuranceStatusId.SelectedValue = InsuranceData.Rows[0]["InsuranceStatus_id"].ToString(); InsuranceID.Value = InsuranceData.Rows[0]["Insurance_id"].ToString(); if (InsuranceData.Rows[0]["InsuranceStatus_id"].ToString() == "1" || InsuranceData.Rows[0]["InsuranceStatus_id"].ToString() == "3") { StockPeriodOfInsuranceCover.Text = InsuranceData.Rows[0]["PeriodOfInsuranceCover"].ToString(); StockKeyClause.Text = InsuranceData.Rows[0]["KeyClause"].ToString(); StockAmountInsured.Text = InsuranceData.Rows[0]["AmountInsured"].ToString(); // StockDateOfInsurance.Value = InsuranceData.Rows[0]["DateOfInsurance"].ToString(); DateTime dt1; dt1 = Convert.ToDateTime(InsuranceData.Rows[0]["DateOfInsurance"].ToString()); StockDateOfInsurance.Value = ((DateTime)dt1).ToString("MM/dd/yyyy"); //DROPDOWNS InsuranceCompany.SelectedValue = InsuranceData.Rows[0]["InsuranceCompany"].ToString(); InsuranceCover_id.SelectedValue = InsuranceData.Rows[0]["InsuranceCover_id"].ToString(); } } catch (Exception) { } } CheckBoxList1_Load(); }