public static LanguageDTO ConvertTableToDTO(tblLanguage objtblLanguage)
{
LanguageDTO objLanguageDTO = new LanguageDTO();
objLanguageDTO = Mapper.Map <tblLanguage, LanguageDTO>(objtblLanguage);
return(objLanguageDTO);
}
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 DeleteConfirmed(int id)
{
tblLanguage tblLanguage = db.tblLanguages.Find(id);
db.tblLanguages.Remove(tblLanguage);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//// POST: api/Language
//public void Post([FromBody]string value)
//{
//}
// PUT: api/Language/5
public void Put(int id, [FromBody] string value)
{
tblLanguage objLang = tblLanguageManager.GetItemByID(id);
if (objLang != null)
{
daitiphu.common.Util.CommonHelper.setCurrentLanguage(objLang);
}
}
public static void Update(Language updLang)
{
tblLanguage dataItem = CurrDBContext.Get().tblLanguage.Where(x => x.Id == updLang.Id).Single();
dataItem.EnumName = updLang.EnumName;
dataItem.UIName = updLang.UIName;
CurrDBContext.Get().SaveChanges();
}
public ActionResult Edit([Bind(Include = "Lang_ID,Lang_Name,Lang_Logo,Lang_Trash")] tblLanguage tblLanguage)
{
if (ModelState.IsValid)
{
db.Entry(tblLanguage).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblLanguage));
}
public static LanguageValueDTO ConvertTableToDTO(tblLanguage objtblLanguage)
{
LanguageValueDTO objLanguageValueDTO = new LanguageValueDTO();
objLanguageValueDTO.LanguageID_FK = objtblLanguage.ID;
objLanguageValueDTO.CultureValue = objtblLanguage.Culture_Value;
objLanguageValueDTO.ShortValue = string.Empty;
objLanguageValueDTO.LongValue = string.Empty;
return(objLanguageValueDTO);
}
public JsonResult UpdateLang(clsLanguage _lang)
{
tblLanguage lang = useroper.GetByID(_lang.Id);
lang.Language = _lang.LangName;
useroper.Edit(lang);
useroper.Save();
return(Json(lang));
}
public static void Create(Language lng)
{
tblLanguage currItem = new tblLanguage
{
EnumName = lng.EnumName,
UIName = lng.UIName
};
CurrDBContext.Get().tblLanguage.Add(currItem);
CurrDBContext.Get().SaveChanges();
}
public ActionResult Create([Bind(Include = "Lang_ID,Lang_Name,Lang_Logo,Lang_Trash")] tblLanguage tblLanguage)
{
if (ModelState.IsValid)
{
db.tblLanguages.Add(tblLanguage);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblLanguage));
}
public JsonResult InsertLang(clsLanguage _lang)
{
tblLanguage lang = new tblLanguage();
lang.Language = _lang.LangName;
lang.IsActive = true;
lang.IsDeleted = true;
useroper.Insert(lang);
useroper.Save();
return(Json(lang));
}
// GET: api/Language/5
public string Get(string id)
{
tblLanguage language = daitiphu.common.ContentHelper.Current.WorkingLanguage;
string item = tblLanguageManager.GetLocaleResourceString(id, 7);//(language.LanguageId) change later
if (item == null)
{
string message = "Resource doesn't exist";
throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.NotFound, message));
}
return(item);
}
// GET: Admin/tblLanguagesAdmin/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblLanguage tblLanguage = db.tblLanguages.Find(id);
if (tblLanguage == null)
{
return(HttpNotFound());
}
return(View(tblLanguage));
}
public void DeleteTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
Guid languageGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblLanguage language = dc.tblLanguages.FirstOrDefault(l => l.Id == languageGuid);
dc.tblLanguages.Remove(language);
dc.SaveChanges();
tblLanguage deletedLanguage = dc.tblLanguages.FirstOrDefault(l => l.Id == languageGuid);
Assert.IsNull(deletedLanguage);
}
}
public void UpdateTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Retrieve test language based on ID and update it
Guid languageGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblLanguage language = dc.tblLanguages.FirstOrDefault(l => l.Id == languageGuid);
language.Description = "UpdatedLang";
//Save changes and get it back out
dc.SaveChanges();
tblLanguage updatedLanguage = dc.tblLanguages.FirstOrDefault(l => l.Description == "UpdatedLang");
//Make sure the Ids match
Assert.AreEqual(language.Id, updatedLanguage.Id);
}
}
public void InsertTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Create a language
tblLanguage language = new tblLanguage
{
//Language a GUID for testing purposes
Id = Guid.Parse("11112222-3333-4444-5555-666677778888"),
Description = "Test"
};
//Add the language to the database
dc.tblLanguages.Add(language);
//Commit changes
int rowsInserted = dc.SaveChanges();
Assert.IsTrue(rowsInserted == 1);
}
}
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);
}
public static tblLanguage CreatetblLanguage(int ID)
{
tblLanguage tblLanguage = new tblLanguage();
tblLanguage.id = ID;
return tblLanguage;
}
public void AddTotblLanguages(tblLanguage tblLanguage)
{
base.AddObject("tblLanguages", tblLanguage);
}
