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));
}
