public async Task <IActionResult> PostSamplingUFTDetail([FromForm] SamplingUFTDetailPostModel samplingUFTDetail)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var insertData = new SamplingUFTDetail()
{
RSubAppraisalID = samplingUFTDetail.RSubAppraisalID,
CIFName = samplingUFTDetail.CIFName,
AANo = samplingUFTDetail.AANo,
RoomNo = samplingUFTDetail.RoomNo,
BuildingNo = samplingUFTDetail.BuildingNo,
RegisterNumber = samplingUFTDetail.RegisterNumber,
FloorNoCondo = samplingUFTDetail.FloorNoCondo,
PositionLatitude = samplingUFTDetail.PositionLatitude,
PositionLongtitude = samplingUFTDetail.PositionLongtitude,
chkconstruction = samplingUFTDetail.chkconstruction,
};
#region :: genPK ::
using (SqlConnection sqlConnection = new SqlConnection(EnumMessage.connectionString.connect))
{
sqlConnection.Open();
SqlCommand sql = new SqlCommand(" SELECT NEXT VALUE FOR dbo.RAppraisalInfo_SEQ", sqlConnection);
using (SqlDataReader reader = sql.ExecuteReader())
{
while (reader.Read())
{
insertData.RAppraisalID = reader.GetInt64(0);
}
}
sqlConnection.Close();
}
#endregion
_context.SamplingUFTDetail.Add(insertData);
await _context.SaveChangesAsync();
return(Ok(EnumMessage.StatusMessage.Success.DataSaved));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task <IActionResult> GetSamplingUFTDetail([FromQuery] SamplingUFTDetail data)
{
try
{
IQueryable <SamplingUFTDetail> iQueryData;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
iQueryData = _context.SamplingUFTDetail;
if (data.RSubAppraisalID != 0)
{
iQueryData = _context.SamplingUFTDetail.Where(x => x.RSubAppraisalID == data.RSubAppraisalID).AsQueryable();
}
if (data.RAppraisalID != 0)
{
iQueryData = _context.SamplingUFTDetail.Where(x => x.RAppraisalID == data.RAppraisalID).AsQueryable();
}
if (!string.IsNullOrEmpty(data.CIFName))
{
iQueryData = _context.SamplingUFTDetail.Where(x => x.CIFName == data.CIFName).AsQueryable();
}
if (!string.IsNullOrEmpty(data.AANo))
{
iQueryData = _context.SamplingUFTDetail.Where(x => x.AANo == data.AANo).AsQueryable();
}
if (!string.IsNullOrEmpty(data.RoomNo))
{
iQueryData = _context.SamplingUFTDetail.Where(x => x.RoomNo == data.RoomNo).AsQueryable();
}
if (!string.IsNullOrEmpty(data.BuildingNo))
{
iQueryData = _context.SamplingUFTDetail.Where(x => x.BuildingNo == data.BuildingNo).AsQueryable();
}
if (!string.IsNullOrEmpty(data.RegisterNumber))
{
iQueryData = _context.SamplingUFTDetail.Where(x => x.RegisterNumber == data.RegisterNumber).AsQueryable();
}
if (!string.IsNullOrEmpty(data.FloorNoCondo))
{
iQueryData = _context.SamplingUFTDetail.Where(x => x.FloorNoCondo == data.FloorNoCondo).AsQueryable();
}
if (!string.IsNullOrEmpty(data.PositionLatitude))
{
iQueryData = _context.SamplingUFTDetail.Where(x => x.PositionLatitude == data.PositionLatitude).AsQueryable();
}
if (!string.IsNullOrEmpty(data.PositionLongtitude))
{
iQueryData = _context.SamplingUFTDetail.Where(x => x.PositionLongtitude == data.PositionLongtitude).AsQueryable();
}
if (data.chkconstruction != null)
{
iQueryData = _context.SamplingUFTDetail.Where(x => x.chkconstruction == data.chkconstruction).AsQueryable();
}
return(Ok(iQueryData));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}