public ActionResult ProcessArticle(int ARTICLE_ID, int ISLEM) { try { IDatabase2 db = DatabaseFactory.GetDbObject(DbSettings.TransactionMode); IQueryGenerator gen = QueryGeneratorFactory.GetDbObject(); gen.TableName = "article"; gen.AddDataParameter("ACTIVE", ISLEM); gen.FilterText = "where ID=:p1"; gen.AddFilterParameter("p1", ARTICLE_ID); db.ExecuteQuery(gen.GetUpdateCommand()); db.Commit(); return(RedirectToAction("ManageArticle")); } catch { return(RedirectToAction("ManageArticle")); } }
public ActionResult Process(string ID, int ISLEM) { IDatabase2 db = DatabaseFactory.GetDbObject(); IQueryGenerator gen = QueryGeneratorFactory.GetDbObject(); gen.TableName = "comment"; if (ISLEM == 1) { gen.AddDataParameter("APPROVED", 1); } else { gen.AddDataParameter("APPROVED", 2); } gen.FilterText = " WHERE ID=:p1"; gen.AddFilterParameter("p1", ID); db.ExecuteQuery(gen.GetUpdateCommand()); List <Comment> cList = ProcessView(); return(View("Index", cList)); }
public bool Login(string UserName, string Password) { IDatabase2 db = DatabaseFactory.GetDbObject(); IQueryGenerator gen = QueryGeneratorFactory.GetDbObject(); gen.SelectText = "select count(*) from blog.user where "; gen.FilterText = "USER_NAME = :p1 and PASSWORD = :p2"; gen.AddFilterParameter("p1", UserName); gen.AddFilterParameter("p2", Password); int i = Util.GetProperty <int>(db.GetSingleValue(gen.GetSelectCommandBasic())); if (i > 0) { HttpContext.Current.Session["UserName"] = UserName; return(true); } return(false); }
public ActionResult AddArticle(string TITLE, string CONTENT, int[] CATEGORIES) { try { string nGuid = Guid.NewGuid().ToString("N"); IDatabase2 db = DatabaseFactory.GetDbObject(DbSettings.TransactionMode); IQueryGenerator gen = QueryGeneratorFactory.GetDbObject(); gen.TableName = "article"; gen.AddDataParameter("TITLE", TITLE); gen.AddDataParameter("TEXT", CONTENT); gen.AddDataParameter("INSERT_DATE", DateTime.Now); gen.AddDataParameter("AUTHOR", "vyigity"); gen.AddDataParameter("ID_GUID", nGuid); db.ExecuteQuery(gen.GetInsertCommand()); IQueryGenerator gen2 = QueryGeneratorFactory.GetDbObject(); gen2.SelectText = "select ID from article where "; gen2.FilterText = "ID_GUID = :p1"; gen2.AddFilterParameter("p1", nGuid); if (CATEGORIES != null && CATEGORIES.Length > 0) { int id = Util.GetProperty <int>(db.GetSingleValue(gen2.GetSelectCommandBasic())); foreach (int i in CATEGORIES) { IQueryGenerator gen3 = QueryGeneratorFactory.GetDbObject(); gen3.TableName = "article_category"; gen3.AddDataParameter("ARTICLE_ID", id); gen3.AddDataParameter("CATEGORY_ID", i); db.ExecuteQuery(gen3.GetInsertCommand()); } } db.Commit(); ProcessView(); return(RedirectToAction("ManageArticle")); } catch { return(RedirectToAction("Index")); } }
private static void FillComments(IDatabase2 db, Article article) { IQueryGenerator gen = QueryGeneratorFactory.GetDbObject(); gen.SelectText = "select * from blog.comment c where c.APPROVED = 1 and "; gen.FilterText = "c.article_id = :p1 "; gen.SelectTail = "order by c.INSERT_DATE desc"; gen.AddFilterParameter("p1", article.ID); List <Comment> cList = db.GetObjectList <Comment>(gen.GetSelectCommandBasic()); article.COMMENTS = cList; }
private Article GetData(int id) { IDatabase2 db = DatabaseFactory.GetDbObject(); IQueryGenerator gen = QueryGeneratorFactory.GetDbObject(); gen.SelectText = "select * from article where "; gen.FilterText = "id=:p1"; gen.AddFilterParameter("p1", id); Article sonuc = db.GetObject <Article>(gen.GetSelectCommandBasic()); return(sonuc); }
private static List <Article> GetData(string searchText) { IDatabase2 db = DatabaseFactory.GetDbObject(); IQueryGenerator gen = QueryGeneratorFactory.GetDbObject(); gen.SelectText = "select a.*,(select count(*) from comment c where c.article_id = a.id and c.APPROVED = 1) COMMENT_COUNT from article a where a.ACTIVE=1 and "; gen.FilterText = "TEXT like CONCAT('%',:p1,'%') "; gen.SelectTail = "order by INSERT_DATE desc"; gen.AddFilterParameter("p1", searchText); List <Article> aList = db.GetObjectList <Article>(gen.GetSelectCommandBasic()); FillCategory(db, aList); return(aList); }
private static List <Category> GetLoadedCategory(int id) { IDatabase2 db = DatabaseFactory.GetDbObject(); IQueryGenerator gen = QueryGeneratorFactory.GetDbObject(); gen.SelectText = "select c.* from category c, article_category ac where "; gen.FilterText = "c.id = ac.category_id and ac.article_id = :p1 "; gen.SelectTail = "order by c.LABEL_TEXT"; gen.AddFilterParameter("p1", id); List <Category> aList = db.GetObjectList <Category>(gen.GetSelectCommandBasic()); return(aList); }
private static List <Article> GetDataWithCategory(int id) { IDatabase2 db = DatabaseFactory.GetDbObject(); IQueryGenerator gen = QueryGeneratorFactory.GetDbObject(); gen.SelectText = "select a.*, (select count(*) from comment co where co.article_id = a.id and co.APPROVED = 1) COMMENT_COUNT from article a, article_category c where a.id = c.article_id and a.ACTIVE=1 and "; gen.FilterText = "c.category_id = :p1 order by a. INSERT_DATE desc"; gen.AddFilterParameter("p1", id); List <Article> aList = db.GetObjectList <Article>(gen.GetSelectCommandBasic()); FillCategory(db, aList); return(aList); }
private static void FillCategory(IDatabase2 db, List <Article> aList) { foreach (var arc in aList) { IQueryGenerator gen = QueryGeneratorFactory.GetDbObject(); gen.SelectText = "select * from category c ,article_category a where "; gen.FilterText = "a.category_id = c.id and a.article_id = :p1"; gen.SelectTail = "order by c.LABEL_TEXT"; gen.AddFilterParameter("p1", arc.ID); List <Category> cList = db.GetObjectList <Category>(gen.GetSelectCommandBasic()); arc.CATEGORIES = cList; } }
private static List <Article> GetData(int id) { IDatabase2 db = DatabaseFactory.GetDbObject(); IQueryGenerator gen = QueryGeneratorFactory.GetDbObject(); gen.SelectText = "select a.*, (select count(*) from comment c where c.article_id = a.id and c.APPROVED = 1) COMMENT_COUNT from article a where a.ACTIVE=1 and "; gen.FilterText = "a.id = :p1"; gen.AddFilterParameter("p1", id); List <Article> aList = db.GetObjectList <Article>(gen.GetSelectCommandBasic()); FillCategory(db, aList); FillComments(db, aList.First()); return(aList); }
public ActionResult DeleteCategory(int ID) { IDatabase2 db = DatabaseFactory.GetDbObject(); IQueryGenerator gen = QueryGeneratorFactory.GetDbObject(); gen.SelectText = "delete from category where "; gen.FilterText = "id = :p1"; gen.AddFilterParameter("p1", ID); db.ExecuteQuery(gen.GetSelectCommandBasic()); List <Category> cList = ProcessView(); return(View("Index", cList)); }
public ActionResult UpdateArticle(int ARTICLE_ID, string TITLE, string CONTENT, int[] CATEGORIES) { try { IDatabase2 db = DatabaseFactory.GetDbObject(DbSettings.TransactionMode); IQueryGenerator gen = QueryGeneratorFactory.GetDbObject(); gen.TableName = "article"; gen.AddDataParameter("TITLE", TITLE); gen.AddDataParameter("TEXT", CONTENT); gen.AddDataParameter("UPDATE_DATE", DateTime.Now); gen.AddDataParameter("AUTHOR", "vyigity"); gen.FilterText = " where ID=:p1"; gen.AddFilterParameter("p1", ARTICLE_ID); db.ExecuteQuery(gen.GetUpdateCommand()); db.ExecuteQuery("delete from article_category where article_id = " + ARTICLE_ID); if (CATEGORIES != null && CATEGORIES.Length > 0) { foreach (int i in CATEGORIES) { IQueryGenerator gen3 = QueryGeneratorFactory.GetDbObject(); gen3.TableName = "article_category"; gen3.AddDataParameter("ARTICLE_ID", ARTICLE_ID); gen3.AddDataParameter("CATEGORY_ID", i); db.ExecuteQuery(gen3.GetInsertCommand()); } } db.Commit(); return(RedirectToAction("ManageArticle")); } catch { return(RedirectToAction("ArticleUpdate")); } }