public async Task <IActionResult> PostRAppraisalInfo([FromForm] RAppraisalInfoPostMode rAppraisalInfo) { try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var insertdata = new RAppraisalInfo { //RAppraisalID = 0, AppraisalID = rAppraisalInfo.AppraisalID, DateCompCheck = rAppraisalInfo.DateCompCheck, BankDateCheck = rAppraisalInfo.BankDateCheck, CIFName = rAppraisalInfo.CIFName, MonthCheck = rAppraisalInfo.MonthCheck, YearCheck = rAppraisalInfo.YearCheck, APPNO = rAppraisalInfo.APPNO, ProjectName = rAppraisalInfo.ProjectName, Houseno = rAppraisalInfo.Houseno, Street = rAppraisalInfo.Street, SubDistrict = rAppraisalInfo.SubDistrict, District = rAppraisalInfo.District, Province = rAppraisalInfo.Province, LandLocationDetail = rAppraisalInfo.LandLocationDetail, Publicutility = rAppraisalInfo.Publicutility, Otherdetail = rAppraisalInfo.Otherdetail, DocumentType = rAppraisalInfo.DocumentType, DocumentNo = rAppraisalInfo.DocumentNo, AreaNgan = rAppraisalInfo.AreaNgan, AreaRai = rAppraisalInfo.AreaRai, AreaWa = rAppraisalInfo.AreaWa, LCAppraisalUPrice = rAppraisalInfo.LCAppraisalUPrice, LCAppraisalPrice = rAppraisalInfo.LCAppraisalPrice, LBAppraisalUPrice = rAppraisalInfo.LBAppraisalUPrice, LBAppraisalPrice = rAppraisalInfo.LBAppraisalPrice, LBPriceSuitable = rAppraisalInfo.LBPriceSuitable, LDAppraisalPrice = rAppraisalInfo.LDAppraisalPrice, LHigh_lower = rAppraisalInfo.LHigh_lower, LDiffAppraisalPercent = rAppraisalInfo.LDiffAppraisalPercent, LAcceptPrice = rAppraisalInfo.LAcceptPrice, BuildingModel = rAppraisalInfo.BuildingModel, NoOfFloor = rAppraisalInfo.NoOfFloor, DocuementAttach = rAppraisalInfo.DocuementAttach, BCAppraisalPrice = rAppraisalInfo.BCAppraisalPrice, BBAppraisalPrice = rAppraisalInfo.BBAppraisalPrice, BDAppraisalPrice = rAppraisalInfo.BDAppraisalPrice, BHigh_lower = rAppraisalInfo.BHigh_lower, BDiffAppraisalPercent = rAppraisalInfo.BDiffAppraisalPercent, BPriceSuitable = rAppraisalInfo.BPriceSuitable, BAcceptPrice = rAppraisalInfo.BAcceptPrice, TPriceSuitable = rAppraisalInfo.TPriceSuitable, TCAppraisalPrice = rAppraisalInfo.TCAppraisalPrice, TBAppraisalPrice = rAppraisalInfo.TBAppraisalPrice, TDAppraisalPrice = rAppraisalInfo.TDAppraisalPrice, THigh_lower = rAppraisalInfo.THigh_lower, TDiffAppraisalPercent = rAppraisalInfo.TDiffAppraisalPercent, AppraisalSummary = rAppraisalInfo.AppraisalSummary, AppraisalList = rAppraisalInfo.AppraisalList, AppraisalBankid = rAppraisalInfo.AppraisalBankid, AppraisalDate = rAppraisalInfo.AppraisalDate, chkmistake = rAppraisalInfo.chkmistake, mistakedetail = rAppraisalInfo.mistakedetail, warningletter = rAppraisalInfo.warningletter, warningdetail = rAppraisalInfo.warningdetail, Headteam = rAppraisalInfo.Headteam, datecheck = rAppraisalInfo.datecheck, AssistantAppDirector = rAppraisalInfo.AssistantAppDirector, AssistDate = rAppraisalInfo.AssistDate, AppDirector = rAppraisalInfo.AppDirector, AppDireDate = rAppraisalInfo.AppDireDate, }; #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.Attach(insertdata).State = EntityState.Added; _context.SaveChanges(); //_context.SaveChanges(); //_context.RAppraisalInfo.Add(insertdata); return(CreatedAtAction("GetRAppraisalInfo", new { id = insertdata.RAppraisalID }, rAppraisalInfo)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public async Task <IActionResult> PutRAppraisalInfo([FromQuery] RAppraisalInfo rAppraisalInfo) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { var updateData = (from data in _context.RAppraisalInfo where data.RAppraisalID == rAppraisalInfo.RAppraisalID select data).FirstOrDefault(); if (updateData == null) { return(BadRequest(EnumMessage.StatusMessage.Error.NotFoundUpdate)); } else { updateData.RAppraisalID = rAppraisalInfo.RAppraisalID; updateData.AppraisalID = rAppraisalInfo.AppraisalID; updateData.DateCompCheck = rAppraisalInfo.DateCompCheck; updateData.BankDateCheck = rAppraisalInfo.BankDateCheck; updateData.CIFName = rAppraisalInfo.CIFName; updateData.MonthCheck = rAppraisalInfo.MonthCheck; updateData.YearCheck = rAppraisalInfo.YearCheck; updateData.APPNO = rAppraisalInfo.APPNO; updateData.ProjectName = rAppraisalInfo.ProjectName; updateData.Houseno = rAppraisalInfo.Houseno; updateData.Street = rAppraisalInfo.Street; updateData.SubDistrict = rAppraisalInfo.SubDistrict; updateData.District = rAppraisalInfo.District; updateData.Province = rAppraisalInfo.Province; updateData.LandLocationDetail = rAppraisalInfo.LandLocationDetail; updateData.Publicutility = rAppraisalInfo.Publicutility; updateData.Otherdetail = rAppraisalInfo.Otherdetail; updateData.DocumentType = rAppraisalInfo.DocumentType; updateData.DocumentNo = rAppraisalInfo.DocumentNo; updateData.AreaNgan = rAppraisalInfo.AreaNgan; updateData.AreaRai = rAppraisalInfo.AreaRai; updateData.AreaWa = rAppraisalInfo.AreaWa; updateData.LCAppraisalUPrice = rAppraisalInfo.LCAppraisalUPrice; updateData.LCAppraisalPrice = rAppraisalInfo.LCAppraisalPrice; updateData.LBAppraisalUPrice = rAppraisalInfo.LBAppraisalUPrice; updateData.LBAppraisalPrice = rAppraisalInfo.LBAppraisalPrice; updateData.LBPriceSuitable = rAppraisalInfo.LBPriceSuitable; updateData.LDAppraisalPrice = rAppraisalInfo.LDAppraisalPrice; updateData.LHigh_lower = rAppraisalInfo.LHigh_lower; updateData.LDiffAppraisalPercent = rAppraisalInfo.LDiffAppraisalPercent; updateData.LAcceptPrice = rAppraisalInfo.LAcceptPrice; updateData.BuildingModel = rAppraisalInfo.BuildingModel; updateData.NoOfFloor = rAppraisalInfo.NoOfFloor; updateData.DocuementAttach = rAppraisalInfo.DocuementAttach; updateData.BCAppraisalPrice = rAppraisalInfo.BCAppraisalPrice; updateData.BBAppraisalPrice = rAppraisalInfo.BBAppraisalPrice; updateData.BDAppraisalPrice = rAppraisalInfo.BDAppraisalPrice; updateData.BHigh_lower = rAppraisalInfo.BHigh_lower; updateData.BDiffAppraisalPercent = rAppraisalInfo.BDiffAppraisalPercent; updateData.BPriceSuitable = rAppraisalInfo.BPriceSuitable; updateData.BAcceptPrice = rAppraisalInfo.BAcceptPrice; updateData.TPriceSuitable = rAppraisalInfo.TPriceSuitable; updateData.TCAppraisalPrice = rAppraisalInfo.TCAppraisalPrice; updateData.TBAppraisalPrice = rAppraisalInfo.TBAppraisalPrice; updateData.TDAppraisalPrice = rAppraisalInfo.TDAppraisalPrice; updateData.THigh_lower = rAppraisalInfo.THigh_lower; updateData.TDiffAppraisalPercent = rAppraisalInfo.TDiffAppraisalPercent; updateData.AppraisalSummary = rAppraisalInfo.AppraisalSummary; updateData.AppraisalList = rAppraisalInfo.AppraisalList; updateData.AppraisalBankid = rAppraisalInfo.AppraisalBankid; updateData.AppraisalDate = rAppraisalInfo.AppraisalDate; updateData.chkmistake = rAppraisalInfo.chkmistake; updateData.mistakedetail = rAppraisalInfo.mistakedetail; updateData.warningletter = rAppraisalInfo.warningletter; updateData.warningdetail = rAppraisalInfo.warningdetail; updateData.Headteam = rAppraisalInfo.Headteam; updateData.datecheck = rAppraisalInfo.datecheck; updateData.AssistantAppDirector = rAppraisalInfo.AssistantAppDirector; updateData.AssistDate = rAppraisalInfo.AssistDate; updateData.AppDirector = rAppraisalInfo.AppDirector; updateData.AppDireDate = rAppraisalInfo.AppDireDate; _context.Update(updateData); await _context.SaveChangesAsync(); return(Ok(EnumMessage.StatusMessage.Success.DataSaveChange)); } } catch (Exception ex) { return(BadRequest(ex.Message)); } }