public int InsertFourmsReply(DaFourms fourms)
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into FourmReply(QuestionId,Reply,LoginId) values(@QuestionId,@Reply,@LoginId)", con);
cmd.Parameters.AddWithValue("@QuestionId",fourms.QuestionId);
cmd.Parameters.AddWithValue("@Reply",fourms.Reply);
cmd.Parameters.AddWithValue("@LoginId", fourms.LoginId);
int status = cmd.ExecuteNonQuery();
con.Close();
return status;
}
public int InsertpostQueries(DaFourms fourms)
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into Fourms(QuestionId,Question,LoginId) values(@QuestionId,@Question,@LoginId)", con);
cmd.Parameters.AddWithValue("@QuestionId", fourms.QuestionId);
cmd.Parameters.AddWithValue("@Question", fourms.Question);
cmd.Parameters.AddWithValue("@LoginId", fourms.LoginId);
int i = cmd.ExecuteNonQuery();
con.Close();
return i;
}
public string GetQuestion(DaFourms fourm)
{
string question="";
con.Open();
SqlCommand cmd = new SqlCommand("Select Question from Fourms where QuestionId=@QuestionId", con);
cmd.Parameters.AddWithValue("@QuestionId",fourm.QuestionId);
SqlDataReader dr = cmd.ExecuteReader();
if(dr.Read())
question = dr["Question"].ToString();
con.Close();
return question;
}
public int DeleteFourms(DaFourms fourm)
{
con.Open();
SqlCommand cmd1=new SqlCommand("delete from FourmReply where QuestionId=@QuestionId",con);
cmd1.Parameters.AddWithValue("@QuestionId", fourm.QuestionId);
int deletestatus2=cmd1.ExecuteNonQuery();
SqlCommand cmd = new SqlCommand("delete from Fourms where QuestionId=@QuestionId", con);
cmd.Parameters.AddWithValue("@QuestionId", fourm.QuestionId);
int deletestatus1 = cmd.ExecuteNonQuery();
int status= 0;
con.Close();
if (deletestatus1 > 0 && deletestatus2 > 0)
status = 1;
else
status = 0;
return status;
}