コード例 #1
0
        public List <AssignManpowerDTO> GetAllAssignManPower(ManpowerBranchDTO objCustomer)
        {
            List <AssignManpowerDTO> manpower = new List <AssignManpowerDTO>();

            using (DbLayer dbLayer = new DbLayer())
            {
                SqlCommand SqlCmd = new SqlCommand("spSelectAllocateManpowerByCustomer");
                SqlCmd.Parameters.AddWithValue("@CustomerId", objCustomer.CustomerId);
                SqlCmd.Parameters.AddWithValue("@ActionBy", objCustomer.ActionBy);
                SqlCmd.CommandType = CommandType.StoredProcedure;
                manpower           = dbLayer.GetEntityList <AssignManpowerDTO>(SqlCmd);
            }
            return(manpower);
        }
コード例 #2
0
        public List <ManpowerBranchAllDTO> GetAllBranch(ManpowerBranchDTO objBranch)
        {
            List <ManpowerBranchAllDTO> branch = new List <ManpowerBranchAllDTO>();

            using (DbLayer dbLayer = new DbLayer())
            {
                SqlCommand SqlCmd = new SqlCommand("spCreateOperation");
                SqlCmd.Parameters.AddWithValue("@CustomerId", objBranch.CustomerId);
                SqlCmd.Parameters.AddWithValue("@ActionBy", objBranch.ActionBy);
                SqlCmd.CommandType = CommandType.StoredProcedure;
                branch             = dbLayer.GetEntityList <ManpowerBranchAllDTO>(SqlCmd);
            }
            return(branch);
        }
コード例 #3
0
        public HttpResponseMessage GetAllBranch(ManpowerBranchDTO objGetManPower)
        {
            HttpResponseMessage message;

            try
            {
                // AssignManpowerDataAccessLayer _manPower = new AssignManpowerDataAccessLayer();
                var dynObj = new { result = _manPower.GetAllBranch(objGetManPower) };
                message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
            }
            catch (Exception ex)
            {
                message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
                ErrorLog.CreateErrorMessage(ex, "AssignManpower", "GetAllBranch");
            }
            return(message);
        }