protected void TWSave_Click(object sender, EventArgs e)
{
string bom1 = WebTools.GetExpr("ITEM_1", "PIP_SPOOL_JOINTS", " WHERE JOINT_ID=" + rcbTWJoint.SelectedValue.ToString());
string bom2 = WebTools.GetExpr("ITEM_2", "PIP_SPOOL_JOINTS", " WHERE JOINT_ID=" + rcbTWJoint.SelectedValue.ToString());
string mat_id1 = WebTools.GetExpr("MAT_ID", "PIP_BOM", " WHERE BOM_ID=" + bom1);
string mat_id2 = WebTools.GetExpr("MAT_ID", "PIP_BOM", " WHERE BOM_ID=" + bom2);
string item_id1 = WebTools.GetExpr("ITEM_ID", "PIP_MAT_STOCK", " WHERE MAT_ID=" + mat_id1);
string item_id2 = WebTools.GetExpr("ITEM_ID", "PIP_MAT_STOCK", " WHERE MAT_ID=" + mat_id2);
string item_group1 = WebTools.GetExpr("SG_GROUP", "PIP_MAT_ITEM", " WHERE ITEM_ID=" + item_id1);
string item_group2 = WebTools.GetExpr("SG_GROUP", "PIP_MAT_ITEM", " WHERE ITEM_ID=" + item_id2);
string hn1 = "";
string hn2 = "";
if (item_group1 == "SUPPORT")
{
hn1 = txtSuppHeatNo1.Text;
}
else
{
if (rcbHeatNo1.SelectedIndex < 0)
{
Master.ShowError("Selected Valid Heat No1");
return;
}
hn1 = rcbHeatNo1.SelectedValue.ToString();
}
if (item_group2 == "SUPPORT")
{
hn2 = txtSuppHeatNo2.Text;
}
else
{
if (rcbHeatNo2.SelectedIndex < 0)
{
Master.ShowError("Selected Valid Heat No2");
return;
}
hn2 = rcbHeatNo2.SelectedValue.ToString();
}
PIP_SPOOL_JOINTSTableAdapter joint_update = new PIP_SPOOL_JOINTSTableAdapter();
joint_update.UpdateJointTW(txtTWRep.Text, DateTime.Parse(txTWDate.SelectedDate.ToString()), hn1, hn2, int.Parse(rcbTWJoint.SelectedValue));
string sql_heat_no = "UPDATE PIP_BOM SET HEAT_NO = '" + hn1 + "' WHERE HEAT_NO IS NOT NULL AND BOM_ID = " + bom1;
WebTools.ExeSql(sql_heat_no);
sql_heat_no = "UPDATE PIP_BOM SET HEAT_NO = '" + hn2 + "' WHERE HEAT_NO IS NOT NULL AND BOM_ID = " + bom2;
WebTools.ExeSql(sql_heat_no);
Master.ShowSuccess("Tack Weld Details Updated Successfully");
}
protected void btnBonding_Click(object sender, EventArgs e)
{
PIP_SPOOL_JOINTSTableAdapter joint_Bonding = new PIP_SPOOL_JOINTSTableAdapter();
joint_Bonding.UpdateBonding(txtBondingRep.Text, DateTime.Parse(txtBondingDate.SelectedDate.ToString()), txtBondingName.Text, DateTime.Parse(txtCuringDate.SelectedDate.ToString()), int.Parse(rcbBondingJoint.SelectedValue));
string sql_1 = "SELECT JOINT_ID, ISO_TITLE1, ISO_REV, JC_REV, SHEET, SPOOL, WO_NAME, JOINT_NO, JOINT_TYPE, JOINT_SIZE, SCHEDULE, JOINT_THK," +
"HEAT_NO1, HEAT_NO2, FITUP_DATE, WELD_DATE, FITUP_REP_NO, WELD_REP_NO, ROOT_HOT_WELDER,FILL_CAP_WELDER,FITUP_INSP,WELD_INSP, CRW_CODE, TRACER," +
"DIS_FLG, WPS_NO, CAT_NAME, JNT_REV_CODE AS REV_CODE, COMMODITY1, COMMODITY2,TW_FLG, SPL_SWN_DT, SPL_REL_DT, LINE_CLASS, MAT_TYPE ," +
" SPL_REL_DT, SPL_SWN_DT,LAMINAT_REP_NO,LAMINAT_DATE,LAMINAT_THK,BONDING_REP_NO,BONDING_DATE,BONDER_NAME,FITUP_FOREMAN,WELD_FOREMAN " +
"FROM VIEW_TOTAL_JOINTS WHERE (JOINT_ID = :JOINT_ID)";
jointDetailsDataSource1.SelectCommand = sql_1;
jointDetailsDataSource1.SelectParameters.Add("JOINT_ID", TypeCode.Empty, rcbBondingJoint.SelectedValue.ToString());
jointDetailsView.DataBind();
rcbHeatNo1.Text = "";
rcbHeatNo2.Text = "";
Master.ShowSuccess("Bonding Details Updated Successfully");
}
protected void FitupSave_Click(object sender, EventArgs e)
{
string bom1 = WebTools.GetExpr("ITEM_1", "PIP_SPOOL_JOINTS", " WHERE JOINT_ID=" + rcbFitupJoint.SelectedValue.ToString());
string bom2 = WebTools.GetExpr("ITEM_2", "PIP_SPOOL_JOINTS", " WHERE JOINT_ID=" + rcbFitupJoint.SelectedValue.ToString());
if (bom1 == "" || bom2 == "")
{
return;
}
string mat_id1 = WebTools.GetExpr("MAT_ID", "PIP_BOM", " WHERE BOM_ID=" + bom1);
string mat_id2 = WebTools.GetExpr("MAT_ID", "PIP_BOM", " WHERE BOM_ID=" + bom2);
string item_id1 = WebTools.GetExpr("ITEM_ID", "AMOGH.PIP_MAT_STOCK", " WHERE MAT_ID=" + mat_id1);
string item_id2 = WebTools.GetExpr("ITEM_ID", "AMOGH.PIP_MAT_STOCK", " WHERE MAT_ID=" + mat_id2);
if (item_id1 == "" || item_id2 == "")
{
Master.ShowError("Update Item name for BOM");
return;
}
string item_group1 = WebTools.GetExpr("SG_GROUP", "AMOGH.PIP_MAT_ITEM", " WHERE ITEM_ID=" + item_id1);
string item_group2 = WebTools.GetExpr("SG_GROUP", "AMOGH.PIP_MAT_ITEM", " WHERE ITEM_ID=" + item_id2);
string hn1 = "";
string hn2 = "";
if (item_group1 == "SUPPORT")
{
hn1 = txtSuppHeatNo1.Text;
if (hn1 == "")
{
Master.ShowError("Selected Valid Heat No1");
return;
}
}
else
{
if (rcbHeatNo1.SelectedIndex < 0)
{
Master.ShowError("Selected Valid Heat No1");
return;
}
hn1 = rcbHeatNo1.SelectedValue.ToString();
}
if (item_group2 == "SUPPORT")
{
hn2 = txtSuppHeatNo2.Text;
if (hn2 == "")
{
Master.ShowError("Selected Valid Heat No2");
return;
}
}
else
{
if (rcbHeatNo2.SelectedIndex < 0 && rcbHeatNo2.SelectedValue.ToString() == string.Empty)
{
Master.ShowError("Selected Valid Heat No2");
return;
}
hn2 = rcbHeatNo2.SelectedValue.ToString();
}
DateTime Date3 = System.DateTime.Now;
string fitup_entry_date = Date3.ToString("dd-MMM-yyyy");
PIP_SPOOL_JOINTSTableAdapter joint_fitup = new PIP_SPOOL_JOINTSTableAdapter();
joint_fitup.UpdateJointFitup(txtFitupRep.Text, DateTime.Parse(txtFitupDate.SelectedDate.ToString()), ddlFitupInspCode.SelectedValue.ToString(), hn1, hn2, DateTime.Parse(fitup_entry_date), txtFitupForeman.Text, int.Parse(rcbFitupJoint.SelectedValue));
string sql_heat_no = "UPDATE PIP_BOM SET HEAT_NO = '" + hn1 + "' WHERE BOM_ID = " + bom1 + " and HEAT_NO IS NULL";
WebTools.ExeSql(sql_heat_no);
sql_heat_no = "UPDATE PIP_BOM SET HEAT_NO = '" + hn2 + "' WHERE BOM_ID = " + bom2 + " AND HEAT_NO IS NULL";
WebTools.ExeSql(sql_heat_no);
string sql_1 = "SELECT JOINT_ID, ISO_TITLE1, ISO_REV, JC_REV, SHEET, SPOOL, WO_NAME, JOINT_NO, JOINT_TYPE, JOINT_SIZE, SCHEDULE, JOINT_THK," +
"HEAT_NO1, HEAT_NO2, FITUP_DATE, WELD_DATE, FITUP_REP_NO, WELD_REP_NO, ROOT_HOT_WELDER,FILL_CAP_WELDER,FITUP_INSP,WELD_INSP, CRW_CODE, TRACER," +
"DIS_FLG, WPS_NO, CAT_NAME, JNT_REV_CODE AS REV_CODE, COMMODITY1, COMMODITY2,TW_FLG, SPL_SWN_DT, SPL_REL_DT, LINE_CLASS, MAT_TYPE ," +
" SPL_REL_DT, SPL_SWN_DT,LAMINAT_REP_NO,LAMINAT_DATE,LAMINAT_THK,BONDING_REP_NO,BONDING_DATE,BONDER_NAME,FITUP_FOREMAN,WELD_FOREMAN " +
"FROM VIEW_TOTAL_JOINTS WHERE (JOINT_ID = :JOINT_ID)";
jointDetailsDataSource1.SelectCommand = sql_1;
jointDetailsDataSource1.SelectParameters.Add("JOINT_ID", TypeCode.Empty, rcbWeldIsoJnt.SelectedValue.ToString());
jointDetailsView.DataBind();
rcbHeatNo1.Text = "";
rcbHeatNo2.Text = "";
Master.ShowSuccess("Fitup Details Updated Successfully");
}
