public void AddEditDel_BlogHeadingLikeShareTbl(DO_BlogLikeShare objblog, DA_BlogLikeShare.BlogHeadingShareLikeFlag flag) { SqlConnection conn = new SqlConnection(); SQLManager co = new SQLManager(); conn = co.GetConnection(); cmd = new SqlCommand("SP_BlogHeadingLikeShareTbl", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag; cmd.Parameters.Add("@intBlogHeadingLikeId", SqlDbType.BigInt).Value = objblog.intBlogHeadingLikeId; cmd.Parameters.Add("@strRepLiShStatus", SqlDbType.VarChar, 2).Value = objblog.strRepLiShStatus; cmd.Parameters.Add("@intBlogId", SqlDbType.Int).Value = objblog.intBlogId; cmd.Parameters.Add("@intAddedBy", SqlDbType.Int).Value = objblog.intAddedBy; cmd.Parameters.Add("@strIpAddress", SqlDbType.VarChar, 20).Value = objblog.strIpAddress; cmd.Parameters.Add("@strInviteeShare", SqlDbType.VarChar, 20).Value = objblog.strInviteeShare; cmd.Parameters.Add("@strLink", SqlDbType.VarChar, 200).Value = objblog.strLink; cmd.Parameters.Add("@strMessage", SqlDbType.VarChar, 900000000).Value = objblog.strMessage; cmd.Parameters.Add("@intModifiedBy", SqlDbType.VarChar, 200).Value = objblog.intAddedBy; cmd.Parameters.Add("@strBlogTitle", SqlDbType.VarChar, 20000).Value = objblog.strBlogTitle; //cmd.ExecuteNonQuery(); objblog.intBlogHeadingLikeId = Convert.ToInt32(cmd.ExecuteScalar()); co.CloseConnection(conn); }
public DataTable GetBlogDataTable(DO_BlogLikeShare objblog, BlogHeadingShareLikeFlag flag) { DataTable dt = new DataTable(); SqlConnection conn = new SqlConnection(); SQLManager co = new SQLManager(); conn = co.GetConnection(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("SP_BlogHeadingLikeShareTbl", conn); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag; da.SelectCommand.Parameters.Add("@intBlogId", SqlDbType.Int).Value = objblog.intBlogId; da.SelectCommand.Parameters.Add("@intAddedBy", SqlDbType.Int).Value = objblog.intAddedBy; da.Fill(dt); co.CloseConnection(conn); return(dt); }
//public void AddEditDel_CaseList(DO_BlogLikeShare objcase, DA_BlogLikeShare.BlogShareLikeFlag flag) //{ // SqlConnection conn = new SqlConnection(); // SQLManager co = new SQLManager(); // conn = co.GetConnection(); // cmd = new SqlCommand("SP_Scrl_BlogLikeShareTbl", conn); // cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag; // cmd.Parameters.Add("@CaseId", SqlDbType.BigInt).Value = objcase.Caseid; // cmd.Parameters.Add("@StrContentTitle", SqlDbType.VarChar, 200).Value = objcase.ContentTitle; // cmd.Parameters.Add("@Citationid", SqlDbType.Int).Value = objcase.CitationId; // cmd.Parameters.Add("@ContentTypeId", SqlDbType.Int).Value = objcase.ContentTypeId; // cmd.Parameters.Add("@intuserid", SqlDbType.Int).Value = objcase.AddedBy; // cmd.ExecuteNonQuery(); // co.CloseConnection(conn); //} //public DataSet GetDataSet(DO_BlogLikeShare objDoCaseList, CaseList flag) //{ // DataSet ds = new DataSet(); // SqlConnection conn = new SqlConnection(); // SQLManager co = new SQLManager(); // conn = co.GetConnection(); // SqlDataAdapter da = new SqlDataAdapter(); // da.SelectCommand = new SqlCommand("scrl_AddEditDeleteCaseList_SP", conn); // da.SelectCommand.CommandType = CommandType.StoredProcedure; // da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag; // da.SelectCommand.Parameters.Add("@CaseId", SqlDbType.BigInt).Value = objDoCaseList.Caseid; // // da.SelectCommand.Parameters.Add("@AddedBy", SqlDbType.BigInt).Value = objDoCaseList.AddedBy; // da.SelectCommand.Parameters.Add("@ContentTypeId", SqlDbType.Int).Value = objDoCaseList.ContentTypeId; // da.Fill(ds); // co.CloseConnection(conn); // return ds; //} //public DataTable GetDataTable(DO_BlogLikeShare objDoCaseList, CaseList flag) //{ // DataTable dt = new DataTable(); // SqlConnection conn = new SqlConnection(); // SQLManager co = new SQLManager(); // conn = co.GetConnection(); // SqlDataAdapter da = new SqlDataAdapter(); // da.SelectCommand = new SqlCommand("scrl_AddEditDeleteCaseList_SP", conn); // da.SelectCommand.CommandType = CommandType.StoredProcedure; // da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag; // da.SelectCommand.Parameters.Add("@CaseId", SqlDbType.BigInt).Value = objDoCaseList.Caseid; // da.SelectCommand.Parameters.Add("@StrContentTitle", SqlDbType.VarChar, 200).Value = objDoCaseList.ContentTitle; // da.SelectCommand.Parameters.Add("@intAddedby", SqlDbType.BigInt).Value = objDoCaseList.AddedBy; // da.SelectCommand.Parameters.Add("@ContentTypeId", SqlDbType.Int).Value = objDoCaseList.ContentTypeId; // da.SelectCommand.Parameters.Add("@intTagType", SqlDbType.VarChar, 20).Value = objDoCaseList.intTagType; // da.Fill(dt); // co.CloseConnection(conn); // return dt; //} public void AddEditDel_BlogCommentLikeShare(DO_BlogLikeShare objcase, DA_BlogLikeShare.BlogShareLikeFlag flag) { SqlConnection conn = new SqlConnection(); SQLManager co = new SQLManager(); conn = co.GetConnection(); cmd = new SqlCommand("SP_Scrl_BlogLikeShareTbl", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag; cmd.Parameters.Add("@intBlogLikeShareId", SqlDbType.BigInt).Value = objcase.intBlogLikeShareId; cmd.Parameters.Add("@strRepLiShStatus", SqlDbType.VarChar, 2).Value = objcase.strRepLiShStatus; cmd.Parameters.Add("@intCommentID", SqlDbType.Int).Value = objcase.intCommentID; cmd.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value = objcase.intRegistrationId; cmd.Parameters.Add("@intAddedBy", SqlDbType.Int).Value = objcase.intAddedBy; cmd.Parameters.Add("@strIpAddress", SqlDbType.VarChar, 20).Value = objcase.strIpAddress; cmd.Parameters.Add("@strInviteeShare", SqlDbType.VarChar, 20).Value = objcase.strInviteeShare; cmd.Parameters.Add("@strLink", SqlDbType.VarChar, 20).Value = objcase.strLink; cmd.Parameters.Add("@strMessage", SqlDbType.VarChar, 20).Value = objcase.strMessage; objcase.intBlogLikeShareId = Convert.ToInt32(cmd.ExecuteScalar()); co.CloseConnection(conn); }