public static void AddUser(string nazwa, string haslo) { SqlConnection sqlConnection = new SqlConnection(); sqlConnection = DataBaseSolution.Get_DB_Connection(); SqlCommand check_User_Name = new SqlCommand("SELECT COUNT(*) FROM [Uzytkownik] WHERE ([Nazwa] = @nazwa)", sqlConnection); check_User_Name.Parameters.AddWithValue("@Nazwa", nazwa); int UserExist = (int)check_User_Name.ExecuteScalar(); if (UserExist == 0) { //< add > string sql_Add = "INSERT INTO Uzytkownik (Nazwa, Haslo) Values ('" + nazwa + "' , '" + haslo + "');"; DataBaseSolution.Execute_SQL(sql_Add); string sql_Add_Profile = "INSERT INTO ProfileUzytkownikow (IdUzytkownika) SELECT (Id) FROM Uzytkownik WHERE (Nazwa='" + nazwa + "') ;"; DataBaseSolution.Execute_SQL(sql_Add_Profile); string sql_Add_UserData = "INSERT INTO DaneUzytkownika (IdUzytkownika) SELECT (Id) FROM Uzytkownik WHERE (Nazwa='" + nazwa + "') ;"; DataBaseSolution.Execute_SQL(sql_Add_UserData); //</ add > } }
public static void ADDWeight(int id, float weight) { SqlConnection sqlConnection = new SqlConnection(); sqlConnection = DataBaseSolution.Get_DB_Connection(); string sql_Add = "INSERT INTO DziennikUzytkownika (IdUzytkownika, Waga, Data) Values ('" + id + "' , '" + weight + "', '" + DateTime.Now + "');"; DataBaseSolution.Execute_SQL(sql_Add); }
public static void AddKCAL(int id, int kcal) { SqlConnection sqlConnection = new SqlConnection(); sqlConnection = DataBaseSolution.Get_DB_Connection(); SqlCommand check_User_Name = new SqlCommand("SELECT COUNT(*) FROM [PlanZywieniowy] WHERE ([IdUzytkownika] = " + @id + ");", sqlConnection); check_User_Name.Parameters.AddWithValue("@IdUzytkownika", id); int UserExist = (int)check_User_Name.ExecuteScalar(); if (UserExist == 0) { string sql_Add = "INSERT INTO PlanZywieniowy (IdUzytkownika, DzienneKCAL) Values ('" + id + "' , '" + kcal + "');"; DataBaseSolution.Execute_SQL(sql_Add); } else if (UserExist > 0) { string sql = "UPDATE PlanZywieniowy SET DzienneKCAL = @kcal WHERE ([IdUzytkownika] = " + @id + ");"; SqlCommand command = new SqlCommand(sql, sqlConnection); command.Parameters.AddWithValue("@kcal", kcal); command.Parameters.AddWithValue("@id", id); command.ExecuteNonQuery(); } }