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