//Read, Details of a specific dog
public DogClass ReadOne(int?id)
{
DogClass d = new DogClass();
using (SqlConnection sqlconn = new SqlConnection(mainconn))
{
SqlCommand sqlcomm = new SqlCommand("SP_ReadDog", sqlconn);
sqlcomm.CommandType = CommandType.StoredProcedure;
//pass in the dogclass model properties
sqlcomm.Parameters.AddWithValue("@DogID", id);
//open db connection
sqlconn.Open();
SqlDataReader rdr = sqlcomm.ExecuteReader();
//Excute or invoke the CreateDog stored procedure
//use while loop
while (rdr.Read())
{
d.ID = Convert.ToInt32(rdr["DogId"]);
d.Name = rdr["DogName"].ToString();
d.Breed = rdr["Breed"].ToString();
d.Gender = rdr["Gender"].ToString();
d.Comment = rdr["Comment"].ToString();
}
//Close db connection
sqlconn.Close();
}
return(d);
}
public List <DogInfoDTO> getByUserId(int userId)
{
List <Dog> dogs = context.Dog.Where(d => d.OwnerId == userId).ToList();
if (dogs.Count < 1)
{
throw new AppException("Nie odnaleziono psów");
}
List <DogInfoDTO> dogInfo = new List <DogInfoDTO>();
foreach (Dog dog in dogs)
{
DogBreed breed = context.DogBreed.Where(db => db.BreedId == dog.BreedId).FirstOrDefault();
DogClass dogClass = context.DogClass.Where(dc => dc.ClassId == dog.ClassId).FirstOrDefault();
dogInfo.Add(new DogInfoDTO
{
dogId = dog.DogId,
name = dog.Name,
breedName = breed.NamePolish,
className = dogClass.NamePolish,
chipNumber = dog.ChipNumber
});
}
return(dogInfo);
}
//List
public List <DogClass> ListDogs()
{
List <DogClass> Ldog = new List <DogClass>();
using (SqlConnection sqlconn = new SqlConnection(mainconn))
{
SqlCommand sqlcomm = new SqlCommand("ListDog", sqlconn);
sqlcomm.CommandType = CommandType.StoredProcedure;
//open db connection
sqlconn.Open();
SqlDataReader rdr = sqlcomm.ExecuteReader();
//Excute or invoke the CreateDog stored procedure
//use while loop
while (rdr.Read())
{
DogClass d = new DogClass();
d.ID = Convert.ToInt32(rdr["DogId"]);
d.Name = rdr["DogName"].ToString();
d.Breed = rdr["Breed"].ToString();
d.Gender = rdr["Gender"].ToString();
d.Comment = rdr["Comment"].ToString();
//populate the Ldog List
Ldog.Add(d);
}
//Close db connection
sqlconn.Close();
}
return(Ldog);
}
// Use this for initialization
void Start()
{
IDogClass MynewDog = new LabradorRetriever();
print(" My Dog Color is " + MynewDog.Color);
print("My Dogs Aging rate is " + MynewDog.CurrentAging() + "%");
DogClass BullDog = new DogClass(3, 10, "BullDog", "White", 15);
IDogClass JohnNewDog = new DogClass(5, 10, "Lab", "Brown", 11);
}
public ActionResult Edit(DogClass dog)
{
if (ModelState.IsValid)
{
//update db
db.UpdateDog(dog);
return(RedirectToAction("Index"));
}
//if the model state is not valid
return(View(dog));
}
public ActionResult Create(DogClass dog)
{
if (ModelState.IsValid)
{ //Insert the form info to db
db.CreateDog(dog);
return(RedirectToAction("Index"));
}
//if the model state is not valid
return(View(dog));
}
// GET:Workers/Edit/4
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//check if the worker exist in db
DogClass dog = db.ReadOne(id);
if (dog == null)
{
return(HttpNotFound());
}
return(View(dog));
}
void Start()
{ // i. Write a function that uses a condition:
//Testing and Printing:
if (CheckPrime(someNumber))
{
print("The number " + someNumber + " is a prime number");
}
else
{
print("The number " + someNumber + " is not a prime number");
}
DogClass Jimmy = new DogClass("Jimmy", "Old English Bulldog", 2);
print(Jimmy.dogProfile());
}
public DogDetailsDTO getDogDetailsById(int dogId)
{
Dog dog = context.Dog.Where(d => d.DogId == dogId).FirstOrDefault();
if (dog == null)
{
throw new AppException("Nie odnaleziono psa");
}
DogBreed breed = context.DogBreed.Where(db => db.BreedId == dog.BreedId).FirstOrDefault();
if (breed == null)
{
throw new AppException("Nie odnaleziono rasy");
}
DogClass classD = context.DogClass.Where(c => c.ClassId == dog.ClassId).FirstOrDefault();
if (classD == null)
{
throw new AppException("Nie odnaleziono klasy");
}
string sex = dog.Sex == "M" ? "Pies" : "Suka";
DogDetailsDTO dogDetails = new DogDetailsDTO
{
dogId = dog.DogId,
name = dog.Name,
lineageNumber = dog.LineageNumber,
registrationNumber = dog.RegistrationNumber,
titles = dog.Titles,
chipNumber = dog.ChipNumber,
breedName = breed.NamePolish,
sex = sex,
birthday = dog.Birthday,
fatherName = dog.FatherName,
motherName = dog.MotherName,
breederName = dog.BreederName,
breederAddress = dog.BreederAddress,
className = classD.NamePolish
};
return(dogDetails);
}
//Create,add new dog to database
public void CreateDog(DogClass dog)
{
using (SqlConnection sqlconn = new SqlConnection(mainconn))
{
SqlCommand sqlcomm = new SqlCommand("CreateDog", sqlconn);
sqlcomm.CommandType = CommandType.StoredProcedure;
//pass in the dogclass model properties
sqlcomm.Parameters.AddWithValue("@DogName", dog.Name);
sqlcomm.Parameters.AddWithValue("@Breed", dog.Breed);
sqlcomm.Parameters.AddWithValue("@Gender", dog.Gender);
sqlcomm.Parameters.AddWithValue("@Comment", dog.Comment);
//open db connection
sqlconn.Open();
//Excute or invoke the CreateDog stored procedure
sqlcomm.ExecuteNonQuery();
//Close db connection
sqlconn.Close();
}
}
// Use this for initialization
void Start()
{
DogClass Mr8 = new DogClass(1, 0.6f, 20f, true, "Mr8", "Husky", "White");
DogClass Kahn = new DogClass(3, 0.3f, 5f, true, "Kahn", "Teddy", "brown");
DogClass Forty = new DogClass(2, 0.5f, 10f, false, "Forty", "Hybrid", "Yellow");
DogClass Leo = new DogClass(7, 0.8f, 22f, true, "Leo", "Golden Retriever", "Golden");
mydog.Add(Mr8);
mydog.Add(Kahn);
mydog.Add(Forty);
mydog.Add(Leo);
Debug.Log("I have " + mydog.Count + " dogs, they are " + mydog[0].Name + ", " + mydog[1].Name + ", " + mydog[2].Name + " and " + mydog[3].Name);
for (int a = 0; a < mydog.Count; a++)
{
Debug.Log(mydog[a].Name + " is a " + mydog[a].Breeds + " and its color is " + mydog[a].Color + ", it is " +
mydog[a].Age + " years old.");
}
//Write a for loop
for (int i = 0; i < s1.students.Count; i++)
{
Debug.Log("Student " + (i + 1) + " of RC3 is " + s1.students[i]);
}
if (j < s1.students.Count)
{
Debug.Log(s1.students[j] + " is an RC3 student.");
}
else
{
Debug.Log("There are no " + j + " students in RC3");
}
}
//START
// Start is called before the first frame update
void Start()
{
//CONDITION
if (isSunny == true)
{
Debug.Log("The weather is sunny today!");
}
else
{
Debug.Log("The weather is rainny today!");
}
//LOOP
// For example
for (int i = 0; i < myNumberArray.Length; i++)
{
if (myNumberArray[i] == 4)
{
Debug.Log("There's a 4 here");
}
else
{
Debug.Log("There's no 4 here");
}
}
// Foreach example
foreach (int i in myNumberArray)
{
Debug.Log("it works");
}
//DOG CLASS
rex = new DogClass("rex", 5, "male");
pongo = new DogClass("pongo", 10, "male");
milly = new DogClass("milly", 4, "female");
}
public ContestDetailsDTO getContest(int id)
{
ContestDetailsDTO contestDetails;
ContestType contestType = context.ContestType.Where(ct => ct.ContestTypeId == id).FirstOrDefault();
if (contestType == null)
{
throw new AppException("Nie odnaleziono konkursu o podanym id");
}
List <BreedInfoDTO> allowedBreeds = new List <BreedInfoDTO>();
List <AllowedBreedsContest> allowed = context.AllowedBreedsContest.Where(abc => abc.ContestTypeId == id).ToList();
foreach (AllowedBreedsContest abc in allowed)
{
DogBreed breed = context.DogBreed.Where(db => db.BreedId == abc.BreedTypeId).FirstOrDefault();
allowedBreeds.Add(new BreedInfoDTO
{
breedId = abc.BreedTypeId,
name = breed.NamePolish
});
}
List <ParticipationInfoDTO> participations = new List <ParticipationInfoDTO>();
List <Participation> part = context.Participation.Where(p => p.ContestId == id).ToList();
foreach (Participation p in part)
{
Dog dog = context.Dog.Where(d => d.DogId == p.DogId).FirstOrDefault();
DogBreed breed = context.DogBreed.Where(db => db.BreedId == dog.BreedId).FirstOrDefault();
Grade grade = context.Grade.Where(g => g.GradeId == p.GradeId).FirstOrDefault();
DogClass classD = context.DogClass.Where(c => c.ClassId == dog.ClassId).FirstOrDefault();
string place = (p.Place == null) ? "Nie przyznano" : p.Place.ToString();
if (grade == null)
{
participations.Add(new ParticipationInfoDTO
{
participationId = p.ParticipationId,
dogId = p.DogId,
name = dog.Name,
breedName = breed.NamePolish,
className = classD.NamePolish,
chipNumber = dog.ChipNumber,
gradeId = 0,
grade = "Nie oceniono",
place = place,
description = p.Description
});
}
else
{
participations.Add(new ParticipationInfoDTO
{
participationId = p.ParticipationId,
dogId = p.DogId,
name = dog.Name,
breedName = breed.NamePolish,
className = classD.NamePolish,
chipNumber = dog.ChipNumber,
gradeId = grade.GradeId,
grade = grade.NamePolish,
place = place,
description = p.Description
});
}
}
Contest contest = context.Contest.Where(c => c.ContestTypeId == id).FirstOrDefault();
if (contest == null)
{
contestDetails = new ContestDetailsDTO
{
contestTypeId = contestType.ContestTypeId,
contestId = -1,
name = contestType.NamePolish,
isEnterable = Convert.ToBoolean(contestType.Enterable),
placeId = -1,
placeName = null,
startDate = new DateTime(),
endDate = new DateTime(),
allowedBreeds = allowedBreeds,
participants = participations
};
}
else
{
Place place = context.Place.Where(p => p.PlaceId == contest.PlaceId).FirstOrDefault();
contestDetails = new ContestDetailsDTO
{
contestTypeId = contestType.ContestTypeId,
contestId = contest.ContestId,
name = contestType.NamePolish,
isEnterable = Convert.ToBoolean(contestType.Enterable),
placeId = contest.PlaceId,
placeName = place.Name,
startDate = contest.StartDate,
endDate = contest.EndDate,
allowedBreeds = allowedBreeds,
participants = participations
};
}
return(contestDetails);
}
public Dog GenerateDog(int power, int experience)
{
var rnd = new Random(Guid.NewGuid().GetHashCode());
var dog = new Dog();
var remainingChance = (power * 0.01F);
var randomRoll = rnd.Next(0, 6);
switch (randomRoll)
{
case 0:
dog.dog_class = (int)DogClasses.Guardian;
dog.defense = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.health = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.atk_power = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.will = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.prayer = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.intelligence = _rollStat(remainingChance);
break;
case 1:
dog.dog_class = (int)DogClasses.Champion;
dog.health = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.atk_power = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.defense = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.will = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.prayer = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.intelligence = _rollStat(remainingChance);
break;
case 2:
dog.dog_class = (int)DogClasses.Paladin;
dog.prayer = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.will = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.intelligence = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.health = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.defense = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.atk_power = _rollStat(remainingChance);
break;
case 3:
dog.dog_class = (int)DogClasses.Assassin;
dog.atk_power = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.will = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.prayer = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.defense = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.intelligence = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.health = _rollStat(remainingChance);
break;
case 4:
dog.dog_class = (int)DogClasses.Warlock;
dog.will = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.defense = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.health = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.intelligence = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.prayer = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.atk_power = _rollStat(remainingChance);
break;
case 5:
dog.dog_class = (int)DogClasses.Elementalist;
dog.intelligence = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.will = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.health = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.prayer = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.defense = _rollStat(remainingChance);
remainingChance = remainingChance / StatPenaltyScaling;
dog.atk_power = _rollStat(remainingChance);
break;
}
var classBonus = DogClass.GetClassBonus((DogClasses)dog.dog_class);
dog.prayer = Math.Min(200, Math.Max(0, (int)(dog.prayer * classBonus.PrayerScaling)));
dog.atk_power = Math.Min(200, Math.Max(0, (int)(dog.atk_power * classBonus.AtkPowerScaling)));
dog.defense = Math.Min(200, Math.Max(0, (int)(dog.defense * classBonus.DefenseScaling)));
dog.health = Math.Min(200, Math.Max(0, (int)(dog.health * classBonus.HealthScaling)));
dog.intelligence = Math.Min(200, Math.Max(0, (int)(dog.intelligence * classBonus.IntelligenceScaling)));
dog.will = Math.Min(200, Math.Max(0, (int)(dog.will * classBonus.WillScaling)));
dog.name = _ng.GenerateDogName(ref dog);
dog.experience = experience;
dog.image_path = "https://random.dog/" + DogPictures[rnd.Next(DogPictures.Count)];
return(dog);
}
