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