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