public async Task <IActionResult> PostSamplingLBFTDetail([FromForm] SamplingLBFTPostModel samplingLBFTDetail)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var insertData = new SamplingLBFTDetail()
{
RSubAppraisalID = samplingLBFTDetail.RSubAppraisalID,
CIFName = samplingLBFTDetail.CIFName,
AANo = samplingLBFTDetail.AANo,
ConstDeedNo = samplingLBFTDetail.ConstDeedNo,
Houseno = samplingLBFTDetail.Houseno,
BuildingModel = samplingLBFTDetail.BuildingModel,
NoOfFloor = samplingLBFTDetail.NoOfFloor.GetValueOrDefault(),
PositionLatitude = samplingLBFTDetail.PositionLatitude,
PositionLongtitude = samplingLBFTDetail.PositionLongtitude,
chkconstruction = samplingLBFTDetail.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.SamplingLBFTDetail.Add(insertData);
await _context.SaveChangesAsync();
return(Ok(EnumMessage.StatusMessage.Success.DataSaved));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task <IActionResult> GetSamplingLBFTDetail([FromQuery] SamplingLBFTDetail data)
{
try
{
IQueryable <SamplingLBFTDetail> iQueryData;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
iQueryData = _context.SamplingLBFTDetail;
if (data.RSubAppraisalID != 0)
{
iQueryData = _context.SamplingLBFTDetail.Where(x => x.RSubAppraisalID == data.RSubAppraisalID).AsQueryable();
}
if (data.RAppraisalID != 0)
{
iQueryData = _context.SamplingLBFTDetail.Where(x => x.RAppraisalID == data.RAppraisalID).AsQueryable();
}
if (!string.IsNullOrEmpty(data.CIFName))
{
iQueryData = _context.SamplingLBFTDetail.Where(x => x.CIFName == data.CIFName).AsQueryable();
}
if (!string.IsNullOrEmpty(data.AANo))
{
iQueryData = _context.SamplingLBFTDetail.Where(x => x.AANo == data.AANo).AsQueryable();
}
if (!string.IsNullOrEmpty(data.ConstDeedNo))
{
iQueryData = _context.SamplingLBFTDetail.Where(x => x.ConstDeedNo == data.ConstDeedNo).AsQueryable();
}
if (!string.IsNullOrEmpty(data.Houseno))
{
iQueryData = _context.SamplingLBFTDetail.Where(x => x.Houseno == data.Houseno).AsQueryable();
}
if (!string.IsNullOrEmpty(data.BuildingModel))
{
iQueryData = _context.SamplingLBFTDetail.Where(x => x.BuildingModel == data.BuildingModel).AsQueryable();
}
if (data.NoOfFloor != null)
{
iQueryData = _context.SamplingLBFTDetail.Where(x => x.NoOfFloor == data.NoOfFloor).AsQueryable();
}
if (!string.IsNullOrEmpty(data.PositionLatitude))
{
iQueryData = _context.SamplingLBFTDetail.Where(x => x.PositionLatitude == data.PositionLatitude).AsQueryable();
}
if (!string.IsNullOrEmpty(data.PositionLongtitude))
{
iQueryData = _context.SamplingLBFTDetail.Where(x => x.PositionLongtitude == data.PositionLongtitude).AsQueryable();
}
if (data.chkconstruction != null)
{
iQueryData = _context.SamplingLBFTDetail.Where(x => x.chkconstruction == data.chkconstruction).AsQueryable();
}
return(Ok(iQueryData));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
