//-----Get Data Employee----//-- public List <TargetDTO> GetAllEmployee(TargetGetDTO objTarget) { List <TargetDTO> target = new List <TargetDTO>(); using (DbLayer dbLayer = new DbLayer()) { SqlCommand SqlCmd = new SqlCommand("spSelectEmployeebyReportTo"); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.AddWithValue("@EmployeeId", objTarget.EmployeeId); target = dbLayer.GetEntityList <TargetDTO>(SqlCmd); } return(target); }
//-----Get Data----//-- public List <TargetGetAllDTO> GetAllTargets(TargetGetDTO objTarget) { List <TargetGetAllDTO> target = new List <TargetGetAllDTO>(); using (DbLayer dbLayer = new DbLayer()) { SqlCommand SqlCmd = new SqlCommand("spSelectTarget"); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.AddWithValue("@ActionBy", objTarget.ActionBy); target = dbLayer.GetEntityList <TargetGetAllDTO>(SqlCmd); } return(target); }
public HttpResponseMessage GetTargetById(TargetGetDTO objTarget) { HttpResponseMessage message; try { // TargetDataAccessLayer dal = new TargetDataAccessLayer(); var dynObj = new { result = _target.GetTargetById(objTarget) }; message = Request.CreateResponse(HttpStatusCode.OK, dynObj); } catch (Exception ex) { message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" }); ErrorLog.CreateErrorMessage(ex, "Target", "GetTargetById"); } return(message); }