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)); } }