public void FeeScheduleModelTest1()
{
var data = new FeeScheduleData
{
FeeScheduleKey = 1,
CompanyKey = 1,
AccountKey = 1,
ProductKey = 1,
FeeScheduleStartDate = new System.DateTime(2018, 1, 1),
FeeScheduleEndDate = new System.DateTime(2018, 1, 1),
FeeScheduleType = "TEST",
FeeScheduleValue = 1,
AuditAddUserId = "TEST",
AuditAddDatetime = new System.DateTime(2018, 1, 1),
AuditUpdateUserId = "TEST",
AuditUpdateDatetime = new System.DateTime(2018, 1, 1),
};
var sut = new FeeSchedule(data);
Assert.True(sut.FeeScheduleKey == 1);
Assert.True(sut.CompanyKey == 1);
Assert.True(sut.AccountKey == 1);
Assert.True(sut.ProductKey == 1);
Assert.True(sut.FeeScheduleStartDate == new System.DateTime(2018, 1, 1));
Assert.True(sut.FeeScheduleEndDate == new System.DateTime(2018, 1, 1));
Assert.True(sut.FeeScheduleTypeCode == "TEST");
Assert.True(sut.FeeScheduleValue == 1);
}
public void SetFeeSchedule(FeeScheduleData feeScheduleData)
{
if (feeScheduleData == null)
{
throw new ArgumentNullException(nameof(feeScheduleData));
}
var existingSchedule = FeeSchedules.FirstOrDefault(a => a.Product.ProductCode == feeScheduleData.Product.ProductCode);
if (existingSchedule != null)
{
FeeSchedules.Remove(existingSchedule);
}
FeeSchedules.Add(new FeeSchedule(feeScheduleData));
}
} // Map function closer
public List <SqlParameter> MapParamsForUpsert(FeeScheduleData entity)
{
var sql_params = new List <SqlParameter>();
sql_params.Add(new SqlParameter("@fee_schedule_key", entity.FeeScheduleKey));
sql_params.Add(new SqlParameter("@company_key", entity.CompanyKey));
sql_params.Add(new SqlParameter("@account_key", entity.AccountKey));
sql_params.Add(new SqlParameter("@product_key", entity.ProductKey));
sql_params.Add(new SqlParameter("@fee_schedule_start_date", entity.FeeScheduleStartDate));
sql_params.Add(new SqlParameter("@fee_schedule_end_date", entity.FeeScheduleEndDate));
sql_params.Add(new SqlParameter("@fee_schedule_type", entity.FeeScheduleType));
sql_params.Add(new SqlParameter("@fee_schedule_value", entity.FeeScheduleValue));
sql_params.Add(GetOutParam());
return(sql_params);
}
public FeeSchedule(FeeScheduleData feeScheduleData)
{
if (feeScheduleData == null)
{
throw new ArgumentNullException(nameof(feeScheduleData));
}
FeeScheduleId = feeScheduleData.FeeScheduleId;
CompanyId = feeScheduleData.CompanyId;
FeeScheduleStartDate = feeScheduleData.FeeScheduleStartDate;
FeeScheduleEndDate = feeScheduleData.FeeScheduleEndDate;
FeeScheduleTypeCode = feeScheduleData.FeeScheduleTypeCode;
FeeScheduleValue = feeScheduleData.FeeScheduleValue;
ProductDesc = feeScheduleData.ProductDesc;
SetProduct(feeScheduleData.Product);
}
public FeeSchedule(FeeScheduleData feeScheduleData)
{
FeeScheduleKey = feeScheduleData.FeeScheduleKey;
CompanyKey = feeScheduleData.CompanyKey;
AccountKey = feeScheduleData.AccountKey;
ProductKey = feeScheduleData.ProductKey;
FeeScheduleStartDate = feeScheduleData.FeeScheduleStartDate;
FeeScheduleEndDate = feeScheduleData.FeeScheduleEndDate;
FeeScheduleTypeCode = feeScheduleData.FeeScheduleType;
FeeScheduleValue = feeScheduleData.FeeScheduleValue;
AddedUserID = feeScheduleData.AuditAddUserId;
AddedDateTime = feeScheduleData.AuditAddDatetime;
UpdateUserID = feeScheduleData.AuditUpdateUserId;
UpdateDateTime = feeScheduleData.AuditUpdateDatetime;
ProductDesc = feeScheduleData.ProductDesc;
ProductCode = feeScheduleData.ProductCode;
AccountCode = feeScheduleData.AccountCode;
AccountName = feeScheduleData.AccountName;
}
public FeeSchedule Map(FeeScheduleData fee_schedule_data)
{
return(new FeeSchedule()
{
FeeScheduleKey = fee_schedule_data.FeeScheduleKey,
CompanyKey = fee_schedule_data.CompanyKey,
AccountKey = fee_schedule_data.AccountKey,
ProductKey = fee_schedule_data.ProductKey,
FeeScheduleStartDate = fee_schedule_data.FeeScheduleStartDate,
FeeScheduleEndDate = fee_schedule_data.FeeScheduleEndDate,
FeeScheduleTypeCode = fee_schedule_data.FeeScheduleType,
FeeScheduleValue = fee_schedule_data.FeeScheduleValue,
AddedUserID = fee_schedule_data.AuditAddUserId,
AddedDateTime = fee_schedule_data.AuditAddDatetime,
UpdateUserID = fee_schedule_data.AuditUpdateUserId,
UpdateDateTime = fee_schedule_data.AuditUpdateDatetime,
ProductDesc = fee_schedule_data.ProductDesc,
ProductCode = fee_schedule_data.ProductCode,
AccountCode = fee_schedule_data.AccountCode,
AccountName = fee_schedule_data.AccountName
});
}
public List <SqlParameter> MapParamsForDelete(FeeScheduleData entity)
{
return(MapParamsForDelete(entity.FeeScheduleKey));
}
public FeeSchedule Map(FeeScheduleData feeScheduleData) => new FeeSchedule(feeScheduleData);
