protected void Button1_Click(object sender, EventArgs e) { RobotTableAdapters.CollateralType_GuaranteeTableAdapter robot = new RobotTableAdapters.CollateralType_GuaranteeTableAdapter(); //initialize values int collateralId = Convert.ToInt32(Request.QueryString["collateralId"]); int CollateralTypeId = Convert.ToInt32(Request.QueryString["CollateralTypeId"]); String collateraldetails_id = Request.QueryString["collateraldetails_id"]; int collateraldetailsid = Convert.ToInt32(Request.QueryString["collateraldetails_id"]); //insert values into CollateralType_Cash and retrieve max id as collateralDetailsId robot.Update(guarantorName.Text, guarantorAddress.Text, guarantorBizAddress.Text, obligorRelationship.Text, telephoneNo.Text, Convert.ToInt32(meansOfID.SelectedValue), collateralSupportingGuaranty.Text, collateralId, Convert.ToInt32(collateraldetails_id)); //robot.Update(varValueOfCash, varTypeOfCashGuarantee, AccountLien.Text, DateTime.Now, -1, collateralId, Smart.GetEmployeeID(), "NULL", collateraldetailsid); hiddenDetailsId.Text = collateraldetailsid.ToString(); //enable and move focus to next tab, disable current tab ASPxPageControl1.TabPages[1].Enabled = true; ASPxPageControl1.ActiveTabIndex = 1; CheckBoxList1_Load(); }
protected void Button1_Click(object sender, EventArgs e) { RobotTableAdapters.CollateralType_GuaranteeTableAdapter robot = new RobotTableAdapters.CollateralType_GuaranteeTableAdapter(); //initialize values int collateralId = Convert.ToInt32(Request.QueryString["collateralId"]); int CollateralTypeId = Convert.ToInt32(Request.QueryString["CollateralTypeId"]); //insert values into CollateralType_Cash and retrieve max id as collateralDetailsId int collateralDetailsId = Convert.ToInt32(robot.proc_insertGuarantee(guarantorName.Text, guarantorAddress.Text, guarantorBizAddress.Text, obligorRelationship.Text, telephoneNo.Text, Convert.ToInt32(meansOfID.SelectedValue), collateralSupportingGuaranty.Text, collateralId)); hiddenDetailsId.Text = collateralDetailsId.ToString(); //hiddenDetailsId.Text = "9"; //enable and move focus to next tab, disable current tab ASPxPageControl1.TabPages[1].Enabled = true; ASPxPageControl1.ActiveTabIndex = 1; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ASPxPageControl1.TabPages[0].Enabled = true; ASPxPageControl1.TabPages[1].Enabled = false; 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_GuaranteeTableAdapter Engine = new RobotTableAdapters.CollateralType_GuaranteeTableAdapter(); DataTable returnedData = Engine.getGuranteeById(Convert.ToInt32(collateraldetailsid)); //TextBOXES guarantorName.Text = returnedData.Rows[0]["guarantor_name"].ToString(); collateralSupportingGuaranty.Text = returnedData.Rows[0]["collateralSupportingGuarantee"].ToString(); obligorRelationship.Text = returnedData.Rows[0]["relationship"].ToString(); //DateTime dt; //dt = Convert.ToDateTime(returnedData.Rows[0]["DateOfMaturity"].ToString()); //DateOfMaturity.Value = ((DateTime)dt).ToString("MM/dd/yyyy"); guarantorAddress.Text = returnedData.Rows[0]["address_residential"].ToString(); guarantorBizAddress.Text = returnedData.Rows[0]["address_business"].ToString(); telephoneNo.Text = returnedData.Rows[0]["telephone"].ToString(); if (returnedData.Rows[0]["documenttype_id"].ToString()!="-1") documenttype_id.SelectedValue = returnedData.Rows[0]["documenttype_id"].ToString(); //DROPDOWN if (returnedData.Rows[0]["meansOfID"].ToString() != "-1") meansOfID.SelectedValue = returnedData.Rows[0]["meansOfID"].ToString(); } CheckBoxList1_Load(); }