public ActionResult Remove(int TagID) { TagDAO tagDAO = new TagDAO(); tagDAO.Remove(TagID); return(RedirectToAction("Index", "Tag")); }
public ActionResult TagsAutocomplete(string term) { var lastValue = term.Split(';').Last().Trim(); var listTags = TagDAO.TagsAutocomplete(lastValue); return(Json(listTags, JsonRequestBehavior.AllowGet)); }
public ActionResult Index(string searchString, int page = 1, int pageSize = 100) { var listTags = new TagDAO().GetTagsPaging(searchString, page, pageSize); ViewBag.SearchString = searchString; return(View(listTags)); }
/// <summary> /// /// </summary> /// <param name="_userGuid"></param> /// <param name="_page"></param> /// <param name="_pageSize"></param> /// <returns></returns> public List <Tag> GetTagsForUser(Guid _userGuid, int _page, int _pageSize) { TagDAO dao = new TagDAO(MongoDB); var tags = dao.GetTagsForUser(_userGuid, _page, _pageSize); return(tags); }
public ActionResult Edit(int id, int page) { prioripage = page; TagDAO tagDAO = new TagDAO(); var listTag = tagDAO.GetTag(id); return(View(listTag)); }
// GET: Admin/Tag public ActionResult Index(string searchString, int page = 1, int pagesize = 10) { var dao = new TagDAO(); var model = dao.ListAllPage(searchString, page, pagesize); ViewBag.SearchString = searchString; return(View(model)); }
public ActionResult Modify(int tagId, string tagName) { string msg = TagDAO.ModifyTagName(tagId, tagName); ViewBag.msg = msg; return(View()); }
public ActionResult Delete(int tagId) { TagDAO.DeleteTag(tagId); Response.Redirect(Request.UrlReferrer.ToString()); return(View()); }
public JsonResult Get(int TagId, string Nombre) { var lPerfil = TagDAO.Get(TagId, Nombre); return(new JsonResult() { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { Datos = lPerfil } }); }
public void fresh(EventHandler e) { TagDAO tagDAO = new TagDAO(); List <Tag> tags = tagDAO.getAll(); foreach (Tag tag in tags) { tagEachs.Add(Add(tag, e)); } }
public ActionResult Create(string tagName) { var logger = NLog.LogManager.GetCurrentClassLogger(); logger.Info($"tagName: {tagName}"); string msg = TagDAO.Create(tagName); ViewBag.msg = msg; return(View()); }
// GET: Admin/Tag public ActionResult Index(string searchString = "", int page = 1, int pagesize = 2) { ViewBag.searchString = searchString; TagDAO tagDAO = new TagDAO(); if (searchString == "") { var listTag = tagDAO.SelectAll().ToPagedList(page, pagesize); return(View(listTag)); } else { var listTag = tagDAO.SelectWithCondition(searchString).ToPagedList(page, pagesize); return(View(listTag)); } }
public void BuildDB() { HydrantDAO hydrantDAO = new HydrantDAO(MongoDB); hydrantDAO.BuildTable(); HydrantImageDAO hydrantImageDAO = new HydrantImageDAO(MongoDB); hydrantImageDAO.BuildTable(); TagDAO tagDAO = new TagDAO(MongoDB); tagDAO.BuildTable(); UserDAO userDAO = new UserDAO(MongoDB); userDAO.BuildTable(); UserStatsDAO userStatsDAO = new UserStatsDAO(MongoDB); userStatsDAO.BuildTable(); CannedEmailDAO cannedEmailDAO = new CannedEmailDAO(MongoDB); cannedEmailDAO.BuildTable(); SystemEmailDAO systemEmailDAO = new SystemEmailDAO(MongoDB); systemEmailDAO.BuildTable(); TGUserAuthorizationDAO tgUserAuthorizationDAO = new TGUserAuthorizationDAO(MongoDB); tgUserAuthorizationDAO.BuildTable(); TGUserEmailValidationDAO tgUserEmailValidationDAO = new TGUserEmailValidationDAO(MongoDB); tgUserEmailValidationDAO.BuildTable(); TGUserPasswordDAO tgUserPasswordDAO = new TGUserPasswordDAO(MongoDB); tgUserPasswordDAO.BuildTable(); WebLogEntryDAO webLogEntryDAO = new WebLogEntryDAO(MongoDB); webLogEntryDAO.BuildTable(); }
public ActionResult Create(Tag tag) { if (ModelState.IsValid) { TagDAO tagDAO = new TagDAO(); var check = tagDAO.Create(tag); if (check > 0) { TempData["msg"] = MessageBox.Show("Create successfully"); return(RedirectToAction("Create", "Tag")); } else { ModelState.AddModelError("", "Edit fail"); } } return(View()); }
public ActionResult Edit(Tag tag) { if (ModelState.IsValid) { var tagDao = new TagDAO(); var res = tagDao.Edit(tag); if (res) { SetAlert("Tag đã được cập nhật thành công", "success"); return(RedirectToAction("Index", "Tag")); } } else { ModelState.AddModelError("", "Thông tin nhập vào không hợp lệ"); } return(View()); }
public ActionResult Edit(Tag tag, int id) { tag.TagID = id; if (ModelState.IsValid) { TagDAO tagDAO = new TagDAO(); var check = tagDAO.Edit(tag); if (check > 0) { TempData["msg"] = MessageBox.Show("Edit successfully"); return(RedirectToAction("Index", "Tag", new { @page = prioripage })); } else { ModelState.AddModelError("", "Edit fail"); } } return(View()); }
internal override List <TagDAO> SaveTags(List <string> tagList) { List <TagDAO> tags = new List <TagDAO>(); foreach (String tag in tagList) { TagDAO tagDao = _tag.Where(e => e.Tag == tag).SingleOrDefault(); if (tagDao == null) { tagDao = new TagDAO { Tag = tag }; _tag.Add(tagDao); } tags.Add(tagDao); } return(tags); }
public ActionResult AddTag(Tag tag) { if (ModelState.IsValid) { var dao = new TagDAO(); var res = dao.AddTag(tag); if (res) { SetAlert("Tag đã được thêm thành công", "success"); return(RedirectToAction("Index", "Tag")); } if (res) { SetAlert("Tag đã được thêm thành công", "success"); return(View()); } } return(View()); }
public void setTag(int tagId) { if (tagId != 999) { Tag tag = new TagDAO().getById(tagId); this.tagLabel.Text = tag.Name; this.tagLabel.ForeColor = Color.FromArgb(55, 97, 241); this.tagImage.BackgroundImage = Properties.Resources.eglass_tag_fix; this.tagDelete.Enabled = true; this.tagDelete.Visible = true; } else { this.tagLabel.ForeColor = SystemColors.GrayText; this.tagLabel.Text = "添加任务标记"; this.tagImage.BackgroundImage = Properties.Resources.eglass_tag; } }
public ActionResult Create(Tag model) { if (ModelState.IsValid) { var dao = new TagDAO(); var id = dao.Insert(model); if (id != null) { SetAlert("Thêm mới thành công", "success"); return(RedirectToAction("Index", "Tag")); } else { ModelState.AddModelError("", "Thêm mới không thành công ! "); } } return(View()); }
public ActionResult Create(Note note) { try { NoteDAO.Create(note); //get tags var tagList = note.TagList; char[] delimiter = { ' ' }; string[] tags = tagList.Split(delimiter); foreach (var tag in tags) { if (tag != null || tag != "") { var t = new Tag { Name = tag }; TagDAO.Create(t); } var tagItem = TagDAO.GetTag(tag); var nTag = new Note_Tag(); nTag.NoteId = note.NoteId; nTag.TagId = tagItem.Id; Note_TagDAO.Create(nTag); } return(RedirectToAction("Index", "Home")); } catch { return(RedirectToAction("Index", "Home")); return(View()); } return(RedirectToAction("Index", "Home")); }
public int ThemThucDon(ThucDonDTO thucdon, String[] strDsMaMon, String strTag) { int Kq = 0; // mã thực đơn Connect(); SqlCommand cmd = new SqlCommand("spThemThucDon", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@tenthucdon", SqlDbType.NVarChar); cmd.Parameters.Add("@maloaithucdon", SqlDbType.Int); cmd.Parameters.Add("@mota", SqlDbType.NVarChar); cmd.Parameters.Add("@hinhanhminhhoa", SqlDbType.VarChar); cmd.Parameters.Add("@diembinhchon", SqlDbType.Int); cmd.Parameters.Add("@gia", SqlDbType.Money); cmd.Parameters.Add("@tinhtrang", SqlDbType.Bit); cmd.Parameters.Add("@trangthaihienthi", SqlDbType.Bit); cmd.Parameters["@tenthucdon"].Value = thucdon.Ten_thuc_don; cmd.Parameters["@maloaithucdon"].Value = thucdon.Ma_loai_thuc_don; cmd.Parameters["@mota"].Value = thucdon.Mo_ta; cmd.Parameters["@hinhanhminhhoa"].Value = thucdon.Hinh_anh_minh_hoa; cmd.Parameters["@diembinhchon"].Value = thucdon.Diem_binh_chon; cmd.Parameters["@gia"].Value = thucdon.Gia; cmd.Parameters["@tinhtrang"].Value = thucdon.Tinh_trang; cmd.Parameters["@trangthaihienthi"].Value = thucdon.Trang_thai_hien_thi; cmd.Parameters.Add("@mathucdon", SqlDbType.Int); cmd.Parameters["@mathucdon"].Direction = ParameterDirection.Output; try { cmd.ExecuteNonQuery(); int mathucdon = int.Parse(cmd.Parameters["@mathucdon"].Value.ToString()); Kq = mathucdon; Disconnect(); for (int i = 0; i < strDsMaMon.Length; ++i) { CTThucDonDTO ctDto = new CTThucDonDTO(); ctDto.Ma_thuc_don = mathucdon; ctDto.Ma_mon = int.Parse(strDsMaMon[i]); CTThucDonBUS ctBus = new CTThucDonBUS(); ctBus.ThemCTThucDon(ctDto); } String[] dsTag = TagDAO.XuLyChuoiTag(strTag); TagDTO tagDTO = new TagDTO(); TagThucDonDTO tagthucdonDTO = new TagThucDonDTO(); tagthucdonDTO.Ma_thuc_don = mathucdon; for (int i = 0; i < dsTag.Length; ++i) { tagDTO.Ten_tag = dsTag[i]; int matag = (new TagDAO()).ThemTag(tagDTO); tagthucdonDTO.Ma_tag = matag; (new TagThucDonDAO()).ThemTagThucDon(tagthucdonDTO); } } catch (SqlException ex) { Disconnect(); throw ex; } return(Kq); }
public static Tag GetTag(string ID) { return(TagDAO.GetTag(ID)); }
public static List <Tag> GetAllTag(int contentID) { return(TagDAO.GetAllTag(contentID)); }
public ActionResult Edit(long id) { var tag = new TagDAO().ViewDetail(id); return(View(tag)); }
public int ThemMonAn(MonAnDTO monan, String strTag) { int Kq = 0; //mã người dùng Connect(); SqlCommand cmd = new SqlCommand("spThemMonAn", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@tenmon", SqlDbType.NVarChar); cmd.Parameters.Add("@hinhanhminhhoa", SqlDbType.NVarChar); cmd.Parameters.Add("@mota", SqlDbType.Text); cmd.Parameters.Add("@diembinhchon", SqlDbType.Int); cmd.Parameters.Add("@donvitinh", SqlDbType.NVarChar); cmd.Parameters.Add("@gia", SqlDbType.Money); cmd.Parameters.Add("@maloaimon", SqlDbType.Int); cmd.Parameters.Add("@tinhtrang", SqlDbType.Bit); cmd.Parameters.Add("@trangthaihienthi", SqlDbType.Bit); cmd.Parameters["@tenmon"].Value = monan.Ten_mon; cmd.Parameters["@hinhanhminhhoa"].Value = monan.Hinh_anh_minh_hoa; cmd.Parameters["@mota"].Value = monan.Mo_ta; cmd.Parameters["@diembinhchon"].Value = monan.Diem_binh_chon; cmd.Parameters["@donvitinh"].Value = monan.Don_vi_tinh; cmd.Parameters["@gia"].Value = monan.Gia; cmd.Parameters["@maloaimon"].Value = monan.Ma_loai_mon; cmd.Parameters["@tinhtrang"].Value = monan.Tinh_trang; cmd.Parameters["@trangthaihienthi"].Value = monan.Trang_thai_hien_thi; cmd.Parameters.Add("@mamon", SqlDbType.Int); cmd.Parameters["@mamon"].Direction = ParameterDirection.Output; try { cmd.ExecuteNonQuery(); int mamon = int.Parse(cmd.Parameters["@mamon"].Value.ToString()); Kq = mamon; Disconnect(); String[] dsTag = TagDAO.XuLyChuoiTag(strTag); TagDTO tagDTO = new TagDTO(); TagMonAnDTO tagmonanDTO = new TagMonAnDTO(); tagmonanDTO.Ma_mon = mamon; for (int i = 0; i < dsTag.Length; ++i) { tagDTO.Ten_tag = dsTag[i]; int matag = (new TagDAO()).ThemTag(tagDTO); tagmonanDTO.Ma_tag = matag; (new TagMonAnDAO()).ThemTagMonAn(tagmonanDTO); } } catch (SqlException ex) { Disconnect(); throw ex; } return(Kq); }
public PostController() { postDAO = new PostDAO(db); tagDAO = new TagDAO(db); }
public ActionResult List(string orderColumn, string orderType, string noteId, string tagId) { OrderColumn defaultOrderColumn = OrderColumn.Notedate; OrderType defaultOrderType = OrderType.Desc; OrderColumn selectedOrderColumn; OrderType selectedOrderType; int selectedTagId; if (String.IsNullOrEmpty(orderColumn)) { // parameter is empty //selectedOrderColumn = defaultOrderColumn; if (Session["OrderColumn"] != null) { // do nothing } else { // use default value Session["OrderColumn"] = defaultOrderColumn; } } else { // parameter is delivered by user selectedOrderColumn = (OrderColumn)Enum.Parse(typeof(OrderColumn), orderColumn); Session["OrderColumn"] = selectedOrderColumn; } if (String.IsNullOrEmpty(orderType)) { // parameter is empty //selectedOrderColumn = defaultOrderColumn; if (Session["OrderType"] != null) { // do nothing } else { // use default value Session["OrderType"] = defaultOrderType; } } else { // parameter is delivered by user selectedOrderType = (OrderType)Enum.Parse(typeof(OrderType), orderType); Session["OrderType"] = selectedOrderType; } //Tagid selectedTagId = int.Parse(tagId); var noteList = TagDAO.GetNoteListByTagId(selectedTagId); // 리스트 정렬 정보 (column, asc|desc) // note detail int selectedNoteid = noteList[0].NoteId; NoteVO selectedNote = NoteDAO.GetNotebyId(selectedNoteid); NoteIndexVM model = new NoteIndexVM(); model.NoteList = noteList; model.SelectedNote = selectedNote; int notebookIdParsedInt = int.Parse(tagId); model.NoteBook = NoteBookDAO.GetNoteBookbyId(notebookIdParsedInt); //바로가기 여부 보여줌 //ViewBag.isShortCut = ShortcutManager.IsShorcut(id, 1); return(View(model)); }
public ActionResult AddTagToNote(string tagName, int noteId) { TagDAO.AddTagToNote(tagName, noteId); return(RedirectToAction("../note/index")); }
// GET: Tag public ActionResult Index() { List <TagVO> tagList = TagDAO.GetTagList(); return(View(tagList)); }