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