private string GenerateCollateralCode(int collateralTypeId)
{
var Code = _dataContext.credit_collateraltype.FirstOrDefault(x => x.CollateralTypeId == collateralTypeId).Name;
var count = ((_dataContext.credit_collateralcustomer.Count(x => x.CollateralTypeId == collateralTypeId)) + 1);
var reference = $"{Code.Substring(0, 3).ToUpper()}-{GeneralHelpers.GenerateZeroString(5) + count.ToString().PadRight(5)}";
return(reference);
}