public HttpResponseMessage GetDistinctEmployeeName(BDMDistinctEmployeeName objbdmName)
{
HttpResponseMessage message;
try
{
// BDMAppointmentDetailDAL dal = new BDMAppointmentDetailDAL();
var dynObj = new { result = _obj.GetDistinctEmployeeName(objbdmName) };
message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Something wrong. Try Again!" });
ErrorLog.CreateErrorMessage(ex, "BDMAppoinmentDetail", "GetDistinctEmployeeName");
}
return(message);
}
public List <BDMDistinctEmployeeName> GetDistinctEmployeeName(BDMDistinctEmployeeName objbdmName)
{
List <BDMDistinctEmployeeName> EmployeeList = new List <BDMDistinctEmployeeName>();
using (DbLayer dbLayer = new DbLayer())
{
if (objbdmName.Position != 1)
{
SqlCommand SqlCmd = new SqlCommand("spSelectDistinctEmployeeName");
SqlCmd.Parameters.AddWithValue("@ActionBy", objbdmName.ActionBy);
SqlCmd.CommandType = CommandType.StoredProcedure;
EmployeeList = dbLayer.GetEntityList <BDMDistinctEmployeeName>(SqlCmd);
}
else
{
SqlCommand SqlCmd = new SqlCommand("spCEOSelectDistinctEmployeeName");
SqlCmd.CommandType = CommandType.StoredProcedure;
EmployeeList = dbLayer.GetEntityList <BDMDistinctEmployeeName>(SqlCmd);
}
}
return(EmployeeList);
}
