public Sportnik ParseSportnik(MySqlDataReader beripodatke)
{
Sportnik sportnik = new Sportnik();
sportnik.id = Convert.ToInt32(beripodatke["id"]);
sportnik.Name = beripodatke["Name"].ToString();
sportnik.Rank = Convert.ToInt32(beripodatke["Rank"]);
sportnik.GenderRank = beripodatke["GenderRank"].ToString();
sportnik.DivRank = Convert.ToInt32(beripodatke["DivRank"]);
sportnik.OverallRank = beripodatke["OveralRank"].ToString();
sportnik.Bib = Convert.ToInt32(beripodatke["Bib"]);
sportnik.Division = beripodatke["Division"].ToString();
sportnik.Age = Convert.ToInt32(beripodatke["Age"]);
sportnik.AgeCategory = beripodatke["AgeCategory"].ToString();
sportnik.State = beripodatke["State"].ToString();
sportnik.Country = beripodatke["Country"].ToString();
sportnik.Profession = beripodatke["Profession"].ToString();
sportnik.Points = Convert.ToInt32(beripodatke["Points"]);
sportnik.Swim = TimeSpan.Parse(beripodatke["Swim"].ToString());
sportnik.SwimDistance = float.Parse(beripodatke["SwimDistance"].ToString());
sportnik.T1 = TimeSpan.Parse(beripodatke["T1"].ToString());
sportnik.Bike = TimeSpan.Parse(beripodatke["Bike"].ToString());
sportnik.BikeDistance = float.Parse(beripodatke["BikeDistance"].ToString());
sportnik.T2 = TimeSpan.Parse(beripodatke["T2"].ToString());
sportnik.Run = TimeSpan.Parse(beripodatke["Run"].ToString());
sportnik.RunDistance = float.Parse(beripodatke["RunDistance"].ToString());
sportnik.Overall = beripodatke["Overall"].ToString();
sportnik.Finish = TimeSpan.Parse(beripodatke["Finish"].ToString());
sportnik.OverAllTri = Convert.ToInt32(beripodatke["OverAllTri"]);
sportnik.Comment = beripodatke["Comment"].ToString();
return(sportnik);
}
public ActionResult <Sportnik> Get(int id) //pridobitev sportnika po id
{
var zazeni = new MySqlCommand("SELECT * FROM sportniki where id=" + id, con);
con.Open();
zazeni.ExecuteNonQuery();
MySqlDataReader beripodatke = zazeni.ExecuteReader();
Sportnik sportnik = new Sportnik();
while (beripodatke.Read())
{
sportnik = ParseSportnik(beripodatke);
}
beripodatke.Close();
return(sportnik);
}
[HttpPut] //tun tudi pazi id
public bool UrejanjeSportnika(string Rank, string id, string Name, string GenderRank, string DivRank, string OverallRank, string Bib, string Division, string Age, string AgeCategory, string State, string Country, string Profession, string Points, string Swim, string SwimDistance, string T1, string Bike, string BikeDistance, string T2, string Run, string RunDistance, string Overall, string Finish, string OverAllTri, string Comment) //urejanje sportnika po id
{
int stevilo = 0;
TimeSpan cas;
float float1;
Sportnik sportnik = new Sportnik();
if (int.TryParse(Rank, out stevilo))
{
sportnik.Rank = stevilo;
}
if (int.TryParse(id, out stevilo))
{
sportnik.id = stevilo;
}
sportnik.Name = Name;
sportnik.GenderRank = GenderRank;
if (int.TryParse(DivRank, out stevilo))
{
sportnik.DivRank = stevilo;
}
sportnik.OverallRank = OverallRank;
if (int.TryParse(Bib, out stevilo))
{
sportnik.Bib = stevilo;
}
sportnik.Division = Division;
if (int.TryParse(Age, out stevilo))
{
sportnik.Age = stevilo;
}
sportnik.AgeCategory = AgeCategory;
sportnik.State = State;
sportnik.Country = Country;
sportnik.Profession = Profession;
if (int.TryParse(Points, out stevilo))
{
sportnik.Points = stevilo;
}
if (TimeSpan.TryParse(Swim, out cas))
{
sportnik.Swim = cas;
}
if (float.TryParse(SwimDistance, out float1))
{
sportnik.SwimDistance = float1;
}
if (TimeSpan.TryParse(T1, out cas))
{
sportnik.T1 = cas;
}
if (TimeSpan.TryParse(Bike, out cas))
{
sportnik.Bike = cas;
}
if (float.TryParse(BikeDistance, out float1))
{
sportnik.BikeDistance = float1;
}
if (TimeSpan.TryParse(T2, out cas))
{
sportnik.T2 = cas;
}
if (TimeSpan.TryParse(Run, out cas))
{
sportnik.Run = cas;
}
if (float.TryParse(RunDistance, out float1))
{
sportnik.RunDistance = float1;
}
sportnik.Overall = Overall;
if (TimeSpan.TryParse(Finish, out cas))
{
sportnik.Finish = cas;
}
if (int.TryParse(OverAllTri, out stevilo))
{
sportnik.OverAllTri = stevilo;
}
sportnik.Comment = Comment;
var zazeni = new MySqlCommand($"UPDATE sportniki SET Rank='{sportnik.Rank}',Name='{sportnik.Name}',GenderRank='{sportnik.GenderRank}',DivRank='{sportnik.DivRank}',OveralRank='{sportnik.OverallRank}',Bib='{sportnik.Bib}',Division='{sportnik.Division}',Age='{sportnik.Age}',AgeCategory='{sportnik.AgeCategory}',State='{sportnik.State}',Country='{sportnik.Country}',Profession='{sportnik.Profession}',Points='{sportnik.Points}',Swim='{sportnik.Swim}',SwimDistance='{sportnik.SwimDistance}',T1='{sportnik.T1}',Bike='{sportnik.Bike}',BikeDistance='{sportnik.BikeDistance}',T2='{sportnik.T2}',Run='{sportnik.Run}',RunDistance='{sportnik.RunDistance}',Overall='{sportnik.Overall}',Finish='{sportnik.Finish}',OverAllTri='{sportnik.OverAllTri}',Comment='{sportnik.Comment}' WHERE id=" + sportnik.id, con);
con.Open();
zazeni.ExecuteNonQuery();
con.Close();
return(true);//se ni ok
}
public bool DodajanjeSportnika(string Rank, string Name, string GenderRank, string DivRank, string OverallRank, string Bib, string Division, string Age, string AgeCategory, string State, string Country, string Profession, string Points, string Swim, string SwimDistance, string T1, string Bike, string BikeDistance, string T2, string Run, string RunDistance, string Overall, string Finish, string OverAllTri, string Comment)//dodajanje spoertnika
{
int stevilo = 0;
TimeSpan cas;
float float1;
Sportnik sportnik = new Sportnik();
if (int.TryParse(Rank, out stevilo))
{
sportnik.Rank = stevilo;
}
sportnik.Name = Name;
sportnik.GenderRank = GenderRank;
if (int.TryParse(DivRank, out stevilo))
{
sportnik.DivRank = stevilo;
}
sportnik.OverallRank = OverallRank;
if (int.TryParse(Bib, out stevilo))
{
sportnik.Bib = stevilo;
}
sportnik.Division = Division;
if (int.TryParse(Age, out stevilo))
{
sportnik.Age = stevilo;
}
sportnik.AgeCategory = AgeCategory;
sportnik.State = State;
sportnik.Country = Country;
sportnik.Profession = Profession;
if (int.TryParse(Points, out stevilo))
{
sportnik.Points = stevilo;
}
if (TimeSpan.TryParse(Swim, out cas))
{
sportnik.Swim = cas;
}
if (float.TryParse(SwimDistance, out float1))
{
sportnik.SwimDistance = float1;
}
if (TimeSpan.TryParse(T1, out cas))
{
sportnik.T1 = cas;
}
if (TimeSpan.TryParse(Bike, out cas))
{
sportnik.Bike = cas;
}
if (float.TryParse(BikeDistance, out float1))
{
sportnik.BikeDistance = float1;
}
if (TimeSpan.TryParse(T2, out cas))
{
sportnik.T2 = cas;
}
if (TimeSpan.TryParse(Run, out cas))
{
sportnik.Run = cas;
}
if (float.TryParse(RunDistance, out float1))
{
sportnik.RunDistance = float1;
}
sportnik.Overall = Overall;
if (TimeSpan.TryParse(Finish, out cas))
{
sportnik.Finish = cas;
}
if (int.TryParse(OverAllTri, out stevilo))
{
sportnik.OverAllTri = stevilo;
}
sportnik.Comment = Comment;
var zazeni = new MySqlCommand($"INSERT INTO sportniki VALUES(null,'{sportnik.Rank}','{sportnik.Name}','{sportnik.GenderRank}','{sportnik.DivRank}','{sportnik.OverallRank}','{sportnik.Bib}','{sportnik.Division}','{sportnik.Age}','{sportnik.AgeCategory}','{sportnik.State}','{sportnik.Country}','{sportnik.Profession}','{sportnik.Points}','{sportnik.Swim}','{sportnik.SwimDistance}','{sportnik.T1}','{sportnik.Bike}','{sportnik.BikeDistance}','{sportnik.T2}','{sportnik.Run}','{sportnik.RunDistance}','{sportnik.Overall}','{sportnik.Finish}','{sportnik.OverAllTri}','{sportnik.Comment}')", con);
con.Open();
zazeni.ExecuteNonQuery();
con.Close();
return(true);
}
