Example #1
0
        public List <GetAllManpowerDTO> GetAllManPowerMaster(GetManpowerDTO objGetMaster)
        {
            List <GetAllManpowerDTO> manPower = new List <GetAllManpowerDTO>();

            using (DbLayer dbLayer = new DbLayer())
            {
                SqlCommand SqlCmd = new SqlCommand("spSelectManPower");
                SqlCmd.Parameters.AddWithValue("@ActionBy", objGetMaster.ActionBy);
                SqlCmd.CommandType = CommandType.StoredProcedure;
                manPower           = dbLayer.GetEntityList <GetAllManpowerDTO>(SqlCmd);
            }
            return(manPower);
        }
Example #2
0
        public List <ProofMasterGetDTO> GetProofMaster(GetManpowerDTO objGetProof)
        {
            List <ProofMasterGetDTO> proof = new List <ProofMasterGetDTO>();

            using (DbLayer dbLayer = new DbLayer())
            {
                SqlCommand SqlCmd = new SqlCommand("spSelectProofMaster");
                SqlCmd.Parameters.AddWithValue("@ActionBy", objGetProof.ActionBy);
                SqlCmd.CommandType = CommandType.StoredProcedure;
                proof = dbLayer.GetEntityList <ProofMasterGetDTO>(SqlCmd);
            }
            return(proof);
        }
Example #3
0
        public HttpResponseMessage GetProofMaster(GetManpowerDTO objGetProof)
        {
            HttpResponseMessage message;

            try
            {
                // ManPowerDataAccessLayer dal = new ManPowerDataAccessLayer();
                var dynObj = new { result = _obj.GetProofMaster(objGetProof) };
                message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
            }
            catch (Exception ex)
            {
                message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
                ErrorLog.CreateErrorMessage(ex, "ManPower", "GetProofMaster");
            }
            return(message);
        }