public DataTable Select1(Customer_Report_Class d)
{
SqlConnection conn = new SqlConnection(myconnstrng);
DataTable dt = new DataTable();
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)";
string sql = "Select BMI ,Report_Date FROM Monthly_Report_Info WHERE Customer_Name= @Customer_Name ";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Customer_Name", d.Customer_Name);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
conn.Open();
adapter.Fill(dt);
int rows = cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException sqlException)
{
System.Windows.Forms.MessageBox.Show(sqlException.Message);
}
finally
{
conn.Close();
}
return(dt);
}
public bool Insert2(Customer_Report_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 Monthly_Report_Info(Customer_Name,Report_Date,BMI,Biceps_Size,Triceps_Size,Chest_Size,Back_Size,Shoulder_Size,Legs_Size,Height,Weight,Fat_Percent) VALUES(@Customer_Name,@Report_Date,@BMI,@Biceps_Size,@Triceps_Size,@Chest_Size,@Back_Size,@Shoulder_Size,@Legs_Size,@Height,@Weight,@Fat_Percent)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Customer_Name", c.Customer_Name);
cmd.Parameters.AddWithValue("@Biceps_Size", c.Biceps_Size);
cmd.Parameters.AddWithValue("@Back_Size", c.Back_Size);
cmd.Parameters.AddWithValue("@Chest_Size", c.Chest_Size);
cmd.Parameters.AddWithValue("@Triceps_Size", c.Triceps_Size);
cmd.Parameters.AddWithValue("@Shoulder_Size", c.Shoulder_Size);
cmd.Parameters.AddWithValue("@Legs_Size", c.Legs_Size);
cmd.Parameters.AddWithValue("@Weight", c.Weight);
cmd.Parameters.AddWithValue("@Height", c.Height);
cmd.Parameters.AddWithValue("@Fat_Percent", c.Fat_Percent);
cmd.Parameters.AddWithValue("@BMI", c.BMI);
cmd.Parameters.AddWithValue("@Report_Date", c.Report_Date);
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);
}