protected void btnSave_Click(object sender, EventArgs e) { try { VIEW_MAT_ISSUE_ASSEMBLY_JOINTTableAdapter joint = new VIEW_MAT_ISSUE_ASSEMBLY_JOINTTableAdapter(); VIEW_SITE_JC_ASSEMBLY_DETAILTableAdapter loose = new VIEW_SITE_JC_ASSEMBLY_DETAILTableAdapter(); int flag = 0; foreach (RadComboBoxItem item in ddlJointList.Items) { if (item.Checked) { string bolt_qty = WebTools.GetExpr("BOLT_QTY", "PIP_SITE_JOINTS", " WHERE JOINT_ID='" + decimal.Parse(item.Value) + "'"); string gasket_qty = WebTools.GetExpr("GASKET_QTY", "PIP_SITE_JOINTS", " WHERE JOINT_ID='" + decimal.Parse(item.Value) + "'"); if (bolt_qty == "") { bolt_qty = "0"; } if (gasket_qty == "") { gasket_qty = "0"; } //string iso_id= WebTools.GetExpr("ISO_ID", "PIP_SITE_JOINTS", " WHERE JOINT_ID='" + decimal.Parse(item.Value) + "'"); // string bolt_item_code = WebTools.GetExpr("BOLT_ITEM_CODE", "PIP_SITE_JOINTS", " WHERE JOINT_ID='" + decimal.Parse(item.Value) + "'"); // string gasket_item_code = WebTools.GetExpr("GASKET_ITEM_CODE", "PIP_SITE_JOINTS", " WHERE JOINT_ID='" + decimal.Parse(item.Value) + "'"); // string bolt_mat_id = WebTools.GetExpr("MAT_ID", "AMOGH.PIP_MAT_STOCK", " WHERE MAT_CODE1='" + bolt_item_code + "'"); // string gasket_mat_id = WebTools.GetExpr("MAT_ID", "AMOGH.PIP_MAT_STOCK", " WHERE MAT_CODE1='" + gasket_item_code + "'"); // string bolt_bom_id = WebTools.GetExpr("BOM_ID", "VIEW_ISO_BOM_LINK", " WHERE ISO_ID='"+iso_id+"' AND MAT_ID='" + bolt_mat_id + "'"); // string gasket_bom_id = WebTools.GetExpr("BOM_ID", "VIEW_ISO_BOM_LINK", " WHERE ISO_ID='" + iso_id + "' AND MAT_ID='" + gasket_mat_id + "'"); joint.InsertQuery(decimal.Parse(Request.QueryString["JC_ID"].ToString()), decimal.Parse(item.Value), null, decimal.Parse(bolt_qty), decimal.Parse(gasket_qty)); //if (bolt_bom_id != "") //{ // loose.InsertQuery(decimal.Parse(Request.QueryString["JC_ID"].ToString()),decimal.Parse(bolt_bom_id), decimal.Parse(bolt_qty), null); //} //if ( gasket_bom_id != "") //{ // loose.InsertQuery(decimal.Parse(Request.QueryString["JC_ID"].ToString()), decimal.Parse(gasket_bom_id), decimal.Parse(gasket_qty), null); //} } } itemsGridView.Rebind(); Master.ShowMessage("Items Added!"); } catch (Exception ex) { Master.ShowError(ex.Message + ": BOM NOT FOUND FOR GASKET/BOLT IN ISOMETRIC"); } }
protected void btnSubmit_Click(object sender, EventArgs e) { //string ADD_SPL = InsertSpoolsCheckBox.Checked == true ? "Y" : "N"; //if (ddEntryType.SelectedValue.ToString() == "1") //{ // try // { // string RET_CODE = WebTools.GetExpr( // "FNC_SITE_JC_SAVE_ALL(" + // Request.QueryString["JC_ID"] + ",'" + txtIsome.Text + // "','" + ddSheetNo.SelectedValue.ToString() + "','" + // ADD_SPL + "','" + ddAvailable.SelectedValue.ToString() + "')", "DUAL", ""); // itemsGridView.DataBind(); // Master.ShowMessage("Saved!"); // } // catch (Exception ex) // { // Master.ShowWarn(ex.Message); // } // return; //} VIEW_SITE_JC_ASSEMBLY_DETAILTableAdapter loose = new VIEW_SITE_JC_ASSEMBLY_DETAILTableAdapter(); try { foreach (RadComboBoxItem item in cboBOM.Items) { if (item.Checked) { string MAT_ID = WebTools.GetExpr("MAT_ID", "PIP_BOM", " WHERE BOM_ID='" + item.Value.ToString() + "'"); //string ISO_ID = WebTools.GetExpr("ISO_ID", "VIEW_SITE_ASSEMBLY_REQUIRED", " WHERE BOM_ID='" + item.Value.ToString() + "'"); string net_qty = WebTools.GetExpr("NET_QTY", "PIP_MAT_ISSUE_ASSEMBLY_JOINT", " WHERE JC_ID='" + Request.QueryString["JC_ID"] + "'"); loose.InsertQuery(Decimal.Parse(Request.QueryString["JC_ID"]), Decimal.Parse(item.Value.ToString()), Decimal.Parse(net_qty), txtRemarks.Text); } } Master.ShowMessage("Saved."); loose.Dispose(); } catch (Exception ex) { Master.ShowWarn(ex.Message); loose.Dispose(); } }
protected void btnYes_Click(object sender, EventArgs e) { try { GridDataItem item = (GridDataItem)itemsGridView.SelectedItems[0]; //JC_ID,BOM_ID string jc_id = item.GetDataKeyValue("JC_ID").ToString(); string bom_id = item.GetDataKeyValue("BOM_ID").ToString(); dsErectionTableAdapters.VIEW_SITE_JC_ASSEMBLY_DETAILTableAdapter r = new VIEW_SITE_JC_ASSEMBLY_DETAILTableAdapter(); r.DeleteQuery(decimal.Parse(jc_id), decimal.Parse(bom_id)); Master.ShowMessage("Selected row deleted."); itemsGridView.Rebind(); } catch (Exception ex) { Master.ShowWarn(ex.Message); } }