public static int InsertAlternative(EmployeeAddRequest model)
{
int empId = 0;
Action <SqlParameterCollection> inputParamDelegate = delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@FirstName", model.FirstName);
paramCollection.AddWithValue("@LastName", model.LastName);
paramCollection.AddWithValue("@Email", model.Email);
paramCollection.AddWithValue("@JobTitle", model.JobTitle);
paramCollection.AddWithValue("@DOB", model.DOB);
paramCollection.AddWithValue("@Salary", model.Salary);
SqlParameter idParameter = new SqlParameter("@Id", System.Data.SqlDbType.Int);
idParameter.Direction = System.Data.ParameterDirection.Output;
paramCollection.Add(idParameter);
};
Action <SqlParameterCollection> returnParamDelegate = delegate(SqlParameterCollection paramCollection)
{
Int32.TryParse(paramCollection["@Id"].Value.ToString(), out empId);
};
DataProvider.ExecuteNonQuery(GetConnection
, "dbo.Employees_Insert"
, inputParamDelegate
, returnParamDelegate);
return(empId);
}
public int AddEmployee(EmployeeAddRequest model)
{
using (var conn = Getconn())
{
int id = 0;
if (conn.State == ConnectionState.Open)
{
using (var cmd = new SqlCommand("Employee_Create", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@first_name", model.First_Name);
cmd.Parameters.AddWithValue("@last_name", model.Last_Name);
cmd.Parameters.AddWithValue("@gender", model.Gender);
cmd.Parameters.AddWithValue("@salary", model.Salary);
cmd.Parameters.AddWithValue("@position", model.Position);
cmd.Parameters.AddWithValue("@department_id", model.Department_Id);
cmd.Parameters.AddWithValue("@employee_id", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
id = (int)cmd.Parameters["@employee_id"].Value;
}
}
else
{
BadConn();
}
return(id);
}
}
public async Task <EmployeeDto> AddEmployeeAsync(EmployeeAddRequest employeeAddRequest)
{
var position = await _positionRepository.GetByIdAsync(employeeAddRequest.PositionId);
var employee = new Employee()
{
Name = employeeAddRequest.Name,
Surname = employeeAddRequest.Surname,
CreatedAtUtc = _dateService.GetDateTimeUtcNow(),
ModifiedAtUtc = _dateService.GetDateTimeUtcNow(),
Positions = new List <EmployeePosition>()
{
new EmployeePosition
{
HiredAt = employeeAddRequest.HiredAt,
LeftAt = employeeAddRequest.LeftAt,
PositionId = employeeAddRequest.PositionId,
Title = position.Title,
Salary = employeeAddRequest.Salary
}
}
};
await _employeeRepository.InsertAsync(employee);
return(_mapper.Map <Employee, EmployeeDto>(employee));
}
public bool Add(EmployeeAddRequest employee)
{
try
{
SqlConnection sqlconn = new SqlConnection(connectionString);
SqlCommand sqlComm = new SqlCommand("addEmployee");
sqlconn.Open();
sqlComm.Connection = sqlconn;
sqlComm.CommandType = CommandType.StoredProcedure;
sqlComm.Parameters.AddWithValue("@empType", employee.EmpType);
sqlComm.Parameters.AddWithValue("@firstName", employee.FirstName);
sqlComm.Parameters.AddWithValue("@middleName", employee.MiddleName);
sqlComm.Parameters.AddWithValue("@lastName", employee.LastName);
sqlComm.Parameters.AddWithValue("@email", employee.Email);
sqlComm.Parameters.AddWithValue("@salary", employee.Salary);
sqlComm.Parameters.AddWithValue("@username", employee.Username);
sqlComm.Parameters.AddWithValue("@locationId", employee.Location);
sqlComm.Parameters.AddWithValue("@project", employee.Project);
sqlComm.ExecuteNonQuery();
SqlCommand sqlCommand = new SqlCommand("addOtherEmployeeDetails");
sqlCommand.Connection = sqlconn;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@manager", employee.Manager);
sqlCommand.Parameters.AddWithValue("@email", employee.Email);
sqlCommand.ExecuteNonQuery();
sqlconn.Close();
return(true);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Adds emplyee to database
/// </summary>
/// <param name="addRequest">Employee add request</param>
public async Task AddEmployee(EmployeeAddRequest addRequest)
{
var newShopUser = Mapper.Map <ShopEmployee>(addRequest);
await ShopEmployeeRepo.CreateAsync(newShopUser);
await ShopEmployeeRepo.SaveChangesAsync();
}
public IHttpActionResult Add(EmployeeAddRequest model)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
else
{
return(Ok("Employee " + svc.AddEmployee(model) + " has been added"));
}
}
public bool Add(EmployeeAddRequest employee)
{
try
{
return(_employeeRepository.Add(employee));
}
catch (Exception ex)
{
throw ex;
}
}
public int AddEmployee(EmployeeAddRequest model)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "dbo.Employee_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FirstName", model.FirstName);
cmd.Parameters.AddWithValue("@LastName", model.LastName);
cmd.Parameters.AddWithValue("@HiredDate", model.HiredDate);
DataTable taskTable = null;
if (model.Tasks.Count > 0)
{
taskTable = new DataTable();
taskTable.Columns.Add("Name", typeof(string));
taskTable.Columns.Add("StartTime", typeof(DateTime));
taskTable.Columns.Add("Deadline", typeof(DateTime));
foreach (var item in model.Tasks)
{
DataRow dr = taskTable.NewRow();
dr[0] = item.Name;
dr[1] = item.StartTime;
dr[2] = item.Deadline;
taskTable.Rows.Add(dr);
}
}
cmd.Parameters.AddWithValue("@Tasks", taskTable);
SqlParameter idParam = cmd.Parameters.Add("@Id", SqlDbType.Int);
idParam.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
conn.Close();
return((int)idParam.Value);
}
}
public EmployeeResponse Create(EmployeeAddRequest request)
{
using (var adapter = DataAccessAdapterFactory.NewDataAccessAdapter())
{
OnBeforeEmployeeAddRequest(adapter, request);
var entity = request.FromDto();
entity.IsNew = true;
if (adapter.SaveEntity(entity, true))
{
OnAfterEmployeeAddRequest(adapter, request);
return(new EmployeeResponse(entity.ToDto()));
}
}
throw new InvalidOperationException();
}
public async Task <EmployeeInfo> AddEmployeeInfoAsync(EmployeeAddRequest employeeAddRequest)
{
DateTime dateTime = DateTime.UtcNow;
EmployeeInfo employeeInfo = new EmployeeInfo
{
FirstName = employeeAddRequest.FirstName,
LastName = employeeAddRequest.LastName,
Email = employeeAddRequest.Email,
NationalID = employeeAddRequest.NationalID
};
await employeeInfoRepository.CreateAsync(employeeInfo);
if (await employeeInfoRepository.EntitySaveChangeAsync())
{
return(employeeInfo);
}
else
{
throw new ApiExceptions("somthing went wrong");
}
}
partial void OnAfterEmployeeAddRequest(IDataAccessAdapter adapter, EmployeeAddRequest request);
public async Task <ActionResult <EmployeeDto> > AddEmployeeAsync([FromBody] EmployeeAddRequest request)
{
var employeeDto = await _employeeService.AddEmployeeAsync(request);
return(new ActionResult <EmployeeDto>(employeeDto));
}
public async Task <IActionResult> AddEmployee(EmployeeAddRequest employeeInfo)
{
return(Ok(await _employeeService.AddEmployeeInfoAsync(employeeInfo)));
}