public int AddYak(YakDetails yak)
{
var sql = "INSERT INTO YakItems (Name, Age, Sex, ageLastShaved) VALUES(@Name, @Age, @Sex, @ageLastShaved);" + "SELECT CAST(SCOPE_IDENTITY() as int)";
var id = this.db.Query <int>(sql, yak).Single();
yak.Id = id;
return(id);
}
private static double GetMilk(int days, YakDetails yak, float ageInDaysNow)
{
float yakAgePlusDays = ageInDaysNow + days;
int elapsedDays;
double totalMilk = 0f;
if (yakAgePlusDays >= MAX_YAK_AGE_DAYS)
{
elapsedDays = ((MAX_YAK_AGE_DAYS - 1) - (int)(yak.Age * 100));
}
else
{
elapsedDays = days;
}
for (int i = 0; i < elapsedDays; i++)
{
totalMilk += (50 - ((ageInDaysNow + i) * 0.03));
}
return(totalMilk);
}
private static int GetSkins(int days, YakDetails yak, ref float ageInDaysNow)
{
int countSkins = 1;
int lastShaved = (int)(yak.ageLastShaved * 100);
for (int i = 1; i <= days; i++)
{
int ageNow = (int)(yak.Age * 100 + i);
if (ageNow >= MAX_YAK_AGE_DAYS)
{
break;
}
if (canBeShaved(ageNow, lastShaved))
{
countSkins++;
lastShaved = ageNow;
}
}
ageInDaysNow = (float)lastShaved;
return(countSkins);
}
//public YakDetails FindYakData(int id)
//{
// return this.db.Query<YakDetails>("SELECT * FROM YakDetailsData WHERE Id = @Id", new { id }).SingleOrDefault();
//}
public void UpdateYakData(YakDetails yak)
{
var sql = "UPDATE YakItems " + "SET Name = @Name, " + "Age = @Age, " + "Sex = @Sex, " + "ageLastShaved = @ageLastShaved " + "WHERE Id = @Id";
this.db.Execute(sql, yak);
}
