private void filterGv(int job) { List <int> emID = new List <int>(); List <EmployeeScore> s = new List <EmployeeScore>(); EmployeeJobRepository ej = new EmployeeJobRepository(); DataTable dt = ej.findEmployeeByJob(job); EmployeeScore ss = new EmployeeScore(); for (int i = 0; i < dt.Rows.Count; i++) { emID.Add(dt.Rows[i][1].ToString().ToInt()); ss = er.getEmployeeScore(emID[i]); s.Add(ss); } DataTable data = new DataTable(); data = OnlineTools.ToDataTable(s); gvEmployees.DataSource = data; gvEmployees.DataBind(); for (int i = 0; i < data.Rows.Count; i++) { GridViewRow row = gvEmployees.Rows[i]; var input = new HtmlInputGenericControl("number"); input = (HtmlInputGenericControl)row.FindControl("Score"); input.Value = er.getEmployeeScore(emID[i]).Score.ToString(); } }
private void fillListBox() { EmployeeJobRepository ej = new EmployeeJobRepository(); SelectedSubGroups.DataSource = ej.getEmployeeJobs(empid); SelectedSubGroups.DataTextField = "JobTitle"; SelectedSubGroups.DataValueField = "JobID"; SelectedSubGroups.DataBind(); }
protected void RemoveFromSub_Click(object sender, EventArgs e) { if (SelectedSubGroups.SelectedIndex != -1) { EmployeeJobRepository ej = new EmployeeJobRepository(); ej.DeleteByEmpid_Jobid(empid, SelectedSubGroups.SelectedItem.Value.ToInt()); SelectedSubGroups.Items.RemoveAt(SelectedSubGroups.SelectedIndex); } }
public void GetAll_Test() { // Arrange TestKolgraphEntities context = new TestKolgraphEntities(); var repository = new EmployeeJobRepository(context); // Act IEnumerable <employeeJob> result = repository.GetAll(); // Assert Assert.IsNotNull(result); Assert.AreEqual(context.employeeJob.Count(), result.Count()); }
public void GetById_Test() { // Arrange TestKolgraphEntities context = new TestKolgraphEntities(); var repository = new EmployeeJobRepository(context); int id = 1; // Act employeeJob result = repository.GetById(id); // Assert Assert.IsNotNull(result); Assert.AreEqual(id, result.id); }
public void GetAllFilterByCurrent_Test() { // Arrange TestKolgraphEntities context = new TestKolgraphEntities(); var repository = new EmployeeJobRepository(context); var service = new EmployeeJobService(repository); // Act IEnumerable <EmployeeJobModel> result = service.GetAllFilterByCurrent(); // Assert Assert.IsNotNull(result); Assert.AreEqual(context.employeeJob.Where(x => x.isCurrent).Count(), result.Count()); Assert.AreEqual(result.Where(x => x.IsCurrent).Count(), result.Count()); }
public void GetById_Test() { // Arrange TestKolgraphEntities context = new TestKolgraphEntities(); var repository = new EmployeeJobRepository(context); var service = new EmployeeJobService(repository); int id = 1; // Act EmployeeJobModel result = service.GetById(id); // Assert Assert.IsNotNull(result); Assert.AreEqual(id, result.Id); }
private void setLabels() { EmployeesRepository er = new EmployeesRepository(); DataTable dt = er.getEmployeeProfileInfo(empid); lbladdress.Value = dt.Rows[0][8].ToString(); lblcitystate.Value = dt.Rows[0][21].ToString(); lblemail.Value = dt.Rows[0][10].ToString(); lblfullname.Value = dt.Rows[0][20].ToString(); lblid.Value = dt.Rows[0][0].ToString(); lblmobile.Value = dt.Rows[0][9].ToString(); lblusername.Value = dt.Rows[0][3].ToString(); lblzip.Value = dt.Rows[0][11].ToString(); hFullName.InnerText = dt.Rows[0][20].ToString(); EmployeeJobRepository ejr = new EmployeeJobRepository(); DataTable dtJob = ejr.getEmployeeJobs(empid); lbxJobs.DataSource = dtJob; lbxJobs.DataTextField = "JobTitle"; lbxJobs.DataValueField = "JobID"; lbxJobs.DataBind(); setImage(); }
protected void AddToSub_Click(object sender, EventArgs e) { if (SubGroups.SelectedIndex != -1) { bool isadd = false; string text = SubGroups.SelectedItem.Text; string value = SubGroups.SelectedItem.Value; for (int i = 0; i < SelectedSubGroups.Items.Count; i++) { if (SelectedSubGroups.Items[i].Text == text) { isadd = true; } } if (!isadd) { SelectedSubGroups.Items.Add(new ListItem(text, value)); JobEmployee je = new JobEmployee(); je.EmployeeID = empid; je.JobID = value.ToInt(); EmployeeJobRepository ejr = new EmployeeJobRepository(); ejr.SaveJobEmployee(je); NoItemDiv.InnerText = ""; } else { NoItemDiv.InnerText = "این مورد قبلا اضافه شده است!"; NoItemDiv.Attributes["class"] = "error"; } } else { NoItemDiv.InnerText = "شما هیچ موردی را انتخاب نکرده اید!"; NoItemDiv.Attributes["class"] = "error"; } }