public async Task <IActionResult> RegisterEmployee(EmployeeRegistration employee)
{
if (ModelState.IsValid)
{
using (var httpClient = new HttpClient())
{
try
{
StringContent content = new StringContent(JsonConvert.SerializeObject(employee), Encoding.UTF8, "application/json");
using (var response = await httpClient.PostAsync("http://localhost:62288/api/Employees/", content))
{
if (response.StatusCode == System.Net.HttpStatusCode.BadRequest)
{
ViewBag.Message = "Failed";
}
else
{
_log4net.Info("Registration Was Done With Email " + employee.EmployeeEmail);
return(RedirectToAction("FirstEmployeeLogin", "Login", new { email = employee.EmployeeEmail, role = employee.EmployeeDept }));
}
}
}
catch (Exception)
{
ViewBag.Message = "Employee API Not Reachable. Please Try Again Later.";
}
}
}
return(View());
}
private void button1_Click(object sender, EventArgs e)
{
EmployeeRegistration er = new EmployeeRegistration();
er.Show();
Hide();
}
public void Post([FromBody] EmployeeRegistration Emp)
{
if (ModelState.IsValid)
{
EmployeeRegistrationRepository.Add(Emp);
}
}
public void Add(EmployeeRegistration Emp)
{
using (IDbConnection dbConnection = Connection)
{
string Q = "select max(EmpId)from EmployeeRegistration"; dbConnection.Open(); var EmpId = dbConnection.ExecuteScalar(Q);
if (Convert.ToInt32(EmpId) > 0)
{
Emp.EmpId = (int)EmpId + 1;
Emp.EmployeeID = "Emp-" + EmpId + 1;
}
else
{
EmpId = 1;
Emp.EmpId = (int)EmpId;
Emp.EmployeeID = "Emp-" + EmpId + 1;
}
// var custDOB = System.Convert.ToDateTime(Emp.DateOfJoining);
}
using (IDbConnection dbConnection = Connection)
{
string sQuery = "INSERT INTO EmployeeRegistration (EmpId,EmployeeID, EmployeeName, Address, City, ContactNo, Email, DateOfJoining, Active, Photo)"
+ "VALUES(@EmpId,@EmployeeId, @EmployeeName, @Address, @City,@ContactNo,@Email,@dateofJoining,@Active,@Photo)";
dbConnection.Open();
dbConnection.Query(sQuery, Emp);
}
}
public void Put(string EmployeeID, [FromBody] EmployeeRegistration Emp)
{
Emp.EmployeeID = EmployeeID;
if (ModelState.IsValid)
{
EmployeeRegistrationRepository.Update(Emp);
}
}
static void Main(string[] args)
{
EmployeeRegistration newEmployee = new EmployeeRegistration("Igor Henrique", "44224632845", "22/04/1993", 'M', JobSector.Maintenance);
newEmployee.Name = "IG";
newEmployee.DocumentNumber = "452200";
Console.WriteLine(newEmployee);
}
public void Update(EmployeeRegistration Emp)
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = "UPDATE EmployeeRegistration SET EmployeeName = @EmployeeName,Address = @Address,City = @City,ContactNo = @ContactNo,Email = @Email," +
"DateOfJoining = @dateofJoining,Active = @Active,Photo = @Photo Where EmpId=@EmpId ";
dbConnection.Open();
dbConnection.Query(sQuery, Emp);
}
}
public async Task <ActionResult> Register(EmployeeRegistration model)
{
if (ModelState.IsValid)
{
ApplicationUser user = new ApplicationUser();
user.UserName = model.RegisterViewModel.UserName;
user.Email = model.RegisterViewModel.Email;
var result = await UserManager.CreateAsync(user, model.RegisterViewModel.Password);
if (result.Succeeded)
{
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
await this.UserManager.AddToRoleAsync(user.Id, model.RegisterViewModel.UserRoles);
var emp = new Employee
{
FirstName = model.Employee.FirstName,
LastName = model.Employee.LastName,
PersonalNumber = model.Employee.PersonalNumber,
Email = model.RegisterViewModel.Email,
HiredDate = model.Employee.HiredDate,
Address = model.Employee.Address,
Postcode = model.Employee.Postcode,
City = model.Employee.City,
PhoneNumber = model.Employee.PhoneNumber,
ProfilePic = model.Employee.ProfilePic,
Notes = model.Employee.Notes,
HourlySalary = model.Employee.HourlySalary,
MonthlySalary = model.Employee.MonthlySalary
};
var allRoles = context.Roles.ToList().Select
(r => new SelectListItem {
Value = r.Name.ToString(), Text = r.Name
}).ToList();
ViewBag.Roles = allRoles;
context.Employees.Add(emp);
context.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public EmployeeRegistrationResponse registerEmployee(Employee employeeRegd)
{
Console.WriteLine("In registerEmployee");
EmployeeRegistrationResponse employeeReply = new EmployeeRegistrationResponse();
EmployeeRegistration.getInstance().Add(employeeRegd);
employeeReply.EmpName = employeeRegd.EmpName;
employeeReply.EmpID = employeeRegd.EmpID;
employeeReply.Department = employeeRegd.Department;
return(employeeReply);
}
public EmployeeRegistrationReply registerEmployee(Employee empregd)
{
Console.WriteLine("In registerEmployee");
EmployeeRegistrationReply empregreply = new EmployeeRegistrationReply();
EmployeeRegistration.getInstance().Add(empregd);
empregreply.Name = empregd.Name;
empregreply.Age = empregd.Age;
empregreply.ID = empregd.EmployeeID;
empregreply.registrationStatus = "Successful";
return(empregreply);
}
public Employee PostEmployee([FromBody] Employee value)
{
Employee emp = new Employee();
Console.WriteLine("In employeeRegistration");
Employee empObj = new Employee();
EmployeeRegistration.getInstance().Add(value);
empObj.ID = value.ID;
empObj.Name = value.Name;
empObj.Age = value.Age;
return(empObj);
}
public EmployeeRegistrationReply addEmployee(Employees empregd)
{
Console.WriteLine("In registerStudent");
EmployeeRegistrationReply empregreply = new EmployeeRegistrationReply();
EmployeeRegistration.getInstance().Add(empregd);
empregreply.firstName = empregd.firstName;
empregreply.lastName = empregd.lastName;
empregreply.Email = empregd.Email;
empregreply.HireDate = empregd.HireDate;
empregreply.EmployeeID = empregd.EmployeeID;
empregreply.DepartmentName = empregd.DepartmentName;
empregreply.Salary = empregd.Salary;
empregreply.RegistrationStatus = "Successful";
return(empregreply);
}
public ActionResult EmployeeRegistrationUpdate(EmployeeRegistration Emp)
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(Baseurl);
client.DefaultRequestHeaders.Clear();
//Define request data format
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
//Sending request to find web api REST service resource GetAllEmployees using HttpClient
HttpResponseMessage Res = client.PutAsJsonAsync("api/EmployeeRegistration/" + Emp.EmpId, Emp).Result;
//Checking the response is successful or not which is sent using HttpClient
if (Res.IsSuccessStatusCode)
{
//Storing the response details recieved from web api
var EmpResponse = Res.Content.ReadAsStringAsync().Result;
ViewBag.Name = JsonConvert.SerializeObject(EmpResponse);
//Deserializing the response recieved from web api and storing into the Employee list
//CatInfo = JsonConvert.DeserializeObject<List<Category>>(CatResponse);
}
}
return(RedirectToAction("EmployeeRegistration"));
}
public ActionResult Register(EmployeeRegistration model)
{
var officeOwnerId = WebSecurity.CurrentUserId;
if (ModelState.IsValid)
{
try
{
var userAlReadyExists =
dbContex.UserProfiles.Any(_ => _.UserName.ToLower() == model.UserName.ToLower());
if (userAlReadyExists)
{
ViewBag.ErrorMessage = "UserName Already Exists";
return(View("RegisterError"));
// return View(_officeRepository.GetAllByOfficeOwnerId(officeOwnerId));
}
WebSecurity.CreateUserAndAccount(model.UserName, model.Password);
var userId = WebSecurity.GetUserId(model.UserName);
dbContex.EmpRegInfos.Add(
new EmpRegInfo()
{
EmpId = userId,
IsAccept = true,
OfficeId = model.OfficeId
});
dbContex.SaveChanges();
Roles.AddUserToRole(model.UserName, "Employee");
return(RedirectToAction("OfficeOwnerHome"));
}
catch (MembershipCreateUserException e)
{
ModelState.AddModelError("", ErrorCodeToString(e.StatusCode));
}
}
return(View());
}
public List <Employees> GetAllEmployee()
{
//if (EmployeeRegistration.getInstance().getAllEmployees() == null)
//{
// return new List<Employees>
//{
// new Employees
// {
// firstName = "Glenn",
// lastName = "Block",
// Email = "",
// HireDate = "03/04/2018",
// Salary = 8900,
// DepartmentName = "QA",
// EmployeeID = 777
// },
// new Employees
// {
// firstName = "Dan",
// lastName = "Roth",
// Email = "",
// HireDate = "03/02/2018",
// Salary = 89000,
// DepartmentName = "QA II",
// EmployeeID = 333
// }
//};
//}
//else
//{
Console.WriteLine("Get method is called");
return(EmployeeRegistration.getInstance().getAllEmployees());
//}
}
public String DeleteEmployeeRecord(int ID)
{
Console.WriteLine("In deleteStudentRecord");
return(EmployeeRegistration.getInstance().Remove(ID));
}
public string UpdateEmployee([FromBody] Employee value)
{
Console.WriteLine("In updateStudentRecord");
return(EmployeeRegistration.getInstance().UpdateEmployee(value));
}
public Employee GetByEmployeesID(int empID)
{
Employee employees_data = EmployeeRegistration.getInstance().GetbyID(empID);
return(employees_data);
}
//Employee[] employees = new Employee[]
//{
// new Employee { ID = 1, Name = "Mark", Age = 30 },
// new Employee { ID = 2, Name = "Allan", Age = 35 },
// new Employee { ID = 3, Name = "Johny", Age = 21 }
//};
public List <Employee> GetAllEmployees()
{
var employees = EmployeeRegistration.getInstance().getAllEmployee();
return(employees);
}
public List <Employee> GetAllEmployee()
{
return(EmployeeRegistration.getInstance().getAllEmployee());
}
public String DeleteEmployee(int empID)
{
Console.WriteLine("In delete Employee record");
return(EmployeeRegistration.getInstance().Remove(empID));
}
public String PutEmployeeRecord(Employee emp)
{
Console.WriteLine("In updateEmployeeRecord");
return(EmployeeRegistration.getInstance().UpdateEmployee(emp));
}
public ActionResult AddEmployeeToSPList(EmployeeRegistration.MVCWeb.Models.Employee model)
{
string SPHostUrl = Request.QueryString["SPHostUrl"];
StringBuilder sbSkills = new StringBuilder();
StringBuilder sbAttachments = new StringBuilder();
if (!model.isFileUploaded)
{
model.AttachmentID = "";
}
foreach (var skill in model.Skills)
{
sbSkills.Append(skill.Technology).Append(",").Append(skill.Experience).Append(";");
}
var spContext = SharePointContextProvider.Current.GetSharePointContext(HttpContext);
using (var clientContext = spContext.CreateUserClientContextForSPHost())
{
if (clientContext != null)
{
var lstEmployee = clientContext.Web.Lists.GetByTitle("Employees");
var itemCreateInfo = new ListItemCreationInformation();
var listItem = lstEmployee.AddItem(itemCreateInfo);
listItem["EmpNumber"] = ConvertToEmptyString(model.EmpNumber);
listItem["Title"] = ConvertToEmptyString(model.Name);
listItem["UserID"] = ConvertToEmptyString(model.UserID);
listItem["EmpManager"] = ConvertToEmptyString(model.EmpManager);
listItem["Designation"] = ConvertToEmptyString(model.Designation);
listItem["Location"] = ConvertToEmptyString(model.Location);
listItem["Skills"] = ConvertToEmptyString(sbSkills.ToString());
listItem["AttachmentID"] = model.AttachmentID;
listItem.Update();
clientContext.ExecuteQuery();
AddUserToSelectedSiteGroups(model, clientContext, model.UserID);
}
} // using (var clientContext
return RedirectToAction("Thanks", new { SPHostUrl });
}
public void UpdateEmployeeToSPList(EmployeeRegistration.MVCWeb.Models.Employee model)
{
string employeeListName = "Employees";
string SPHostUrl = string.Format("{0}/Lists/{1}", Request.QueryString["SPHostUrl"], employeeListName);
StringBuilder sbSkills = new StringBuilder();
foreach (var skill in model.Skills)
{
sbSkills.Append(skill.Technology).Append(",").Append(skill.Experience).Append(";");
}
var spContext = SharePointContextProvider.Current.GetSharePointContext(HttpContext);
using (var clientContext = spContext.CreateUserClientContextForSPHost())
{
if (clientContext != null)
{
List lstEmployee = clientContext.Web.Lists.GetByTitle(employeeListName);
var listItem = lstEmployee.GetItemById(model.Id);
listItem["EmpNumber"] = model.EmpNumber;
listItem["Title"] = model.Name;
listItem["UserID"] = model.UserID;
listItem["EmpManager"] = model.EmpManager;
listItem["Designation"] = model.Designation;
listItem["Location"] = model.Location;
listItem["Skills"] = sbSkills.ToString();
if (model.isFileUploaded)
{
listItem["AttachmentID"] = model.AttachmentID;
}
listItem.Update();
clientContext.ExecuteQuery();
AddUserToSelectedSiteGroups(model, clientContext, model.UserID);
}
} // using (var clientContext
Response.Redirect(SPHostUrl);
}
