protected void btnErrlog_Click(object sender, EventArgs e)
{
string filename = WebTools.GetExpr("IMP_REP_TITLE", "PIP_BULK_IMPORT_REP", " IMP_REP_ID=" + Request.QueryString["IMPORT_ID"]);
string sql = WebTools.GetExpr("IMP_ERR_LOG_SQL", "PIP_BULK_IMPORT_REP", " IMP_REP_ID=" + Request.QueryString["IMPORT_ID"]);
string user_id = WebTools.GetExpr("USER_ID", "USERS", " USER_NAME='" + Session["USER_NAME"].ToString() + "'");
itemsErrorSource.SelectCommand = sql.Replace("PARAM", user_id);
WebTools.ExportDataSetToExcel(itemsErrorSource, filename + ".xls");
}
protected void btnExport_Click(object sender, EventArgs e)
{
if (RadListBoxSource.SelectedItem != null)
{
string export_option = RadListBoxSource.SelectedItem.Value.ToString();
if (export_option == "")
{
export_option = RadListBox1.SelectedValue;
}
//Master.show_info(export_option);
switch (export_option)
{
case "SPOOL":
dsExport.SelectCommand = "SELECT * FROM PROJECT_PRIORITY_SPOOL";
break;
case "MAIN_MAT":
dsExport.SelectCommand = "SELECT * FROM PROJECT_PRIORITY_MAIN_MAT";
break;
case "AREA":
dsExport.SelectCommand = "SELECT * FROM PROJECT_PRIORITY_AREA";
break;
case "SERVICE":
dsExport.SelectCommand = "SELECT * FROM PROJECT_PRIORITY_SERVICE";
break;
case "LINE":
dsExport.SelectCommand = "SELECT * FROM PROJECT_PRIORITY_LINE";
break;
case "ISOMETRIC":
dsExport.SelectCommand = "SELECT * FROM PROJECT_PRIORITY_ISOMETRIC";
break;
case "SPLIT_WBS":
dsExport.SelectCommand = "SELECT * FROM PROJECT_PRIORITY_SPLIT_WBS";
break;
case "CRD":
dsExport.SelectCommand = "SELECT ISO_TITLE1, CRD_DATE FROM PIP_ISOMETRIC WHERE CRD_DATE IS NOT NULL";
break;
case "EQP":
dsExport.SelectCommand = "SELECT * FROM PROJECT_PRIORITY_EQP_EREC";
break;
}
dsExport.DataBind();
WebTools.ExportDataSetToExcel(dsExport, "Priority_" + export_option + ".xls");
}
else
{
lblMessage.Text = "<font color='red'>Please select an item !!!</font>";
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
if (grdMRIR.SelectedIndexes.Count == 0)
{
Master.ShowError("Select MRIR to proceed.");
return;
}
string filename = WebTools.GetExpr("MIR_No", "PRC_MAT_INSP", " MIR_ID='" + grdMRIR.SelectedValue + "'");
WebTools.ExportDataSetToExcel(sqlExportMIR, "MRIR_" + filename + ".xls");
}
protected void btnExport_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(dsExport, "SimulationSpools.xls");
}
//protected void rdoCountOrInchdia_SelectedIndexChanged(object sender, EventArgs e)
//{
// if (rdoCountOrInchdia.SelectedValue.Equals("ID"))
// {
// PieChart6.DataBind();
// PieChart6.Visible = true;
// PieChart5.Visible = false;
// }
// else
// {
// PieChart5.DataBind();
// PieChart5.Visible = true;
// PieChart6.Visible = false;
// }
//}
protected void btnExportPlannedVsActual_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(dsISOPlanningReport, "PlannedVsActual.xls");
}
protected void btnExportIso_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(dsSmlSelectedIso, "SimulationIsometrics.xls");
}
protected void btnFlange_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(AmoghSiteJointList, "Flange_error.xls");
}
protected void btnDownload_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(sqlDownloadSource, "Material_Status_Report.xls");
}
protected void btnErrorExport_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(SqlDataSource1, "SgImportErrorLog.xls");
}
protected void linkDownloadError_Click(object sender, EventArgs e)
{
//Response.Redirect()
WebTools.ExportDataSetToExcel(SqlDataSource1, "ISO_ATTRIBUTE_IMPORT_ERROR.xls");
}
protected void btnMiller_Click(object sender, EventArgs e)
{
//db_export.ExportDataSetToExcel(posplitDataSource, "Miller_Status.xls");
WebTools.ExportDataSetToExcel(posplitDataSource, "Miller_Status.xls");
}
protected void btnJoint_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(AmoghJointList, "Joint_error.xls");
}
protected void EpicBalJoint_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(sqlEpicBalJoint, "Balance_Joints.xls");
}
protected void EpicBalSpool_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(sqlEpicBalSpool, "Balance_Spool.xls");
}
protected void AmgBalBom_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(sqlAmgBalBom, "Balance_Bom.xls");
}
protected void AmpBalFlangeJoints_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(sqlAmpBalFlangeJoints, "Balance_Flange_Joints.xls");
}
protected void btnEpicBom_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(EpicBomList, "Epic_Lom_error.xls");
}
protected void btnExport_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(sqlDownload, "Material_Requisition.xls");
}
protected void btnSpool_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(AmoghSpoolList, "Spool_error.xls");
}
protected void btnPOBal_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(sqlPOBalance, "PO_Balance.xls");
}
protected void btnExport_Click(object sender, EventArgs e)
{
string itemcode = WebTools.GetExpr("Mat_code1", "PIP_MAT_STOCK", " MAT_ID='" + Request.QueryString["MAT_ID"].ToString() + "'");
WebTools.ExportDataSetToExcel(sqlDataSource, itemcode + "_MRIR.xls");
}
protected void btnExportAll_Click(object sender, EventArgs e)
{
string job_code = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " PROJECT_ID='" + Session["PROJECT_ID"].ToString() + "'");
WebTools.ExportDataSetToExcel(sqlExportMIRAll, "MRIR-" + job_code + ".xls");
}
protected void RadMenu1_ItemClick(object sender, Telerik.Web.UI.RadMenuEventArgs e)
{
if (itemsGrid.SelectedIndexes.Count == 0 && e.Item.Value != "DOWNLOAD" && e.Item.Value != "SHORTAGE")
{
Master.ShowError("Select Material Code to Proceed.");
return;
}
switch (e.Item.Value)
{
case "LINE_MTO":
Response.Redirect("MaterialStock_LineMTO.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "ISO_MTO":
Response.Redirect("MaterialStock_iso_mto.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "MR":
Response.Redirect("MaterialStock_Requisition.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "PO":
Response.Redirect("MaterialStock_PO.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "MRV":
Response.Redirect("MaterialStock_Received.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "MRIR":
Response.Redirect("MaterialStock_MRIR.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "ESD":
Response.Redirect("MaterialStock_ESD.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "JC":
Response.Redirect("MaterialStock_JC.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "JC_MIV":
Response.Redirect("MaterialStock_JC_MIV.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "SITE_MIV":
Response.Redirect("MaterialStock_SITE_MIV.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "ADD_ISSUE":
Response.Redirect("MaterialStock_Add_Issue.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "TRANSF":
Response.Redirect("MaterialStock_Transfer.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "HEAT_NO":
Response.Redirect("MaterialStock_HeatNo.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "MTC":
Response.Redirect("MaterialStock_MTC.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "BOM":
Response.Redirect("MaterialStock_BOM_QTY.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "JOINT_LIST":
Response.Redirect("MaterialStock_Joints.aspx?MAT_ID=" + itemsGrid.SelectedValue + "&RetUrl=MaterialStatusReport.aspx");
break;
case "DOWNLOAD":
WebTools.ExportDataSetToExcel(sqlDownloadSource, "Material_Status_Report.xls");
break;
case "SHORTAGE":
WebTools.ExportDataSetToExcel(sqlDownShort, "Material_Shortage.xls");
break;
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(sqlExport, "TOTAL_MATERIAL_LIST.xls");
}
protected void btnLom_Click(object sender, EventArgs e)
{
WebTools.ExportDataSetToExcel(AmoghLomList, "Lom_error.xls");
}
