public ResponseGeneric <EmployeeET> GetEmployee(EmployeeET model)
{
try
{
IEnumerable <EmployeeET> res = null;
Dictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("@parametro1", model.Id.ToString());
parameters.Add("@parametro2", model.Email.CleanParameter());
string query = $@"SELECT Name,LastName FROM Employee WITH(NOLOCK) WHERE Id = '{model.Id}' ";
//res = Extensions.Utils.Execute_Query<EmployeeET>(query, this._configuration["ConnectionStrings:CRM"]);
//return new ResponseGeneric<EmployeeET>(res.First());
EmployeeET employee = new EmployeeET()
{
Id = 1,
Country = "CR",
Email = "*****@*****.**",
LastName = "lastname",
Name = "Maria"
};
return(new ResponseGeneric <EmployeeET>(employee));
}
catch (Exception ex)
{
return(new ResponseGeneric <EmployeeET>(new Exception($"{System.Reflection.MethodBase.GetCurrentMethod().Name} - JsonInput: {JsonConvert.SerializeObject(model)}", ex)));
}
}
public ResponseGeneric <EmployeeET> GetEmployee(EmployeeET model)
{
//logica negocio
//paso1
//paso2
return(this._employeDA.GetEmployee(model));
}
public ResponseGeneric <IEnumerable <EmployeeET> > GetEmployees(EmployeeET model)
{
//logica negocio
//paso1
//paso2
return(this._employeDA.GetEmployees(model));
}
public IActionResult ListdoEmployee(EmployeeET model)
{
try
{
return(Json(_shared.EjecutarServicio <ResponseGeneric <IEnumerable <EmployeeET> > >(JsonConvert.SerializeObject(model), "Employee/GetEmployees")));
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
public ResponseGeneric <EmployeeET> UpsertEmployee(EmployeeET model)
{
try
{
IEnumerable <EmployeeET> res = null;
Dictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("@parametro1", model.Id.ToString());
parameters.Add("@parametro2", model.Email.CleanParameter());
res = Utils.Execute_Query <EmployeeET>("[dbo].[ect_Upsert_Employee]", parameters, this._configuration["ConnectionStrings:CRM"]);
return(new ResponseGeneric <EmployeeET>(res.First()));
}
catch (Exception ex)
{
return(new ResponseGeneric <EmployeeET>(new Exception($"{System.Reflection.MethodBase.GetCurrentMethod().Name} - JsonInput: {JsonConvert.SerializeObject(model)}", ex)));
}
}
public ResponseGeneric <IEnumerable <EmployeeET> > GetEmployees(EmployeeET model)
{
try
{
IEnumerable <EmployeeET> res = null;
Dictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("@parametro1", model.Id.ToString());
parameters.Add("@parametro2", model.Email.CleanParameter());
res = Utils.Execute_Query <EmployeeET>("[dbo].[ect_Upsert_Employee]", parameters, this._configuration["ConnectionStrings:CRM"]);
return(new ResponseGeneric <IEnumerable <EmployeeET> >(res));
//List<EmployeeET> list_employee = new List<EmployeeET>();
//for (int i = 0; i < 15; i++)
//{
// EmployeeET employee = new EmployeeET()
// {
// Id = i,
// Country = "CR",
// Email = "*****@*****.**",
// LastName = "lastname",
// Name = "Maria"
// };
// list_employee.Add(employee);
//}
//return new ResponseGeneric<IEnumerable<EmployeeET>>(list_employee.ToList());
}
catch (Exception ex)
{
return(new ResponseGeneric <IEnumerable <EmployeeET> >(new Exception($"{System.Reflection.MethodBase.GetCurrentMethod().Name} - JsonInput: {JsonConvert.SerializeObject(model)}", ex)));
}
}
public ResponseGeneric <EmployeeET> GetEmployee([FromBody] EmployeeET model)
{
return(this._employeeBL.GetEmployee(model));
}
public ResponseGeneric <IEnumerable <EmployeeET> > GetEmployees([FromBody] EmployeeET model)
{
return(this._employeeBL.GetEmployees(model));
}