public int AddEditDel_Scrl_UserAddingAnsPost(DO_Scrl_UserQAPostingAnswer objQueAns, QuetionAns Flag)
{
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
cmd = new SqlCommand("Scrl_AddEditDelQuetionAns", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = Flag;
cmd.Parameters.Add("@intAnswerId", SqlDbType.Int).Value = objQueAns.intAnswerId;
cmd.Parameters.Add("@strRepLiShStatus", SqlDbType.VarChar, 2).Value = objQueAns.strAnsLiStatus;
cmd.Parameters.Add("@strComment", SqlDbType.VarChar, 500000000).Value = objQueAns.strComment;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = objQueAns.intAnsAddedBy;
//cmd.ExecuteScalar();
objQueAns.ResultId = Convert.ToInt32(cmd.ExecuteScalar());
co.CloseConnection(conn);
return(objQueAns.ResultId);
}
public void AddEditDel_Scrl_UserQueAnswerTbl(DO_Scrl_UserQAPostingAnswer objQueAns, QuetionAns Flag)
{
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
cmd = new SqlCommand("Scrl_AddEditDelQuetionAns", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = Flag;
cmd.Parameters.Add("@intAnswerId", SqlDbType.Int).Value = objQueAns.intAnswerId;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = objQueAns.intAnsAddedBy;
cmd.Parameters.Add("@strRepLiShStatus", SqlDbType.VarChar, 2).Value = objQueAns.strAnsLiStatus;
cmd.ExecuteScalar();
co.CloseConnection(conn);
}
public void AddEditDel_Scrl_UserQueAnswerTbl(DO_Scrl_UserQAPosting objQueAns, QuetionAns Flag)
{
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
}
public void AddEditDel_Scrl_UserQueAnsUpdateCmntsTbl(DO_Scrl_UserQAPostingAnswer objQueAns, QuetionAns Flag)
{
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
cmd = new SqlCommand("Scrl_AddEditDelQuetionAns", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = Flag;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = objQueAns.ID;
cmd.Parameters.Add("@strComment", SqlDbType.VarChar).Value = objQueAns.strComment;
cmd.ExecuteScalar();
co.CloseConnection(conn);
}
public void AddEditDel_Scrl_UserQueAnsPostingTbl(DO_Scrl_UserQAPosting objQueAns, QuetionAns Flag)
{
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
cmd = new SqlCommand("Scrl_AddEditDelQuetionAns", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = Flag;
cmd.Parameters.Add("@intPostQuestionId", SqlDbType.Int).Value = objQueAns.intPostQuestionId;
cmd.Parameters.Add("@strQuestionDescription", SqlDbType.VarChar, 500).Value = objQueAns.strQuestionDescription;
cmd.Parameters.Add("@intContextId", SqlDbType.Int).Value = objQueAns.intContextId;
cmd.Parameters.Add("@strFileName", SqlDbType.VarChar, 50).Value = objQueAns.strFileName;
cmd.Parameters.Add("@FilePath", SqlDbType.VarChar, 50).Value = objQueAns.strFilePath;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = objQueAns.intAddedBy;
cmd.Parameters.Add("@intModifiedBy", SqlDbType.Int).Value = objQueAns.intModifiedBy;
cmd.Parameters.Add("@intSubjectCategoryId", SqlDbType.Int).Value = objQueAns.intSubjectCategoryId;
cmd.Parameters.Add("@strIpAddress", SqlDbType.VarChar, 50).Value = objQueAns.strIPAddress;
cmd.Parameters.Add("@strRepLiShStatus", SqlDbType.VarChar, 2).Value = objQueAns.strRepLiShStatus;
cmd.Parameters.Add("@strComment", SqlDbType.VarChar, 500000000).Value = objQueAns.strComment;
cmd.Parameters.Add("@PrvateMessage", SqlDbType.Int).Value = objQueAns.PrvateMessage;
cmd.Parameters.Add("@intQAReplyLikeShareId", SqlDbType.Int).Value = objQueAns.intQAReplyLikeShareId;
cmd.Parameters.Add("@strInvitee", SqlDbType.VarChar, 500).Value = objQueAns.strInvitee;
cmd.Parameters.Add("@strSharelink", SqlDbType.VarChar, 500).Value = objQueAns.strSharelink;
objQueAns.intPostQuestionId = Convert.ToInt32(cmd.ExecuteScalar());
co.CloseConnection(conn);
}
