/// <summary>
/// 获取返回到前端的BondViewModel
/// </summary>
/// <param name="dtWorkItem"></param>
/// <param name="columns"></param>
/// <returns></returns>
public List <RepaymentViewModel> Getgriddata(DataTable dt)
{
List <RepaymentViewModel> griddata = new List <RepaymentViewModel>();
if (dt == null)
{
return(griddata);
}
foreach (DataRow row in dt.Rows)
{
RepaymentViewModel bv = new RepaymentViewModel();
if (dt.Columns.Contains("HKBH"))
{
bv.HKBH = this.GetColumnsValue(row, "HKBH");
}
if (dt.Columns.Contains("CX"))
{
bv.CX = this.GetColumnsValue(row, "CX");
}
if (dt.Columns.Contains("CJH"))
{
bv.CJH = this.GetColumnsValue(row, "CJH");
}
if (dt.Columns.Contains("FKFS"))
{
bv.FKFS = this.GetColumnsValue(row, "FKFS");
}
if (dt.Columns.Contains("CLBH"))
{
bv.CLBH = this.GetColumnsValue(row, "CLBH");
}
if (dt.Columns.Contains("CJHXZ"))
{
bv.CJHXZ = this.GetColumnsValue(row, "CJHXZ");
}
if (dt.Columns.Contains("HKZT"))
{
bv.HKZT = this.GetColumnsValue(row, "HKZT");
}
if (dt.Columns.Contains("DKJE"))
{
bv.DKJE = this.GetColumnsValue(row, "DKJE") == "" ? 0 : Convert.ToDecimal(this.GetColumnsValue(row, "DKJE"));
}
griddata.Add(bv);
}
return(griddata);
}
public async Task <IActionResult> RentRepayments(long contractId, RepaymentViewModel model)
{
var repayments = model.Repayments
.Select(x => new RentRepayment()
{
Amount = x.Value1, DueDate = x.Date, ContractId = contractId
})
.OrderBy(x => x.DueDate);
foreach (var repayment in repayments)
{
repaymentRepository.Add(repayment);
}
await repaymentRepository.Save();
return(await IncreaseDraftStepAndRedirect(model.ContractId));
}
public IEnumerable <RepaymentViewModel> GetAll()
{
var view = new List <RepaymentViewModel>();
var repayments = _repaymentRepository.Get();
foreach (var repayment in repayments)
{
var summary = new RepaymentViewModel
{
CustomerName = repayment.Customer.CustomerName,
SeasonName = repayment.Season.SeasonName,
Date = repayment.Date,
Amount = repayment.Amount,
};
view.Add(summary);
}
return(view);
}
public ActionResult SaveRepayment(RepaymentViewModel model)
{
if (ModelState.IsValid)
{
if (model.Id > 0)
{
var repayment = db.PropertyRepayment.FirstOrDefault(x => x.Id == model.Id);
if (repayment == null)
{
return(Json(new { Success = false }));
}
repayment.Amount = model.Amount;
repayment.FrequencyType = model.FrequencyType;
repayment.StartDate = model.StartDate;
repayment.EndDate = model.EndDate;
db.SaveChanges();
return(Json(new { Success = true }));
}
else
{
var newRepayment = new PropertyRepayment
{
PropertyId = model.PropertyId,
Amount = model.Amount,
FrequencyType = model.FrequencyType,
StartDate = model.StartDate,
EndDate = model.EndDate
};
db.PropertyRepayment.Add(newRepayment);
db.SaveChanges();
return(Json(new { Success = true, NewId = newRepayment.Id }));
}
}
else
{
return(Json(new { Success = false }));
}
}
