public async Task GetFunctionAsync_WithRandomGuid_ReturnsNotFoundResult()
{
// Arrange
var controller = new FunctionController(functionService, orderByHelper, paginationHelper, mapper);
// Act
var result = await controller.GetFunctionAsync(Guid.NewGuid());
// Assert
Assert.IsType <NotFoundResult>(result);
}
private void pictureBox1_Click(object sender, EventArgs e)
{
FunctionController fc = new FunctionController();
coverpath = fc.addCover();
if (coverpath != null)
{
pictureBox1.Image = Image.FromFile(coverpath);
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
}
}
public ActionResult Details(int?id)
{
var coo = new FunctionController();
var idus = coo.CookieID();
if (idus.version_id == 2)
{
Response.Redirect("/Pays/IndexPakage");
}
return(View(db.Pakages.Find(id)));
}
//Danh sách yêu thích theo người dùng
public JsonResult JsonFavourite(int?idmusic)
{
var cookie = new FunctionController();
var idus = cookie.CookieID();
var music = db.Groups.Where(n => n.group_item == 5 && n.user_id == idus.user_id && n.music_id == idmusic).OrderByDescending(n => n.group_datecreate).Select(n => new
{
id = n.group_id
}).ToList();
return(Json(music, JsonRequestBehavior.AllowGet));
}
//Danh sách theo theo trang cá nhân nhà tuyển dụng
public JsonResult JsonIndexFollow(int?id)
{
var cookie = new FunctionController();
var idus = cookie.CookieID();
var list = db.Groups.Where(n => n.group_item == Common.Common.GROUP_EMPLOYER_CANDIDATE && n.user_id == idus.user_id && n.em_id == id).OrderByDescending(n => n.datecreate).Select(n => new
{
id = n.group_id
}).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
//Danh sách yêu thích theo công việc
public JsonResult IndexFavourite(int?id)
{
var cookie = new FunctionController();
var idus = cookie.CookieID();
var list = db.Groups.Where(n => n.group_item == Common.Common.GROUP_JOB_USERS && n.user_id == idus.user_id && n.job_id == id).Select(n => new
{
id = n.group_id
}).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
public async Task GetFunctionAsync_WithRandomGuid_ReturnsNotFoundResult()
{
// Arrange
var functionService = Substitute.For <IFunctionService>();
var controller = new FunctionController(functionService);
// Act
var result = await controller.GetFunctionAsync(Guid.NewGuid());
// Assert
Assert.IsType <NotFoundResult>(result);
}
//------------------- candidate
public JsonResult GetCandidate(int?idem)
{
var cookie = new FunctionController();
var idus = cookie.CookieID();
var em = db.Users.Find(idem);
var key = idus.user_id + "key" + em.user_id + idus.user_email.Substring(1, 5) + "key" + em.user_email.Substring(1, 5);
var key2 = em.user_id + "key" + idus.user_id + em.user_email.Substring(1, 5) + "key" + idus.user_email.Substring(1, 5);
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DataQuickJob"].ConnectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(@"SELECT [chat_id]
,[chat_sender]
,[chat_receiver]
,[chat_content]
,[chat_datecreate]
,[chat_color]
,[chat_key]
,[chat_active]
FROM [dbo].[Chats]", connection))
{
// Make sure the command object does not already have
// a notification object associated with it.
command.Notification = null;
SqlDependency dependency = new SqlDependency(command);
dependency.OnChange += new OnChangeEventHandler(show_chatcandidate);
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
SqlDataReader reader = command.ExecuteReader();
var list = db.Chats.Where(n => n.chat_key == key || n.chat_key == key2).OrderByDescending(n => n.chat_datecreate).Select(n => new {
id = n.chat_id,
send = n.chat_sender,
rec = n.chat_receiver,
content = n.chat_content,
date = n.chat_datecreate.ToString(),
chatkey = n.chat_key
}).ToList();
return(Json(new { list = list }, JsonRequestBehavior.AllowGet));
}
}
}
public async Task UpdateFunctionAsync_WithRandomGuid_ReturnsNotImplemented()
{
// Arrange
var controller = new FunctionController(functionService, orderByHelper, paginationHelper, mapper);
// Act
IActionResult actionResult = await controller.UpdateFunctionAsync(Guid.NewGuid(), new FunctionSubmit());
// Assert
var badRequestResult = actionResult as BadRequestResult;
Assert.NotNull(badRequestResult);
}
public async Task GetFunctionAsync_WithEmptyGuid_ReturnsBadRequest()
{
// Arrange
var controller = new FunctionController(functionService, orderByHelper, paginationHelper, mapper);
// Act
var result = await controller.GetFunctionAsync(Guid.Empty);
// Assert
var badRequestResult = result as BadRequestResult;
Assert.NotNull(badRequestResult);
}
public async Task GetFunctionAsync_WithEmptyGuid_ReturnsBadRequest()
{
// Arrange
var functionService = Substitute.For <IFunctionService>();
var controller = new FunctionController(functionService);
// Act
var result = await controller.GetFunctionAsync(Guid.Empty);
// Assert
var badRequestResult = result as BadRequestResult;
Assert.NotNull(badRequestResult);
}
public ActionResult Rating(Rating rating)
{
var cookie = new FunctionController();
var idus = cookie.CookieID();
rating.rating_datecreate = DateTime.Now;
rating.user_id = idus.user_id;
db.Ratings.Add(rating);
db.SaveChanges();
return(Redirect(Request.UrlReferrer.ToString()));
}
public ActionResult SubmitJob(SubmitJob submitJob, int?id)
{
var cookie = new FunctionController();
var idus = cookie.CookieIDEm();
submitJob.user_id = idus.user_id;
submitJob.sj_datecreate = DateTime.Now;
submitJob.cv_id = id;
db.SubmitJobs.Add(submitJob);
db.SaveChanges();
return(Redirect("/Employer/CvsEmployer/DetailsCvs?id=" + id));
}
public JsonResult JsonIndexFavourite()
{
var cookie = new FunctionController();
var idus = cookie.CookieID();
var fa = db.Groups.Where(n => n.group_item == 5 && n.user_id == idus.user_id).OrderByDescending(n => n.group_datecreate).Select(n => new
{
id = n.group_id,
idmusic = n.music_id,
title = n.Music.music_name,
img = n.Music.music_img
}).ToList();
return(Json(fa, JsonRequestBehavior.AllowGet));
}
public ActionResult EditBirth(DateTime birth)
{
var cookie = new FunctionController();
var idus = cookie.CookieID();
User user = db.Users.Find(idus.user_id);
if (birth != null)
{
user.user_birth = birth;
}
db.SaveChanges();
return(Redirect("/Users/MyInfo?id=" + idus.user_id));
}
private void treeMain_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
{
FunctionController fc = new FunctionController();
string typeOfNode = getTypeOfNode(e.Node);
setDetailEditingPanelsInvisible();
if (typeOfNode == "interpret")
{
String interpretName = e.Node.Text;
InterpretDTO iDTO = fc.getInterpretByName(interpretName);
löschenToolStripMenuItem.Enabled = true;
alsFavoritMarkierenToolStripMenuItem.Enabled = true;
pnDetailEditingInterpret.Visible = true;
edDetailEditingInterpretName.Text = iDTO.getName();
edDetailEditingInterpretFoundationYear.Text = iDTO.getFoundationYear();
edDetailEditingInterpretLand.Text = iDTO.getLand();
edDetailEditingInterpretNoOfAlbums.Text = fc.getAlbumsByInterpret(iDTO.getName()).Count.ToString();
}
else if (typeOfNode == "album")
{
String albumName = e.Node.Text;
AlbumDTO aDTO = fc.getAlbumByName(albumName);
List <SongDTO> songs = new List <SongDTO>();
listSongs.Items.Clear();
pnDetailEditingAlbum.Visible = true;
edDetailEditingAlbumName.Text = aDTO.getName();
edDetailEditingAlbumInterpret.Text = fc.getInterpretNameById(aDTO.getInterpret());
edDetailEditingAlbumYear.Text = aDTO.getReleaseYear();
edDetailEditingAlbumGenre.Text = fc.getGenreById(aDTO.getGenre());
if (aDTO.getCoverpath() != null && aDTO.getCoverpath() != "")
{
pictureBox1.Image = Image.FromFile(aDTO.getCoverpath());
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
}
else
{
pictureBox1.Image = null;
}
songs = fc.getAllSongsByAlbum(albumName);
foreach (SongDTO song in songs)
{
listSongs.Items.Add(song.getTrackNo() + " - " + song.getName() + " | " + song.getDuration());
}
}
}
public async Task UpdateFunctionAsync_WithBlankGuid_ReturnsNotImplemented()
{
// Arrange
var controller = new FunctionController(functionService, orderByHelper, paginationHelper, mapper);
functionService.UpdateAsync(functionSubmitModel, Arg.Any <Guid>())
.Returns(functionModel);
// Act
IActionResult actionResult = await controller.UpdateFunctionAsync(Guid.Empty, functionSubmitModel);
// Assert
var badRequestResult = actionResult as BadRequestResult;
Assert.NotNull(badRequestResult);
}
private List <object> LoadChucNangCon(List <object> obj, int menuID, int k)
{
List <FunctionInfo> lists = FunctionController.GetInstance().GetByParentID(menuID);
foreach (var item in lists)
{
string tmp = "";
for (int i = 0; i < k; i++)
{
tmp += "- ";
}
obj.Add(new { ID = item.ID, Description = tmp + " " + item.Description });
obj = LoadChucNangCon(obj, item.ID, k + 1);
}
return(obj);
}
//Hủy thheo dõi telex
public ActionResult CancelFollowDetails(int?id)
{
var cookie = new FunctionController();
var idus = cookie.CookieID();
Group group = db.Groups.Find(id);
var emid = group.em_id;
db.Groups.Remove(group);
db.SaveChanges();
return(Redirect("/View/DetailsEmployer?id=" + emid));
}
//Hủy yêu thích telex
public ActionResult CancelFavouriteDetails(int?id)
{
var cookie = new FunctionController();
var idus = cookie.CookieID();
Group group = db.Groups.Find(id);
var idjob = group.job_id;
db.Groups.Remove(group);
db.SaveChanges();
return(Redirect("/View/DetailsJob?id=" + idjob));
}
public JsonResult GetAttentionEmployer()
{
var cookie = new FunctionController();
var idus = cookie.CookieID();
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DataQuickJob"].ConnectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(@"SELECT [view_id]
,[view_view]
,[cv_id]
,[user_id]
,[view_dateupdate]
FROM [dbo].[ViewCvs]", connection))
{
// Make sure the command object does not already have
// a notification object associated with it.
command.Notification = null;
SqlDependency dependency = new SqlDependency(command);
dependency.OnChange += new OnChangeEventHandler(showAttentionEmployer);
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
SqlDataReader reader = command.ExecuteReader();
var list = db.SubmitJobs.Where(n => n.Cv.user_id == idus.user_id).OrderByDescending(n => n.sj_datecreate).Select(n => new
{
company = n.Job.User.employer_company,
title = n.Job.job_title,
textpeice = n.Job.job_textprice,
payend = n.Job.job_payend,
paystart = n.Job.job_paystart,
fullname = n.Cv.cv_fullname,
location = n.Cv.cv_location,
id = n.sj_id,
logo = n.Job.User.employer_logo
}).ToList();
return(Json(new { list = list }, JsonRequestBehavior.AllowGet));
}
}
}
/// <summary>
/// Bind danh sách các nút chức năng trên form
/// </summary>
/// <param name="child"></param>
/// <param name="parentID">MenuID</param>
private string BindFunctionOfMenu(int menuID)
{
FunctionController controller = new FunctionController();
List <FunctionInfo> functionInfoList = controller.GetFunctionByMenuId(menuID);
string rs = "";
foreach (var item in functionInfoList)
{
//rs += string.Format("<li id='F{0}'>[{1}]</li>", item.ID, item.ControlText);
if (item.ParentID == -1) // la cha
{
List <FunctionInfo> childList = controller.GetByParentID(item.ID);
string cap2 = "";
foreach (FunctionInfo tmp in childList)
{
List <FunctionInfo> chauList = controller.GetByParentID(tmp.ID);
string cap3 = "";
foreach (FunctionInfo t in chauList)
{
cap3 += string.Format("<li id='F{0}'>[{1}]</li>", t.ID, t.Description);
}
if (cap3 != "")
{
cap3 = "<ul>" + cap3 + "</ul>";
}
cap2 += string.Format("<li id='F{0}'>[{1}]{2}</li>", tmp.ID, tmp.Description, cap3);
}
if (cap2 != "")
{
cap2 = "<ul>" + cap2 + "</ul>";
}
rs += string.Format("<li id='F{0}'>[{1}]{2}</li>", item.ID, item.Description, cap2);
}
//else
//{
// rs += string.Format("<li id='F{0}'>[{1}]</li>", item.ID, item.ControlText);
//}
}
if (!string.IsNullOrEmpty(rs))
{
rs = "<div class='functionTree' id='functionTree{0}' style='display:none;'><ul>" + rs + "</ul></div>";
}
Literal1.Text += string.Format(rs, menuID);
return(rs);
}
public async Task ListFunctionsAsync_WithNoInputs_ReturnsList()
{
// Arrange
var functionService = Substitute.For <IFunctionService>();
var inList = new List <FunctionModel>();
inList.Add(new FunctionModel {
Name = "Test Functions 1", Id = Guid.NewGuid()
});
inList.Add(new FunctionModel {
Name = "Test Functions 2", Id = Guid.NewGuid()
});
inList.Add(new FunctionModel {
Name = "Test Functions 3", Id = Guid.NewGuid()
});
PaginatedResult <FunctionModel> paginatedResult = new PaginatedResult <FunctionModel>
{
CurrentPage = 1,
PageCount = 1,
PageSize = 3,
Results = inList
};
functionService.GetPaginatedListAsync(Arg.Any <int>(), Arg.Any <int>(), Arg.Any <bool>(), Arg.Any <string>(), Arg.Any <List <KeyValuePair <string, string> > >()).Returns(paginatedResult);
var controller = new FunctionController(functionService, orderByHelper, paginationHelper, mapper);
// Act
IActionResult actionResult = await controller.ListFunctionsAsync(1, 10, true, string.Empty, string.Empty);
// Assert
var okResult = actionResult as OkObjectResult;
Assert.NotNull(okResult);
var outList = okResult.Value as List <Function>;
Assert.NotNull(outList);
for (var i = 0; i < outList.Count; i++)
{
Assert.Equal(outList[i].Uuid, inList[i].Id);
Assert.Equal(outList[i].Name, inList[i].Name);
}
}
private void BindTree()
{
this.tvMenu.Nodes.Clear();
FunctionController controller = new FunctionController();
DataSet dstMenu = controller.QueryFunctions(this.txtQueryFunCode.Text.Trim(), this.txtQueryFunName.Text.Trim());
TreeNode node = new TreeNode();
node.Text = "系统功能";
node.Value = "0";
node.NavigateUrl = "";
this.tvMenu.Nodes.Add(node);
if (dstMenu != null && dstMenu.Tables[0].Rows.Count > 0)
{
this.BindChildNode(dstMenu, node);
}
this.tvMenu.ExpandAll();
}
public void cbxChucNangChaStore_OnRefreshData(object sender, StoreRefreshDataEventArgs e)
{
List <FunctionInfo> lists = FunctionController.GetInstance().GetFunctionByMenuId(int.Parse("0" + hdfTreeNodeID.Text));
List <object> obj = new List <object>();
obj.Add(new { ID = -1, Description = "Là gốc" });
foreach (FunctionInfo item in lists)
{
if (item.ParentID == -1)
{
obj.Add(new { ID = item.ID, Description = item.Description });
obj = LoadChucNangCon(obj, item.ID, 1);
}
}
cbxChucNangChaStore.DataSource = obj;
cbxChucNangChaStore.DataBind();
}
protected void btnAddFunction_Click(object sender, DirectEventArgs e)
{
try
{
FunctionInfo info = new FunctionInfo()
{
ControlText = txtControlText.Text,
Description = txtDescription.Text,
MenuID = int.Parse(hdfTreeNodeID.Text),
ParentID = int.Parse(cbxChucNangCha.SelectedItem.Value.ToString())
};
FunctionController.GetInstance().CreateFunction(info);
if (e.ExtraParams["Continue"] == "No")
{
wdFunction.Hide();
}
if (string.IsNullOrEmpty(hdfRoleID.Text) == false || AjaxSearchUser.GetValue() != null)
{
Dialog.ShowNotification(GlobalResourceManager.GetInstance().GetLanguageValue("SetPermissionSuccess"));
}
else
{
Dialog.ShowNotification(GlobalResourceManager.GetInstance().GetLanguageValue("AddFunctionSuccess"));
}
ResourceManager1.RegisterClientScriptBlock("ds", "resetWdFunction();");
}
catch (Exception ex)
{
Dialog.ShowError(GlobalResourceManager.GetInstance().GetErrorMessageValue("DefaultErrorMessage"));
NhatkyTruycapInfo accessDiary = new NhatkyTruycapInfo()
{
CHUCNANG = GlobalResourceManager.GetInstance().GetHistoryAccessValue("AddFunction") + " Default/btnAddFunction_Click",
MOTA = ex.Message.Replace("'", " "),
IsError = true,
USERNAME = CurrentUser.UserName,
THOIGIAN = DateTime.Now,
MANGHIEPVU = "Functions",
TENMAY = Util.GetInstance().GetComputerName(Request.UserHostAddress),
IPMAY = Request.UserHostAddress,
THAMCHIEU = "",
};
new SoftCore.AccessHistory.AccessHistoryController().AddAccessHistory(accessDiary);
}
}
public ActionResult SubmitCv(SubmitCv submitCv, int?id)
{
var cookie = new FunctionController();
var idus = cookie.CookieID();
submitCv.sb_datecreate = DateTime.Now;
submitCv.sb_update = DateTime.Now;
submitCv.user_id = idus.user_id;
submitCv.job_id = id;
submitCv.sb_active = 1;
db.SubmitCvs.Add(submitCv);
db.SaveChanges();
return(Redirect("/View/ViewCvEmployer"));
}
//Hủy lưu
public JsonResult CancelFavourite(int?id)
{
var cookie = new FunctionController();
var idus = cookie.CookieID();
Group group = db.Groups.Find(id);
var idmusic = group.music_id;
db.Groups.Remove(group);
db.SaveChanges();
var fa = db.Groups.Where(n => n.group_item == 5 && n.user_id == idus.user_id && n.music_id == idmusic).OrderByDescending(n => n.group_datecreate).Select(n => new
{
id = n.group_id
}).ToList();
return(Json(fa, JsonRequestBehavior.AllowGet));
}
public ActionResult Create([Bind(Include = "news_id,news_title,news_contents,news_image,cate_id,news_tags,news_genres,news_datecreate,news_dateupdate,news_active,news_option,news_bin,user_id,news_view")] News news)
{
var coo = new FunctionController();
news.cate_id = 1;
news.news_datecreate = DateTime.Now;
news.news_dateupdate = DateTime.Now;
news.news_active = true;
news.news_option = true;
news.news_bin = false;
news.news_view = 1;
news.user_id = coo.CookieID().user_id;
db.News.Add(news);
db.SaveChanges();
ViewBag.user_id = new SelectList(db.Users, "user_id", "user_email", news.user_id);
return(RedirectToAction("Index"));
}
//---------------------------Thông báo
public JsonResult RMess()
{
var cookie = new FunctionController();
var idus = cookie.CookieID();
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DataQuickJob"].ConnectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(@"SELECT [chat_id]
,[chat_sender]
,[chat_receiver]
,[chat_content]
,[chat_datecreate]
,[chat_color]
,[chat_key]
FROM [dbo].[Chats]", connection))
{
// Make sure the command object does not already have
// a notification object associated with it.
command.Notification = null;
SqlDependency dependency = new SqlDependency(command);
dependency.OnChange += new OnChangeEventHandler(showMessenger);
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
SqlDataReader reader = command.ExecuteReader();
var list = db.Chats.Where(n => n.chat_active == false).OrderByDescending(n => n.chat_datecreate).Select(n => new
{
id = n.chat_id,
sender = n.chat_sender,
receiver = n.chat_receiver,
content = n.chat_content
}).ToList();
return(Json(new { list = list }, JsonRequestBehavior.AllowGet));
}
}
}
