public SortableBindingList <sp_RPT001_GetWorkPlaceLight_Result> GetWorkPlaceLight(RPT001_WorkPlaceLight_Criteria criteria)
{
try
{
//var config = new MapperConfiguration(cfg => {
// cfg.CreateMap<sp_RPT001_GetWorkPlaceLight_Result, RPT001_WorkPlaceLightDTO>();
// cfg.CreateMap<List<sp_RPT001_GetWorkPlaceLight_Result>, List<RPT001_WorkPlaceLightDTO>>();
//});
//IMapper mapper = config.CreateMapper();
using (OIS_RPTEntities ct = new OIS_RPTEntities())
{
var result = ct.sp_RPT001_GetWorkPlaceLight(
criteria.ID,
criteria.REPORTNUMBER,
criteria.CUSTOMER_ID,
criteria.DATE_FROM,
criteria.DATE_TO,
criteria.MEASURED_BY,
criteria.INSTRUMENT_ID,
criteria.CRT_USER_ID,
criteria.SHOW_DELETE_RECORD).ToList();
return(new SortableBindingList <sp_RPT001_GetWorkPlaceLight_Result>(result));
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <sp_RPT002_GetWorkPlaceAirReport_2_Result> GetWorkPlaceAirReport_2(int ID)
{
try
{
using (OIS_RPTEntities ct = new OIS_RPTEntities())
{
var result = ct.sp_RPT002_GetWorkPlaceAirReport_2(ID).ToList();
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public SortableBindingList <sp_RPT001_GetWorkPlaceLightReport_Result> GetWorkPlaceLightReport(int ID)
{
try
{
using (OIS_RPTEntities ct = new OIS_RPTEntities())
{
var result = ct.sp_RPT001_GetWorkPlaceLightReport(ID).ToList();
return(new SortableBindingList <sp_RPT001_GetWorkPlaceLightReport_Result>(result));
}
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetWorkPlaceLightUser(int ID)
{
try
{
using (OIS_RPTEntities ct = new OIS_RPTEntities())
{
var result = ct.TBR_WORK_PLACE_LIGHT_USER.Where(x => x.ID == ID).ToList();
if (result == null)
{
result = new List <TBR_WORK_PLACE_LIGHT_USER>();
}
return(result.ToDataTable());
}
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetWorkPlaceLightDt(int ID)
{
try
{
using (OIS_RPTEntities ct = new OIS_RPTEntities())
{
var result = ct.sp_RPT001_GetWorkPlaceLightDt(ID).ToList();
if (result == null)
{
result = new List <sp_RPT001_GetWorkPlaceLightDt_Result>();
}
return(result.ToDataTable());
}
}
catch (Exception ex)
{
throw ex;
}
}
public SortableBindingList <sp_RPT002_GetWorkPlaceAir_Result> GetWorkPlaceAir(RPT002_WorkPlaceAir_Criteria criteria)
{
try
{
using (OIS_RPTEntities ct = new OIS_RPTEntities())
{
var result = ct.sp_RPT002_GetWorkPlaceAir(criteria.ID,
criteria.ANALYSYS_NO,
criteria.JOB_NO,
criteria.CUSTOMER_ID,
criteria.ANALYTICAL_DATE_FROM,
criteria.ANALYTICAL_DATE_TO,
criteria.SAMPLING_DATE_FROM,
criteria.SAMPLING_DATE_TO,
criteria.SAMPING_BY,
criteria.SHOW_DELETE_RECORD).ToList();
return(new SortableBindingList <sp_RPT002_GetWorkPlaceAir_Result>(result));
}
}
catch (Exception ex)
{
throw ex;
}
}
public int SaveWorkPlaceAir(RPT002_WorkPlaceAirDTO data, bool IS_CANCEL)
{
try
{
int ID = 0;
using (OIS_RPTEntities ct = new OIS_RPTEntities())
using (TransactionScope trans = new TransactionScope())
{
ID = ct.sp_RPT002_SaveWorkPlaceAir(data.ID,
data.REPORT_DATE,
data.REPORT_TYPE,
data.ANALYSYS_NO,
data.CUSTOMER_ID,
data.CUSTOMER_ADDR,
data.CUSTOMER_PROJECT_ID,
data.CUSTOMER_PROJECT_ADDR,
data.RECEIVED_DATE,
data.ANALYTICAL_DATE_FROM,
data.ANALYTICAL_DATE_TO,
data.ANALYSIS_ID,
data.JOB_NO,
data.SAMPLING_BY,
data.REGISTRATION_ID,
data.LAB_SUPERVISOR_ID,
data.AGENT_FLAG,
data.AGENT_NAME,
data.SHOW_LV3_EACH_PAGE,
data.SHOW_LV3_CONT,
data.SHOW_LV2_CONT,
data.SHOW_PROJECT_ADDR,
OISDataInfo.UserInfomation.USER_ID,
IS_CANCEL).FirstOrDefault().GetValueOrDefault();
if (data.Detail != null)
{
foreach (DataRow dr in data.Detail.Rows)
{
ct.sp_RPT002_SaveWorkPlaceAirDt(dr.Field <int?>("ID"),
ID,
null,
dr.Field <string>("LOC_NAME"),
dr.Field <string>("LOC_NAME_LV2"),
dr.Field <string>("LOC_NAME_LV3"),
dr.Field <DateTime>("SAMPLING_DATE"),
dr.Field <int>("PARAMETER_ID"),
dr.Field <TimeSpan>("SAMPLING_TIME"),
dr.Field <decimal?>("AIR_FLOW"),
dr.Field <int>("SAMPLING_MINS"),
dr.Field <decimal?>("AIR_VOLUME"),
dr.Field <decimal?>("RESULT_VALUE"),
dr.Field <bool>("LESS_RESULT_VALUE"),
dr.Field <int>("UNIT_ID"),
dr.Field <decimal?>("STANDARD_THAI"),
dr.Field <decimal?>("STANDARD_ACGIH"),
dr.Field <bool>("CEILING_LIMIT"),
dr.Field <bool>("WAIT_RESULT"),
dr.Field <string>("REMARK"),
OISDataInfo.UserInfomation.USER_ID,
false);
}
}
string sql = "";
if (data.User != null)
{
foreach (DataRow dr in data.User.Rows)
{
if (sql.Length > 0)
{
sql = sql + Environment.NewLine;
}
sql = sql + string.Format("INSERT INTO TBR_WORK_PLACE_AIR_USER VALUES ({0}, '{1}');", ID, dr.Field <string>("SAMPLING_BY"));
}
}
if (sql.Length > 0)
{
ct.Database.ExecuteSqlCommand(sql);
}
trans.Complete();
}
return(ID);
}
catch (Exception ex)
{
throw ex;
}
}
public int SaveWorkPlaceLight(RPT001_WorkPlaceLightDTO data, bool IS_CANCEL = false)
{
try
{
int ID = 0;
using (OIS_RPTEntities ct = new OIS_RPTEntities())
using (TransactionScope trans = new TransactionScope())
{
ID = ct.sp_RPT001_SaveWorkPlaceLight(data.ID,
data.REPORT_CODE,
data.CUSTOMER_ID,
data.CUSTOMER_LANG,
data.CUSTOMER_NAME,
data.CUSTOMER_ADDR,
data.CUSTOMER_PROJECT_ID,
data.CUSTOMER_PROJECT_LANG,
data.CUSTOMER_PROJECT_NAME,
data.CUSTOMER_PROJECT_ADDR,
data.MEASURED_DATE,
data.MEASURED_DATE_TO,
data.MEASURED_TIME_FROM,
data.MEASURED_TIME_TO,
data.MEASURED_DATE_NIGHT,
data.MEASURED_DATE_NIGHT_TO,
data.MEASURED_TIME_FROM_NIGHT,
data.MEASURED_TIME_TO_NIGHT,
data.MEASURED_BY,
data.MEASURED_INSTRUMENT_ID,
data.REGISTRATION_ID,
data.LAB_SUPERVISOR_ID,
data.SHOW_LV3_EACH_PAGE,
data.SHOW_LV3_CONT,
data.SHOW_LV2_CONT,
data.SHOW_PROJECT_ADDR,
OISDataInfo.UserInfomation.USER_ID,
IS_CANCEL).FirstOrDefault().GetValueOrDefault();
if (data.Detail != null)
{
foreach (DataRow dr in data.Detail.Rows)
{
ct.sp_RPT001_SaveWorkPlaceLightDt(dr.Field <int?>("ID"),
ID,
null,
dr.Field <string>("LOC_NAME"),
dr.Field <string>("LOC_NAME_LV2"),
dr.Field <string>("LOC_NAME_LV3"),
dr.Field <int?>("STDLIGHT_ID"),
dr.Field <string>("STDLIGHT_NAME"),
dr.Field <int>("STDLIGHT_STANDARD"),
dr.Field <int?>("RESULT_DAY"),
dr.Field <int?>("RESULT_NIGHT"),
dr.Field <string>("CONDITION"),
OISDataInfo.UserInfomation.USER_ID,
false);
}
}
string sql = "";
if (data.Instrument != null)
{
foreach (DataRow dr in data.Instrument.Rows)
{
if (sql.Length > 0)
{
sql = sql + Environment.NewLine;
}
sql = sql + string.Format("INSERT INTO TBR_WORK_PLACE_LIGHT_INSTRUMENT VALUES ({0}, {1});", ID, dr.Field <int>("MEASURED_INSTRUMENT_ID"));
}
}
if (data.User != null)
{
foreach (DataRow dr in data.User.Rows)
{
if (sql.Length > 0)
{
sql = sql + Environment.NewLine;
}
sql = sql + string.Format("INSERT INTO TBR_WORK_PLACE_LIGHT_USER VALUES ({0}, '{1}');", ID, dr.Field <string>("MEASURED_BY"));
}
}
if (sql.Length > 0)
{
ct.Database.ExecuteSqlCommand(sql);
}
trans.Complete();
}
return(ID);
}
catch (Exception ex)
{
throw ex;
}
}
