public DAL.Models.Employee Add(DAL.Models.Employee employee)
{
DAL.Models.Employee employeeAdded = new Models.Employee();
try
{
using (sqlConnection)
{
sqlConnection.Open();
SqlCommand dbCommand = new SqlCommand(SQL.Querys.GetInsertEmployeeQuery(), sqlConnection);
AddParameters(dbCommand, employee);
using (SqlDataReader sqlDataReader = dbCommand.ExecuteReader())
{
while (sqlDataReader.Read())
{
employeeAdded = GetEmployee(sqlDataReader);
}
}
sqlConnection.Close();
return(employeeAdded);
};
}
catch (Exception exception)
{
throw exception;
}
}
public void Update_ReturnsExpectedResult(int id)
{
Process.Models.Employee ProcessEmployee = ProcessEmployeeTest;
DAL.Models.Employee DALEmployee = DALEmployeeTest;
mockEmployeeDAL = new Mock <DAL.Interfaces.IEmployeeDAL>(MockBehavior.Strict);
mockEmployeeDAL.Setup(a => a.Update(id, It.IsAny <DAL.Models.Employee>()));
processUnderTest = new Process.EmployeeProcess(mapper, mockEmployeeDAL.Object);
Assert.DoesNotThrow(() => processUnderTest.Update(id, ProcessEmployee));
}
public IActionResult Save(Employee emp)
{
//System.Threading.Thread.Sleep(2000);
//return Ok(true);
var dalEmp = new DAL.Models.Employee {
Id = emp.Id,
FirstName = emp.FirstName,
LastName = emp.LastName,
DateOfBirth = emp.Dob,
DateOfJoining = emp.Doj,
Salary = emp.Salary,
Location = emp.Location
};
var success = employeeBs.Create(dalEmp);
System.Threading.Thread.Sleep(2000);
return(Ok(success));
}
private string convertValue(string value, string fieldName)
{
if (value == String.Empty)
{
return("null");
}
//GetWhere
if (fieldName == "AreaID")
{
using (IAreaRepository db = new AreaRepository())
{
return(db.Find(Int32.Parse(value)).Name);
}
}
if (fieldName == "SubAreaID")
{
using (ISubAreaRepository db = new SubAreaRepository())
{
return(db.Find(Int32.Parse(value)).Name);
}
}
if (fieldName == "QuestionOwner")
{
using (IEmployeeRepository db = new EmployeeRepository())
{
DAL.Models.Employee emp = db.Find(Int32.Parse(value));
return(emp.FirstName + " " + emp.LastName);
}
}
if (fieldName == "RiskLevelID")
{
// return EnumExtentions<RiskLevels>.GetDisplayValue(value);
return(EnumExtentions <RiskLevels> .GetDisplayValue((RiskLevels)Int32.Parse(value)));
}
if (fieldName == "Responsibility")
{
return(Enum.GetName(typeof(Responsibility), Int32.Parse(value)));
}
return(value);
}
public void Update(int id, DAL.Models.Employee employee)
{
try
{
using (sqlConnection)
{
sqlConnection.Open();
SqlCommand dbCommand = new SqlCommand(SQL.Querys.GetUpdateEmployeeQuery(), sqlConnection);
AddParameters(dbCommand, employee);
AddIdParameter(dbCommand, id);
int afectedRows = dbCommand.ExecuteNonQuery();
if (afectedRows != 1)
{
throw new InvalidOperationException("Error at Update SQL");
}
};
}
catch (Exception exception)
{
throw exception;
}
}
public IActionResult Edit(Employee emp)
{
// return BadRequest();
//var employee = employeeBs.GetById(emp.Id);
var empl = new DAL.Models.Employee
{
Id = emp.Id,
FirstName = emp.FirstName,
LastName = emp.LastName,
Gender = "Male",
Country = "UK",
DateOfBirth = emp.Dob,
DateOfJoining = emp.Doj,
Location = emp.Location,
Salary = emp.Salary
};
employeeBs.Update(empl);
//return employeeBs.Update(emp);
// System.Threading.Thread.Sleep(5000);
return(Ok(empl));
}
