Beispiel #1
0
        //-----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);
        }
Beispiel #2
0
        //-----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);
        }