public DataTable CheckCount(int CommentId, string CustomerEmail)
{
string[] arrParam = { "@CommentId", "@CustomerEmail" };
object[] arrValue = { CommentId, CustomerEmail };
return cnts.TableWithParameter("tblCountLikeComment_CheckLike", arrParam, arrValue);
}
public DataTable GetAllData()
{
string[] para = new string[] { };
object[] obj = new object[] { };
return(cnts.TableWithParameter("tblCommentForum_GetAllData", para, obj));
}
public DataTable GetData()
{
string[] arrParam = { };
object[] arrValue = { };
return(objCon.TableWithParameter("tblFooter_GetData", arrParam, arrValue));
}
public DataTable GetAllTags()
{
string[] arrParam = { };
object[] arrValue = { };
return(cnts.TableWithParameter("tblTags_GetAll", arrParam, arrValue));
}
public DataTable GetAll()
{
string[] arrParam = { };
object[] arrValue = { };
return(objCon.TableWithParameter("tblRole_GetAll", arrParam, arrValue));
}
public DataTable GetDataByCategory(int CATEGORYID)
{
string[] para = new string[] { "@CATEGORYID" };
object[] obj = new object[] { CATEGORYID };
return(cnts.TableWithParameter("tblNews_GetDataByCategoryID", para, obj));
}
public DataTable GetDataByID(int VIDEO_ID)
{
string[] arrParam = { "@VIDEO_ID" };
object[] arrValue = { VIDEO_ID };
return(cnts.TableWithParameter("tblVideo_GetByID", arrParam, arrValue));
}
public DataTable CheckCount(int ThreadId, string CustomerEmail)
{
string[] arrParam = { "@ThreadId", "@CustomerEmail" };
object[] arrValue = { ThreadId, CustomerEmail };
return(cnts.TableWithParameter("tblCountLike_CheckLike", arrParam, arrValue));
}
public DataTable GetDataByID(string id)
{
return(cnts.TableWithParameter("tblCategory_GetByID", new string[] { "@ID" }, new object[] { id }));
}
public DataTable GetAll()
{
string[] arrParam = { };
object[] arrValue = { };
return(cnts.TableWithParameter("tblTeacher_GetData", arrParam, arrValue));
}
public DataTable GetById(string id)
{
string[] arrParam = { "@ID" };
string[] arrValue = { id };
return(cnts.TableWithParameter("tblMailReceiver_GetByID", arrParam, arrValue));
}
public DataTable tblAdministratorsSelectWithPaged(int STATUS, int STARTINDEX, int MAXRECORDS)
{
return(cnts.TableWithParameter("tblAdministratorsSelectWithPaged", new string[] { "@STATUS", "@STARTINDEX", "@MAXRECORDS" }
, new object[] { STATUS, STARTINDEX, MAXRECORDS }));
}
public DataTable tblEmailTemplateSearch(string emailid)
{
return(cnts.TableWithParameter("tblEmailTemplateSearch", new string[] { "@EMAILID" }, new object[] { emailid }));
}
public DataTable GetAllData()
{
string[] arrParam = { };
object[] arrValue = { };
return(cnts.TableWithParameter("tblEventComment_GetAllData", arrParam, arrValue));
}
public DataTable GetDataByID(int ID)
{
string[] arrParam = { "@ID" };
object[] arrValue = { ID };
return(cnts.TableWithParameter("tblPicture_GetDataByID", arrParam, arrValue));
}
public DataTable GetDataByID(string id)
{
return(cnts.TableWithParameter("tblTestimonialGetbyID", new string[] { "@ID" }, new object[] { id }));
}
public DataTable GetDataByID(int ID)
{
string[] arrParam = { "@ID" };
object[] arrValue = { ID };
return(objCon.TableWithParameter("tblForum_GetDataByID", arrParam, arrValue));
}
public DataTable dataCheckTags(int News_ID)
{
string[] arrParam = { "@News_ID" };
object[] arrValue = { News_ID };
return(objCon.TableWithParameter("tblNewsTags_CheckTags", arrParam, arrValue));
}