public IHttpActionResult PuttblTag(int id, tblTag tblTag)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblTag.tagId)
{
return(BadRequest());
}
db.Entry(tblTag).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tblTagExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Edit(tblTag tbltag, int id, FormCollection collection)
{
string idUser = Request.Cookies["Username"].Values["UserID"];
tbltag.idUser = int.Parse(idUser);
tbltag.DateCreate = DateTime.Now;
db.Entry(tbltag).State = EntityState.Modified;
db.SaveChanges();
#region [Updatehistory]
Updatehistoty.UpdateHistory("Edit Tags", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
#endregion
if (collection["btnSave"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã sửa thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Tagsad/Index"));
}
if (collection["btnSaveCreate"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm thành công, mời bạn thêm mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Tagsad/Create"));
}
return(View(tbltag));
}
public ActionResult FilterPostsByLanguage(int?id, int?page)
{
if (id == null)
{
return(HttpNotFound());
}
tblLanguage language = db.tblLanguages.Find(id);
if (language == null)
{
return(HttpNotFound());
}
if (db.tblTags.FirstOrDefault(t => t.Tag_Title.Contains(language.Lang_Name)) != null)
{
db.tblTags.FirstOrDefault(t => t.Tag_Title.Contains(language.Lang_Name)).Tag_CountSearch++;
db.SaveChanges();
}
else
{
tblTag tag = new tblTag()
{
Tag_Title = language.Lang_Name,
Tag_DateAdd = DateTime.Now,
Tag_CountSearch = 1
};
db.tblTags.Add(tag);
db.SaveChanges();
}
ViewBag.Title = "Tìm kiếm code theo nhóm loại";
ViewBag.countPost = db.tblPostLangs.Where(t => t.Lang_ID == id).Select(t => t.tblPost).Where(t => t.Post_Active == true && t.Post_Trash == false).Count();
IPagedList <tblPost> post = db.tblPostLangs.Where(t => t.Lang_ID == id).Select(t => t.tblPost).Where(t => t.Post_Active == true && t.Post_Trash == false).OrderByDescending(t => t.Post_DateCreate).ToPagedList(page ?? 1, PAGE_SIZE);
return(View("Index", post));
}
public ActionResult FilterPostsByCatID(int?id, int?page)
{
if (id == null)
{
return(HttpNotFound());
}
tblCategory category = db.tblCategories.Find(id);
if (db.tblTags.FirstOrDefault(t => t.Tag_Title.Contains(category.Cat_Name)) != null)
{
db.tblTags.FirstOrDefault(t => t.Tag_Title.Contains(category.Cat_Name)).Tag_CountSearch++;
db.SaveChanges();
}
else
{
tblTag tag = new tblTag()
{
Tag_Title = category.Cat_Name,
Tag_DateAdd = DateTime.Now,
Tag_CountSearch = 1
};
db.tblTags.Add(tag);
db.SaveChanges();
}
ViewBag.Title = "Tìm kiếm code theo danh mục";
ViewBag.countPost = db.tblPosts.Where(t => t.Post_Cat == id && t.Post_Active == true && t.Post_Trash == false).Count();
IPagedList <tblPost> post = db.tblPosts.Where(t => t.Post_Cat == id && t.Post_Active == true && t.Post_Trash == false).OrderByDescending(t => t.Post_DateCreate).ToPagedList(page ?? 1, PAGE_SIZE);
return(View("Index", post));
}
public ActionResult Create(tblTag tbltag, FormCollection collection)
{
tbltag.DateCreate = DateTime.Now;
string idUser = Request.Cookies["Username"].Values["UserID"];
tbltag.idUser = int.Parse(idUser);
db.tblTags.Add(tbltag);
db.SaveChanges();
#region [Updatehistory]
Updatehistoty.UpdateHistory("Add tbltag", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
#endregion
if (collection["btnSave"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã thêm thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Tagsad/Index"));
}
if (collection["btnSaveCreate"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm thành công, mời bạn thêm danh mục mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Tagsad/Create"));
}
return(Redirect("Index"));
}
//protected void lbtnAddTag_Click(object sender, EventArgs e)
//{
// //---for multiple move----
// if (lstboxAddTag.SelectedIndex >= 0)
// {
// for (int i = 0; i < lstboxAddTag.Items.Count; i++)
// {
// if (lstboxAddTag.Items[i].Selected)
// {
// if (!array1.Contains(lstboxAddTag.Items[i]))
// {
// array1.Add(lstboxAddTag.Items[i]);
// }
// }
// }
// for (int i = 0; i < array1.Count; i++)
// {
// if (!lstboxRemoveTag.Items.Contains(((ListItem)array1[i])))
// {
// lstboxRemoveTag.Items.Add(((ListItem)array1[i]));
// }
// lstboxAddTag.Items.Remove(((ListItem)array1[i]));
// }
// lstboxRemoveTag.SelectedIndex = -1;
// }
// else
// {
// Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('" + "Select a tag to add!" + "');", true);
// }
// //---for multiple move----
// //---for single move----
// //if (lstboxAddTag.SelectedIndex != -1)
// //{
// // lstboxRemoveTag.Items.Add(lstboxAddTag.SelectedItem);
// // lstboxAddTag.Items.RemoveAt(lstboxAddTag.SelectedIndex);
// //}
// //else
// //{
// // Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('" + "Select a tag to add!" + "');", true);
// //}
// //---for single move----
//}
//protected void lstboxAddTag_SelectedIndexChanged(object sender, EventArgs e)
//{
// if (lstboxAddTag.SelectedIndex > -1)
// {
// if (lstboxRemoveTag.Items.Count > lstboxAddTag.SelectedIndex) //checking if listBox2 has enough items to select
// {
// lstboxRemoveTag.SelectedIndex = lstboxAddTag.SelectedIndex;
// }
// }
//}
//protected void lbtnRemoveTag_Click(object sender, EventArgs e)
//{
// if (lstboxRemoveTag.SelectedIndex >= 0)
// {
// for (int i = 0; i < lstboxRemoveTag.Items.Count; i++)
// {
// if (lstboxRemoveTag.Items[i].Selected)
// {
// if (!array2.Contains(lstboxRemoveTag.Items[i]))
// {
// array2.Add(lstboxRemoveTag.Items[i]);
// }
// }
// }
// for (int i = 0; i < array2.Count; i++)
// {
// if (!lstboxAddTag.Items.Contains(((ListItem)array2[i])))
// {
// lstboxAddTag.Items.Add(((ListItem)array2[i]));
// }
// lstboxRemoveTag.Items.Remove(((ListItem)array2[i]));
// }
// lstboxAddTag.SelectedIndex = -1;
// }
// else
// {
// Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('" + "Select a tag to remove!" + "');", true);
// }
//}
protected void btnSubmit_Click(object sender, EventArgs e)
{
tblPost post = new tblPost();
tblTag tag = new tblTag();
tblPostNotification postnotification = new tblPostNotification();
var timeZone = TimeZoneInfo.FindSystemTimeZoneById("Bangladesh Standard Time");
var now = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, timeZone);
string date = now.ToString("yyyy-MM-dd hh:mm:ss tt");
post.Description = txtDescription.Text;
post.PostDate = Convert.ToDateTime(date);
post.Status = "Active";
if (fupSpecification.HasFile)
{
string fileNameSpecification = fupSpecification.FileName.Replace(",", "");
post.Specification = fileNameSpecification;
fupSpecification.SaveAs(Server.MapPath("../UploadedFiles/" + fileNameSpecification));
}
post.UserId = Convert.ToInt32(Session["userid"].ToString());
db.tblPosts.Add(post);
db.SaveChanges();
string[] tagsArray = new string[ddlTags.Items.Count];
int index = 0;
foreach (ListItem li in ddlTags.Items)
{
if (li.Selected)
{
tagsArray[index] = li.Value;
index = index + 1;
tag.Tag = li.Text;
tag.PostId = Convert.ToInt32(post.Id);
db.tblTags.Add(tag);
db.SaveChanges();
Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('" + "Post created successfully!" + "');", true);
}
}
//for (int i = 0; i < lstboxRemoveTag.Items.Count; i++)
//{
// if (!lstboxRemoveTag.Items[i].Selected || lstboxRemoveTag.Items[i].Selected)
// {
// tag.Tag = lstboxRemoveTag.Items[i].Text;
// tag.PostId = post.Id;
// db.tblTags.Add(tag);
// db.SaveChanges();
// Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('" + "Post created successfully!" + "');", true);
// }
//}
//lstboxRemoveTag.Items.Clear();
txtDescription.Text = "";
populateTags();
postnotification.PostId = post.Id;
postnotification.NotificationDate = post.PostDate;
db.tblPostNotifications.Add(postnotification);
db.SaveChanges();
}
public int Insert(Models.Tag tag)
{
tblTag newTag = new tblTag {
Name = tag.Name
};
db.Tags.Add(newTag);
db.SaveChanges();
return(newTag.Id);
}
public async Task <IHttpActionResult> GettblTag(int id)
{
tblTag tblTag = await db.tblTags.FindAsync(id);
if (tblTag == null)
{
return(NotFound());
}
return(Ok(tblTag));
}
public IHttpActionResult GettblTag(int id)
{
tblTag tblTag = db.tblTags.Find(id);
if (tblTag == null)
{
return(NotFound());
}
return(Ok(tblTag));
}
public IHttpActionResult PosttblTag(tblTag tblTag)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tblTags.Add(tblTag);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = tblTag.tagId }, tblTag));
}
/// <summary>
/// Add tag to tag table and set count to zero
/// </summary>
/// <param name="tagName">Tag to be added to the database, this should be pre-checked for whitespace or blank</param>
/// <returns>Returns a true or false</returns>
public static tblTag AddTag(string tagName)
{
var tag = new tblTag
{
TagName = tagName.Trim().ToLower(), // standerdise tags to lower case and trimmed
Count = 0 // new tags is autommatically set to zero
};
db.tblTags.InsertOnSubmit(tag);
db.SubmitChanges();
return(tag);
}
public void Update(long Id, TagDTO tagDTO)
{
tblTag tagTbl = _dbcontext.tblTags.SingleOrDefault(t => t.ID == Id);
if (tagTbl != null)
{
TagDTO.ConvertDTOtoTable(tagDTO, ref tagTbl);
}
else
{
throw new TagException(Resources.TagNullException);
}
}
public IHttpActionResult DeletetblTag(int id)
{
tblTag tblTag = db.tblTags.Find(id);
if (tblTag == null)
{
return(NotFound());
}
db.tblTags.Remove(tblTag);
db.SaveChanges();
return(Ok(tblTag));
}
public async Task <IHttpActionResult> DeletetblTag(int id)
{
tblTag tblTag = await db.tblTags.FindAsync(id);
if (tblTag == null)
{
return(NotFound());
}
db.tblTags.Remove(tblTag);
await db.SaveChangesAsync();
return(Ok(tblTag));
}
/// <summary>
/// Single Convertion of DTO to Database Table, this is used normally for when update the record in database
/// </summary>
/// <param name="tagDTO"></param>
/// <param name="tagsTable"></param>
public static void ConvertDTOtoTable(TagDTO tagDTO, ref tblTag tagsTable)
{
try
{
tagsTable.ID = tagDTO.ID;
tagsTable.Tag_Kind = tagDTO.Tag_Kind.ToString();
tagsTable.Tag_Type = tagDTO.Tag_Type.ToString();
tagsTable.Tag_Value = tagDTO.Tag_Value;
tagsTable.Is_Disabled = tagDTO.Is_Disabled;
tagsTable.tblDescription = DescriptionConvert.DescriptionConvertDTOToTbl(tagDTO.TagName);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult DeleteTags(int id)
{
if (ClsCheckRole.CheckQuyen(4, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
tblTag tbltag = db.tblTags.Find(id);
var result = string.Empty;
db.tblTags.Remove(tbltag);
db.SaveChanges();
result = "Bạn đã xóa thành công.";
return(Json(new { result = result }));
}
else
{
var result = string.Empty;
result = "Bạn không có quyền thay đổi tính năng này";
return(Json(new { result = result }));
}
}
public ActionResult Edit(int id = 0)
{
if ((Request.Cookies["Username"] == null))
{
return(RedirectToAction("LoginIndex", "Login"));
}
if (ClsCheckRole.CheckQuyen(4, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
tblTag tbltag = db.tblTags.Find(id);
if (tbltag == null)
{
return(HttpNotFound());
}
return(View(tbltag));
}
else
{
return(Redirect("/Users/Erro"));
}
}
/// <summary>
/// Single Convertion of Database Table to DTO
/// </summary>
/// <param name="tagTbl"></param>
/// <returns type ="TagDTO" ></returns>
public static TagDTO ConvertTableToDTO(tblTag tagTbl)
{
TagDTO tagsDTO = new TagDTO();
try
{
tagsDTO.ID = tagTbl.ID;
tagsDTO.Tag_Kind = (TagKind)Enums.TryParse(typeof(TagKind), tagTbl.Tag_Kind);
tagsDTO.Tag_Type = (TagType)Enums.TryParse(typeof(TagType), tagTbl.Tag_Type);
tagsDTO.Tag_Value = tagTbl.Tag_Value;
tagsDTO.Is_Disabled = tagTbl.Is_Disabled;
if (tagTbl.tblDescription != null)
{
tagsDTO.TagName = DescriptionConvert.DescriptionConvertDTOToTbl(tagTbl.tblDescription);
}
return(tagsDTO);
}
catch (Exception ex)
{
throw ex;
}
}
public List <tblPost> FilterGenres(int?id)
{
tblGenre genre = db.tblGenres.Find(id);
if (db.tblTags.FirstOrDefault(t => t.Tag_Title.Contains(genre.Genres_Name)) != null)
{
db.tblTags.FirstOrDefault(t => t.Tag_Title.Contains(genre.Genres_Name)).Tag_CountSearch++;
db.SaveChanges();
}
else
{
tblTag tag = new tblTag()
{
Tag_Title = genre.Genres_Name,
Tag_DateAdd = DateTime.Now,
Tag_CountSearch = 1
};
db.tblTags.Add(tag);
db.SaveChanges();
}
List <tblPost> posts = db.tblPosts.Where(t => t.Post_Genres == id).ToList();
return(posts);
}
public List <tblPost> FilterLanguages(int id)
{
tblLanguage language = db.tblLanguages.Find(id);
if (db.tblTags.FirstOrDefault(t => t.Tag_Title.Contains(language.Lang_Name)) != null)
{
db.tblTags.FirstOrDefault(t => t.Tag_Title.Contains(language.Lang_Name)).Tag_CountSearch++;
db.SaveChanges();
}
else
{
tblTag tag = new tblTag()
{
Tag_Title = language.Lang_Name,
Tag_DateAdd = DateTime.Now,
Tag_CountSearch = 1
};
db.tblTags.Add(tag);
db.SaveChanges();
}
List <tblPost> posts = db.tblPostLangs.Where(t => t.Lang_ID == id).Select(t => t.tblPost).Where(t => t.Post_Active == true && t.Post_Trash == false).OrderByDescending(t => t.Post_DateCreate).ToList();
return(posts);
}
// GET: Capacityad
public ActionResult Index(int?page, string id, FormCollection collection)
{
if ((Request.Cookies["Username"] == null))
{
return(RedirectToAction("LoginIndex", "Login"));
}
if (ClsCheckRole.CheckQuyen(4, 0, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
var ListTags = db.tblTags.OrderBy(p => p.Ord).ToList();
const int pageSize = 20;
var pageNumber = (page ?? 1);
// Thiết lập phân trang
var ship = new PagedListRenderOptions
{
DisplayLinkToFirstPage = PagedListDisplayMode.Always,
DisplayLinkToLastPage = PagedListDisplayMode.Always,
DisplayLinkToPreviousPage = PagedListDisplayMode.Always,
DisplayLinkToNextPage = PagedListDisplayMode.Always,
DisplayLinkToIndividualPages = true,
DisplayPageCountAndCurrentLocation = false,
MaximumPageNumbersToDisplay = 5,
DisplayEllipsesWhenNotShowingAllPageNumbers = true,
EllipsesFormat = "…",
LinkToFirstPageFormat = "Trang đầu",
LinkToPreviousPageFormat = "«",
LinkToIndividualPageFormat = "{0}",
LinkToNextPageFormat = "»",
LinkToLastPageFormat = "Trang cuối",
PageCountAndCurrentLocationFormat = "Page {0} of {1}.",
ItemSliceAndTotalFormat = "Showing items {0} through {1} of {2}.",
FunctionToDisplayEachPageNumber = null,
ClassToApplyToFirstListItemInPager = null,
ClassToApplyToLastListItemInPager = null,
ContainerDivClasses = new[] { "pagination-container" },
UlElementClasses = new[] { "pagination" },
LiElementClasses = Enumerable.Empty <string>()
};
ViewBag.ship = ship;
if (Session["Thongbao"] != null && Session["Thongbao"] != "")
{
ViewBag.thongbao = Session["Thongbao"].ToString();
Session["Thongbao"] = "";
}
if (collection["btnDelete"] != null)
{
foreach (string key in Request.Form.Keys)
{
var checkbox = "";
if (key.StartsWith("chk_"))
{
checkbox = Request.Form["" + key];
if (checkbox != "false")
{
if (ClsCheckRole.CheckQuyen(4, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
int ids = Convert.ToInt32(key.Remove(0, 4));
tblTag tbltags = db.tblTags.Find(ids);
db.tblTags.Remove(tbltags);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(Redirect("/Users/Erro"));
}
}
}
}
}
return(View(ListTags.ToPagedList(pageNumber, pageSize)));
}
else
{
return(Redirect("/Users/Erro"));
}
}
