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