public long AddEmployee(AddEmployeeRequest employee) { var newEmployee = mapper.Map <Employees>(employee); newEmployee.DateHired = DateTime.Now; newEmployee.LastUpdate = DateTime.Now; context.Add(newEmployee); context.SaveChanges(); return(newEmployee.Id); }
public bool Delete(Employee employee) { try { _humanResourceContext.Employees.Remove(employee); _humanResourceContext.SaveChanges(); return(true); } catch (Exception e) { Console.WriteLine(e);//Logger eklenicek return(false); } }
public async Task When_Get_Employees_Async_Then_Return_Full_List_Of_Employee() { // Arrange for (int i = 0; i < 5; i++) { context.Employees.Add(fixture.Build <Employee>().Without(x => x.Positions).Without(x => x.ManagerEmployee).Create()); context.SaveChanges(); } // Act var result = await sut.GetEmployeesAsync(); // Assert result.Should().BeEquivalentTo(context.Employees); }
public string Post([FromBody] Workers value) { //First we need check User have existing in database if (!dbContext.Workers.Any(user => user.Login.Equals(value.Login))) { Workers user = new Workers(); user.Login = value.Login; // assign value from POST user.Name = value.Name; user.Surname = value.Surname; user.Sex = value.Sex; user.Department = value.Department; user.Position = value.Position; user.Salt = Convert.ToBase64String(Common.GetRandomSalt(16)); //Get Random Salt user.Password = Convert.ToBase64String(Common.SaltHashPassword( Encoding.ASCII.GetBytes(value.Password), Convert.FromBase64String(user.Salt))); //Add to Database try { dbContext.Add(user); dbContext.SaveChanges(); return(JsonConvert.SerializeObject("Register successfully")); } catch (Exception ex) { return(JsonConvert.SerializeObject(ex.Message)); } } else { return(JsonConvert.SerializeObject("User is existing in Database")); } }
public string Post([FromBody] Workers value) { if (dbContext.Workers.Any(user => user.Login.Equals(value.Login))) { Workers user = dbContext.Workers.Where(u => u.Login.Equals(value.Login)).First(); try { dbContext.Workers.Remove(user); user.Login = value.Login; // assign value from POST user.Name = value.Name; user.Surname = value.Surname; user.Sex = value.Sex; user.Department = value.Department; user.Position = value.Position; user.Salt = Convert.ToBase64String(Common.GetRandomSalt(16)); //Get Random Salt user.Password = Convert.ToBase64String(Common.SaltHashPassword( Encoding.ASCII.GetBytes(value.Password), Convert.FromBase64String(user.Salt))); dbContext.Add(user); dbContext.SaveChanges(); return(JsonConvert.SerializeObject("Update successfully")); } catch (Exception ex) { return(JsonConvert.SerializeObject(ex.Message)); } } else { return(JsonConvert.SerializeObject("User is not existing")); } }
public ActionResult SendMessage(Message m, FormCollection fc) { string Role = fc["Role"]; string Id = fc["EmpId"]; string newpassword = fc["Password"]; int EmpId = Convert.ToInt32(Id); HumanResourceContext context = new HumanResourceContext(); context.MessageSet.Add(m); context.SaveChanges(); var senderEmail1 = ""; var staffpassword = ""; if (Role != "Admin") { senderEmail1 = "*****@*****.**"; staffpassword = newpassword; } else { senderEmail1 = "*****@*****.**"; staffpassword = "******"; } try { if (ModelState.IsValid) { var senderEmail = senderEmail1; var receiverEmail = m.email; var password = staffpassword; var sub = m.subject; var body = m.message; var smtp = new SmtpClient { Host = "smtp.gmail.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new NetworkCredential(senderEmail, password) }; using (var mess = new MailMessage(senderEmail, receiverEmail) { Subject = sub, Body = body }) { smtp.Send(mess); } return(View(m)); } } catch (Exception) { ViewBag.Error = "Some Error"; } return(View()); }
public ActionResult Index(Employees employee, HttpPostedFileBase image, HttpPostedFileBase Resume) { HumanResourceContext context = new HumanResourceContext(); if (Resume != null) { Resume.SaveAs(Path.Combine(Server.MapPath("~/Resume"), Resume.FileName)); employee.Resume = "~/Resume/" + Resume.FileName; } if (image != null) { image.SaveAs(HttpContext.Server.MapPath("~/Image/") + image.FileName); employee.Photo = "~/Image/" + image.FileName; } employee.Resume = employee.Resume.Replace("~", string.Empty); employee.Photo = employee.Photo.Replace("~", string.Empty); context.Employeeset.Add(employee); context.SaveChanges(); ModelState.Clear(); return(View("Detail", employee)); }
public string Post([FromBody] Workers value) { if (dbContext.Workers.Any(user => user.Id.Equals(value.Id))) { Workers user = dbContext.Workers.Where(u => u.Id.Equals(value.Id)).First(); try { dbContext.Workers.Remove(user); dbContext.SaveChanges(); return(JsonConvert.SerializeObject("Delete successfully")); } catch (Exception ex) { return(JsonConvert.SerializeObject(ex.Message)); } } else { return(JsonConvert.SerializeObject("User is not existing")); } }
public ActionResult Edit([Bind(Include = "EmpId,Name,MiddleName,LastName,PhoneNumber,EmailAddress,Salary,IsContract,Photo,Department,Resume,Address,Sex,MaritalStatus,StartDate,Education,NRC,Manager,Birthday,SpousePh,SpouseName,Position,ContactName,ContactPh")] Employees employee, HttpPostedFileBase image, HttpPostedFileBase Resume) { if (ModelState.IsValid) { HumanResourceContext context = new HumanResourceContext(); if (Resume != null) { Resume.SaveAs(Path.Combine(Server.MapPath("~/Resume"), Resume.FileName)); employee.Resume = "~/Resume/" + Resume.FileName; employee.Resume = employee.Resume.Replace("~", string.Empty); } if (image != null) { image.SaveAs(HttpContext.Server.MapPath("~/Image/") + image.FileName); employee.Photo = "~/Image/" + image.FileName; employee.Photo = employee.Photo.Replace("~", string.Empty); } context.Entry(employee).State = EntityState.Modified; context.SaveChanges(); return(RedirectToAction("EmployeeList", "HumanResource")); } return(View(employee)); }