public List<EmploymentDTO> findAll() { var objs = (from p in ctx.Employments select p); EmploymentDTO add = null; List<EmploymentDTO> addList = new List<EmploymentDTO>(); foreach (Employment obj in objs) { add = new EmploymentDTO(); add.userName = obj.userName; add.startDate = obj.startDate; add.title = obj.title; add.company = obj.company; add.industry = obj.industry; add.town = obj.town; add.province = obj.province; add.country = obj.country; add.empType = obj.empType; add.currentEmployer = obj.currentEmployer; add.gross = Double.Parse(obj.gross.ToString()); add.startDate = obj.startDate; add.endDate = obj.endDate; add.responsibilities = obj.responsibilities; addList.Add(add); } return addList; }
//[Authorize(Roles = "SuperUser")] public async Task <ActionResult <EmploymentDTO> > EmployUser(EmploymentDTO employmentDTO) { //Use Identity Role to check if logged user is a superuser //Can wire up the AUTHORIZE attribute or custom check using the HttpClient object //if (currentUser.Role != superUser) //{ // _logger.LogWarning("Hack Attempt"); // return BadRequest(); //} var employment = new Employment { UserId = employmentDTO.UserId, EmployerId = employmentDTO.EmployerId, IsSuperUser = employmentDTO.IsSuperUser, AssignmentDate = DateTime.UtcNow }; try { _context.Employments.Add(employment); await _context.SaveChangesAsync(); } catch (Exception) { _logger.LogError("Error occurred while Employing a User"); throw; } return(CreatedAtAction("EmployUser", new { id = employment.Id }, ConvertEmployment(employment))); }
public EmploymentDTO find(string userName, DateTime startDate) { EmploymentDTO info = new EmploymentDTO(); SqlConnection oConn = new SqlConnection(); SqlCommand sqlCmd = null; try { oConn.ConnectionString = ConfigurationManager.AppSettings["conn"]; oConn.Open(); sqlCmd = oConn.CreateCommand(); sqlCmd.CommandType = CommandType.Text; sqlCmd.CommandText = "select * from Employment where userName = '******' AND startDate = '" + startDate + "'"; SqlDataReader rdr = sqlCmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { info.userName = rdr["userName"].ToString(); info.title = rdr["title"].ToString(); info.company = rdr["company"].ToString(); info.industry = rdr["industry"].ToString(); info.town = rdr["town"].ToString(); info.province = rdr["province"].ToString(); info.country = rdr["country"].ToString(); info.empType = rdr["empType"].ToString(); info.currentEmployer = rdr["currentEmployer"].ToString(); info.gross = Double .Parse(rdr["gross"].ToString() ); info.startDate = DateTime.Parse( rdr["startDate"].ToString() ); info.endDate = DateTime.Parse(rdr["endDate"].ToString() ); info.responsibilities = rdr["responsibilities"].ToString(); } } } catch { } finally { if (sqlCmd != null) { sqlCmd = null; } if (oConn != null) { if (oConn.State.Equals(ConnectionState.Open)) { oConn.Close(); } oConn = null; } } return info; }
public void EmploymentDAO_Test() { /*Context*/ EmploymentDAO emp_context = new EmploymentDAO(); AccountDAO account_context = new AccountDAO(); /*Insert*/ AccountDTO account = new AccountDTO(); account.userName = "******"; account.status = "active"; account.password = "******"; account.accountType = "admin"; account_context.presist(account); EmploymentDTO employment = new EmploymentDTO(); employment.company = "fuzion"; employment.country = "SA"; employment.currentEmployer = "Apple"; employment.empType = "Contract"; employment.endDate = new DateTime(2012, 12, 30); employment.gross = 10000; employment.industry = "IT"; employment.province = "WP"; employment.responsibilities = "web development"; employment.startDate = new DateTime(2012, 6, 7); employment.title = "web developer"; employment.town = "cape town"; employment.userName = "******"; emp_context.presist(employment); bool expected = true; bool actual; actual = emp_context.isFound("griddy", new DateTime(2012, 6, 7) ); Assert.AreEqual(expected, actual); /*Update*/ employment.gross = 125000; emp_context.merge(employment); double expectedUpdate = 125000; EmploymentDTO contUpd = emp_context.find("griddy", new DateTime(2012, 6, 7)); Assert.AreEqual(expectedUpdate, contUpd.gross); /*Delete*/ emp_context.removeByUserId("griddy", new DateTime(2012, 6, 7)); bool expectedDelete = false; bool actualDelete = emp_context.isFound("griddy", new DateTime(2012, 6, 7)); Assert.AreEqual(expectedDelete, actualDelete); account_context.removeByUserId("griddy"); }
public EmploymentDTO find(string userName, DateTime startDate) { var obj = (from p in ctx.Employments where p.userName == @userName && p.startDate == @startDate select p).Single(); EmploymentDTO add = new EmploymentDTO(); add.userName = obj.userName; add.title = obj.title; add.company = obj.company; add.industry = obj.industry; add.town = obj.town; add.province = obj.province; add.country = obj.country; add.empType = obj.empType; add.currentEmployer = obj.currentEmployer; add.gross = Double.Parse(obj.gross.ToString() ); add.startDate = obj.startDate; add.endDate = obj.endDate; add.responsibilities = obj.responsibilities; return add; }
public void setEmploymentDto(EmploymentDTO employmentDto) { view.setTitle(employmentDto.title); view.setCompany(employmentDto.company); view.setIndustry(employmentDto.industry); view.setTown(employmentDto.town); view.setProvince(employmentDto.province); view.setCountry(employmentDto.country); view.setEducationType(employmentDto.empType); view.setCurrentEmployer(employmentDto.currentEmployer); view.setGross(employmentDto.gross.ToString()); view.setStartDate(employmentDto.startDate.ToString()); view.setEndDate(employmentDto.endDate.ToString()); view.setResponsibilities(employmentDto.responsibilities); //view.setUsername(employmentInformationDto.userName); }
public EmploymentDTO getEmploymentDto() { EmploymentDTO employmentDto = new EmploymentDTO(); employmentDto.userName = view.getUsername(); employmentDto.country = view.getCountry(); employmentDto.company = view.getCompany(); employmentDto.currentEmployer = view.getCurrentEmployer(); employmentDto.empType = view.getEducationType(); employmentDto.endDate = view.getEndDate(); employmentDto.gross = view.getGross(); employmentDto.industry = view.getIndustry(); employmentDto.province = view.getProvince(); employmentDto.responsibilities = view.getResponsibilities(); employmentDto.startDate = view.getStartDate(); employmentDto.title = view.getTitle(); employmentDto.town = view.getTown(); return employmentDto; }
public bool remove(EmploymentDTO entity) { return this.removeByUserId(entity.userName, entity.startDate); }
public bool presist(EmploymentDTO entity) { bool success = false; SqlConnection oConn = new SqlConnection(); SqlCommand sqlCmd = null; try { oConn.ConnectionString = ConfigurationManager.AppSettings["conn"]; oConn.Open(); sqlCmd = oConn.CreateCommand(); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "insertEmployment"; sqlCmd.Parameters.Add(new SqlParameter("userName", entity.userName)); sqlCmd.Parameters.Add(new SqlParameter("title", entity.title)); sqlCmd.Parameters.Add(new SqlParameter("company", entity.company)); sqlCmd.Parameters.Add(new SqlParameter("industry", entity.industry)); sqlCmd.Parameters.Add(new SqlParameter("town", entity.town)); sqlCmd.Parameters.Add(new SqlParameter("province", entity.province)); sqlCmd.Parameters.Add(new SqlParameter("country", entity.country)); sqlCmd.Parameters.Add(new SqlParameter("empType", entity.empType)); sqlCmd.Parameters.Add(new SqlParameter("currentEmployer", entity.currentEmployer)); sqlCmd.Parameters.Add(new SqlParameter("gross", entity.gross)); sqlCmd.Parameters.Add(new SqlParameter("startDate", entity.startDate)); sqlCmd.Parameters.Add(new SqlParameter("endDate", entity.endDate)); sqlCmd.Parameters.Add(new SqlParameter("responsibilities", entity.responsibilities)); SqlDataReader rdr = sqlCmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { } //Read all } rdr.Close(); if (rdr.RecordsAffected > 0) success = true; } catch { } finally { if (sqlCmd != null) { sqlCmd = null; } if (oConn != null) { if (oConn.State.Equals(ConnectionState.Open)) { oConn.Close(); } oConn = null; } } return success; }
public bool merge(EmploymentDTO entity) { try { var addObj = (from p in ctx.Employments where p.userName == @entity.userName && p.startDate == @entity.startDate select p).Single(); model.Employment obj = (Employment)addObj; /*Update*/ obj.userName = entity.userName; obj.startDate = entity.startDate; obj.title = entity.title; obj.company = entity.company; obj.industry = entity.industry; obj.town = entity.town; obj.province = entity.province; obj.country = entity.country; obj.empType = entity.empType; obj.currentEmployer = entity.currentEmployer; obj.gross = Decimal.Parse(entity.gross.ToString()); obj.startDate = entity.startDate; obj.endDate = entity.endDate; obj.responsibilities = entity.responsibilities; ctx.SubmitChanges(); return true; } catch (Exception e) { model.Log log = new Log(); log.message = "Employment Merge: " + " ["+entity.userName+" , "+entity.startDate+"] " + e.Message; ctx.SubmitChanges(); ctx.Dispose(); ctx = new ModelDataContext(); return false; } }
public bool presist(EmploymentDTO entity) { try { model.Employment obj = new Employment(); obj.userName = entity.userName; obj.startDate = entity.startDate; obj.title = entity.title; obj.company = entity.company; obj.industry = entity.industry; obj.town = entity.town; obj.province = entity.province; obj.country = entity.country; obj.empType = entity.empType; obj.currentEmployer = entity.currentEmployer; obj.gross = Decimal.Parse(entity.gross.ToString() ); obj.startDate = entity.startDate; obj.endDate = entity.endDate; obj.responsibilities = entity.responsibilities; ctx.Employments.InsertOnSubmit(obj); ctx.SubmitChanges(); return true; } catch (Exception) { ctx.Dispose(); ctx = new ModelDataContext(); return false; } }