public void GetWeldReportNo(int ProjId, string weldReportNo)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <DuqmDailyWeldingControlSheetModel> weldSummary = new List <DuqmDailyWeldingControlSheetModel>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = "SELECT DISTINCT WELD_REP_NO FROM REP_DAILY_WELDING_CTRL_SHT" +
$" WHERE PROJECT_ID={1} AND WELD_REP_NO LIKE '%{weldReportNo}%'";
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
DuqmDailyWeldingControlSheetModel summary = new DuqmDailyWeldingControlSheetModel();
summary.weld_rep_no = dr["WELD_REP_NO"].ToString();
weldSummary.Add(summary);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(weldSummary);
Context.Response.Write(data);
}
public void GetAllSubContractorDetails(int ProjId)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <SubContractorsModel> subConList = new List <SubContractorsModel>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = "SELECT SUB_CON_ID, SUB_CON_NAME FROM SUB_CONTRACTOR" +
$" WHERE PROJ_ID={1} ORDER BY SUB_CON_NAME";
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
SubContractorsModel subCon = new SubContractorsModel();
subCon.SUB_CON_ID = dr["SUB_CON_ID"].ToString();
subCon.SUB_CON_NAME = dr["SUB_CON_NAME"].ToString();
subConList.Add(subCon);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(subConList);
Context.Response.Write(data);
}
public int RegisterRFITransmittalDetails(int ProjId, string RFI_Number, int SUB_CON_ID, string Inspector_Name, string Inspection_Date, string Item_Desc, string Inspection_Result)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
int statusCode = 0;
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = "INSERT INTO RFI_TRANS_MASTER (RFI_NUMBER, PROJECT_ID, SUB_CON_ID, RFI_DATE, INSPECTOR_NAME, INSPECTOR_ACTIVITY, INSPECTION_RESULT, CREATED_AT, CREATED_BY) " +
$" VALUES('{RFI_Number}', {1}, {SUB_CON_ID}, '{Inspection_Date}','{Inspector_Name}', '{Item_Desc}', '{Inspection_Result}', '{DateTime.Now.ToString("dd/MMM/yyyy")}', '{Inspector_Name}') ";
try
{
using (OracleCommand cmd = new OracleCommand(sql, conn))
{
statusCode = cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw ex;
}
}
return(statusCode);
}
public void GetMagneticParticleTestingDetails(int ProjId, string NDE_Rep_No)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <MagneticParticleTestingModel> magneticParticleList = new List <MagneticParticleTestingModel>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = "SELECT * FROM VIEW_MT_REPORT_FORMAT_DT" +
$" WHERE PROJECT_ID={1} AND NDE_REP_NO = '{NDE_Rep_No}'";
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
MagneticParticleTestingModel magneticParticle = new MagneticParticleTestingModel();
magneticParticle.project_id = dr["PROJECT_ID"].ToString();
magneticParticle.job_code = dr["JOB_CODE"].ToString();
magneticParticle.iso_title1 = dr["ISO_TITLE1"].ToString();
magneticParticle.spool = dr["SPOOL"].ToString();
magneticParticle.joint_no = dr["JOINT_NO"].ToString();
magneticParticle.joint_id = dr["JOINT_ID"].ToString();
magneticParticle.root_hot_welder = dr["ROOT_HOT_WELDER"].ToString();
magneticParticle.fill_cap_welder = dr["FILL_CAP_WELDER"].ToString();
magneticParticle.joint_size_dec = dr["JOINT_SIZE_DEC"].ToString();
magneticParticle.schedule = dr["SCHEDULE"].ToString();
magneticParticle.joint_type = dr["JOINT_TYPE"].ToString();
magneticParticle.weld_process = dr["WELD_PROCESS"].ToString();
magneticParticle.material = dr["MATERIAL"].ToString();
magneticParticle.wps_no = dr["WPS_NO"].ToString();
magneticParticle.pwht = dr["PWHT"].ToString();
magneticParticle.nde_rep_no = dr["NDE_REP_NO"].ToString();
string nde_date = dr["NDE_DATE"].ToString();
if (!string.IsNullOrEmpty(nde_date))
{
magneticParticle.nde_date = DateTime.Parse(dr["NDE_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
magneticParticle.pass_flg = dr["PASS_FLG"].ToString();
magneticParticle.nde_type = dr["NDE_TYPE"].ToString();
magneticParticle.total_films = dr["TOTAL_FILMS"].ToString();
magneticParticle.repair_films = dr["REPAIR_FILMS"].ToString();
magneticParticle.reshoot_films = dr["RESHOOT_FILMS"].ToString();
magneticParticle.repair_code = dr["REPAIR_CODE"].ToString();
magneticParticle.cat_name = dr["CAT_NAME"].ToString();
magneticParticleList.Add(magneticParticle);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(magneticParticleList);
Context.Response.Write(data);
}
public void GetRadiographyInspectionDetails(int ProjId, string NDE_Rep_No)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <RadiographyInspectionModel> radiographyInspection = new List <RadiographyInspectionModel>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = "SELECT * FROM VIEW_RT_REPORT_FORMAT_DT" +
$" WHERE PROJECT_ID={1} AND NDE_REP_NO = '{NDE_Rep_No}'";
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
RadiographyInspectionModel inspection = new RadiographyInspectionModel();
inspection.project_id = dr["project_id"].ToString();
inspection.job_code = dr["job_code"].ToString();
inspection.iso_title1 = dr["iso_title1"].ToString();
inspection.spool = dr["spool"].ToString();
inspection.joint_no = dr["joint_no"].ToString();
inspection.joint_id = dr["joint_id"].ToString();
inspection.root_hot_welder = dr["root_hot_welder"].ToString();
inspection.fill_cap_welder = dr["fill_cap_welder"].ToString();
inspection.joint_size_dec = dr["joint_size_dec"].ToString();
inspection.schedule = dr["schedule"].ToString();
inspection.joint_type = dr["joint_type"].ToString();
inspection.weld_process = dr["weld_process"].ToString();
inspection.material = dr["material"].ToString();
inspection.wps_no = dr["wps_no"].ToString();
inspection.pwht = dr["pwht"].ToString();
inspection.nde_rep_no = dr["nde_rep_no"].ToString();
string nde_date = dr["nde_date"].ToString();
if (!string.IsNullOrEmpty(nde_date))
{
inspection.nde_date = DateTime.Parse(dr["nde_date"].ToString()).ToString("dd-MMM-yyyy");
}
inspection.pass_flg = dr["pass_flg"].ToString();
inspection.nde_type = dr["nde_type"].ToString();
inspection.total_films = dr["total_films"].ToString();
inspection.repair_films = dr["repair_films"].ToString();
inspection.reshoot_films = dr["reshoot_films"].ToString();
inspection.repair_code = dr["repair_code"].ToString();
radiographyInspection.Add(inspection);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(radiographyInspection);
Context.Response.Write(data);
}
public void GetMaterialWise(int ProjId)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <ReportSpoolIdMatWiseModel> items = new List <ReportSpoolIdMatWiseModel>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = "SELECT * FROM REP_SPOOL_INCH_DIA_MAT WHERE PROJECT_ID=1";
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
ReportSpoolIdMatWiseModel item = new ReportSpoolIdMatWiseModel();
item.project_id = int.Parse(dr["PROJECT_ID"].ToString());
item.job_code = dr["JOB_CODE"].ToString();
item.job_name = dr["JOB_NAME"].ToString();
item.client_name = dr["CLIENT_NAME"].ToString();
item.proj_rem = dr["PROJ_REM"].ToString();
item.mat_type = dr["MAT_TYPE"].ToString();
item.sg_shop = MathUtility.stringToDouble(dr["SG_SHOP"].ToString());
item.sg_field = MathUtility.stringToDouble(dr["SG_FIELD"].ToString());
item.sg_total = MathUtility.stringToDouble(dr["SG_TOTAL_ID"].ToString());
item.mat_avl = MathUtility.stringToDouble(dr["MAT_AVL"].ToString());
item.jc_issued = MathUtility.stringToDouble(dr["JC_ISSUED"].ToString());
item.swn = MathUtility.stringToDouble(dr["SWN"].ToString());
item.dim_check = MathUtility.stringToDouble(dr["DIM_CHECK"].ToString());
item.qc_cleared = MathUtility.stringToDouble(dr["QC_CLEARED"].ToString());
item.paint_req = MathUtility.stringToDouble(dr["PAINT_REQ"].ToString());
item.shipping_jc = MathUtility.stringToDouble(dr["SHIPPING_JC"].ToString());
item.painted = MathUtility.stringToDouble(dr["PAINTED"].ToString());
item.shipping = MathUtility.stringToDouble(dr["SHIPPING"].ToString());
item.shop_fitup = MathUtility.stringToDouble(dr["SHOP_FITUP"].ToString());
item.shop_welding = MathUtility.stringToDouble(dr["SHOP_WELDING"].ToString());
item.field_fitup = MathUtility.stringToDouble(dr["FIELD_FITUP"].ToString());
item.field_welding = MathUtility.stringToDouble(dr["FIELD_WELDING"].ToString());
items.Add(item);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(items);
Context.Response.Write(data);
} // method
public void GetSpoolGenStatusDetails(int ProjId)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <SpoolGenProgress_LotWise_Model> spoolGenProgressList = new List <SpoolGenProgress_LotWise_Model>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = "SELECT * FROM VIEW_ISOME_REP_C" +
$" WHERE PROJECT_ID={1} ORDER BY LOT_NO";
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
SpoolGenProgress_LotWise_Model spoolGen = new SpoolGenProgress_LotWise_Model();
spoolGen.PROJECT_ID = dr["PROJECT_ID"].ToString();
spoolGen.JOB_CODE = dr["JOB_CODE"].ToString();
spoolGen.CLIENT_NAME = dr["CLIENT_NAME"].ToString();
spoolGen.PROJ_REM = dr["PROJ_REM"].ToString();
spoolGen.JOB_NAME = dr["JOB_NAME"].ToString();
string LOT_RECV = dr["LOT_RECV"].ToString();
if (!string.IsNullOrEmpty(LOT_RECV))
{
spoolGen.LOT_RECV = DateTime.Parse(dr["LOT_RECV"].ToString()).ToString("dd-MMM-yyyy");
}
spoolGen.LOT_NO = dr["LOT_NO"].ToString();
spoolGen.HCOPY_RECV = Convert.ToInt32(dr["HCOPY_RECV"].ToString());
spoolGen.IDF_RECV = Convert.ToInt32(dr["IDF_RECV"].ToString());
spoolGen.MARK_DATE = Convert.ToInt32(dr["MARK_DATE"].ToString());
spoolGen.SG_DATE = Convert.ToInt32(dr["SG_DATE"].ToString());
spoolGen.SG_BAL = Convert.ToInt32(dr["SG_BAL"].ToString());
spoolGen.BACK_CHK = Convert.ToInt32(dr["BACK_CHK"].ToString());
spoolGen.BCK_CHK_BAL = Convert.ToInt32(dr["BCK_CHK_BAL"].ToString());
spoolGen.MAT_CHK = Convert.ToInt32(dr["MAT_CHK"].ToString());
spoolGen.MAT_CHK_BAL = Convert.ToInt32(dr["MAT_CHK_BAL"].ToString());
spoolGen.TRANS_QTY = Convert.ToInt32(dr["TRANS_QTY"].ToString());
spoolGen.HOLD_QTY = Convert.ToInt32(dr["HOLD_QTY"].ToString());
spoolGen.TRANS_BAL = Convert.ToInt32(dr["TRANS_BAL"].ToString());
spoolGenProgressList.Add(spoolGen);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(spoolGenProgressList);
Context.Response.Write(data);
}
public void GetSgSummaryAreaWise(int ProjId)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <IsomeSumaryAreaWiseModel> items = new List <IsomeSumaryAreaWiseModel>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = "SELECT * FROM REP_SG_SUMMARY_AREA WHERE PROJECT_ID = 1 ORDER BY AREA_L2, AREA_L1";
//PROJECT_ID, JOB_CODE, JOB_NAME, CLIENT_NAME, PROJ_REM,
//APP_LOGO1, APP_LOGO2, APP_LOGO3, AREA_L1, AREA_L2, RECVD, IDF_RECVD,
//HOLD_QTY, SG_DONE, BCHK_DONE, TRANSMITTED
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
IsomeSumaryAreaWiseModel item = new IsomeSumaryAreaWiseModel();
item.ProjectId = int.Parse(dr["PROJECT_ID"].ToString());
item.AreaL1 = dr["AREA_L1"].ToString();
item.AreaL2 = dr["AREA_L2"].ToString();
item.IsoReceived = MathUtility.stringToInt(dr["RECVD"].ToString());
item.IdfReceived = MathUtility.stringToInt(dr["IDF_RECVD"].ToString());
item.OnHold = MathUtility.stringToInt(dr["HOLD_QTY"].ToString());
item.SgDone = MathUtility.stringToInt(dr["SG_DONE"].ToString());
item.BackCheckDone = MathUtility.stringToInt(dr["BCHK_DONE"].ToString());
item.Transmitted = MathUtility.stringToInt(dr["TRANSMITTED"].ToString());
items.Add(item);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(items);
Context.Response.Write(data);
} // method
public void GetRTSummaryMaterialWise(int ProjId, int CatId)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <RTSummaryMaterialWiseModel> items = new List <RTSummaryMaterialWiseModel>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = $"SELECT * FROM REP_RT_SUMMARY_MAT WHERE PROJECT_ID=1 AND CAT_ID={CatId} ORDER BY MAT_TYPE, RT";
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
RTSummaryMaterialWiseModel item = new RTSummaryMaterialWiseModel();
item.project_id = int.Parse(dr["PROJECT_ID"].ToString());
item.mat_type = dr["MAT_TYPE"].ToString();
item.cat_id = MathUtility.stringToInt(dr["CAT_ID"].ToString());
item.rt_percentage = MathUtility.stringToInt(dr["RT"].ToString());
item.jnt_welded = MathUtility.stringToInt(dr["JNT_WELDED"].ToString());
item.jnt_nde_done = MathUtility.stringToInt(dr["JNT_NDE_DONE"].ToString());
item.jnt_repair = MathUtility.stringToInt(dr["JNT_REPAIR"].ToString());
item.jnt_repaired = MathUtility.stringToInt(dr["JNT_REPAIRED"].ToString());
item.total_films = MathUtility.stringToInt(dr["TOTAL_FILMS"].ToString());
item.acc_films = MathUtility.stringToInt(dr["ACC_FILMS"].ToString());
item.rej_films = MathUtility.stringToInt(dr["REJ_FILMS"].ToString());
items.Add(item);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(items);
Context.Response.Write(data);
} // method
public void GetRFITransmittalDetails(int ProjId, string RFI_Number)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <RFI_Transmittal_Model> rfiTransmittalList = new List <RFI_Transmittal_Model>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = "SELECT * FROM VW_RFI_TRANS_MASTER" +
$" WHERE PROJECT_ID={1} AND RFI_NUMBER = '{RFI_Number}'";
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
RFI_Transmittal_Model rfiTransmittal = new RFI_Transmittal_Model();
rfiTransmittal.project_id = dr["project_id"].ToString();
rfiTransmittal.rfi_number = dr["rfi_number"].ToString();
rfiTransmittal.sub_con_name = dr["sub_con_name"].ToString();
rfiTransmittal.rfi_date = dr["rfi_date"].ToString();
rfiTransmittal.inspector_name = dr["inspector_name"].ToString();
rfiTransmittal.inspector_activity = dr["inspector_activity"].ToString();
rfiTransmittal.inspection_result = dr["inspection_result"].ToString();
rfiTransmittal.created_at = dr["created_at"].ToString();
rfiTransmittal.created_by = dr["created_by"].ToString();
rfiTransmittalList.Add(rfiTransmittal);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(rfiTransmittalList);
Context.Response.Write(data);
}
public void GetAreaWise(int ProjId)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <ReportSpoolIdAreaWiseModel> areas = new List <ReportSpoolIdAreaWiseModel>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = "SELECT * FROM REP_SPOOL_INCH_DIA_AREA"
+ $" WHERE LENGTH(NVL(AREA_L1,''))>0 AND PROJECT_ID=1";
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
//PROJECT_ID, JOB_CODE, JOB_NAME, CLIENT_NAME, PROJ_REM,
//APP_LOGO1, APP_LOGO2, AREA_L2, AREA_L1, SG_SHOP, SG_FIELD,
//MAT_AVL, JC_ISSUED, SWN, NDE_CMPLT, DIM_CHECK, QC_CLEARED,
//PAINT_REQ, SHIPPING_JC, PAINTED, SHIPPING, SHOP_FITUP,
//SHOP_WELDING, FIELD_FITUP, FIELD_WELDING
ReportSpoolIdAreaWiseModel area = new ReportSpoolIdAreaWiseModel();
area.project_id = int.Parse(dr["PROJECT_ID"].ToString());
area.job_code = dr["JOB_CODE"].ToString();
area.job_name = dr["JOB_NAME"].ToString();
area.client_name = dr["CLIENT_NAME"].ToString();
area.proj_rem = dr["PROJ_REM"].ToString();
area.app_logo1 = dr["APP_LOGO1"].ToString();
area.area_l1 = dr["AREA_L1"].ToString();
area.area_l2 = dr["AREA_L2"].ToString();
area.sg_shop = MathUtility.stringToDouble(dr["SG_SHOP"].ToString());
area.sg_field = MathUtility.stringToDouble(dr["SG_FIELD"].ToString());
area.mat_avl = MathUtility.stringToDouble(dr["MAT_AVL"].ToString());
area.jc_issued = MathUtility.stringToDouble(dr["JC_ISSUED"].ToString());
area.swn = MathUtility.stringToDouble(dr["SWN"].ToString());
area.dim_check = MathUtility.stringToDouble(dr["DIM_CHECK"].ToString());
area.qc_cleared = MathUtility.stringToDouble(dr["QC_CLEARED"].ToString());
area.paint_req = MathUtility.stringToDouble(dr["PAINT_REQ"].ToString());
area.shipping_jc = MathUtility.stringToDouble(dr["SHIPPING_JC"].ToString());
area.painted = MathUtility.stringToDouble(dr["PAINTED"].ToString());
area.shipping = MathUtility.stringToDouble(dr["SHIPPING"].ToString());
area.shop_fitup = MathUtility.stringToDouble(dr["SHOP_FITUP"].ToString());
area.shop_welding = MathUtility.stringToDouble(dr["SHOP_WELDING"].ToString());
area.field_fitup = MathUtility.stringToDouble(dr["FIELD_FITUP"].ToString());
area.field_welding = MathUtility.stringToDouble(dr["FIELD_WELDING"].ToString());
areas.Add(area);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(areas);
Context.Response.Write(data);
} // method
public void GetNDEPMIStatusDetails(int ProjId, string SUB_CON_ID, string CAT_ID, string Inclde_Prod)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <Duqm_NDE_PMI_Status_Model> ndePMIStatusList = new List <Duqm_NDE_PMI_Status_Model>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = string.Empty;
if (Inclde_Prod.ToUpper() == "Y")
{
string prod = "SELECT * FROM VIEW_LINE_CLASS_WISE_PMI" +
$" WHERE PROJ_ID={1} AND SUB_CON_ID = '{SUB_CON_ID}' AND CAT_ID= '{CAT_ID}'";
sql = prod;
}
else
{
string nonProd = "SELECT * FROM VIEW_LINE_CLS_PMI_NON_PROD" +
$" WHERE PROJ_ID={1} AND SUB_CON_ID = '{SUB_CON_ID}' AND CAT_ID= '{CAT_ID}'";
sql = nonProd;
}
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Duqm_NDE_PMI_Status_Model ndePMIStatus = new Duqm_NDE_PMI_Status_Model();
ndePMIStatus.PROJ_ID = dr["PROJ_ID"].ToString();
ndePMIStatus.JOB_CODE = dr["JOB_CODE"].ToString();
ndePMIStatus.CLIENT_NAME = dr["CLIENT_NAME"].ToString();
ndePMIStatus.JV_OF = dr["JV_OF"].ToString();
ndePMIStatus.JOB_NAME = dr["JOB_NAME"].ToString();
ndePMIStatus.SHORT_CODE = dr["SHORT_CODE"].ToString();
ndePMIStatus.REP_TITLE1 = dr["REP_TITLE1"].ToString();
ndePMIStatus.REP_TITLE2 = dr["REP_TITLE2"].ToString();
ndePMIStatus.SUB_CON_ID = Convert.ToInt32(dr["SUB_CON_ID"].ToString());
ndePMIStatus.SUB_CON_NAME = dr["SUB_CON_NAME"].ToString();
ndePMIStatus.CAT_ID = Convert.ToInt32(dr["CAT_ID"].ToString());
bool catName = DatabaseTools.ColumnExists(dr, "CAT_NAME");
if (catName)
{
ndePMIStatus.CAT_NAME = dr["CAT_NAME"].ToString();
}
//ndePWHTStatus.CAT_NAME = dr["CAT_NAME"].ToString();
ndePMIStatus.LINE_CLASS = dr["LINE_CLASS"].ToString();
ndePMIStatus.PMI = dr["PMI"].ToString();
ndePMIStatus.TOTAL_JOINTS = Convert.ToInt32(dr["TOTAL_JOINTS"].ToString());
ndePMIStatus.PMI_WELDED = Convert.ToInt32(dr["PMI_WELDED"].ToString());
ndePMIStatus.PMI_REQUIRED = Convert.ToInt32(dr["PMI_REQUIRED"].ToString());
ndePMIStatus.PMI_REQUESTED = Convert.ToInt32(dr["PMI_REQUESTED"].ToString());
ndePMIStatus.PMI_DONE = Convert.ToInt32(dr["PMI_DONE"].ToString());
ndePMIStatus.PMI_COVERAGE = Convert.ToDouble(dr["PMI_COVERAGE"].ToString());
ndePMIStatus.PMI_BALANCE = Convert.ToInt32(dr["PMI_BALANCE"].ToString());
ndePMIStatusList.Add(ndePMIStatus);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(ndePMIStatusList);
Context.Response.Write(data);
}
public void GetDailyFitupJointDetails(int PROJECT_ID, string SUB_CON_ID, string CAT_ID, string MAT_TYPE, string DATE_FROM, string DATE_TO)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <DailyFitupWelding_Joint_Model> dailyFitupJointShopList = new List <DailyFitupWelding_Joint_Model>();
string conn_str = DatabaseTools.AmgDbConnectionString(PROJECT_ID);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = string.Empty;
if (string.IsNullOrEmpty(DATE_FROM) && string.IsNullOrEmpty(DATE_TO))
{
DATE_FROM = DateTime.Now.ToString("dd-MMM-yyyy");
DATE_TO = DateTime.Now.ToString("dd-MMM-yyyy");
}
if (CAT_ID == "1")
{
string categoryType = "SELECT * FROM VIEW_WELDING_REPORT" +
$" WHERE PROJECT_ID={1} AND (SUB_CON_ID = '{SUB_CON_ID}' OR '{SUB_CON_ID}' ='99') AND (CAT_ID= '{1}' OR CAT_ID='{3}') AND (FITUP_DATE >= '{DATE_FROM}') AND (FITUP_DATE <= '{DATE_TO}') AND (MAT_TYPE = '{MAT_TYPE}' OR '{MAT_TYPE}' = 'XXX') ORDER BY ISO_TITLE1, SPOOL, JOINT_NO";
sql = categoryType;
}
else
{
string categoryType = "SELECT * FROM VIEW_WELDING_REPORT" +
$" WHERE PROJECT_ID={1} AND (SUB_CON_ID = '{SUB_CON_ID}' OR '{SUB_CON_ID}' ='99') AND (CAT_ID= '{2}' OR CAT_ID='{4}') AND (FITUP_DATE >= '{DATE_FROM}') AND (FITUP_DATE <= '{DATE_TO}') AND (MAT_TYPE = '{MAT_TYPE}' OR '{MAT_TYPE}' = 'XXX') ORDER BY ISO_TITLE1, SPOOL, JOINT_NO";
sql = categoryType;
}
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
DailyFitupWelding_Joint_Model dailyFitupJointShop = new DailyFitupWelding_Joint_Model();
dailyFitupJointShop.project_id = dr["PROJECT_ID"].ToString();
dailyFitupJointShop.job_code = dr["job_code"].ToString();
dailyFitupJointShop.client_name = dr["client_name"].ToString();
dailyFitupJointShop.rep_title1 = dr["rep_title1"].ToString();
dailyFitupJointShop.rep_title2 = dr["rep_title2"].ToString();
dailyFitupJointShop.job_name = dr["job_name"].ToString();
dailyFitupJointShop.proj_rem = dr["proj_rem"].ToString();
// dailyFitupJointShop.app_logo1 = dr["app_logo1"].ToString();
// dailyFitupJointShop.app_logo2 = dr["app_logo2"].ToString();
//dailyFitupJointShop.wo_id = dr["wo_id"].ToString();
//dailyFitupJointShop.wo_name = dr["wo_name"].ToString();
dailyFitupJointShop.sub_con_id = dr["sub_con_id"].ToString();
dailyFitupJointShop.sub_con_name = dr["sub_con_name"].ToString();
//dailyFitupJointShop.iso_id = dr["iso_id"].ToString();
dailyFitupJointShop.line_no = dr["line_no"].ToString();
dailyFitupJointShop.iso_title1 = dr["iso_title1"].ToString();
//dailyFitupJointShop.sheet = dr["sheet"].ToString();
dailyFitupJointShop.spool = dr["spool"].ToString();
dailyFitupJointShop.rev_no = dr["rev_no"].ToString();
dailyFitupJointShop.fcr = dr["fcr"].ToString();
dailyFitupJointShop.scr = dr["scr"].ToString();
//dailyFitupJointShop.area_l1 = dr["area_l1"].ToString();
//dailyFitupJointShop.train = dr["train"].ToString();
//dailyFitupJointShop.srv_code = dr["srv_code"].ToString();
dailyFitupJointShop.spl_id = dr["spl_id"].ToString();
dailyFitupJointShop.main_mat = dr["main_mat"].ToString();
dailyFitupJointShop.field_sc_id = dr["field_sc_id"].ToString();
dailyFitupJointShop.field_sc_name = dr["field_sc_name"].ToString();
dailyFitupJointShop.mat_type = dr["mat_type"].ToString();
dailyFitupJointShop.mat_class = dr["mat_class"].ToString();
dailyFitupJointShop.joint_id = dr["joint_id"].ToString();
dailyFitupJointShop.joint_no = dr["joint_no"].ToString();
dailyFitupJointShop.rev_code = dr["rev_code"].ToString();
dailyFitupJointShop.crw_code = dr["crw_code"].ToString();
dailyFitupJointShop.joint_type = dr["joint_type"].ToString();
dailyFitupJointShop.joint_size = dr["joint_size"].ToString();
dailyFitupJointShop.joint_size_dec = dr["joint_size_dec"].ToString();
dailyFitupJointShop.joint_thk = dr["joint_thk"].ToString();
dailyFitupJointShop.schedule = dr["schedule"].ToString();
dailyFitupJointShop.cat_id = dr["cat_id"].ToString();
dailyFitupJointShop.cat_name = dr["cat_name"].ToString();
dailyFitupJointShop.item_1 = dr["item_1"].ToString();
dailyFitupJointShop.item_2 = dr["item_2"].ToString();
//dailyFitupJointShop.mat_id1 = dr["mat_id1"].ToString();
//dailyFitupJointShop.mat_id2 = dr["mat_id2"].ToString();
//dailyFitupJointShop.mat_code1 = dr["mat_code1"].ToString();
//dailyFitupJointShop.short_descr1 = dr["short_descr1"].ToString();
//dailyFitupJointShop.mat_code2 = dr["mat_code2"].ToString();
//dailyFitupJointShop.short_descr2 = dr["short_descr2"].ToString();
dailyFitupJointShop.heat_no1 = dr["heat_no1"].ToString();
dailyFitupJointShop.heat_no2 = dr["heat_no2"].ToString();
dailyFitupJointShop.fitup_rep_no = dr["fitup_rep_no"].ToString();
dailyFitupJointShop.weld_rep_no = dr["weld_rep_no"].ToString();
dailyFitupJointShop.weld_insp = dr["weld_insp"].ToString();
//dailyFitupJointShop.amg_insp_rep = dr["amg_insp_rep"].ToString();
string fitupDate = dr["fitup_date"].ToString();
if (!string.IsNullOrEmpty(fitupDate))
{
dailyFitupJointShop.fitup_date = DateTime.Parse(dr["fitup_date"].ToString()).ToString("dd-MMM-yyyy");
}
string weld_insp_date = dr["weld_insp_date"].ToString();
if (!string.IsNullOrEmpty(weld_insp_date))
{
dailyFitupJointShop.weld_insp_date = DateTime.Parse(dr["weld_insp_date"].ToString()).ToString("dd-MMM-yyyy");
}
string weld_date = dr["weld_date"].ToString();
if (!string.IsNullOrEmpty(weld_date))
{
dailyFitupJointShop.weld_date = DateTime.Parse(dr["weld_date"].ToString()).ToString("dd-MMM-yyyy");
}
string weld_entry_date = dr["weld_entry_date"].ToString();
if (!string.IsNullOrEmpty(weld_entry_date))
{
dailyFitupJointShop.weld_entry_date = DateTime.Parse(dr["weld_entry_date"].ToString()).ToString("dd-MMM-yyyy");
}
dailyFitupJointShop.fitup_insp = dr["fitup_insp"].ToString();
dailyFitupJointShop.amg_weld_rep = dr["amg_weld_rep"].ToString();
dailyFitupJointShop.root_hot_welder = dr["root_hot_welder"].ToString();
dailyFitupJointShop.fill_cap_welder = dr["fill_cap_welder"].ToString();
dailyFitupJointShop.rt = dr["rt"].ToString();
dailyFitupJointShop.pt = dr["pt"].ToString();
dailyFitupJointShop.mt = dr["mt"].ToString();
dailyFitupJointShop.pwht = dr["pwht"].ToString();
dailyFitupJointShop.pmi = dr["pmi"].ToString();
dailyFitupJointShop.ht = dr["ht"].ToString();
//dailyFitupJointShop.wps_no = dr["wps_no"].ToString();
//dailyFitupJointShop.prog_factor = dr["prog_factor"].ToString();
//dailyFitupJointShop.cns_batch = dr["cns_batch"].ToString();
dailyFitupJointShop.weld_process = dr["weld_process"].ToString();
dailyFitupJointShopList.Add(dailyFitupJointShop);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(dailyFitupJointShopList);
Context.Response.Write(data);
}
public void GetSpoolClearanceAndReleaseServiceDetails(int ProjId, string SpoolId)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <DuqmSpoolClearanceAndReleaseModel> spoolClearance = new List <DuqmSpoolClearanceAndReleaseModel>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = "SELECT * FROM VIEW_SPL_CLR_HS" +
$" WHERE PROJECT_ID=1 AND spl_id={SpoolId}";
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
DuqmSpoolClearanceAndReleaseModel clearance = new DuqmSpoolClearanceAndReleaseModel();
clearance.LINE_NO = dr["LINE_NO"].ToString();
clearance.ISO_TITLE1 = dr["ISO_TITLE1"].ToString();
clearance.SPOOL = dr["SPOOL"].ToString();
clearance.SC_NAME = dr["SC_NAME"].ToString();
clearance.SPL_REV = dr["SPL_REV"].ToString();
clearance.SPL_SCR = dr["SPL_SCR"].ToString();
clearance.SPL_FCR = dr["SPL_FCR"].ToString();
clearance.MAT_CLASS = dr["MAT_CLASS"].ToString();
clearance.MAT_TYPE = dr["MAT_TYPE"].ToString();
clearance.SPL_PS = dr["SPL_PS"].ToString();
clearance.SHOP_ID = dr["SHOP_ID"].ToString();
clearance.DIM_CHECK = dr["DIM_CHECK"].ToString();
clearance.HYDRO_REP_NO = dr["HYDRO_REP_NO"].ToString();
string hydro_rep_date = dr["HYDRO_REP_DATE"].ToString();
if (!string.IsNullOrEmpty(hydro_rep_date))
{
clearance.HYDRO_REP_DATE = DateTime.Parse(dr["HYDRO_REP_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
clearance.PNT_REP_NO = dr["PNT_REP_NO"].ToString();
string pick_rep_no_date = dr["PICK_REP_NO_DATE"].ToString();
if ((!string.IsNullOrEmpty(pick_rep_no_date)) && (pick_rep_no_date != "/"))
{
clearance.PICK_REP_NO_DATE = DateTime.Parse(dr["PICK_REP_NO_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
clearance.PNT_REQ_NO = dr["PNT_REQ_NO"].ToString();
clearance.JOINT_NO = dr["JOINT_NO"].ToString();
clearance.JOINT_TYPE = dr["JOINT_TYPE"].ToString();
clearance.WPS_NO = dr["WPS_NO"].ToString();
clearance.TW_FLG = dr["TW_FLG"].ToString();
clearance.MRV_NOS1 = dr["MRV_NOS1"].ToString();
clearance.MAT_CODE1 = dr["MAT_CODE1"].ToString();
clearance.HEAT_NO1 = dr["HEAT_NO1"].ToString();
clearance.FITUP_REP_NO = dr["FITUP_REP_NO"].ToString();
clearance.ROOT_HOT_WELDER = dr["ROOT_HOT_WELDER"].ToString();
clearance.WELD_REP_NO = dr["WELD_REP_NO"].ToString();
clearance.PT_REP_NO = dr["PT_REP_NO"].ToString();
clearance.MT_PT_ROOT_REP_NO = dr["MT_PT_ROOT_REP_NO"].ToString();
clearance.PMI1_REP_NO = dr["PMI1_REP_NO"].ToString();
clearance.RT1_REP_NO = dr["RT1_REP_NO"].ToString();
clearance.RT2_REP_NO = dr["RT2_REP_NO"].ToString();
clearance.PWHT_REP_NO = dr["PWHT_REP_NO"].ToString();
clearance.UT_REP_NO = dr["UT_REP_NO"].ToString();
clearance.HT_REP_NO = dr["HT_REP_NO"].ToString();
clearance.FT_REP_NO = dr["FT_REP_NO"].ToString();
clearance.RT1_PASS_FLG = dr["RT1_PASS_FLG"].ToString();
clearance.RT2_PASS_FLG = dr["RT2_PASS_FLG"].ToString();
clearance.TRACER = dr["TRACER"].ToString();
clearance.SYMBOL = dr["SYMBOL"].ToString();
clearance.JOINT_SIZE = dr["JOINT_SIZE"].ToString();
clearance.JOINT_THK = dr["JOINT_THK"].ToString();
clearance.CAT_NAME = dr["CAT_NAME"].ToString();
clearance.MRV_NOS2 = dr["MRV_NOS2"].ToString();
clearance.MAT_CODE2 = dr["MAT_CODE2"].ToString();
clearance.HEAT_NO2 = dr["HEAT_NO2"].ToString();
string fitup_date = dr["FITUP_DATE"].ToString();
if (!string.IsNullOrEmpty(fitup_date))
{
clearance.FITUP_DATE = DateTime.Parse(dr["FITUP_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
clearance.FILL_CAP_WELDER = dr["FILL_CAP_WELDER"].ToString();
string weld_date = dr["WELD_DATE"].ToString();
if (!string.IsNullOrEmpty(weld_date))
{
clearance.WELD_DATE = DateTime.Parse(dr["WELD_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
string pt_date = dr["PT_DATE"].ToString();
if (!string.IsNullOrEmpty(pt_date))
{
clearance.PT_DATE = DateTime.Parse(dr["PT_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
string mt_pt_rootRep_date = dr["MT_PT_ROOT_REP_DATE"].ToString();
if (!string.IsNullOrEmpty(mt_pt_rootRep_date))
{
clearance.MT_PT_ROOT_REP_DATE = DateTime.Parse(dr["MT_PT_ROOT_REP_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
string mt_date = dr["MT_DATE"].ToString();
if (!string.IsNullOrEmpty(mt_date))
{
clearance.MT_DATE = DateTime.Parse(dr["MT_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
string pmi1_date = dr["PMI1_DATE"].ToString();
if (!string.IsNullOrEmpty(pmi1_date))
{
clearance.PMI1_DATE = DateTime.Parse(dr["PMI1_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
string rt1_date = dr["RT1_DATE"].ToString();
if (!string.IsNullOrEmpty(rt1_date))
{
clearance.RT1_DATE = DateTime.Parse(dr["RT1_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
string rt2_date = dr["RT2_DATE"].ToString();
if (!string.IsNullOrEmpty(rt2_date))
{
clearance.RT2_DATE = DateTime.Parse(dr["RT2_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
string pwht_date = dr["PWHT_DATE"].ToString();
if (!string.IsNullOrEmpty(pwht_date))
{
clearance.PWHT_DATE = DateTime.Parse(dr["PWHT_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
string ut_date = dr["UT_DATE"].ToString();
if (!string.IsNullOrEmpty(ut_date))
{
clearance.UT_DATE = DateTime.Parse(dr["UT_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
string ht_date = dr["HT_DATE"].ToString();
if (!string.IsNullOrEmpty(ht_date))
{
clearance.HT_DATE = DateTime.Parse(dr["HT_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
string ft_date = dr["FT_DATE"].ToString();
if (!string.IsNullOrEmpty(ft_date))
{
clearance.FT_DATE = DateTime.Parse(dr["FT_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
clearance.UT_PASS_FLG = dr["UT_PASS_FLG"].ToString();
clearance.DIM_CHECK = dr["DIM_CHECK"].ToString();
clearance.NDE_CMPLT = dr["NDE_CMPLT"].ToString();
clearance.PAINT_CLR = dr["PAINT_CLR"].ToString();
spoolClearance.Add(clearance);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(spoolClearance);
Context.Response.Write(data);
}
public void GetWelderPerformanceMonthlyDetails(int ProjId, int SUB_CON_ID, string DATE_FROM, string DATE_TO)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <Welder_Performance_Model> welderPerformanceList = new List <Welder_Performance_Model>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
if (string.IsNullOrEmpty(DATE_FROM) && string.IsNullOrEmpty(DATE_TO))
{
DATE_FROM = DateTime.Now.ToString("dd-MMM-yyyy");
DATE_TO = DateTime.Now.ToString("dd-MMM-yyyy");
}
string sql = "SELECT PROJECT_ID, JOB_CODE, CLIENT_NAME, JOB_NAME, PROJ_DESC, " +
$"SC_ID, SUB_CON_NAME, WELDER_ID, WELDER_NO, " +
$"SUM(FNC_IIF_DATE(CREATE_DATE, '{DATE_TO}', WELD_JNTS, WELD_JNTS, 0)) AS JNTS_WELDED_C," +
$"SUM(FNC_IIF_DATE(CREATE_DATE, '{DATE_TO}', RT_JNTS, RT_JNTS, 0)) AS JNTS_RT_DONE_C," +
$"SUM(FNC_IIF_DATE(CREATE_DATE, '{DATE_TO}', REP_JNTS, REP_JNTS, 0)) AS JNTS_REPAR_C," +
$"SUM(FNC_BETWEEN_DATE('{DATE_FROM}', '{DATE_TO}', CREATE_DATE, WELD_JNTS)) AS JNTS_WELDED_THIS," +
$"SUM(FNC_BETWEEN_DATE('{DATE_FROM}', '{DATE_TO}', CREATE_DATE, RT_JNTS)) AS JNTS_RT_DONE_THIS," +
$"SUM(FNC_BETWEEN_DATE('{DATE_FROM}', '{DATE_TO}', CREATE_DATE, REP_JNTS)) AS JNTS_REPAR_THIS," +
$"SUM(FNC_BETWEEN_DATE(TO_DATE('{DATE_FROM}') -7, TO_DATE('{DATE_FROM}') - 1, CREATE_DATE, WELD_JNTS)) AS JNTS_WELDED_LAST_WEEK," +
$"SUM(FNC_BETWEEN_DATE(TO_DATE('{DATE_FROM}') -7, TO_DATE('{DATE_FROM}') - 1, CREATE_DATE, RT_JNTS)) AS JNTS_RT_DONE_LAST_WEEK," +
$"SUM(FNC_BETWEEN_DATE(TO_DATE('{DATE_FROM}') -7, TO_DATE('{DATE_FROM}') - 1, CREATE_DATE, REP_JNTS)) AS JNTS_REPAR_LAST_WEEK," +
$"SUM(FNC_IIF_DATE(CREATE_DATE, TO_DATE('{DATE_FROM}' )-7, 0, WELD_JNTS, 0)) AS JNTS_WELDED_PREV," +
$"SUM(FNC_IIF_DATE(CREATE_DATE, TO_DATE('{DATE_FROM}') -7, 0, RT_JNTS, 0)) AS JNTS_RT_DONE_PREV," +
$"SUM(FNC_IIF_DATE(CREATE_DATE, TO_DATE('{DATE_FROM}') -7, 0, REP_JNTS, 0)) AS JNTS_REPAR_PREV FROM VIEW_WELDER_PERF_F " +
$"WHERE PROJECT_ID={1} AND SC_ID = {SUB_CON_ID} " +
$"GROUP BY WELDER_ID, WELDER_NO, SC_ID, SUB_CON_NAME, PROJECT_ID, JOB_CODE, CLIENT_NAME, JOB_NAME, PROJ_DESC " +
$"ORDER BY SUB_CON_NAME, WELDER_NO";
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Welder_Performance_Model welderPerformance = new Welder_Performance_Model();
welderPerformance.PROJECT_ID = dr["PROJECT_ID"].ToString();
welderPerformance.JOB_CODE = dr["JOB_CODE"].ToString();
welderPerformance.CLIENT_NAME = dr["CLIENT_NAME"].ToString();
welderPerformance.PROJ_DESC = dr["PROJ_DESC"].ToString();
welderPerformance.JOB_NAME = dr["JOB_NAME"].ToString();
welderPerformance.SUB_CON_NAME = dr["SUB_CON_NAME"].ToString();
welderPerformance.SC_ID = Convert.ToInt32(dr["SC_ID"].ToString());
string welderID = dr["WELDER_ID"].ToString();
if (!string.IsNullOrEmpty(welderID))
{
welderPerformance.WELDER_ID = Convert.ToInt32(dr["WELDER_ID"].ToString());
}
welderPerformance.WELDER_NO = dr["WELDER_NO"].ToString();
welderPerformance.JNTS_WELDED_C = Convert.ToDouble(dr["JNTS_WELDED_C"].ToString());
welderPerformance.JNTS_RT_DONE_C = Convert.ToDouble(dr["JNTS_RT_DONE_C"].ToString());
welderPerformance.JNTS_REPAR_C = Convert.ToDouble(dr["JNTS_REPAR_C"].ToString());
welderPerformance.JNTS_WELDED_THIS = Convert.ToDouble(dr["JNTS_WELDED_THIS"].ToString());
welderPerformance.JNTS_RT_DONE_THIS = Convert.ToDouble(dr["JNTS_RT_DONE_THIS"].ToString());
welderPerformance.JNTS_REPAR_THIS = Convert.ToDouble(dr["JNTS_REPAR_THIS"].ToString());
welderPerformance.JNTS_WELDED_LAST_WEEK = Convert.ToDouble(dr["JNTS_WELDED_LAST_WEEK"].ToString());
welderPerformance.JNTS_RT_DONE_LAST_WEEK = Convert.ToDouble(dr["JNTS_RT_DONE_LAST_WEEK"].ToString());
welderPerformance.JNTS_REPAR_LAST_WEEK = Convert.ToDouble(dr["JNTS_REPAR_LAST_WEEK"].ToString());
welderPerformance.JNTS_WELDED_PREV = Convert.ToDouble(dr["JNTS_WELDED_PREV"].ToString());
welderPerformance.JNTS_RT_DONE_PREV = Convert.ToDouble(dr["JNTS_RT_DONE_PREV"].ToString());
welderPerformance.JNTS_REPAR_PREV = Convert.ToDouble(dr["JNTS_REPAR_PREV"].ToString());
welderPerformanceList.Add(welderPerformance);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(welderPerformanceList);
Context.Response.Write(data);
}
public void GetFitupWeldingProgress_MatWiseDetails(int ProjId, string CAT_ID, int SUB_CON_ID, string DATE_FROM, string DATE_TO, string IsShop)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <FitupWeldingProgress_MatWise_Model> fitupWeldingProgressList = new List <FitupWeldingProgress_MatWise_Model>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = string.Empty;
if (string.IsNullOrEmpty(DATE_FROM) && string.IsNullOrEmpty(DATE_TO))
{
DATE_FROM = DateTime.Now.ToString("dd-MMM-yyyy");
DATE_TO = DateTime.Now.ToString("dd-MMM-yyyy");
}
if (IsShop.ToUpper() == "Y")
{
string query = "SELECT JOB_CODE, JOB_NAME, PROJ_REM, SUB_CON_ID, " +
$"SUB_CON_NAME, MAIN_MAT, " +
$"SUM(S_ID_SCOPE) AS S_ID_SCOPE," +
$"SUM(FNC_BETWEEN_DATE('{DATE_FROM}', '{DATE_TO}', FITUP_DATE, S_FITUP_DONE)) AS S_FITUP_DONE," +
$"SUM(FNC_BETWEEN_DATE('{DATE_FROM}', '{DATE_TO}', WELD_DATE, S_WELDING_DONE)) AS S_WELDING_DONE," +
$"SUM(F_ID_SCOPE) AS F_ID_SCOPE," +
$"SUM(FNC_BETWEEN_DATE('{DATE_FROM}', '{DATE_TO}', FITUP_DATE, F_FITUP_DONE)) AS F_FITUP_DONE," +
$"SUM(FNC_BETWEEN_DATE('{DATE_FROM}', '{DATE_TO}', WELD_DATE, F_WELDING_DONE)) AS F_WELDING_DONE," +
$"SUM(FNC_BETWEEN_DATE('{DATE_FROM}', '{DATE_TO}', SWN_DATE, SWN_BAL_ID)) AS S_SWN_BALANCE FROM VIEW_WELDING_REPORT_SF " +
$"WHERE PROJECT_ID={1} AND (SUB_CON_ID = {SUB_CON_ID} OR {SUB_CON_ID} = 99) " +
$"GROUP BY JOB_CODE, JOB_NAME, PROJ_REM, SUB_CON_ID, SUB_CON_NAME, MAIN_MAT ";
sql = query;
}
else
{
string query = "SELECT JOB_CODE, JOB_NAME, PROJ_REM, FIELD_SC_ID, " +
$"SUB_CON_NAME, MAIN_MAT, " +
$"SUM(F_ID_SCOPE) AS F_ID_SCOPE," +
$"SUM(FNC_BETWEEN_DATE('{DATE_FROM}', '{DATE_TO}', FITUP_DATE, F_FITUP_DONE)) AS F_FITUP_DONE," +
$"SUM(FNC_BETWEEN_DATE('{DATE_FROM}', '{DATE_TO}', WELD_DATE, F_WELDING_DONE)) AS F_WELDING_DONE FROM VIEW_WELDING_REPORT_FIELD_A " +
$"WHERE PROJECT_ID={1} AND (FIELD_SC_ID = {SUB_CON_ID} OR {SUB_CON_ID} = 99) " +
$"GROUP BY JOB_CODE, JOB_NAME, PROJ_REM, FIELD_SC_ID, SUB_CON_NAME, MAIN_MAT ";
sql = query;
}
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
FitupWeldingProgress_MatWise_Model fitupWeldingProgress = new FitupWeldingProgress_MatWise_Model();
fitupWeldingProgress.JOB_CODE = dr["JOB_CODE"].ToString();
fitupWeldingProgress.JOB_NAME = dr["JOB_NAME"].ToString();
fitupWeldingProgress.PROJ_REM = dr["PROJ_REM"].ToString();
fitupWeldingProgress.SUB_CON_NAME = dr["SUB_CON_NAME"].ToString();
if (IsShop.ToUpper() == "Y")
{
fitupWeldingProgress.SUB_CON_ID = Convert.ToInt32(dr["SUB_CON_ID"].ToString());
fitupWeldingProgress.S_ID_SCOPE = MathUtility.stringToDouble(dr["S_ID_SCOPE"].ToString());
fitupWeldingProgress.S_FITUP_DONE = MathUtility.stringToDouble(dr["S_FITUP_DONE"].ToString());
fitupWeldingProgress.S_WELDING_DONE = MathUtility.stringToDouble(dr["S_WELDING_DONE"].ToString());
fitupWeldingProgress.S_SWN_BALANCE = MathUtility.stringToDouble(dr["S_SWN_BALANCE"].ToString());
}
if (IsShop.ToUpper() == "N")
{
fitupWeldingProgress.FIELD_SC_ID = Convert.ToInt32(dr["FIELD_SC_ID"].ToString());
}
fitupWeldingProgress.MAIN_MAT = dr["MAIN_MAT"].ToString();
fitupWeldingProgress.F_ID_SCOPE = MathUtility.stringToDouble(dr["F_ID_SCOPE"].ToString());
fitupWeldingProgress.F_FITUP_DONE = MathUtility.stringToDouble(dr["F_FITUP_DONE"].ToString());
fitupWeldingProgress.F_WELDING_DONE = MathUtility.stringToDouble(dr["F_WELDING_DONE"].ToString());
fitupWeldingProgressList.Add(fitupWeldingProgress);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(fitupWeldingProgressList);
Context.Response.Write(data);
}
public void GetDailyWeldingControlSheet(int ProjId, string weldReportNo)
{
Context.Response.Clear();
Context.Response.ContentType = "application/json";
List <DuqmDailyWeldingControlSheetModel> weldSummary = new List <DuqmDailyWeldingControlSheetModel>();
string conn_str = DatabaseTools.AmgDbConnectionString(ProjId);
using (OracleConnection conn = new OracleConnection(conn_str))
{
conn.Open();
string sql = "SELECT * FROM REP_DAILY_WELDING_CTRL_SHT" +
$" WHERE PROJECT_ID={1} AND WELD_REP_NO = '{weldReportNo}'";
using (OracleCommand cmd = new OracleCommand(sql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
DuqmDailyWeldingControlSheetModel summary = new DuqmDailyWeldingControlSheetModel();
summary.duqm_no = dr["DUQM_NO"].ToString();
summary.iso_title1 = dr["ISO_TITLE1"].ToString();
summary.spool = dr["SPOOL"].ToString();
summary.joint_no = dr["JOINT_NO"].ToString();
summary.heat_no1 = dr["HEAT_NO1"].ToString();
summary.heat_no2 = dr["HEAT_NO2"].ToString();
summary.cat_name = dr["CAT_NAME"].ToString();
summary.mat_class = dr["MAT_CLASS"].ToString();
summary.ps = dr["PS"].ToString();
summary.joint_size_dec = double.Parse(dr["JOINT_SIZE_DEC"].ToString());
summary.schedule = dr["SCHEDULE"].ToString();
summary.joint_thk = double.Parse(dr["JOINT_THK"].ToString());
summary.joint_type = dr["JOINT_TYPE"].ToString();
summary.wps_no = dr["WPS_NO"].ToString();
//summary.welding_consumables = dr["WELDING_CONSUMABLES"].ToString();
summary.electrode_size = dr["ELECTRODE_SIZE"].ToString();
summary.batch_no = dr["BATCH_NO"].ToString();
string weld_date = dr["WELD_DATE"].ToString();
if (!string.IsNullOrEmpty(weld_date))
{
summary.weld_date = DateTime.Parse(dr["WELD_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
summary.fitup_date = DateTime.Parse(dr["FITUP_DATE"].ToString()).ToString("dd-MMM-yyyy");
summary.visual_affect = dr["VISUAL_AFFECT"].ToString();
summary.root_hot_welder = dr["ROOT_HOT_WELDER"].ToString();
summary.fill_cap_welder = dr["FILL_CAP_WELDER"].ToString();
summary.weld_rep_no = dr["WELD_REP_NO"].ToString();
summary.rt = double.Parse(string.IsNullOrEmpty(dr["RT"].ToString()) ? "0" : dr["RT"].ToString());
summary.pwht = dr["PWHT"].ToString();
summary.mt = dr["MT"].ToString();
summary.pt = dr["PT"].ToString();
summary.ut = dr["UT"].ToString();
summary.pmi = dr["PMI"].ToString();
summary.ht = dr["HT"].ToString();
weldSummary.Add(summary);
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string data = js.Serialize(weldSummary);
Context.Response.Write(data);
}