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