public async Task <IActionResult> PostSamplingworkBZP([FromForm] SamplingworkBZPPostModel samplingworkBZP)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
#region :: MapperData ::
var getModelToDbModel = new SamplingworkBZP()
{
AppraisalID = samplingworkBZP.AppraisalID,
RJobType = samplingworkBZP.RJobType,
ProjectName = samplingworkBZP.ProjectName,
ProjectCode = samplingworkBZP.ProjectCode,
CIFName = samplingworkBZP.CIFName,
AANo = samplingworkBZP.AANo,
APNO = samplingworkBZP.APNO,
ConstDeedNo = samplingworkBZP.ConstDeedNo,
LandNo = samplingworkBZP.LandNo,
SubCategory = samplingworkBZP.SubCategory,
SplitEntry = samplingworkBZP.SplitEntry,
Street = samplingworkBZP.Street,
SubDistrict = samplingworkBZP.SubDistrict,
District = samplingworkBZP.District,
Province = samplingworkBZP.Province,
AssessCompany = samplingworkBZP.AssessCompany,
MonthCheck = samplingworkBZP.MonthCheck,
LastDateSurvey = samplingworkBZP.LastDateSurvey,
BankDateCheck = samplingworkBZP.BankDateCheck,
checkdevland = samplingworkBZP.checkdevland,
chkpublicutility = samplingworkBZP.chkpublicutility,
chkconstruction = samplingworkBZP.chkconstruction,
chkfacility = samplingworkBZP.chkfacility,
chklandlocation = samplingworkBZP.chklandlocation,
surveybanklist = samplingworkBZP.surveybanklist,
appraisalbanklist = samplingworkBZP.appraisalbanklist,
Ownerbanklist = samplingworkBZP.Ownerbanklist,
Otherdetail = samplingworkBZP.Otherdetail,
Remark = samplingworkBZP.Remark,
Buildingplan = samplingworkBZP.Buildingplan,
Other = samplingworkBZP.Other,
Appraisalchk = samplingworkBZP.Appraisalchk,
CommentDetail = samplingworkBZP.CommentDetail,
AppraisalBankid = samplingworkBZP.AppraisalBankid,
AppraisalDate = samplingworkBZP.AppraisalDate,
chkmistake = samplingworkBZP.chkmistake,
mistakedetail = samplingworkBZP.mistakedetail,
warningletter = samplingworkBZP.warningletter,
warningdetail = samplingworkBZP.warningdetail,
Headteam = samplingworkBZP.Headteam,
datecheck = samplingworkBZP.datecheck,
AssistantAppDirector = samplingworkBZP.AssistantAppDirector,
AssistDate = samplingworkBZP.AssistDate,
AppDirector = samplingworkBZP.AppDirector,
AppDireDate = samplingworkBZP.AppDireDate,
reportdetail = samplingworkBZP.reportdetail,
};
#endregion
#region :: generate PK ::
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())
{
getModelToDbModel.RAppraisalID = reader.GetInt64(0);
}
}
sqlConnection.Close();
}
#endregion
_context.SamplingworkBZP.Add(getModelToDbModel);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetSamplingworkBZP", new { id = getModelToDbModel.RAppraisalID }, samplingworkBZP));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task <IActionResult> PutSamplingworkBZP([FromQuery] SamplingworkBZP samplingworkBZP)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var updateData = _context.SamplingworkBZP.Where(x => x.RAppraisalID == samplingworkBZP.RAppraisalID).FirstOrDefault();
if (updateData == null)
{
return(NotFound(EnumMessage.StatusMessage.Error.NotFoundUpdate));
}
else
{
updateData.RJobType = samplingworkBZP.RJobType;
updateData.ProjectName = samplingworkBZP.ProjectName;
updateData.ProjectCode = samplingworkBZP.ProjectCode;
updateData.CIFName = samplingworkBZP.CIFName;
updateData.AANo = samplingworkBZP.AANo;
updateData.APNO = samplingworkBZP.APNO;
updateData.ConstDeedNo = samplingworkBZP.ConstDeedNo;
updateData.LandNo = samplingworkBZP.LandNo;
updateData.SubCategory = samplingworkBZP.SubCategory;
updateData.SplitEntry = samplingworkBZP.SplitEntry;
updateData.Street = samplingworkBZP.Street;
updateData.SubDistrict = samplingworkBZP.SubDistrict;
updateData.District = samplingworkBZP.District;
updateData.Province = samplingworkBZP.Province;
updateData.AssessCompany = samplingworkBZP.AssessCompany;
updateData.MonthCheck = samplingworkBZP.MonthCheck;
updateData.LastDateSurvey = samplingworkBZP.LastDateSurvey;
updateData.BankDateCheck = samplingworkBZP.BankDateCheck;
updateData.checkdevland = samplingworkBZP.checkdevland;
updateData.chkpublicutility = samplingworkBZP.chkpublicutility;
updateData.chkconstruction = samplingworkBZP.chkconstruction;
updateData.chkfacility = samplingworkBZP.chkfacility;
updateData.chklandlocation = samplingworkBZP.chklandlocation;
updateData.surveybanklist = samplingworkBZP.surveybanklist;
updateData.appraisalbanklist = samplingworkBZP.appraisalbanklist;
updateData.Ownerbanklist = samplingworkBZP.Ownerbanklist;
updateData.Otherdetail = samplingworkBZP.Otherdetail;
updateData.Remark = samplingworkBZP.Remark;
updateData.Buildingplan = samplingworkBZP.Buildingplan;
updateData.Other = samplingworkBZP.Other;
updateData.Appraisalchk = samplingworkBZP.Appraisalchk;
updateData.CommentDetail = samplingworkBZP.CommentDetail;
updateData.AppraisalBankid = samplingworkBZP.AppraisalBankid;
updateData.AppraisalDate = samplingworkBZP.AppraisalDate;
updateData.chkmistake = samplingworkBZP.chkmistake;
updateData.mistakedetail = samplingworkBZP.mistakedetail;
updateData.warningletter = samplingworkBZP.warningletter;
updateData.warningdetail = samplingworkBZP.warningdetail;
updateData.Headteam = samplingworkBZP.Headteam;
updateData.datecheck = samplingworkBZP.datecheck;
updateData.AssistantAppDirector = samplingworkBZP.AssistantAppDirector;
updateData.AssistDate = samplingworkBZP.AssistDate;
updateData.AppDirector = samplingworkBZP.AppDirector;
updateData.AppDireDate = samplingworkBZP.AppDireDate;
updateData.reportdetail = samplingworkBZP.reportdetail;
_context.Update(updateData);
await _context.SaveChangesAsync();
return(Ok(EnumMessage.StatusMessage.Success.DataSaveChange));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
