public int AddDoctor(Doctor doctor)
{
string procName = "spDoctorInsert";
var param = new DynamicParameters();
int doctorId = 0;
param.Add("@Id", doctor.Id, null, ParameterDirection.Output);
param.Add("@FirstName", doctor.FirstName);
param.Add("@LastName", doctor.LastName);
//param.Add("@DOB", doctor.DOB);
//param.Add("@Gender", doctor.Gender);
param.Add("@Phone", doctor.Phone);
param.Add("@Email", doctor.Email);
try
{
SqlMapper.Execute(_connectionFactory.GetConnection,
procName, param, commandType: CommandType.StoredProcedure);
doctorId = param.Get <int>("@Id");
}
finally
{
_connectionFactory.CloseConnection();
}
return(doctorId);
}
public int AddEmployee(Employees employees)
{
string procName = "spEmployeeInsert";
var param = new DynamicParameters();
int EmployeeId = 0;
param.Add("@EmployeeId", employees.EmployeeID, null, ParameterDirection.Output);
param.Add("@Title", employees.Title);
param.Add("@TitleOfCourtesy", employees.TitleOfCourtesy);
param.Add("@FirstName", employees.FirstName);
param.Add("@LastName", employees.LastName);
param.Add("@Address", employees.Address);
param.Add("@City", employees.City);
param.Add("@Region", employees.Region);
param.Add("@PostalCode", employees.PostalCode);
param.Add("@HomePhone", employees.HomePhone);
param.Add("@Country", employees.Country);
try
{
SqlMapper.Execute(_connectionFactory.GetConnection,
procName, param, commandType: CommandType.StoredProcedure);
EmployeeId = param.Get <int>("@EmployeeId");
}
finally
{
_connectionFactory.CloseConnection();
}
return(EmployeeId);
}