public bool Update(int ID, string NAME, string IMAGE, string SUMMURY, string DESCRIPTION, DateTime CREATED_DATE, int STATUS)
{
string[] parameter = new string[] { "@ID", "@NAME", "@IMAGE", "@SUMMURY", "@DESCRIPTION", "@CREATED_DATE", "@STATUS" };
object[] obj = new object[] { ID, NAME, IMAGE, SUMMURY, DESCRIPTION, CREATED_DATE, STATUS };
return(cnts.Update("tblTestimonialUpdate", parameter, obj));
}
public bool Update(int VIDEO_ID, string NAME, string LINK_YOUTUBE, string DESCRIPTION, int SORT_DISPLAY, DateTime CREATE_DATE, int STATUS)
{
string[] arrParam = { "@VIDEO_ID", "@NAME", "@LINK_YOUTUBE", "@DESCRIPTION", "@SORT_DISPLAY", "@CREATE_DATE", "@STATUS" };
object[] arrValue = { VIDEO_ID, NAME, LINK_YOUTUBE, DESCRIPTION, SORT_DISPLAY, CREATE_DATE, STATUS };
return(cnts.Update("tblVideoEdit", arrParam, arrValue));
}
public bool Update(int ID, string NAME, string IMAGE, string SUMMURY, int STATUS, int isHot)
{
string[] arrParam = { "@ID", "@NAME", "@IMAGE", "@SUMMURY", "@STATUS", "@isHot" };
object[] arrValue = { ID, NAME, IMAGE, SUMMURY, STATUS, isHot };
return(objCon.Update("tblSubject_Update", arrParam, arrValue));
}
public bool Update(int ID, int PARENT_ID, string NAME, string LINK, string SORT_DISPLAY, DateTime CREATED_DATE, int STATUS, int DISPLAY_MENU, string Meta_keywords, string Meta_title, string Meta_description)
{
string[] parameter = new string[] { "@ID", "@PARENT_ID", "@NAME", "@LINK", "@SORT_DISPLAY", "@CREATED_DATE", "@STATUS", "@DISPLAY_MENU", "@Meta_keywords", "@Meta_title", "@Meta_description" };
object[] obj = new object[] { ID, PARENT_ID, NAME, LINK, SORT_DISPLAY, CREATED_DATE, STATUS, DISPLAY_MENU, Meta_keywords, Meta_title, Meta_description };
return(cnts.Update("tblCategory_Update", parameter, obj));
}
public bool Update(string content)
{
string[] arrParam = { "@Content" };
object[] arrValue = { content };
return(objCon.Update("tblFooter_Update", arrParam, arrValue));
}
public bool Update(int ID, string TITLE, string AVARTA, string DESCRIPTION, int STATUS)
{
string[] arrParam = { "@ID", "@TITLE", "@AVARTA", "@DESCRIPTION", "@STATUS" };
object[] arrValue = { ID, TITLE, AVARTA, DESCRIPTION, STATUS };
return(cnts.Update("tblPicture_Edit", arrParam, arrValue));
}
public bool UpdateByUsername(string username, string password)
{
string[] para = new string[] { "@USERNAME", "@PASSWORD" };
string[] obj = new string[] { username, password };
return(cnts.Update("tblAdministrator_UpdateByUsername", para, obj));
}
public bool Update(string id, string title, string status)
{
string[] arrParam = { "@ID", "@ROLENAME", "@STATUS" };
object[] arrValue = { id, title, status };
return(objCon.Update("tblRole_Update", arrParam, arrValue));
}
public bool Update(int ID, string NAME, string IMAGE, string LINK, int SORT_DISPLAY, int STATUS, string DESCRIPTION, int TYPE)
{
string[] arrParam = { "@ID", "@NAME", "@IMAGE", "@LINK", "@SORT_DISPLAY", "@STATUS", "@DESCRIPTION", "@TYPE" };
object[] arrValue = { ID, NAME, IMAGE, LINK, SORT_DISPLAY, STATUS, DESCRIPTION, TYPE };
return(objCon.Update("tblSlideShow_Update", arrParam, arrValue));
}
public bool Delete(string ID)
{
string[] para = new string[] { "@ID" };
object[] obj = new object[] { ID };
return(cnts.Update("tblCustomer_Delete", para, obj));
}
public bool tblNewsUpdate(int ID, string CATEGORYID, string TITLE, string IMAGE, string SUMMARY, string CONTENT, int SORT_DISPLAY, int STATUS, string META_KEYWORD, string META_DESCRIPTION, int IS_HOT, int IS_HIGHTLIGHT, int SchoolId)
{
string[] parameter = new string[] { "@ID", "@CATEGORYID", "@TITLE", "@IMAGE", "@SUMMARY", "@CONTENT", "@SORT_DISPLAY", "@STATUS", "@META_KEYWORD", "@META_DESCRIPTION", "@IS_HOT", "@IS_HIGHTLIGHT", "@SchoolId" };
object[] obj = new object[] { ID, CATEGORYID, TITLE, IMAGE, SUMMARY, CONTENT, SORT_DISPLAY, STATUS, META_KEYWORD, META_DESCRIPTION, IS_HOT, IS_HIGHTLIGHT, SchoolId };
return(cnts.Update("tblNewsUpdate", parameter, obj));
}
public bool Update(int News_ID, string TAG_ID)
{
string[] arrParam = { "@News_ID", "@TAG_ID" };
object[] arrValue = { News_ID, TAG_ID };
return(objCon.Update("tblNewsTags_Update", arrParam, arrValue));
}
public bool Update(int ID, string DESCRIPTION, string ANSWER, int STATUS)
{
string[] arrParam = { "@ID", "@DESCRIPTION", "@ANSWER", "@STATUS" };
object[] arrValue = { ID, DESCRIPTION, ANSWER, STATUS };
return(cnts.Update("tblHoiDap_Update", arrParam, arrValue));
}
public bool Update(int ID, string NAME)
{
string[] arrParam = { "@ID", "@NAME" };
object[] arrValue = { ID, NAME };
return(cnts.Update("tblTags_update", arrParam, arrValue));
}
public bool Update(int TEACHER_ID, string NAME, string IMAGE, string DESCRIPTION, DateTime CREATED_DATE, int STATUS)
{
string[] arrParam = { "@TEACHER_ID", "@NAME", "@IMAGE", "@DESCRIPTION", "@CREATED_DATE", "@STATUS" };
object[] arrValue = { TEACHER_ID, NAME, IMAGE, DESCRIPTION, CREATED_DATE, STATUS };
return(cnts.Update("tblTeacher_Update", arrParam, arrValue));
}
public bool Update(int ID, string School_Name, string School_Image, int Status, string Link_Facebook)
{
string[] arrParam = { "@ID", "@School_Name", "@School_Image", "@Status", "@Link_Facebook" };
object[] arrValue = { ID, School_Name, School_Image, Status, Link_Facebook };
return(objCon.Update("tblSchool_Update", arrParam, arrValue));
}
public bool Update(string id, string email, string fullname, string status)
{
string[] arrParam = { "@ID", "@EMAIL", "@FULLNAME", "@STATUS" };
string[] arrValue = { id, email, fullname, status };
return(cnts.Update("tblMailReceiver_Update", arrParam, arrValue));
}
//public bool Update(int ForumID)
//{
// string[] para = new string[] { "@ForumID" };
// object[] obj = new object[] { ForumID };
// return cnts.Update("tblCommentForum_Delete_ForumID", para, obj);
//}
public bool DeleteByForum(int ForumID)
{
string[] para = new string[] { "@ForumID" };
object[] obj = new object[] { ForumID };
return(cnts.Update("tblCommentForum_Delete_ForumID", para, obj));
}
public bool Update(string id, string parentid, string functionname, string url, string isDisplay, string indexes, string updateby)
{
string[] arrParam = { "@ID", "@ParentID", "@FunctionName", "@Url", "@isDisplay", "@Indexes", "@UpdateBy" };
object[] arrValue = { id, parentid, functionname, url, isDisplay, indexes, updateby };
return(objCon.Update("tblFunction_Update", arrParam, arrValue));
}
public bool Delete(int CommentId, string CustomerEmail)
{
string[] arrParam = { "@CommentId", "@CustomerEmail" };
object[] arrValue = { CommentId, CustomerEmail };
return cnts.Update("tblCountLikeComment_Delete", arrParam, arrValue);
}
public bool Delete(int ThreadId, string CustomerEmail)
{
string[] arrParam = { "@ThreadId", "@CustomerEmail" };
object[] arrValue = { ThreadId, CustomerEmail };
return(cnts.Update("tblCountLike_Delete", arrParam, arrValue));
}
public bool Update(int ID, int SubjectID, string Article_Name, string Article_Content, int Status)
{
string[] arrParam = { "@ID", "@SubjectID", "@Article_Name", "@Article_Content", "@Status" };
object[] arrValue = { ID, SubjectID, Article_Name, Article_Content, Status };
return(objCon.Update("tblForum_Update", arrParam, arrValue));
}
public bool DisplayCategoryStatus(string ID)
{
string[] arrParam = { "@ID" };
object[] arrValue = { ID };
return(cnts.Update("tblCategory_UpdateStatus", arrParam, arrValue));
}
