public HttpResponseMessage removeSiteAllocation(removeSiteAllocation service)
        {
            HttpResponseMessage message;

            try
            {
                // SiteMappingDataAccessLayer dal = new SiteMappingDataAccessLayer();
                var dynObj = new { result = _Site.removeSiteAllocation(service) };
                message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
            }
            catch (Exception ex)
            {
                message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Something wrong. Try Again!" });

                ErrorLog.CreateErrorMessage(ex, "SiteMapping", "removeSiteAllocation");
            }
            return(message);
        }
        public bool removeSiteAllocation(removeSiteAllocation objSiteAllocation)
        {
            bool       res    = false;
            SqlCommand SqlCmd = new SqlCommand("spDeleteAllocateManPower");

            SqlCmd.CommandType = CommandType.StoredProcedure;
            SqlCmd.Parameters.AddWithValue("@CustomerId", objSiteAllocation.CustomerId);
            SqlCmd.Parameters.AddWithValue("@BranchId", objSiteAllocation.BranchId);
            SqlCmd.Parameters.AddWithValue("@SiteId", objSiteAllocation.SiteId);
            SqlCmd.Parameters.AddWithValue("@ClassificationId", objSiteAllocation.ClassificationId);
            SqlCmd.Parameters.AddWithValue("@ServiceId", objSiteAllocation.ServiceId);
            SqlCmd.Parameters.AddWithValue("@ActionBy", objSiteAllocation.ActionBy);
            int result = new DbLayer().ExecuteNonQuery(SqlCmd);

            if (result != Int32.MaxValue)
            {
                res = true;
            }
            return(res);
        }