public bool Create(Bodyparts_Info_Class c)
{
bool isSuccess = true;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
// string sql = "INSERT INTO Exercise_Info(Customer_Name,Address,Phone_No,Email_Id,Gender,Age,Biceps_Size,Calf_Size,Chest_Size,Hip_Size,Weight,Height,Fat_Percent,Package,Personal_Trainer,Time_Preference,BMI) VALUES(@Customer_Name, @Address, @Phone_No, @Email_Id, @Gender, @Age, @Biceps_Size, @Calf_Size, @Chest_Size, @Hip_Size,@Weight,@Height,@Fat_Percent,@Package,@Personal_Trainer,@Time_Preference,@BMI)";
if (c.Body_Parts == "Back")
{
sql2 = "CREATE TABLE Back_Exercise_Info (Customer_Name varchar(50),Day varchar(10),Date varchar(20))";
}
if (c.Body_Parts == "Legs")
{
sql2 = "CREATE TABLE Legs_Exercise_Info (Customer_Name varchar(50),Day varchar(10),Date varchar(20))";
}
SqlCommand cmd2 = new SqlCommand(sql2, conn);
cmd2.Parameters.AddWithValue("@Body_Parts", c.Body_Parts);
conn.Open();
int rows2 = cmd2.ExecuteNonQuery();
if (rows2 > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (System.Data.SqlClient.SqlException sqlException)
{
System.Windows.Forms.MessageBox.Show(sqlException.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool TableDelete(Bodyparts_Info_Class d)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
if (d.Body_Parts == "Back")
{
sql2 = "DROP TABLE Back_Exercise_Info";
}
SqlCommand cmd = new SqlCommand(sql2, conn);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (System.Data.SqlClient.SqlException sqlException)
{
System.Windows.Forms.MessageBox.Show(sqlException.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool Insert(Bodyparts_Info_Class c)
{
bool isSuccess = true;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
// string sql = "INSERT INTO Customer_Info(Customer_Name,Address,Phone_No,Email_Id,Gender,Age,Biceps_Size,Calf_Size,Chest_Size,Hip_Size,Weight,Height,Fat_Percent,Package,Personal_Trainer,Time_Preference,BMI) VALUES(@Customer_Name, @Address, @Phone_No, @Email_Id, @Gender, @Age, @Biceps_Size, @Calf_Size, @Chest_Size, @Hip_Size,@Weight,@Height,@Fat_Percent,@Package,@Personal_Trainer,@Time_Preference,@BMI)";
string sql = "INSERT INTO Bodyparts_Info(Body_Parts) VALUES(@Body_Parts)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Body_Parts", c.Body_Parts);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (System.Data.SqlClient.SqlException sqlException)
{
System.Windows.Forms.MessageBox.Show(sqlException.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool Delete(Bodyparts_Info_Class d)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
string sql = "DELETE FROM Bodyparts_Info WHERE Body_Parts=@Body_Parts";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Body_Parts", d.Body_Parts);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (System.Data.SqlClient.SqlException sqlException)
{
System.Windows.Forms.MessageBox.Show(sqlException.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}